1055 - Expression #20 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bigpop_sns.p.colorFrontImage' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT ps.*, p.colorFrontImage FROM `product_styles` AS ps JOIN products AS p on ( p.styleID = ps.styleID ) WHERE p.colorFamily = 'Reds' GROUP BY p.styleID

[TEP STOP]