mySQL Error (1055): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'winia_newbranchdb.c.permalink' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Error occurred while running query:
SELECT DISTINCT(m.subtitle), c.permalink AS categoria FROM models m , categorys c WHERE m.id_products =4 AND c.id_category = m.id_category AND m.is_deleted = 0 AND m.is_active = 1 GROUP BY m.subtitle mySQL Error (1055): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'winia_newbranchdb.c.permalink' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Error occurred while running query:
SELECT DISTINCT(m.color), c.permalink AS categoria FROM models m , categorys c WHERE m.id_products =4 AND c.id_category = m.id_category AND m.is_deleted = 0 AND m.is_active = 1 AND m.color!='' GROUP BY m.color Winia Electronics México
 
Productos