SET NAMES utf8mb4

SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV1_core_users AS u INNER JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV1_core_users_online AS o ON
o.ident='c87fe7d4f85dbb7895e160301e7731f4f5dd8283a0fb54f668076eed2f00bb9b'
WHERE u.id=1

REPLACE INTO oktopusV1_core_users_online (user_id, ident,
logged, csrf_token, prev_url) VALUES
(1,'c87fe7d4f85dbb7895e160301e7731f4f5dd8283a0fb54f668076eed2f00bb9b',
1715840725, '73f2fc7807a82400fa8142178671d224f75e6b4b',
'https://www.leshautsdechaumont.com/fr/f-les-hauts-de-chaumont')

SELECT id_selection FROM oktopusV1_mod_resa_selection 
                      WHERE UNIX_TIMESTAMP(date) + 86400 <=
UNIX_TIMESTAMP() 

SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
					  WHERE `table` = 'reservation_statut'

SELECT u.*, g.* FROM oktopusV1_core_users AS u LEFT JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
WHERE 1 ORDER BY u.username DESC 

 SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
                        DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
                        DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
                        DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr, 
                        DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
                        FROM oktopusV1_mod_resa_reservation
c, oktopusV1_mod_resa_reservation_statut_ligne cl,
oktopusV1_mod_resa_reservation_statut cs
                        WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
cl.id_reservation_statut = '1' AND c.moyen_paiement
IN('cheque','virement','telephone') ORDER BY
date_reservation DESC 

SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
					  WHERE `table` = 'reservation_statut'

SELECT u.*, g.* FROM oktopusV1_core_users AS u LEFT JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
WHERE 1 ORDER BY u.username DESC 

 SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
                        DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
                        DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
                        DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr, 
                        DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
                        FROM oktopusV1_mod_resa_reservation
c, oktopusV1_mod_resa_reservation_statut_ligne cl,
oktopusV1_mod_resa_reservation_statut cs
                        WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
cl.id_reservation_statut IN (1,11) ORDER BY date_reservation
DESC 

SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
					  WHERE `table` = 'reservation_statut'

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '506'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '505'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '504'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '503'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '499'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '498'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '495'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '494'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '493'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '492'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '488'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '487'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '486'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '484'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '483'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '481'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '480'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '479'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '477'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '476'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '475'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '474'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '472'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '469'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '468'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '467'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '465'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '464'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '463'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '462'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '461'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '460'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '459'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '458'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '457'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '456'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '455'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '453'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '452'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '451'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '450'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '449'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '448'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '447'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '445'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '442'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '441'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '440'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '439'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '438'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '437'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '436'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '435'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '434'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '433'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '432'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '431'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '430'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '429'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '428'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '422'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '421'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '420'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '419'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '418'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '417'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '415'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '414'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '413'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '412'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '411'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '410'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '409'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '408'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '406'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '405'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '404'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '402'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '401'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '400'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '399'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '398'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '397'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '395'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '394'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '393'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '392'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '390'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '389'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '387'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '386'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '384'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '383'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '382'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '381'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '380'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '379'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '378'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '376'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '375'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '374'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '373'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '371'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '370'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '369'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '368'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '367'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '365'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '364'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '363'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '362'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '361'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '359'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '358'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '357'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '356'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '355'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '354'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '353'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '352'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '350'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '348'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '347'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '345'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '344'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '343'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '341'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '340'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '339'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '337'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '336'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '334'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '333'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '329'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '328'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '327'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '322'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '321'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '320'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '319'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '316'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '315'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '313'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '311'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '310'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '309'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '308'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '305'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '303'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '302'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '301'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '299'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '296'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '295'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '293'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '292'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '291'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '289'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '288'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '287'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '286'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '285'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '267'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '251'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '242'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '236'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '232'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '230'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '225'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '224'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '223'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '218'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '217'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '214'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '211'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '210'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '206'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '205'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '204'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '203'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '202'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '201'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '199'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '195'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '193'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '192'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '191'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '190'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '188'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '187'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '186'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '184'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '183'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '182'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '181'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '178'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '176'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '171'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '170'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '169'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '168'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '166'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '165'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '163'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '161'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '160'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '157'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '155'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '153'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '151'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '149'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '146'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '145'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '142'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '141'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '139'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '120'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '116'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '107'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '106'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '105'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '104'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '103'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '102'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '101'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '100'  ORDER BY
index_selection, libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '99'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '98'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '96'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '95'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '94'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '92'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '91'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '90'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '89'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '88'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '87'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '86'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '85'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '83'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '82'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '81'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '78'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '77'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '76'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '65'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '64'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '63'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '61'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '60'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '56'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '55'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '51'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '50'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '48'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '47'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '43'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '42'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '33'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '11'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '8'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '7'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '6'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '5'  ORDER BY index_selection,
libelle 

 SELECT * 
                        FROM
