| 1 |
SET NAMES utf8mb4
|
0.00038 |
| 2 |
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='2bfe447a67b8a9c989a261054c48c3488dcba8959be19490d3ce93da7a4f8581'
WHERE u.id=1
|
0.00110 |
| 3 |
REPLACE INTO oktopusV1_core_users_online (user_id, ident,
logged, csrf_token, prev_url) VALUES
(1,'2bfe447a67b8a9c989a261054c48c3488dcba8959be19490d3ce93da7a4f8581',
1701258716, 'dac5772d23b1bafda477fd6bd8510fc8b4172009',
'https://www.leshautsdechaumont.com/en/la-longere')
|
0.00052 |
| 4 |
SELECT id_selection FROM oktopusV1_mod_resa_selection
WHERE UNIX_TIMESTAMP(date) + 86400 <=
UNIX_TIMESTAMP()
|
0.00086 |
| 5 |
SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00049 |
| 6 |
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
|
0.00214 |
| 7 |
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
|
0.00068 |
| 8 |
SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00040 |
| 9 |
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
|
0.00192 |
| 10 |
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
|
0.00125 |
| 11 |
SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00056 |
| 12 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '450' ORDER BY
index_selection, libelle
|
0.00046 |
| 13 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '449' ORDER BY
index_selection, libelle
|
0.00037 |
| 14 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '448' ORDER BY
index_selection, libelle
|
0.00037 |
| 15 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '447' ORDER BY
index_selection, libelle
|
0.00048 |
| 16 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '445' ORDER BY
index_selection, libelle
|
0.00037 |
| 17 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '442' ORDER BY
index_selection, libelle
|
0.00037 |
| 18 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '441' ORDER BY
index_selection, libelle
|
0.00037 |
| 19 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '440' ORDER BY
index_selection, libelle
|
0.00037 |
| 20 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '439' ORDER BY
index_selection, libelle
|
0.00036 |
| 21 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '438' ORDER BY
index_selection, libelle
|
0.00037 |
| 22 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '437' ORDER BY
index_selection, libelle
|
0.00038 |
| 23 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '436' ORDER BY
index_selection, libelle
|
0.00036 |
| 24 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '435' ORDER BY
index_selection, libelle
|
0.00041 |
| 25 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '434' ORDER BY
index_selection, libelle
|
0.00036 |
| 26 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '433' ORDER BY
index_selection, libelle
|
0.00038 |
| 27 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '432' ORDER BY
index_selection, libelle
|
0.00039 |
| 28 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '431' ORDER BY
index_selection, libelle
|
0.00037 |
| 29 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '430' ORDER BY
index_selection, libelle
|
0.00036 |
| 30 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '429' ORDER BY
index_selection, libelle
|
0.00040 |
| 31 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '428' ORDER BY
index_selection, libelle
|
0.00039 |
| 32 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '422' ORDER BY
index_selection, libelle
|
0.00033 |
| 33 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '421' ORDER BY
index_selection, libelle
|
0.00035 |
| 34 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '420' ORDER BY
index_selection, libelle
|
0.00036 |
| 35 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '419' ORDER BY
index_selection, libelle
|
0.00035 |
| 36 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '418' ORDER BY
index_selection, libelle
|
0.00043 |
| 37 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '417' ORDER BY
index_selection, libelle
|
0.00034 |
| 38 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '415' ORDER BY
index_selection, libelle
|
0.00033 |
| 39 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '414' ORDER BY
index_selection, libelle
|
0.00034 |
| 40 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '413' ORDER BY
index_selection, libelle
|
0.00044 |
| 41 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '412' ORDER BY
index_selection, libelle
|
0.00041 |
| 42 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '411' ORDER BY
index_selection, libelle
|
0.00037 |
| 43 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '410' ORDER BY
index_selection, libelle
|
0.00035 |
| 44 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '409' ORDER BY
index_selection, libelle
|
0.00036 |
| 45 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '408' ORDER BY
index_selection, libelle
|
0.00034 |
| 46 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '406' ORDER BY
index_selection, libelle
|
0.00034 |
| 47 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '405' ORDER BY
index_selection, libelle
|
0.00035 |
| 48 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '404' ORDER BY
index_selection, libelle
|
0.00034 |
| 49 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '402' ORDER BY
index_selection, libelle
|
0.00035 |
| 50 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '401' ORDER BY
index_selection, libelle
|
0.00033 |
| 51 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '400' ORDER BY
index_selection, libelle
|
0.00037 |
| 52 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '399' ORDER BY
index_selection, libelle
|
0.00037 |
| 53 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '398' ORDER BY
index_selection, libelle
|
0.00039 |
| 54 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '397' ORDER BY
index_selection, libelle
|
0.00047 |
| 55 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '395' ORDER BY
index_selection, libelle
|
0.00041 |
| 56 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '394' ORDER BY
index_selection, libelle
|
0.00037 |
| 57 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '393' ORDER BY
index_selection, libelle
|
0.00037 |
| 58 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '392' ORDER BY
index_selection, libelle
|
0.00049 |
| 59 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '390' ORDER BY
index_selection, libelle
|
0.00038 |
| 60 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '389' ORDER BY
index_selection, libelle
|
0.00035 |
| 61 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '387' ORDER BY
index_selection, libelle
|
0.00042 |
| 62 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '386' ORDER BY
index_selection, libelle
|
0.00036 |
| 63 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '384' ORDER BY
index_selection, libelle
|
0.00038 |
| 64 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '383' ORDER BY
index_selection, libelle
|
0.00039 |
| 65 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '382' ORDER BY
index_selection, libelle
|
0.00036 |
| 66 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '381' ORDER BY
index_selection, libelle
|
0.00037 |
| 67 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '380' ORDER BY
index_selection, libelle
|
0.00035 |
| 68 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '379' ORDER BY
index_selection, libelle
|
0.00034 |
| 69 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '378' ORDER BY
index_selection, libelle
|
0.00036 |
| 70 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '376' ORDER BY
index_selection, libelle
|
0.00034 |
| 71 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '375' ORDER BY
index_selection, libelle
|
0.00035 |
| 72 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '374' ORDER BY
index_selection, libelle
|
0.00038 |
| 73 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '373' ORDER BY
index_selection, libelle
|
0.00035 |
| 74 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '371' ORDER BY
index_selection, libelle
|
0.00034 |
| 75 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '370' ORDER BY
index_selection, libelle
|
0.00035 |
| 76 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '369' ORDER BY
index_selection, libelle
|
0.00036 |
| 77 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '368' ORDER BY
index_selection, libelle
|
0.00036 |
| 78 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '367' ORDER BY
index_selection, libelle
|
0.00038 |
| 79 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '365' ORDER BY
index_selection, libelle
|
0.00036 |
| 80 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '364' ORDER BY
index_selection, libelle
|
0.00035 |
| 81 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '363' ORDER BY
index_selection, libelle
|
0.00042 |
| 82 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '362' ORDER BY
index_selection, libelle
|
0.00037 |
| 83 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '361' ORDER BY
index_selection, libelle
|
0.00037 |
| 84 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '359' ORDER BY
index_selection, libelle
|
0.00046 |
| 85 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '358' ORDER BY
index_selection, libelle
|
0.00041 |
| 86 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '357' ORDER BY
index_selection, libelle
|
0.00042 |
| 87 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '356' ORDER BY
index_selection, libelle
|
0.00198 |
| 88 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '355' ORDER BY
index_selection, libelle
|
0.00160 |
| 89 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '354' ORDER BY
index_selection, libelle
|
0.00037 |
| 90 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '353' ORDER BY
index_selection, libelle
|
0.00037 |
| 91 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '352' ORDER BY
index_selection, libelle
|
0.00038 |
| 92 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '350' ORDER BY
index_selection, libelle
|
0.00035 |
| 93 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '348' ORDER BY
index_selection, libelle
|
0.00039 |
| 94 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '347' ORDER BY
index_selection, libelle
|
0.00035 |
| 95 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '345' ORDER BY
index_selection, libelle
|
0.00035 |
| 96 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '344' ORDER BY
index_selection, libelle
|
0.00036 |
| 97 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '343' ORDER BY
index_selection, libelle
|
0.00037 |
| 98 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '341' ORDER BY
index_selection, libelle
|
0.00037 |
| 99 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '340' ORDER BY
index_selection, libelle
|
0.00037 |
| 100 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '339' ORDER BY
index_selection, libelle
|
0.00038 |
| 101 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '337' ORDER BY
index_selection, libelle
|
0.00038 |
| 102 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '336' ORDER BY
index_selection, libelle
|
0.00036 |
| 103 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '334' ORDER BY
index_selection, libelle
|
0.00036 |
| 104 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '333' ORDER BY
index_selection, libelle
|
0.00041 |
| 105 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '329' ORDER BY
index_selection, libelle
|
0.00038 |
| 106 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '328' ORDER BY
index_selection, libelle
|
0.00039 |
| 107 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '327' ORDER BY
index_selection, libelle
|
0.00037 |
| 108 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '322' ORDER BY
index_selection, libelle
|
0.00038 |
| 109 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '321' ORDER BY
index_selection, libelle
|
0.00036 |
| 110 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '320' ORDER BY
index_selection, libelle
|
0.00038 |
| 111 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '319' ORDER BY
index_selection, libelle
|
0.00038 |
| 112 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '316' ORDER BY
index_selection, libelle
|
0.00037 |
| 113 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '315' ORDER BY
index_selection, libelle
|
0.00039 |
| 114 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '313' ORDER BY
index_selection, libelle
|
0.00035 |
| 115 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '311' ORDER BY
index_selection, libelle
|
0.00037 |
| 116 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '310' ORDER BY
index_selection, libelle
|
0.00038 |
| 117 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '309' ORDER BY
index_selection, libelle
|
0.00050 |
| 118 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '308' ORDER BY
index_selection, libelle
|
0.00044 |
| 119 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '305' ORDER BY
index_selection, libelle
|
0.00037 |
| 120 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '303' ORDER BY
index_selection, libelle
|
0.00040 |
| 121 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '302' ORDER BY
index_selection, libelle
|
0.00047 |
| 122 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '301' ORDER BY
index_selection, libelle
|
0.00036 |
| 123 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '299' ORDER BY
index_selection, libelle
|
0.00042 |
| 124 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '296' ORDER BY
index_selection, libelle
|
0.00043 |
| 125 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '295' ORDER BY
index_selection, libelle
|
0.00039 |
| 126 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '293' ORDER BY
index_selection, libelle
|
0.00040 |
| 127 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '292' ORDER BY
index_selection, libelle
|
0.00047 |
| 128 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '291' ORDER BY
index_selection, libelle
|
0.00045 |
| 129 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '289' ORDER BY
index_selection, libelle
|
0.00048 |
| 130 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '288' ORDER BY
index_selection, libelle
|
0.00039 |
| 131 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '287' ORDER BY
index_selection, libelle
|
0.00039 |
| 132 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '286' ORDER BY
index_selection, libelle
|
0.00048 |
| 133 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '285' ORDER BY
index_selection, libelle
|
0.00039 |
| 134 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '267' ORDER BY
index_selection, libelle
|
0.00039 |
| 135 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '251' ORDER BY
index_selection, libelle
|
0.00036 |
| 136 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '242' ORDER BY
index_selection, libelle
|
0.00041 |
| 137 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '236' ORDER BY
index_selection, libelle
|
0.00037 |
| 138 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '232' ORDER BY
index_selection, libelle
|
0.00038 |
| 139 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '230' ORDER BY
index_selection, libelle
|
0.00040 |
| 140 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '225' ORDER BY
index_selection, libelle
|
0.00046 |
| 141 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '224' ORDER BY
index_selection, libelle
|
0.00037 |
| 142 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '223' ORDER BY
index_selection, libelle
|
0.00035 |
| 143 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '218' ORDER BY
index_selection, libelle
|
0.00036 |
| 144 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '217' ORDER BY
index_selection, libelle
|
0.00039 |
| 145 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '214' ORDER BY
index_selection, libelle
|
0.00054 |
| 146 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '211' ORDER BY
index_selection, libelle
|
0.00041 |
| 147 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '210' ORDER BY
index_selection, libelle
|
0.00038 |
| 148 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '206' ORDER BY
index_selection, libelle
|
0.00041 |
| 149 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '205' ORDER BY
index_selection, libelle
|
0.00038 |
| 150 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '204' ORDER BY
index_selection, libelle
|
0.00038 |
| 151 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '203' ORDER BY
index_selection, libelle
|
0.00034 |
| 152 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '202' ORDER BY
index_selection, libelle
|
0.00038 |
| 153 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '201' ORDER BY
index_selection, libelle
|
0.00042 |
| 154 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '199' ORDER BY
index_selection, libelle
|
0.00038 |
| 155 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '195' ORDER BY
index_selection, libelle
|
0.00042 |
| 156 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '193' ORDER BY
index_selection, libelle
|
0.00037 |
| 157 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '192' ORDER BY
index_selection, libelle
|
0.00039 |
| 158 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '191' ORDER BY
index_selection, libelle
|
0.00038 |
| 159 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '190' ORDER BY
index_selection, libelle
|
0.00039 |
| 160 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '188' ORDER BY
index_selection, libelle
|
0.00042 |
| 161 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '187' ORDER BY
index_selection, libelle
|
0.00038 |
| 162 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '186' ORDER BY
index_selection, libelle
|
0.00040 |
| 163 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '184' ORDER BY
index_selection, libelle
|
0.00040 |
| 164 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '183' ORDER BY
index_selection, libelle
|
0.00038 |
| 165 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '182' ORDER BY
index_selection, libelle
|
0.00042 |
| 166 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '181' ORDER BY
index_selection, libelle
|
0.00043 |
| 167 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '178' ORDER BY
index_selection, libelle
|
0.00039 |
| 168 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '176' ORDER BY
index_selection, libelle
|
0.00035 |
| 169 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '171' ORDER BY
index_selection, libelle
|
0.00037 |
| 170 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '170' ORDER BY
index_selection, libelle
|
0.00047 |
| 171 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '169' ORDER BY
index_selection, libelle
|
0.00037 |
| 172 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '168' ORDER BY
index_selection, libelle
|
0.00038 |
| 173 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '166' ORDER BY
index_selection, libelle
|
0.00041 |
| 174 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '165' ORDER BY
index_selection, libelle
|
0.00036 |
| 175 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '163' ORDER BY
index_selection, libelle
|
0.00037 |
| 176 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '161' ORDER BY
index_selection, libelle
|
0.00050 |
| 177 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '160' ORDER BY
index_selection, libelle
|
0.00042 |
| 178 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '157' ORDER BY
index_selection, libelle
|
0.00039 |
| 179 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '155' ORDER BY
index_selection, libelle
|
0.00042 |
| 180 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '153' ORDER BY
index_selection, libelle
|
0.00035 |
| 181 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '151' ORDER BY
index_selection, libelle
|
0.00043 |
| 182 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '149' ORDER BY
index_selection, libelle
|
0.00036 |
| 183 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '146' ORDER BY
index_selection, libelle
|
0.00037 |
| 184 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '145' ORDER BY
index_selection, libelle
|
0.00039 |
| 185 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '142' ORDER BY
index_selection, libelle
|
0.00036 |
| 186 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '141' ORDER BY
index_selection, libelle
|
0.00041 |
| 187 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '139' ORDER BY
index_selection, libelle
|
0.00038 |
| 188 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '120' ORDER BY
index_selection, libelle
|
0.00041 |
| 189 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '116' ORDER BY
index_selection, libelle
|
0.00038 |
| 190 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '107' ORDER BY
index_selection, libelle
|
0.00040 |
| 191 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '106' ORDER BY
index_selection, libelle
|
0.00041 |
| 192 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '105' ORDER BY
index_selection, libelle
|
0.00036 |
| 193 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '104' ORDER BY
index_selection, libelle
|
0.00037 |
| 194 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '103' ORDER BY
index_selection, libelle
|
0.00036 |
| 195 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '102' ORDER BY
index_selection, libelle
|
0.00036 |
| 196 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '101' ORDER BY
index_selection, libelle
|
0.00055 |
| 197 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '100' ORDER BY
index_selection, libelle
|
0.00037 |
| 198 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '99' ORDER BY index_selection,
libelle
|
0.00035 |
| 199 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '98' ORDER BY index_selection,
libelle
|
0.00039 |
| 200 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '96' ORDER BY index_selection,
libelle
|
0.00038 |
| 201 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '95' ORDER BY index_selection,
libelle
|
0.00038 |
| 202 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '94' ORDER BY index_selection,
libelle
|
0.00046 |
| 203 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '92' ORDER BY index_selection,
libelle
|
0.00035 |
| 204 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '91' ORDER BY index_selection,
libelle
|
0.00034 |
| 205 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '90' ORDER BY index_selection,
libelle
|
0.00034 |
| 206 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '89' ORDER BY index_selection,
libelle
|
0.00035 |
| 207 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '88' ORDER BY index_selection,
libelle
|
0.00041 |
| 208 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '87' ORDER BY index_selection,
libelle
|
0.00034 |
| 209 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '86' ORDER BY index_selection,
libelle
|
0.00035 |
| 210 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '85' ORDER BY index_selection,
libelle
|
0.00034 |
| 211 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '83' ORDER BY index_selection,
libelle
|
0.00034 |
| 212 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '82' ORDER BY index_selection,
libelle
|
0.00036 |
| 213 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '81' ORDER BY index_selection,
libelle
|
0.00036 |
| 214 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '78' ORDER BY index_selection,
libelle
|
0.00045 |
| 215 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '77' ORDER BY index_selection,
libelle
|
0.00036 |
| 216 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '76' ORDER BY index_selection,
libelle
|
0.00034 |
| 217 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '65' ORDER BY index_selection,
libelle
|
0.00040 |
| 218 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '64' ORDER BY index_selection,
libelle
|
0.00036 |
| 219 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '63' ORDER BY index_selection,
libelle
|
0.00033 |
| 220 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '61' ORDER BY index_selection,
libelle
|
0.00036 |
| 221 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '60' ORDER BY index_selection,
libelle
|
0.00034 |
| 222 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '56' ORDER BY index_selection,
libelle
|
0.00034 |
| 223 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '55' ORDER BY index_selection,
libelle
|
0.00037 |
| 224 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '51' ORDER BY index_selection,
libelle
|
0.00036 |
| 225 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '50' ORDER BY index_selection,
libelle
|
0.00037 |
| 226 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '48' ORDER BY index_selection,
libelle
|
0.00035 |
| 227 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '47' ORDER BY index_selection,
libelle
|
0.00033 |
| 228 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '43' ORDER BY index_selection,
libelle
|
0.00034 |
| 229 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '42' ORDER BY index_selection,
libelle
|
0.00035 |
| 230 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '33' ORDER BY index_selection,
libelle
|
0.00035 |
| 231 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '11' ORDER BY index_selection,
libelle
|
0.00035 |
| 232 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '8' ORDER BY index_selection,
libelle
|
0.00033 |
| 233 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '7' ORDER BY index_selection,
libelle
|
0.00034 |
| 234 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '6' ORDER BY index_selection,
libelle
|
0.00034 |
| 235 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '5' ORDER BY index_selection,
libelle
|
0.00036 |
| 236 |
SELECT *
FROM
oktopusV1_mod_resa_reservation_detail
WHERE id_reservation = '4' ORDER BY index_selection,
libelle
|
0.00035 |
| 237 |
SELECT id, language, valeur FROM oktopusV1_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00045 |
| 238 |
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
|
0.00186 |
| 239 |
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
|
0.00137 |
| 240 |
SELECT p.id, p.original_id, p.user_id, p.category_id,
p.active, p.created_at, p.updated_at, p.images, p.files,
p.tpl, p.position, pl.language, pl.title, pl.subtitle,
pl.title_tag, pl.title_seo, pl.slug, pl.content,
pl.meta_description, pl.meta_keywords, pl.words, rl.title AS
category_title, rl.slug AS category_slug, rl.title_tag AS
category_title_tag, r.items_tpl AS category_items_tpl,
p.recipients_to, p.recipients_cc, p.recipients_bcc,
p.from_to, p.captcha, p.conversion_google, p.from_copy,
pl.subject FROM oktopusV1_mod_pages AS p INNER JOIN
oktopusV1_mod_pages_locales AS pl ON p.id=pl.page_id AND
pl.language='en' LEFT OUTER JOIN
oktopusV1_mod_pages_categories AS r ON r.id=p.category_id
LEFT OUTER JOIN oktopusV1_mod_pages_categories_locales AS rl
ON r.id=rl.category_id AND rl.language='en' WHERE 1 AND
pl.language='en' AND pl.slug='la-longere' AND p.active=1
ORDER BY p.created_at DESC
|
0.00191 |
| 241 |
SELECT r.*, rl.*, COUNT(p.id) AS num_items FROM
oktopusV1_mod_galleries AS r LEFT JOIN
oktopusV1_mod_galleries_locales AS rl ON r.id=rl.gallery_id
LEFT JOIN oktopusV1_mod_galleries_items AS p ON
r.id=p.gallery_id WHERE 1 AND rl.language='en' AND
r.active=1 GROUP BY r.id ORDER BY nleft asc
|
0.00224 |
| 242 |
SELECT m.*,
ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM oktopusV1_mod_map AS m
LEFT JOIN oktopusV1_mod_map_locales AS ml ON m.id=ml.id_map
AND ml.language='en' WHERE 1 AND ml.language='en' AND
m.active=1 ORDER BY m.created_at DESC
|
0.00122 |
| 243 |
SELECT DISTINCT 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 = 'en'
WHERE 1 AND active = '1' ORDER BY snrl.libelle
|
0.00129 |
| 244 |
SELECT p.id, p.original_id, p.user_id, p.category_id,
p.active, p.created_at, p.updated_at, p.images, p.files,
p.tpl, p.position, pl.language, pl.title, pl.subtitle,
pl.title_tag, pl.title_seo, pl.slug, pl.content,
pl.meta_description, pl.meta_keywords, pl.words, rl.title AS
category_title, rl.slug AS category_slug, rl.title_tag AS
category_title_tag, r.items_tpl AS category_items_tpl,
p.recipients_to, p.recipients_cc, p.recipients_bcc,
p.from_to, p.captcha, p.conversion_google, p.from_copy,
pl.subject FROM oktopusV1_mod_pages AS p INNER JOIN
oktopusV1_mod_pages_locales AS pl ON p.id=pl.page_id AND
pl.language='en' LEFT OUTER JOIN
oktopusV1_mod_pages_categories AS r ON r.id=p.category_id
LEFT OUTER JOIN oktopusV1_mod_pages_categories_locales AS rl
ON r.id=rl.category_id AND rl.language='en' WHERE 1 AND
pl.language='en' AND p.active=1 ORDER BY p.created_at DESC
|
0.00127 |
| 245 |
SELECT f.id, f.page_id, f.active, f.type, f.ord, f.html_id,
f.bloc, f.colonne, f.picto, f.options, f.info_personnelle,
fl.language, fl.title, fl.description, fl.value, fl.legend
FROM oktopusV1_mod_pages_forms_fields AS f LEFT JOIN
oktopusV1_mod_pages_forms_fields_locales AS fl ON
fl.field_id=f.id WHERE 1 AND active>0 AND page_id=2 AND
fl.language='en' ORDER BY ord ASC
|
0.00069 |
| 246 |
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 = 'en' WHERE 1 AND sn.url != '' AND sn.type !=
'' AND type LIKE '%F%' ORDER BY sn.position
|
0.00059 |
| 247 |
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 = 'en'
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
'%\'/en/la-longere\'%') ORDER BY p.rubrique DESC
|
0.00089 |
| 248 |
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 = 'en'
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
'%\'/en/la-longere\'%') ORDER BY p.rubrique DESC
|
0.00090 |
