SELECT SQL_CALC_FOUND_ROWS DISTINCT `pg_lots`.`id` AS `pg_lots___id`, `pg_lots`.`id` AS `pg_lots___id_raw`, `pg_lots`.`date_time` AS `pg_lots___date_time`, `pg_lots`.`date_time` AS `pg_lots___date_time_raw`, `pg_lots`.`ref` AS `pg_lots___ref`, `pg_lots`.`ref` AS `pg_lots___ref_raw`, `pg_lots`.`prog_id` AS `pg_lots___prog_id_raw`, `pg_programmes`.`ref_sci5` AS `pg_lots___prog_id`, `pg_lots`.`surf` AS `pg_lots___surf`, `pg_lots`.`surf` AS `pg_lots___surf_raw`, `pg_lots`.`type` AS `pg_lots___type`, `pg_lots`.`type` AS `pg_lots___type_raw`, `pg_lots`.`etage` AS `pg_lots___etage`, `pg_lots`.`etage` AS `pg_lots___etage_raw`, `pg_lots`.`prix_internet1` AS `pg_lots___prix_internet1`, `pg_lots`.`prix_internet1` AS `pg_lots___prix_internet1_raw`, `pg_lots`.`prix_internet2` AS `pg_lots___prix_internet2`, `pg_lots`.`prix_internet2` AS `pg_lots___prix_internet2_raw`, `pg_lots`.`etat_com` AS `pg_lots___etat_com`, `pg_lots`.`etat_com` AS `pg_lots___etat_com_raw`, `pg_lots`.`diff_internet` AS `pg_lots___diff_internet`, `pg_lots`.`diff_internet` AS `pg_lots___diff_internet_raw`, `pg_lots`.`plan_url` AS `pg_lots___plan_url`, `pg_lots`.`plan_url` AS `pg_lots___plan_url_raw`, `pg_programmes`.`id` AS `pg_programmes___id`, `pg_programmes`.`id` AS `pg_programmes___id_raw`, `pg_programmes`.`date_time` AS `pg_programmes___date_time`, `pg_programmes`.`date_time` AS `pg_programmes___date_time_raw`, `pg_programmes`.`ref_sci5` AS `pg_programmes___ref_sci5`, `pg_programmes`.`ref_sci5` AS `pg_programmes___ref_sci5_raw`, `pg_programmes`.`nom_com` AS `pg_programmes___nom_com`, `pg_programmes`.`nom_com` AS `pg_programmes___nom_com_raw`, `pg_programmes`.`ville` AS `pg_programmes___ville`, `pg_programmes`.`ville` AS `pg_programmes___ville_raw`, `pg_programmes`.`cp` AS `pg_programmes___cp`, `pg_programmes`.`cp` AS `pg_programmes___cp_raw`, `pg_programmes`.`map` AS `pg_programmes___map`, `pg_programmes`.`map` AS `pg_programmes___map_raw`, `pg_programmes`.`etat_chantier` AS `pg_programmes___etat_chantier`, `pg_programmes`.`etat_chantier` AS `pg_programmes___etat_chantier_raw`, `pg_programmes`.`bbc` AS `pg_programmes___bbc`, `pg_programmes`.`bbc` AS `pg_programmes___bbc_raw`, `pg_programmes`.`tva7` AS `pg_programmes___tva7`, `pg_programmes`.`tva7` AS `pg_programmes___tva7_raw`, `pg_programmes`.`etat_com` AS `pg_programmes___etat_com`, `pg_programmes`.`etat_com` AS `pg_programmes___etat_com_raw`, `pg_programmes`.`attrib_com` AS `pg_programmes___attrib_com`, `pg_programmes`.`attrib_com` AS `pg_programmes___attrib_com_raw`, `pg_programmes`.`date_livraison` AS `pg_programmes___date_livraison`, `pg_programmes`.`date_livraison` AS `pg_programmes___date_livraison_raw`, `pg_lot_options`.`id` AS `pg_lot_options___id`, `pg_lot_options`.`id` AS `pg_lot_options___id_raw`, `pg_lot_options`.`date_time` AS `pg_lot_options___date_time`, `pg_lot_options`.`date_time` AS `pg_lot_options___date_time_raw`, `pg_lot_options`.`author` AS `pg_lot_options___author_raw`, `udkmp_users`.`username` AS `pg_lot_options___author`, `pg_lot_options`.`opt_resa` AS `pg_lot_options___opt_resa`, `pg_lot_options`.`opt_resa` AS `pg_lot_options___opt_resa_raw`, `pg_lot_options`.`etat_com` AS `pg_lot_options___etat_com`, `pg_lot_options`.`etat_com` AS `pg_lot_options___etat_com_raw`, `pg_lot_options`.`lot_id` AS `pg_lot_options___lot_id_raw`, `pg_lots_0`.`ref` AS `pg_lot_options___lot_id`, `pg_lot_options`.`etat_gdv` AS `pg_lot_options___etat_gdv`, `pg_lot_options`.`etat_gdv` AS `pg_lot_options___etat_gdv_raw`, `pg_lot_options`.`etat_mod` AS `pg_lot_options___etat_mod`, `pg_lot_options`.`etat_mod` AS `pg_lot_options___etat_mod_raw`, `pg_lot_options`.`date_end` AS `pg_lot_options___date_end`, `pg_lot_options`.`date_end` AS `pg_lot_options___date_end_raw`, `pg_lot_options`.`com` AS `pg_lot_options___com`, `pg_lot_options`.`com` AS `pg_lot_options___com_raw`, `pg_lot_options`.`form_url` AS `pg_lot_options___form_url`, `pg_lot_options`.`form_url` AS `pg_lot_options___form_url_raw`, `pg_lot_options`.`contact_name` AS `pg_lot_options___contact_name`, `pg_lot_options`.`contact_name` AS `pg_lot_options___contact_name_raw`, `pg_lots`.`id` AS slug , `pg_lots`.`id` AS `__pk_val` FROM `pg_lots` LEFT JOIN `pg_programmes` AS `pg_programmes` ON `pg_programmes`.`id` = `pg_lots`.`prog_id` RIGHT JOIN `pg_programmes` AS `pg_programmes_0` ON `pg_programmes_0`.`id` = `pg_lots`.`prog_id` LEFT JOIN `pg_lot_options` AS `pg_lot_options` ON `pg_lot_options`.`lot_id` = `pg_lots`.`id` LEFT JOIN `#__users` AS `udkmp_users` ON `udkmp_users`.`id` = `pg_lot_options`.`author` LEFT JOIN `pg_lots` AS `pg_lots_0` ON `pg_lots_0`.`id` = `pg_lot_options`.`lot_id` ORDER BY `pg_programmes`.`id` ASC,`pg_lots`.`prix_internet1` DESC