Ошибка при обращении к БД:
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ac.f.date_change' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Запрос:
SELECT c.`id`, c.`is_sale`, c.`cover_name`, c.`cover_ext`, c.`collection_id`, c.`num`, c.`prefix_code`, c.`clean_code`, c.`name`, c.`title`, c.`price`, c.`price_nominal`, s.`count` FROM favourites AS f, catalogue AS c LEFT JOIN catalogue_stock AS s ON ( c.`id` = s.`item_id` ) WHERE f.`item_id` = c.`id` AND f.`session_id` = '67edf468053c63.07725193' GROUP BY f.`item_id` ORDER BY f.`date_change` DESC