Animations






 
WindWalker Debug [namespace: Windwalker]: 
Windwalker 0.000 seconds (0.000); 19.41 MB (19.414) - SELECT MIN(`repetition`.`start_date`) AS `min_start_date`,MAX(`repetition`.`end_date`) AS `max_end_date`,MIN(`repetition`.`start_date`) AS `repetition_min_start_date`,MAX(`repetition`.`end_date`) AS `repetition_max_end_date`,COUNT(`repetition`.`id`) AS `repetition_count`,`event`.`id` AS `id`,`event`.`asset_id` AS `asset_id`,`event`.`catid` AS `catid`,`event`.`title` AS `title`,`event`.`type` AS `type`,`event`.`alias` AS `alias`,`event`.`introtext` AS `introtext`,`event`.`fulltext` AS `fulltext`,`event`.`additionalcontent` AS `additionalcontent`,`event`.`additionalcontent2` AS `additionalcontent2`,`event`.`images` AS `images`,`event`.`version` AS `version`,`event`.`created` AS `created`,`event`.`created_by` AS `created_by`,`event`.`modified` AS `modified`,`event`.`modified_by` AS `modified_by`,`event`.`state` AS `state`,`event`.`checked_out` AS `checked_out`,`event`.`checked_out_time` AS `checked_out_time`,`event`.`access` AS `access`,`event`.`featured` AS `featured`,`event`.`language` AS `language`,`event`.`params` AS `params`,`event`.`metakey` AS `metakey`,`event`.`metadesc` AS `metadesc`,`event`.`personalcss` AS `personalcss`,`category`.`id` AS `category_id`,`category`.`asset_id` AS `category_asset_id`,`category`.`parent_id` AS `category_parent_id`,`category`.`lft` AS `category_lft`,`category`.`rgt` AS `category_rgt`,`category`.`level` AS `category_level`,`category`.`path` AS `category_path`,`category`.`extension` AS `category_extension`,`category`.`title` AS `category_title`,`category`.`alias` AS `category_alias`,`category`.`note` AS `category_note`,`category`.`description` AS `category_description`,`category`.`published` AS `category_published`,`category`.`checked_out` AS `category_checked_out`,`category`.`checked_out_time` AS `category_checked_out_time`,`category`.`access` AS `category_access`,`category`.`params` AS `category_params`,`category`.`metadesc` AS `category_metadesc`,`category`.`metakey` AS `category_metakey`,`category`.`metadata` AS `category_metadata`,`category`.`created_user_id` AS `category_created_user_id`,`category`.`created_time` AS `category_created_time`,`category`.`modified_user_id` AS `category_modified_user_id`,`category`.`modified_time` AS `category_modified_time`,`category`.`hits` AS `category_hits`,`category`.`language` AS `category_language`,`category`.`version` AS `category_version`,`repetition`.`id` AS `repetition_id`,`repetition`.`asset_id` AS `repetition_asset_id`,`repetition`.`event_id` AS `repetition_event_id`,`repetition`.`location_type` AS `repetition_location_type`,`repetition`.`location_depot_id` AS `repetition_location_depot_id`,`repetition`.`location_library_id` AS `repetition_location_library_id`,`repetition`.`slots` AS `repetition_slots`,`repetition`.`audience_id` AS `repetition_audience_id`,`repetition`.`sector_id` AS `repetition_sector_id`,`repetition`.`access_condition` AS `repetition_access_condition`,`repetition`.`description` AS `repetition_description`,`repetition`.`start_date` AS `repetition_start_date`,`repetition`.`end_date` AS `repetition_end_date`,`repetition`.`use_time` AS `repetition_use_time`,`repetition`.`recurrence` AS `repetition_recurrence`,`repetition`.`recurrence_parent_id` AS `repetition_recurrence_parent_id`,`repetition`.`recurrence_interval` AS `repetition_recurrence_interval`,`repetition`.`recurrence_freq` AS `repetition_recurrence_freq`,`repetition`.`recurrence_byday` AS `repetition_recurrence_byday`,`repetition`.`recurrence_end` AS `repetition_recurrence_end`,`repetition`.`recurrence_until` AS `repetition_recurrence_until`,`repetition`.`recurrence_count` AS `repetition_recurrence_count`,`repetition`.`duration` AS `repetition_duration`,`repetition`.`created` AS `repetition_created`,`repetition`.`created_by` AS `repetition_created_by`,`repetition`.`modified` AS `repetition_modified`,`repetition`.`modified_by` AS `repetition_modified_by`,`repetition`.`state` AS `repetition_state`,`repetition`.`publish_up` AS `repetition_publish_up`,`repetition`.`publish_down` AS `repetition_publish_down`,`repetition`.`checked_out` AS `repetition_checked_out`,`repetition`.`checked_out_time` AS `repetition_checked_out_time`,`repetition`.`access` AS `repetition_access`,`repetition`.`language` AS `repetition_language`,`repetition`.`params` AS `repetition_params`,`repetition`.`ordering` AS `repetition_ordering`,`audience`.`id` AS `audience_id`,`audience`.`asset_id` AS `audience_asset_id`,`audience`.`age_min` AS `audience_age_min`,`audience`.`age_max` AS `audience_age_max`,`audience`.`title` AS `audience_title`,`audience`.`alias` AS `audience_alias`,`audience`.`created` AS `audience_created`,`audience`.`created_by` AS `audience_created_by`,`audience`.`modified` AS `audience_modified`,`audience`.`modified_by` AS `audience_modified_by`,`audience`.`ordering` AS `audience_ordering`,`audience`.`state` AS `audience_state`,`audience`.`checked_out` AS `audience_checked_out`,`audience`.`checked_out_time` AS `audience_checked_out_time`,`audience`.`access` AS `audience_access`,`audience`.`language` AS `audience_language`,`audience`.`params` AS `audience_params`,`sector`.`id` AS `sector_id`,`sector`.`asset_id` AS `sector_asset_id`,`sector`.`title` AS `sector_title`,`sector`.`alias` AS `sector_alias`,`sector`.`created` AS `sector_created`,`sector`.`created_by` AS `sector_created_by`,`sector`.`modified` AS `sector_modified`,`sector`.`modified_by` AS `sector_modified_by`,`sector`.`ordering` AS `sector_ordering`,`sector`.`state` AS `sector_state`,`sector`.`checked_out` AS `sector_checked_out`,`sector`.`checked_out_time` AS `sector_checked_out_time`,`sector`.`access` AS `sector_access`,`sector`.`language` AS `sector_language`,`sector`.`params` AS `sector_params`,`location_library`.`id` AS `location_library_id`,`location_library`.`asset_id` AS `location_library_asset_id`,`location_library`.`title` AS `location_library_title`,`location_library`.`alias` AS `location_library_alias`,`location_library`.`email` AS `location_library_email`,`location_library`.`phone` AS `location_library_phone`,`location_library`.`mobile` AS `location_library_mobile`,`location_library`.`fax` AS `location_library_fax`,`location_library`.`website` AS `location_library_website`,`location_library`.`facebook` AS `location_library_facebook`,`location_library`.`instagram` AS `location_library_instagram`,`location_library`.`youtube` AS `location_library_youtube`,`location_library`.`latitude` AS `location_library_latitude`,`location_library`.`longitude` AS `location_library_longitude`,`location_library`.`street_address` AS `location_library_street_address`,`location_library`.`postal_code` AS `location_library_postal_code`,`location_library`.`po_box_number` AS `location_library_po_box_number`,`location_library`.`locality` AS `location_library_locality`,`location_library`.`region` AS `location_library_region`,`location_library`.`country` AS `location_library_country`,`location_library`.`introtext` AS `location_library_introtext`,`location_library`.`moreinfos` AS `location_library_moreinfos`,`location_library`.`images` AS `location_library_images`,`location_library`.`created` AS `location_library_created`,`location_library`.`created_by` AS `location_library_created_by`,`location_library`.`modified` AS `location_library_modified`,`location_library`.`modified_by` AS `location_library_modified_by`,`location_library`.`ordering` AS `location_library_ordering`,`location_library`.`state` AS `location_library_state`,`location_library`.`checked_out` AS `location_library_checked_out`,`location_library`.`checked_out_time` AS `location_library_checked_out_time`,`location_library`.`access` AS `location_library_access`,`location_library`.`params` AS `location_library_params`,`location_library`.`affluences_counter_token` AS `location_library_affluences_counter_token`,`location_library`.`affluences_timetable_token` AS `location_library_affluences_timetable_token`,`location_library`.`show_on_map` AS `location_library_show_on_map`,`location_library`.`map_marker_params` AS `location_library_map_marker_params`,`location_library`.`menuitem_detail` AS `location_library_menuitem_detail`,`user`.`id` AS `user_id`,`user`.`name` AS `user_name`,`user`.`username` AS `user_username`,`user`.`email` AS `user_email`,`user`.`password` AS `user_password`,`user`.`block` AS `user_block`,`user`.`sendEmail` AS `user_sendEmail`,`user`.`registerDate` AS `user_registerDate`,`user`.`lastvisitDate` AS `user_lastvisitDate`,`user`.`activation` AS `user_activation`,`user`.`params` AS `user_params`,`user`.`lastResetTime` AS `user_lastResetTime`,`user`.`resetCount` AS `user_resetCount`,`user`.`otpKey` AS `user_otpKey`,`user`.`otep` AS `user_otep`,`user`.`requireReset` AS `user_requireReset`,`user`.`authProvider` AS `user_authProvider`,`viewlevel`.`id` AS `viewlevel_id`,`viewlevel`.`title` AS `viewlevel_title`,`viewlevel`.`ordering` AS `viewlevel_ordering`,`viewlevel`.`rules` AS `viewlevel_rules`,`lang`.`lang_id` AS `lang_lang_id`,`lang`.`asset_id` AS `lang_asset_id`,`lang`.`lang_code` AS `lang_lang_code`,`lang`.`title` AS `lang_title`,`lang`.`title_native` AS `lang_title_native`,`lang`.`sef` AS `lang_sef`,`lang`.`image` AS `lang_image`,`lang`.`description` AS `lang_description`,`lang`.`metakey` AS `lang_metakey`,`lang`.`metadesc` AS `lang_metadesc`,`lang`.`sitename` AS `lang_sitename`,`lang`.`published` AS `lang_published`,`lang`.`access` AS `lang_access`,`lang`.`ordering` AS `lang_ordering`,`location_depot`.`id` AS `location_depot_id`,`location_depot`.`nom` AS `location_depot_nom`,`location_depot`.`adresse1` AS `location_depot_adresse1`,`location_depot`.`adresse2` AS `location_depot_adresse2`,`location_depot`.`cp` AS `location_depot_cp`,`location_depot`.`ville` AS `location_depot_ville`,`location_depot`.`longitude` AS `location_depot_longitude`,`location_depot`.`lattitude` AS `location_depot_lattitude`,`location_depot`.`altitude` AS `location_depot_altitude`,`location_depot`.`status` AS `location_depot_status`,`location_depot`.`lun` AS `location_depot_lun`,`location_depot`.`mar` AS `location_depot_mar`,`location_depot`.`mer` AS `location_depot_mer`,`location_depot`.`jeu` AS `location_depot_jeu`,`location_depot`.`ven` AS `location_depot_ven`,`location_depot`.`sam` AS `location_depot_sam`,`location_depot`.`id_depot` AS `location_depot_id_depot`,`location_depot`.`published` AS `location_depot_published`,`location_depot`.`type_depot` AS `location_depot_type_depot`,`location_depot`.`presentation` AS `location_depot_presentation`,`location_depot`.`published_annuaire` AS `location_depot_published_annuaire`,`location_depot`.`published_events` AS `location_depot_published_events`,`location_depot`.`published_resas_not_log` AS `location_depot_published_resas_not_log`,`location_depot`.`user_id` AS `location_depot_user_id`

  FROM `x03fi_c3rbevenement_events` AS `event`

  LEFT JOIN `x03fi_categories` AS `category` 
  ON event.catid = category.id

  LEFT JOIN `x03fi_c3rbevenement_repetitions` AS `repetition` 
  ON event.id = repetition.event_id

  LEFT JOIN `x03fi_c3rbevenement_audiences` AS `audience` 
  ON repetition.audience_id = audience.id

  LEFT JOIN `x03fi_c3rbevenement_sectors` AS `sector` 
  ON repetition.sector_id = sector.id

  LEFT JOIN `x03fi_c3rbevenement_libraries` AS `location_library` 
  ON repetition.location_library_id = location_library.id

  LEFT JOIN `x03fi_users` AS `user` 
  ON event.created_by = user.id

  LEFT JOIN `x03fi_viewlevels` AS `viewlevel` 
  ON event.access = viewlevel.id

  LEFT JOIN `x03fi_languages` AS `lang` 
  ON event.language = lang.lang_code

  LEFT JOIN `x03fi_opac_carte_depots` AS `location_depot` 
  ON repetition.location_depot_id = location_depot.id

  WHERE `repetition`.`state` > 0 
  AND (`repetition`.`end_date` > NOW()) 
  AND (event.catid = 1 OR event.catid IN (
SELECT sub.id

  FROM x03fi_categories as sub

  INNER JOIN x03fi_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 1)) 
  AND event.state > 0 
  AND (repetition.publish_up = '0000-00-00 00:00:00' OR repetition.publish_up <= '2025-05-16 17:44:33') 
  AND (repetition.publish_down = '0000-00-00 00:00:00' OR repetition.publish_down >= '2025-05-16 17:44:33') 
  AND repetition.state > 0 
  AND event.access 
