Error Number: 1055
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'amyhimmelberger_com.rets_property_re_1.L_AskingPrice' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT distinct(L_City) as city,count(*) as total FROM rets_property_re_1 WHERE L_Status="Active" AND L_SquareFeet > 0 and L_SaleRent="For Sale" group by city order by L_AskingPrice asc
Filename: models/Listings.php
Line Number: 511