Standard Message: DB Error: unknown error<br><br>Standard Code:<br>-1<br><br>DBMS/User Message:<br>SELECT p.id, p.cat_id, p.manufacturer_id FROM ml_product p
					 INNER JOIN ml_category_map cm ON p.cat_id=cm.cat_id  INNER JOIN ml_category ca ON cm.cat_id = ca.id  INNER JOIN ml_delivery de ON p.delivery_id = de.id  INNER JOIN ml_product_option_map mp ON p.id = mp.product_id 
					WHERE p.group_id=65893 AND mp.option_value<>"BLACK"  AND cm.shop_id=715 AND cm.active='1' AND ca.active='1' AND p.active='1' AND mp.option_id=84
					GROUP BY mp.option_value
					 [nativecode=1055 ** Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dhburns_dhburns.p.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]<br><br>DBMS/Debug Message:<br>SELECT p.id, p.cat_id, p.manufacturer_id FROM ml_product p
					 INNER JOIN ml_category_map cm ON p.cat_id=cm.cat_id  INNER JOIN ml_category ca ON cm.cat_id = ca.id  INNER JOIN ml_delivery de ON p.delivery_id = de.id  INNER JOIN ml_product_option_map mp ON p.id = mp.product_id 
					WHERE p.group_id=65893 AND mp.option_value<>"BLACK"  AND cm.shop_id=715 AND cm.active='1' AND ca.active='1' AND p.active='1' AND mp.option_id=84
					GROUP BY mp.option_value
					 [nativecode=1055 ** Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dhburns_dhburns.p.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]