A Database Error Occurred

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