Association des Étudiants aux Cycles Supérieurs

Événements à venir

string(1572) "SELECT SQL_CALC_FOUND_ROWS DISTINCT aecs_posts.*, MIN(aecs_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM aecs_posts  INNER JOIN aecs_postmeta ON ( aecs_posts.ID = aecs_postmeta.post_id ) JOIN aecs_icl_translations t
							ON aecs_posts.ID = t.element_id
								AND t.element_type = CONCAT('post_', aecs_posts.post_type)  LEFT JOIN aecs_postmeta as tribe_event_end_date ON ( aecs_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDate' )  WHERE 1=1  AND ( 
  aecs_postmeta.meta_key = '_EventStartDate'
) AND aecs_posts.post_type = 'tribe_events' AND (aecs_posts.post_status = 'publish' OR aecs_posts.post_status = 'tribe-ea-success' OR aecs_posts.post_status = 'tribe-ea-failed' OR aecs_posts.post_status = 'tribe-ea-schedule' OR aecs_posts.post_status = 'tribe-ea-pending' OR aecs_posts.post_status = 'tribe-ea-draft') AND ( ( t.language_code = 'fr' AND aecs_posts.post_type  IN ('post','page','attachment','custom_css','customize_changeset','acf','tribe_venue','tribe_organizer','tribe_events','tribe-ea-record','deleted_event' )  ) OR aecs_posts.post_type  NOT  IN ('post','page','attachment','custom_css','customize_changeset','acf','tribe_venue','tribe_organizer','tribe_events','tribe-ea-record','deleted_event' )  ) AND (aecs_postmeta.meta_value >= '2017-10-21 00:34:11' OR (aecs_postmeta.meta_value <= '2017-10-21 00:34:11' AND tribe_event_end_date.meta_value >= '2017-10-21 00:34:11' )) GROUP BY aecs_posts.ID ORDER BY EventStartDate ASC, aecs_posts.post_date ASC LIMIT 0, 3"