Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'roshenst_db.catalog_i18n.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [ SELECT `catalog`.`id`, `catalog`.`cost`, `catalog_i18n`.`name`, `catalog_i18n`.`vaga`, `catalog`.`alias`, `catalog`.`image`, `catalog`.`image_second`, `catalog`.`specifications`, `catalog`.`sale`, `catalog`.`new`, `catalog`.`sale_percent`, `catalog`.`sale_end`, `catalog`.`exclusive` FROM `catalog` JOIN `catalog_i18n` ON (`catalog`.`id` = `catalog_i18n`.`row_id`) WHERE `catalog_i18n`.`language` = 'ua' AND `catalog`.`status` = 1 AND `catalog`.`parent_id` IN ('71') GROUP BY `catalog`.`id` ORDER BY `catalog`.`sort` ASC ]