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 IN(7,3)
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 IN(7,3)
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