oktopusV1_mod_resa_reservation_detail
						WHERE id_reservation = '4'  ORDER BY index_selection,
libelle 

SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
					  WHERE `table` = 'reservation_statut'

SELECT u.*, g.* FROM oktopusV1_core_users AS u LEFT JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
WHERE 1 ORDER BY u.username DESC 

 SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
                        DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
                        DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
                        DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr, 
                        DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
                        FROM oktopusV1_mod_resa_reservation
c, oktopusV1_mod_resa_reservation_statut_ligne cl,
oktopusV1_mod_resa_reservation_statut cs
                        WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
acompte != 0 AND mail_2eme_paiement IS NULL AND
cl.id_reservation_statut = '11' ORDER BY date_reservation
DESC 

            SELECT snr.*, snrl.*, 
				DATE_FORMAT(snr.created_at, '%d/%m/%Y %H:%i:%s') as
date_creation_fr,
				DATE_FORMAT(snr.updated_at, '%d/%m/%Y %H:%i:%s') as
date_modification_fr
            FROM oktopusV1_mod_social_network_reseau snr
            JOIN oktopusV1_mod_social_network_reseau_locales
snrl ON snrl.id_reseau = snr.id_reseau AND snrl.language =
'fr'
            WHERE 1 AND snrl.slug ='les-hauts-de-chaumont'

SELECT DISTINCT sn.*, snl.*
                      FROM oktopusV1_mod_social_network sn
                      JOIN
oktopusV1_mod_social_network_locales snl ON
snl.id_social_network = sn.id_social_network AND
snl.language = 'fr' WHERE 1  AND sn.url != '' AND sn.type !=
''  AND type LIKE '%F%' ORDER BY sn.position

SELECT p.*, pl.*,
                         DATE_FORMAT(p.debut, '%d/%m/%Y') as
debut_fr,
                         DATE_FORMAT(p.fin, '%d/%m/%Y') as
fin_fr,
                         DATE_FORMAT(p.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                         DATE_FORMAT(p.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
                      FROM oktopusV1_mod_home_popup p
                      LEFT JOIN
oktopusV1_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'fr'
                      WHERE 1 AND (
                                        CURDATE() BETWEEN
p.debut AND p.fin
                                        OR (p.debut =
'0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00')
                                    )AND pl.content <> ''
AND (p.rubrique = '' OR p.rubrique LIKE
'%\'/fr/f-les-hauts-de-chaumont\'%') ORDER BY p.rubrique
DESC

SELECT p.*, pl.*,
                         DATE_FORMAT(p.debut, '%d/%m/%Y') as
debut_fr,
                         DATE_FORMAT(p.fin, '%d/%m/%Y') as
fin_fr,
                         DATE_FORMAT(p.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                         DATE_FORMAT(p.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
                      FROM oktopusV1_mod_home_popup p
                      LEFT JOIN
oktopusV1_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'fr'
                      WHERE 1 AND (
                                        CURDATE() BETWEEN
p.debut AND p.fin
                                        OR (p.debut =
'0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00')
                                    )AND pl.content <> ''
AND (p.rubrique = '' OR p.rubrique LIKE
'%\'/fr/f-les-hauts-de-chaumont\'%') ORDER BY p.rubrique
DESC