Hi Sandeep,

Thanks for some hidden rules but I found it confusing if the Left-joins are always run last, regardless of the order value then when do they run last ? Because what I'm seeing now is the orders are still being used which means the Order logic is applied in my first attempt which is returns 45,478 records but after I changed Left Join to True value in resource_aggregate_weekly table, the logic now is based on the run last but the not ordering if I understand correctly.