Joe

@Alexmg86 I think I’ve identified it down to Microsoft SQL Server which does not allow for order by alias. The full su query is required which is why that error...

@Alexmg86 Here are the queries from MS SQL: Page 1: select [accounts].*, (select max(total_items) from [counts_view] where [accounts].[account_id] = [counts_view].[collector_id] and [agent_id] = '157') as [counts_view_total_items_max] from [accounts] where [account_status_id]...