IN(1,1,5)

  GROUP BY event.id,`event`.`id`

  ORDER BY min_start_date ASC


Windwalker 0.001 seconds (0.001); 19.51 MB (0.095) - SELECT MIN(`repetition`.`start_date`) AS `min_start_date`,MAX(`repetition`.`end_date`) AS `max_end_date`,MIN(`repetition`.`start_date`) AS `repetition_min_start_date`,MAX(`repetition`.`end_date`) AS `repetition_max_end_date`,COUNT(`repetition`.`id`) AS `repetition_count`,`event`.`id` AS `id`,`event`.`asset_id` AS `asset_id`,`event`.`catid` AS `catid`,`event`.`title` AS `title`,`event`.`type` AS `type`,`event`.`alias` AS `alias`,`event`.`introtext` AS `introtext`,`event`.`fulltext` AS `fulltext`,`event`.`additionalcontent` AS `additionalcontent`,`event`.`additionalcontent2` AS `additionalcontent2`,`event`.`images` AS `images`,`event`.`version` AS `version`,`event`.`created` AS `created`,`event`.`created_by` AS `created_by`,`event`.`modified` AS `modified`,`event`.`modified_by` AS `modified_by`,`event`.`state` AS `state`,`event`.`checked_out` AS `checked_out`,`event`.`checked_out_time` AS `checked_out_time`,`event`.`access` AS `access`,`event`.`featured` AS `featured`,`event`.`language` AS `language`,`event`.`params` AS `params`,`event`.`metakey` AS `metakey`,`event`.`metadesc` AS `metadesc`,`event`.`personalcss` AS `personalcss`,`category`.`id` AS `category_id`,`category`.`asset_id` AS `category_asset_id`,`category`.`parent_id` AS `category_parent_id`,`category`.`lft` AS `category_lft`,`category`.`rgt` AS `category_rgt`,`category`.`level` AS `category_level`,`category`.`path` AS `category_path`,`category`.`extension` AS `category_extension`,`category`.`title` AS `category_title`,`category`.`alias` AS `category_alias`,`category`.`note` AS `category_note`,`category`.`description` AS `category_description`,`category`.`published` AS `category_published`,`category`.`checked_out` AS `category_checked_out`,`category`.`checked_out_time` AS `category_checked_out_time`,`category`.`access` AS `category_access`,`category`.`params` AS `category_params`,`category`.`metadesc` AS `category_metadesc`,`category`.`metakey` AS `category_metakey`,`category`.`metadata` AS `category_metadata`,`category`.`created_user_id` AS `category_created_user_id`,`category`.`created_time` AS `category_created_time`,`category`.`modified_user_id` AS `category_modified_user_id`,`category`.`modified_time` AS `category_modified_time`,`category`.`hits` AS `category_hits`,`category`.`language` AS `category_language`,`category`.`version` AS `category_version`,`repetition`.`id` AS `repetition_id`,`repetition`.`asset_id` AS `repetition_asset_id`,`repetition`.`event_id` AS `repetition_event_id`,`repetition`.`location_type` AS `repetition_location_type`,`repetition`.`location_depot_id` AS `repetition_location_depot_id`,`repetition`.`location_library_id` AS `repetition_location_library_id`,`repetition`.`slots` AS `repetition_slots`,`repetition`.`audience_id` AS `repetition_audience_id`,`repetition`.`sector_id` AS `repetition_sector_id`,`repetition`.`access_condition` AS `repetition_access_condition`,`repetition`.`description` AS `repetition_description`,`repetition`.`start_date` AS `repetition_start_date`,`repetition`.`end_date` AS `repetition_end_date`,`repetition`.`use_time` AS `repetition_use_time`,`repetition`.`recurrence` AS `repetition_recurrence`,`repetition`.`recurrence_parent_id` AS `repetition_recurrence_parent_id`,`repetition`.`recurrence_interval` AS `repetition_recurrence_interval`,`repetition`.`recurrence_freq` AS `repetition_recurrence_freq`,`repetition`.`recurrence_byday` AS `repetition_recurrence_byday`,`repetition`.`recurrence_end` AS `repetition_recurrence_end`,`repetition`.`recurrence_until` AS `repetition_recurrence_until`,`repetition`.`recurrence_count` AS `repetition_recurrence_count`,`repetition`.`duration` AS `repetition_duration`,`repetition`.`created` AS `repetition_created`,`repetition`.`created_by` AS `repetition_created_by`,`repetition`.`modified` AS `repetition_modified`,`repetition`.`modified_by` AS `repetition_modified_by`,`repetition`.`state` AS `repetition_state`,`repetition`.`publish_up` AS `repetition_publish_up`,`repetition`.`publish_down` AS `repetition_publish_down`,`repetition`.`checked_out` AS `repetition_checked_out`,`repetition`.`checked_out_time` AS `repetition_checked_out_time`,`repetition`.`access` AS `repetition_access`,`repetition`.`language` AS `repetition_language`,`repetition`.`params` AS `repetition_params`,`repetition`.`ordering` AS `repetition_ordering`,`audience`.`id` AS `audience_id`,`audience`.`asset_id` AS `audience_asset_id`,`audience`.`age_min` AS `audience_age_min`,`audience`.`age_max` AS `audience_age_max`,`audience`.`title` AS `audience_title`,`audience`.`alias` AS `audience_alias`,`audience`.`created` AS `audience_created`,`audience`.`created_by` AS `audience_created_by`,`audience`.`modified` AS `audience_modified`,`audience`.`modified_by` AS `audience_modified_by`,`audience`.`ordering` AS `audience_ordering`,`audience`.`state` AS `audience_state`,`audience`.`checked_out` AS `audience_checked_out`,`audience`.`checked_out_time` AS `audience_checked_out_time`,`audience`.`access` AS `audience_access`,`audience`.`language` AS `audience_language`,`audience`.`params` AS `audience_params`,`sector`.`id` AS `sector_id`,`sector`.`asset_id` AS `sector_asset_id`,`sector`.`title` AS `sector_title`,`sector`.`alias` AS `sector_alias`,`sector`.`created` AS `sector_created`,`sector`.`created_by` AS `sector_created_by`,`sector`.`modified` AS `sector_modified`,`sector`.`modified_by` AS `sector_modified_by`,`sector`.`ordering` AS `sector_ordering`,`sector`.`state` AS `sector_state`,`sector`.`checked_out` AS `sector_checked_out`,`sector`.`checked_out_time` AS `sector_checked_out_time`,`sector`.`access` AS `sector_access`,`sector`.`language` AS `sector_language`,`sector`.`params` AS `sector_params`,`location_library`.`id` AS `location_library_id`,`location_library`.`asset_id` AS `location_library_asset_id`,`location_library`.`title` AS `location_library_title`,`location_library`.`alias` AS `location_library_alias`,`location_library`.`email` AS `location_library_email`,`location_library`.`phone` AS `location_library_phone`,`location_library`.`mobile` AS `location_library_mobile`,`location_library`.`fax` AS `location_library_fax`,`location_library`.`website` AS `location_library_website`,`location_library`.`facebook` AS `location_library_facebook`,`location_library`.`instagram` AS `location_library_instagram`,`location_library`.`youtube` AS `location_library_youtube`,`location_library`.`latitude` AS `location_library_latitude`,`location_library`.`longitude` AS `location_library_longitude`,`location_library`.`street_address` AS `location_library_street_address`,`location_library`.`postal_code` AS `location_library_postal_code`,`location_library`.`po_box_number` AS `location_library_po_box_number`,`location_library`.`locality` AS `location_library_locality`,`location_library`.`region` AS `location_library_region`,`location_library`.`country` AS `location_library_country`,`location_library`.`introtext` AS `location_library_introtext`,`location_library`.`moreinfos` AS `location_library_moreinfos`,`location_library`.`images` AS `location_library_images`,`location_library`.`created` AS `location_library_created`,`location_library`.`created_by` AS `location_library_created_by`,`location_library`.`modified` AS `location_library_modified`,`location_library`.`modified_by` AS `location_library_modified_by`,`location_library`.`ordering` AS `location_library_ordering`,`location_library`.`state` AS `location_library_state`,`location_library`.`checked_out` AS `location_library_checked_out`,`location_library`.`checked_out_time` AS `location_library_checked_out_time`,`location_library`.`access` AS `location_library_access`,`location_library`.`params` AS `location_library_params`,`location_library`.`affluences_counter_token` AS `location_library_affluences_counter_token`,`location_library`.`affluences_timetable_token` AS `location_library_affluences_timetable_token`,`location_library`.`show_on_map` AS `location_library_show_on_map`,`location_library`.`map_marker_params` AS `location_library_map_marker_params`,`location_library`.`menuitem_detail` AS `location_library_menuitem_detail`,`user`.`id` AS `user_id`,`user`.`name` AS `user_name`,`user`.`username` AS `user_username`,`user`.`email` AS `user_email`,`user`.`password` AS `user_password`,`user`.`block` AS `user_block`,`user`.`sendEmail` AS `user_sendEmail`,`user`.`registerDate` AS `user_registerDate`,`user`.`lastvisitDate` AS `user_lastvisitDate`,`user`.`activation` AS `user_activation`,`user`.`params` AS `user_params`,`user`.`lastResetTime` AS `user_lastResetTime`,`user`.`resetCount` AS `user_resetCount`,`user`.`otpKey` AS `user_otpKey`,`user`.`otep` AS `user_otep`,`user`.`requireReset` AS `user_requireReset`,`user`.`authProvider` AS `user_authProvider`,`viewlevel`.`id` AS `viewlevel_id`,`viewlevel`.`title` AS `viewlevel_title`,`viewlevel`.`ordering` AS `viewlevel_ordering`,`viewlevel`.`rules` AS `viewlevel_rules`,`lang`.`lang_id` AS `lang_lang_id`,`lang`.`asset_id` AS `lang_asset_id`,`lang`.`lang_code` AS `lang_lang_code`,`lang`.`title` AS `lang_title`,`lang`.`title_native` AS `lang_title_native`,`lang`.`sef` AS `lang_sef`,`lang`.`image` AS `lang_image`,`lang`.`description` AS `lang_description`,`lang`.`metakey` AS `lang_metakey`,`lang`.`metadesc` AS `lang_metadesc`,`lang`.`sitename` AS `lang_sitename`,`lang`.`published` AS `lang_published`,`lang`.`access` AS `lang_access`,`lang`.`ordering` AS `lang_ordering`,`location_depot`.`id` AS `location_depot_id`,`location_depot`.`nom` AS `location_depot_nom`,`location_depot`.`adresse1` AS `location_depot_adresse1`,`location_depot`.`adresse2` AS `location_depot_adresse2`,`location_depot`.`cp` AS `location_depot_cp`,`location_depot`.`ville` AS `location_depot_ville`,`location_depot`.`longitude` AS `location_depot_longitude`,`location_depot`.`lattitude` AS `location_depot_lattitude`,`location_depot`.`altitude` AS `location_depot_altitude`,`location_depot`.`status` AS `location_depot_status`,`location_depot`.`lun` AS `location_depot_lun`,`location_depot`.`mar` AS `location_depot_mar`,`location_depot`.`mer` AS `location_depot_mer`,`location_depot`.`jeu` AS `location_depot_jeu`,`location_depot`.`ven` AS `location_depot_ven`,`location_depot`.`sam` AS `location_depot_sam`,`location_depot`.`id_depot` AS `location_depot_id_depot`,`location_depot`.`published` AS `location_depot_published`,`location_depot`.`type_depot` AS `location_depot_type_depot`,`location_depot`.`presentation` AS `location_depot_presentation`,`location_depot`.`published_annuaire` AS `location_depot_published_annuaire`,`location_depot`.`published_events` AS `location_depot_published_events`,`location_depot`.`published_resas_not_log` AS `location_depot_published_resas_not_log`,`location_depot`.`user_id` AS `location_depot_user_id`

  FROM `x03fi_c3rbevenement_events` AS `event`

  LEFT JOIN `x03fi_categories` AS `category` 
  ON event.catid = category.id

  LEFT JOIN `x03fi_c3rbevenement_repetitions` AS `repetition` 
  ON event.id = repetition.event_id

  LEFT JOIN `x03fi_c3rbevenement_audiences` AS `audience` 
  ON repetition.audience_id = audience.id

  LEFT JOIN `x03fi_c3rbevenement_sectors` AS `sector` 
  ON repetition.sector_id = sector.id

  LEFT JOIN `x03fi_c3rbevenement_libraries` AS `location_library` 
  ON repetition.location_library_id = location_library.id

  LEFT JOIN `x03fi_users` AS `user` 
  ON event.created_by = user.id

  LEFT JOIN `x03fi_viewlevels` AS `viewlevel` 
  ON event.access = viewlevel.id

  LEFT JOIN `x03fi_languages` AS `lang` 
  ON event.language = lang.lang_code

  LEFT JOIN `x03fi_opac_carte_depots` AS `location_depot` 
  ON repetition.location_depot_id = location_depot.id

  WHERE `repetition`.`state` > 0 
  AND (`repetition`.`end_date` > NOW()) 
  AND (event.catid = 1 OR event.catid IN (
SELECT sub.id

  FROM x03fi_categories as sub

  INNER JOIN x03fi_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 1)) 
  AND event.state > 0 
  AND (repetition.publish_up = '0000-00-00 00:00:00' OR repetition.publish_up <= '2025-05-16 17:44:33') 
  AND (repetition.publish_down = '0000-00-00 00:00:00' OR repetition.publish_down >= '2025-05-16 17:44:33') 
  AND repetition.state > 0 
  AND event.access 
IN(1,1,5)

  GROUP BY event.id,`event`.`id`

  ORDER BY min_start_date ASC