SELECT DISTINCT `jos_emundus_setup_programmes`.`id` AS `jos_emundus_setup_programmes___id`,
`jos_emundus_setup_programmes`.`id` AS `jos_emundus_setup_programmes___id_raw`,
`jos_emundus_setup_programmes`.`label` AS `jos_emundus_setup_programmes___label`,
`jos_emundus_setup_programmes`.`label` AS `jos_emundus_setup_programmes___label_raw`,
`jos_emundus_setup_programmes`.`programmes` AS `jos_emundus_setup_programmes___programmes_raw`,
`jos_emundus_setup_thematiques_0`.`label` AS `jos_emundus_setup_programmes___programmes`,
`jos_emundus_setup_programmes`.`code` AS `jos_emundus_setup_programmes___code`,
`jos_emundus_setup_programmes`.`code` AS `jos_emundus_setup_programmes___code_raw`,
`jos_emundus_setup_programmes`.`audience` AS `jos_emundus_setup_programmes___audience`,
`jos_emundus_setup_programmes`.`audience` AS `jos_emundus_setup_programmes___audience_raw`,
`jos_emundus_setup_programmes`.`notes` AS `jos_emundus_setup_programmes___notes`,
`jos_emundus_setup_programmes`.`notes` AS `jos_emundus_setup_programmes___notes_raw`,
`jos_emundus_setup_programmes`.`published` AS `jos_emundus_setup_programmes___published`,
`jos_emundus_setup_programmes`.`published` AS `jos_emundus_setup_programmes___published_raw`,
`jos_emundus_setup_programmes`.`content` AS `jos_emundus_setup_programmes___content`,
`jos_emundus_setup_programmes`.`content` AS `jos_emundus_setup_programmes___content_raw`,
`jos_emundus_setup_programmes`.`numcpf` AS `jos_emundus_setup_programmes___numcpf`,
`jos_emundus_setup_programmes`.`numcpf` AS `jos_emundus_setup_programmes___numcpf_raw`,
`jos_emundus_setup_programmes`.`prerequisite` AS `jos_emundus_setup_programmes___prerequisite`,
`jos_emundus_setup_programmes`.`prerequisite` AS `jos_emundus_setup_programmes___prerequisite_raw`,
`jos_emundus_setup_programmes`.`objectives` AS `jos_emundus_setup_programmes___objectives`,
`jos_emundus_setup_programmes`.`objectives` AS `jos_emundus_setup_programmes___objectives_raw`,
`jos_emundus_setup_programmes`.`partner` AS `jos_emundus_setup_programmes___partner`,
`jos_emundus_setup_programmes`.`partner` AS `jos_emundus_setup_programmes___partner_raw`,
`jos_emundus_setup_programmes`.`certificate` AS `jos_emundus_setup_programmes___certificate`,
`jos_emundus_setup_programmes`.`certificate` AS `jos_emundus_setup_programmes___certificate_raw`,
`jos_emundus_setup_programmes`.`target` AS `jos_emundus_setup_programmes___target`,
`jos_emundus_setup_programmes`.`target` AS `jos_emundus_setup_programmes___target_raw`,
`jos_emundus_setup_campaigns`.`id` AS `jos_emundus_setup_campaigns___id`,
`jos_emundus_setup_campaigns`.`id` AS `jos_emundus_setup_campaigns___id_raw`,
`jos_emundus_setup_campaigns`.`date_time` AS `jos_emundus_setup_campaigns___date_time`,
`jos_emundus_setup_campaigns`.`date_time` AS `jos_emundus_setup_campaigns___date_time_raw`,
`jos_emundus_setup_teaching_unity`.`id` AS `jos_emundus_setup_teaching_unity___id`,
`jos_emundus_setup_teaching_unity`.`id` AS `jos_emundus_setup_teaching_unity___id_raw`,
`jos_emundus_setup_teaching_unity`.`location_city` AS `jos_emundus_setup_teaching_unity___location_city`,
`jos_emundus_setup_teaching_unity`.`location_city` AS `jos_emundus_setup_teaching_unity___location_city_raw`,
`jos_emundus_setup_teaching_unity`.`label` AS `jos_emundus_setup_teaching_unity___label`,
`jos_emundus_setup_teaching_unity`.`label` AS `jos_emundus_setup_teaching_unity___label_raw`,
`jos_emundus_setup_teaching_unity`.`published` AS `jos_emundus_setup_teaching_unity___published`,
`jos_emundus_setup_teaching_unity`.`published` AS `jos_emundus_setup_teaching_unity___published_raw`,
`jos_emundus_setup_teaching_unity`.`days` AS `jos_emundus_setup_teaching_unity___days`,
`jos_emundus_setup_teaching_unity`.`days` AS `jos_emundus_setup_teaching_unity___days_raw`,
`jos_emundus_setup_teaching_unity`.`price` AS `jos_emundus_setup_teaching_unity___price`,
`jos_emundus_setup_teaching_unity`.`price` AS `jos_emundus_setup_teaching_unity___price_raw`,
`jos_emundus_setup_teaching_unity`.`date_start` AS `jos_emundus_setup_teaching_unity___date_start`,
`jos_emundus_setup_teaching_unity`.`date_start` AS `jos_emundus_setup_teaching_unity___date_start_raw`,
`jos_emundus_setup_teaching_unity`.`date_end` AS `jos_emundus_setup_teaching_unity___date_end`,
`jos_emundus_setup_teaching_unity`.`date_end` AS `jos_emundus_setup_teaching_unity___date_end_raw`,
`jos_emundus_setup_teaching_unity`.`min_occupants` AS `jos_emundus_setup_teaching_unity___min_occupants`,
`jos_emundus_setup_teaching_unity`.`min_occupants` AS `jos_emundus_setup_teaching_unity___min_occupants_raw`,
`jos_emundus_setup_teaching_unity`.`max_occupants` AS `jos_emundus_setup_teaching_unity___max_occupants`,
`jos_emundus_setup_teaching_unity`.`max_occupants` AS `jos_emundus_setup_teaching_unity___max_occupants_raw`,
`jos_emundus_setup_teaching_unity`.`occupants` AS `jos_emundus_setup_teaching_unity___occupants`,
`jos_emundus_setup_teaching_unity`.`occupants` AS `jos_emundus_setup_teaching_unity___occupants_raw`,
`jos_emundus_setup_teaching_unity`.`location_address` AS `jos_emundus_setup_teaching_unity___location_address`,
`jos_emundus_setup_teaching_unity`.`location_address` AS `jos_emundus_setup_teaching_unity___location_address_raw`,
`jos_emundus_setup_teaching_unity`.`location_zip` AS `jos_emundus_setup_teaching_unity___location_zip`,
`jos_emundus_setup_teaching_unity`.`location_zip` AS `jos_emundus_setup_teaching_unity___location_zip_raw`,
`jos_emundus_setup_teaching_unity`.`location_title` AS `jos_emundus_setup_teaching_unity___location_title`,
`jos_emundus_setup_teaching_unity`.`location_title` AS `jos_emundus_setup_teaching_unity___location_title_raw`,
`jos_emundus_setup_teaching_unity`.`tax_rate` AS `jos_emundus_setup_teaching_unity___tax_rate`,
`jos_emundus_setup_teaching_unity`.`tax_rate` AS `jos_emundus_setup_teaching_unity___tax_rate_raw`,
`jos_emundus_setup_thematiques`.`title` AS `jos_emundus_setup_thematiques___title`,
`jos_emundus_setup_thematiques`.`title` AS `jos_emundus_setup_thematiques___title_raw`,
`jos_emundus_setup_thematiques`.`color` AS `jos_emundus_setup_thematiques___color`,
`jos_emundus_setup_thematiques`.`color` AS `jos_emundus_setup_thematiques___color_raw`,
`jos_emundus_setup_thematiques`.`published` AS `jos_emundus_setup_thematiques___published`,
`jos_emundus_setup_thematiques`.`published` AS `jos_emundus_setup_thematiques___published_raw`,
`jos_emundus_setup_thematiques`.`label` AS `jos_emundus_setup_thematiques___label`,
`jos_emundus_setup_thematiques`.`label` AS `jos_emundus_setup_thematiques___label_raw`,
CONCAT_WS(':', `jos_emundus_setup_programmes`.`id`, `jos_emundus_setup_programmes`.`label`) AS slug
, `jos_emundus_setup_programmes`.`id` AS `__pk_val`
FROM `jos_emundus_setup_programmes`
LEFT JOIN `jos_emundus_setup_thematiques` AS `jos_emundus_setup_thematiques` ON `jos_emundus_setup_thematiques`.`id` = `jos_emundus_setup_programmes`.`programmes`
LEFT JOIN `jos_emundus_setup_campaigns` AS `jos_emundus_setup_campaigns` ON `jos_emundus_setup_campaigns`.`training` = `jos_emundus_setup_programmes`.`code`
LEFT JOIN `jos_emundus_setup_teaching_unity` AS `jos_emundus_setup_teaching_unity` ON `jos_emundus_setup_teaching_unity`.`session_code` = `jos_emundus_setup_campaigns`.`session_code`
LEFT JOIN `jos_emundus_setup_thematiques` AS `jos_emundus_setup_thematiques_0` ON `jos_emundus_setup_thematiques_0`.`id` = `jos_emundus_setup_programmes`.`programmes`
WHERE `jos_emundus_setup_campaigns`.`id` IN ('115','53','4','55','5','56','6','57','40','58','43','60','45','62','47','49','50','51','41','42','44','46','31','33','78','1','66','2','67','3','68','48','69','52','70','54','71','59','72','61','74','63','76','64','77','65','103','10','99','101','102','20','15','149','151','13','152','153','182','137') AND 2 = -2
ORDER BY `jos_emundus_setup_programmes`.`code` ASC