Noticias
Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'photos.image_mini' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT news.id, news.id_section, news.title, news.summary, news.date, news.important, news.video, news.author, news.version_date, COALESCE(photos.image_mini, '../upload/config/WITHOUT_IMAGE.jpg') AS 'image_mini' FROM news LEFT JOIN (SELECT photos.id_reference, REPLACE(REPLACE(REPLACE(image, '..', '#'), '.', '_mini.'), '#', '..') AS 'image_mini' FROM photos WHERE photos.table = 'news' AND photos.deleted = 0 ORDER BY photos.order) AS photos ON news.id = photos.id_reference WHERE news.version_id = 0 AND news.id_section = 109 AND news.deleted = 0 GROUP BY news.id ORDER BY news.date DESC, news.id DESC LIMIT 0, 10
-----
SELECT news.id, news.id_section, news.title, news.summary, news.date, news.important, news.video, news.author, news.version_date, COALESCE(photos.image_mini, '../upload/config/WITHOUT_IMAGE.jpg') AS 'image_mini' FROM news LEFT JOIN (SELECT photos.id_reference, REPLACE(REPLACE(REPLACE(image, '..', '#'), '.', '_mini.'), '#', '..') AS 'image_mini' FROM photos WHERE photos.table = 'news' AND photos.deleted = 0 ORDER BY photos.order) AS photos ON news.id = photos.id_reference WHERE news.version_id = 0 AND news.id_section = 109 AND news.deleted = 0 GROUP BY news.id ORDER BY news.date DESC, news.id DESC LIMIT 0, 10
-----