The aggregate expression '%1' must appear in either the select list or a HAVING clause subquery

Probable cause 

An aggregated expression containing an outer reference must either appear in a select list expression (a subselect), or in a HAVING clause subquery in the query whose FROM clause contains the table with the column being aggregated.