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 ) JOIN colors AS c on ( c.colorGroupName = p.colorGroupName ) WHERE c.color_url = 'Maroon' GROUP BY p.styleID

[TEP STOP]