Error: Expression #35 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'madatagr_katalogos.t9.path' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path` , '0' `id_editor_edit` FROM `dir_links` t1 LEFT JOIN `dir_link_categories` t8 ON t1.`id` = t8.`id_link` AND t8.`crossed` = '0' LEFT JOIN `dir_categories` t9 ON t8.`id_category` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' GROUP BY t1.`id` ORDER BY t1.`date` DESC LIMIT 0, 4