Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lamarel_main.cms_module_cgcalendar_events.event_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by DEBUG: query failed: SELECT COUNT(*) FROM (SELECT cms_module_cgcalendar_events.* FROM cms_module_cgcalendar_events INNER JOIN cms_module_cgcalendar_events_to_categories ON cms_module_cgcalendar_events.event_id = cms_module_cgcalendar_events_to_categories.event_id INNER JOIN cms_module_cgcalendar_categories ON cms_module_cgcalendar_events_to_categories.category_id = cms_module_cgcalendar_categories.category_id WHERE (cms_module_cgcalendar_events.event_date_start >= '2018-08-14 04:29:33' OR (cms_module_cgcalendar_events.event_date_end >= '2018-08-14 04:29:33' AND COALESCE(cms_module_cgcalendar_events.event_date_end,'0000-00-00 00:00:00') != '0000-00-00 00:00:00')) AND ((cms_module_cgcalendar_categories.category_name LIKE 'cinema')) GROUP BY cms_module_cgcalendar_events.event_title) AS sub LIMIT 1
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lamarel_main.cms_module_cgcalendar_events.event_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by DEBUG: query failed: SELECT COUNT(*) FROM (SELECT cms_module_cgcalendar_events.* FROM cms_module_cgcalendar_events INNER JOIN cms_module_cgcalendar_events_to_categories ON cms_module_cgcalendar_events.event_id = cms_module_cgcalendar_events_to_categories.event_id INNER JOIN cms_module_cgcalendar_categories ON cms_module_cgcalendar_events_to_categories.category_id = cms_module_cgcalendar_categories.category_id WHERE (cms_module_cgcalendar_events.event_date_start >= '2018-08-14 04:29:33' OR (cms_module_cgcalendar_events.event_date_end >= '2018-08-14 04:29:33' AND COALESCE(cms_module_cgcalendar_events.event_date_end,'0000-00-00 00:00:00') != '0000-00-00 00:00:00')) AND ((cms_module_cgcalendar_categories.category_name LIKE 'arts visuels')) GROUP BY cms_module_cgcalendar_events.event_title) AS sub LIMIT 1
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lamarel_main.cms_module_cgcalendar_events.event_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by DEBUG: query failed: SELECT COUNT(*) FROM (SELECT cms_module_cgcalendar_events.* FROM cms_module_cgcalendar_events INNER JOIN cms_module_cgcalendar_events_to_categories ON cms_module_cgcalendar_events.event_id = cms_module_cgcalendar_events_to_categories.event_id INNER JOIN cms_module_cgcalendar_categories ON cms_module_cgcalendar_events_to_categories.category_id = cms_module_cgcalendar_categories.category_id WHERE (cms_module_cgcalendar_events.event_date_start >= '2018-08-14 04:29:33' OR (cms_module_cgcalendar_events.event_date_end >= '2018-08-14 04:29:33' AND COALESCE(cms_module_cgcalendar_events.event_date_end,'0000-00-00 00:00:00') != '0000-00-00 00:00:00')) AND ((cms_module_cgcalendar_categories.category_name LIKE 'musique')) GROUP BY cms_module_cgcalendar_events.event_title) AS sub LIMIT 1
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lamarel_main.cms_module_cgcalendar_events.event_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by DEBUG: query failed: SELECT COUNT(*) FROM (SELECT cms_module_cgcalendar_events.* FROM cms_module_cgcalendar_events INNER JOIN cms_module_cgcalendar_events_to_categories ON cms_module_cgcalendar_events.event_id = cms_module_cgcalendar_events_to_categories.event_id INNER JOIN cms_module_cgcalendar_categories ON cms_module_cgcalendar_events_to_categories.category_id = cms_module_cgcalendar_categories.category_id WHERE (cms_module_cgcalendar_events.event_date_start >= '2018-08-14 04:29:33' OR (cms_module_cgcalendar_events.event_date_end >= '2018-08-14 04:29:33' AND COALESCE(cms_module_cgcalendar_events.event_date_end,'0000-00-00 00:00:00') != '0000-00-00 00:00:00')) AND ((cms_module_cgcalendar_categories.category_name LIKE 'architecture-design')) GROUP BY cms_module_cgcalendar_events.event_title) AS sub LIMIT 1
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lamarel_main.cms_module_cgcalendar_events.event_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by DEBUG: query failed: SELECT COUNT(*) FROM (SELECT cms_module_cgcalendar_events.* FROM cms_module_cgcalendar_events INNER JOIN cms_module_cgcalendar_events_to_categories ON cms_module_cgcalendar_events.event_id = cms_module_cgcalendar_events_to_categories.event_id INNER JOIN cms_module_cgcalendar_categories ON cms_module_cgcalendar_events_to_categories.category_id = cms_module_cgcalendar_categories.category_id WHERE (cms_module_cgcalendar_events.event_date_start >= '2018-08-14 04:29:33' OR (cms_module_cgcalendar_events.event_date_end >= '2018-08-14 04:29:33' AND COALESCE(cms_module_cgcalendar_events.event_date_end,'0000-00-00 00:00:00') != '0000-00-00 00:00:00')) AND ((cms_module_cgcalendar_categories.category_name LIKE 'sciences-technos')) GROUP BY cms_module_cgcalendar_events.event_title) AS sub LIMIT 1
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lamarel_main.cms_module_cgcalendar_events.event_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by DEBUG: query failed: SELECT COUNT(*) FROM (SELECT cms_module_cgcalendar_events.* FROM cms_module_cgcalendar_events INNER JOIN cms_module_cgcalendar_events_to_categories ON cms_module_cgcalendar_events.event_id = cms_module_cgcalendar_events_to_categories.event_id INNER JOIN cms_module_cgcalendar_categories ON cms_module_cgcalendar_events_to_categories.category_id = cms_module_cgcalendar_categories.category_id WHERE (cms_module_cgcalendar_events.event_date_start >= '2018-08-14 04:29:33' OR (cms_module_cgcalendar_events.event_date_end >= '2018-08-14 04:29:33' AND COALESCE(cms_module_cgcalendar_events.event_date_end,'0000-00-00 00:00:00') != '0000-00-00 00:00:00')) AND ((cms_module_cgcalendar_categories.category_name LIKE 'evenements familiaux')) GROUP BY cms_module_cgcalendar_events.event_title) AS sub LIMIT 1
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lamarel_main.cms_module_cgcalendar_events.event_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by