Err No : 1055, detail : Expression #33 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'technoplast.g.group_name_en' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT SQL_CALC_FOUND_ROWS p.*, g.group_name_en, g.group_name_id, g.uri_en AS group_uri_en, g.uri_id AS group_uri_id, c.uri_en AS category_uri_en, c.uri_id AS category_uri_id, MATCH(p.product_name_id, p.keywords_id) AGAINST ('* * s* se*') AS score FROM products p LEFT JOIN product_groups pg ON pg.product_id=p.product_id LEFT JOIN groups g ON g.group_id=pg.group_id LEFT JOIN categories c ON c.category_id=g.category_id LEFT JOIN product_styles ps ON ps.product_id=p.product_id WHERE MATCH(p.product_name_id, p.keywords_id) AGAINST ('* * s* se*' IN BOOLEAN MODE) AND p.published=1 GROUP BY p.product_id ORDER BY score, product_name_id LIMIT 0, 12