Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'noorsph_noorbank.tr.tax_class_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Error No: 1055
SELECT tr.tax_class_id, SUM(tr.rate) AS rate, tr.description, tr.priority FROM tax_rate tr LEFT JOIN zone_to_geo_zone z2gz ON (tr.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN geo_zone gz ON (tr.geo_zone_id = gz.geo_zone_id) WHERE (z2gz.country_id = '0' OR z2gz.country_id = '101') AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1538') GROUP BY tr.priority ORDER BY tr.priority ASC