Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '' 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 octax_rate tr LEFT JOIN oczone_to_geo_zone z2gz ON (tr.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN ocgeo_zone gz ON (tr.geo_zone_id = gz.geo_zone_id) WHERE (z2gz.country_id = '0' OR z2gz.country_id = '223') AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') GROUP BY tr.priority ORDER BY tr.priority ASC