0 article(s)

0 article(s)

0.00 €

Le produit a été ajouté au panier

Total : 0.00 €

  • Oeno Mélo
  • Oeno Mélo
Oeno Mélo

Raison sociale

  • Oeno Mélo
    29 RUE DES DAMES A ACCOLAY
    89460 DEUX RIVIERES
  • 06 38 67 03 18

Restez connectés

  • Mémoire utilisée par PHP : 3,92 Mo
  • Pic mémoire allouée par PHP : 5,13 Mo
  • Temps d'execution du script : 0.541 s
  • Lang :
  • Path : bon-cadeau-1
  • Route : mosaicRubrique
  • $okt->page->module : mosaic
  • $okt->page->action :
  • Title tag : Bon cadeau - Oeno Mélo
  • Title:
  • H1:
  • Meta description: Vins locaux à Chablis et Vézelay dans l'Yonne (89)
  • Meta keyword: Atelier dégustation vin Auxerre, Atelier dégustation vin Joigny, Atelier dégustation vin Tonnerre, Atelier dégustation vin Chablis, Atelier dégustation vin Yonne (89), Atelier dégustation vin Vézelay, Animatrice en dégustation Auxerre, Animatrice en dégustation Joigny, Animatrice en dégustation Tonnerre, Animatrice en dégustation Chablis, Animatrice en dégustation Yonne (89), Animatrice en dégustation Vézelay, Dégustation de vins Auxerre, Dégustation de vins Joigny, Dégustation de vins Tonnerre, Dégustation de vins Chablis, Dégustation de vins Yonne (89), Dégustation de vins Vézelay, Visite domaine viticole Auxerre, Visite domaine viticole Joigny, Visite domaine viticole Tonnerre, Visite domaine viticole Chablis, Visite domaine viticole Yonne (89), Visite domaine viticole Vézelay, Vins locaux Auxerre, Vins locaux Joigny, Vins locaux Tonnerre, Vins locaux Chablis, Vins locaux Yonne (89), Vins locaux Vézelay, Evenement oenologie Auxerre, Evenement oenologie Joigny, Evenement oenologie Tonnerre, Evenement oenologie Chablis, Evenement oenologie Yonne (89), Evenement oenologie Vézelay, Oenologie Auxerre, Oenologie Joigny, Oenologie Tonnerre, Oenologie Chablis, Oenologie Yonne (89), Oenologie Vézelay
ID Query Time
1
SET NAMES utf8mb4
0.00034
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='3.237.32.15' WHERE u.id=1
0.00076
3
UPDATE oktopusV1_core_users_online SET logged=1685240698,
prev_url='https://www.oeno-melo.fr/bon-cadeau-1' WHERE
ident='3.237.32.15'
0.00042
4
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 u.active != 3 ORDER BY u.username DESC 
0.00062
5
 SELECT t.*, tl.*, tsl.nom AS nomStatut, couleur,
                       DATE_FORMAT(tl.date_creation,
'%d/%m/%Y à %Hh%i') AS date_creation_fr,
                       DATE_FORMAT(t.date_transaction,
'%d/%m/%Y à %Hh%i') AS date_transaction_fr
                       FROM
oktopusV1_mod_appointments_transaction t
                       JOIN
oktopusV1_mod_appointments_transaction_statut_ligne tl ON
tl.id_transaction_statut_ligne =
t.id_transaction_statut_ligne
                       JOIN
oktopusV1_mod_appointments_transaction_statut ts ON
ts.id_transaction_statut = tl.id_transaction_statut
                       JOIN
oktopusV1_mod_appointments_transaction_statut_locales tsl ON
tsl.id_transaction_statut = ts.id_transaction_statut AND
tsl.language = 'fr'
                       WHERE 1 AND tl.id_transaction_statut
= '1' ORDER BY t.date_transaction DESC 
0.00037
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 u.active != 3 ORDER BY u.username DESC 
0.00036
7
 SELECT t.*, tl.*, tsl.nom AS nomStatut, couleur,
                       DATE_FORMAT(tl.date_creation,
'%d/%m/%Y à %Hh%i') AS date_creation_fr,
                       DATE_FORMAT(t.date_transaction,
'%d/%m/%Y à %Hh%i') AS date_transaction_fr
                       FROM
oktopusV1_mod_appointments_transaction t
                       JOIN
oktopusV1_mod_appointments_transaction_statut_ligne tl ON
tl.id_transaction_statut_ligne =
t.id_transaction_statut_ligne
                       JOIN
oktopusV1_mod_appointments_transaction_statut ts ON
ts.id_transaction_statut = tl.id_transaction_statut
                       JOIN
oktopusV1_mod_appointments_transaction_statut_locales tsl ON
tsl.id_transaction_statut = ts.id_transaction_statut AND
tsl.language = 'fr'
                       WHERE 1 AND tl.id_transaction_statut
IN (1,11) ORDER BY t.date_transaction DESC 
0.00036
8
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 u.active != 3 ORDER BY u.username DESC 
0.00039
9
 SELECT t.*, tl.*, tsl.nom AS nomStatut, couleur,
                       DATE_FORMAT(tl.date_creation,
'%d/%m/%Y à %Hh%i') AS date_creation_fr,
                       DATE_FORMAT(t.date_transaction,
'%d/%m/%Y à %Hh%i') AS date_transaction_fr
                       FROM
oktopusV1_mod_appointments_transaction t
                       JOIN
oktopusV1_mod_appointments_transaction_statut_ligne tl ON
tl.id_transaction_statut_ligne =
t.id_transaction_statut_ligne
                       JOIN
oktopusV1_mod_appointments_transaction_statut ts ON
ts.id_transaction_statut = tl.id_transaction_statut
                       JOIN
oktopusV1_mod_appointments_transaction_statut_locales tsl ON
tsl.id_transaction_statut = ts.id_transaction_statut AND
tsl.language = 'fr'
                       WHERE 1 AND acompte != 0 AND
mail_2eme_paiement IS NULL AND tl.id_transaction_statut =
'11' ORDER BY t.date_transaction DESC 
0.00035
10
UPDATE oktopusV1_mod_news SET active = 1
                           WHERE active = 3 AND NOW() >
created_at 
0.00066
11
UPDATE oktopusV1_mod_news SET active = 0
                              WHERE active = 1 AND end_at !=
"0000-00-00 00:00:00" 
                              AND NOW() > end_at 
0.00040
12
SELECT COUNT(id_rubrique) FROM oktopusV1_mod_mosaic_rubrique
WHERE id_rubrique = '1' 
0.00060
13

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='1'
0.00061
14
SELECT f.id, f.user_id, f.active, f.token, f.created_at,
f.updated_at, f.tpl, f.config_general, f.config_style,
f.config_date,
                              fl.language, fl.title,
fl.title_tag, fl.title_seo, fl.slug, fl.meta_description,
fl.meta_keywords, fl.beforedate, fl.afterdate FROM
oktopusV1_mod_facebook AS f  INNER JOIN
oktopusV1_mod_facebook_locales AS fl ON f.id=fl.id_facebook
AND fl.language='fr' WHERE 1  AND fl.language='fr' AND
f.active=1 ORDER BY f.created_at DESC 
0.00049
15
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='fr' AND
r.active=1  GROUP BY r.id ORDER BY nleft asc 
0.00093
16
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='fr' WHERE 1  AND ml.language='fr' AND
m.active=1 ORDER BY m.created_at DESC 
0.00042
17
SELECT r.*, rl.*, COUNT(r.id_rubrique) AS num_posts FROM
oktopusV1_mod_mosaic_rubrique AS r LEFT JOIN
oktopusV1_mod_mosaic_rubrique_locales AS rl ON r.id_rubrique
= rl.id_rubrique WHERE 1 AND rl.language='fr' AND r.actif =
1  GROUP BY r.id_rubrique ORDER BY nleft asc 
0.00035
18
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 = 'fr'
WHERE 1  AND active = '1' ORDER BY snrl.libelle
0.00040
19
SELECT p.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='fr'  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='fr' WHERE 1  AND
pl.language='fr' AND p.active=1 ORDER BY p.created_at DESC 
0.00071
20
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '1'
0.00057
21
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'rubrique'
0.00054
22
 SELECT DISTINCT m.nom AS nomMarque, m.image AS imageMarque,
mo.nom AS nomModele, p.*, pl.*, 
                            IF(1, promo, NOW() BETWEEN
debut_promo AND fin_promo) AS promo,
                            IF(1, nouveaute, NOW() BETWEEN
debut_nouveaute AND fin_nouveaute) AS nouveaute,
                            IF(1, phare, NOW() BETWEEN
debut_phare AND fin_phare) AS phare,
                            IF(1, solde, NOW() BETWEEN
debut_solde AND fin_solde) AS solde,
							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_mosaic_produit
p
                           JOIN
oktopusV1_mod_mosaic_produit_locales pl ON pl.id_produit =
p.id_produit AND pl.language = 'fr' LEFT JOIN
oktopusV1_mod_mosaic_marque m ON p.id_marque = m.id_marque
                           LEFT JOIN
oktopusV1_mod_mosaic_modele mo ON p.id_modele =
mo.id_modele
                           LEFT JOIN
oktopusV1_mod_mosaic_produit_rubrique pr ON pr.id_produit =
p.id_produit
                           WHERE 1 ORDER BY nom
0.00352
23
SELECT COUNT(p.id_produit) FROM
oktopusV1_mod_mosaic_rubrique r,
oktopusV1_mod_mosaic_rubrique_locales rl,
oktopusV1_mod_mosaic_produit_rubrique pr,
oktopusV1_mod_mosaic_produit p,
oktopusV1_mod_mosaic_produit_locales pl
                        WHERE r.id_rubrique =
pr.id_rubrique
                        AND r.id_rubrique = rl.id_rubrique
                        AND rl.language = 'fr'
						AND p.id_produit = pr.id_produit
                        AND p.id_produit = pl.id_produit
                        AND pl.language = 'fr'  AND
pr.id_rubrique = '1' AND p.actif = '1' AND r.actif = '1' 
0.00069
24
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'rubrique'
0.00031
25
 SELECT DISTINCT m.nom AS nomMarque, m.image AS imageMarque,
mo.nom AS nomModele, p.*, pl.*, 
                            IF(1, promo, NOW() BETWEEN
debut_promo AND fin_promo) AS promo,
                            IF(1, nouveaute, NOW() BETWEEN
debut_nouveaute AND fin_nouveaute) AS nouveaute,
                            IF(1, phare, NOW() BETWEEN
debut_phare AND fin_phare) AS phare,
                            IF(1, solde, NOW() BETWEEN
debut_solde AND fin_solde) AS solde,
							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_mosaic_produit
p
                           JOIN
oktopusV1_mod_mosaic_produit_locales pl ON pl.id_produit =
p.id_produit AND pl.language = 'fr' LEFT JOIN
oktopusV1_mod_mosaic_marque m ON p.id_marque = m.id_marque
                           LEFT JOIN
oktopusV1_mod_mosaic_modele mo ON p.id_modele =
mo.id_modele
                           LEFT JOIN
oktopusV1_mod_mosaic_produit_rubrique pr ON pr.id_produit =
p.id_produit
                           WHERE 1 ORDER BY nom
0.00190
26
SELECT COUNT(p.id_produit) FROM
oktopusV1_mod_mosaic_rubrique r,
oktopusV1_mod_mosaic_rubrique_locales rl,
oktopusV1_mod_mosaic_produit_rubrique pr,
oktopusV1_mod_mosaic_produit p,
oktopusV1_mod_mosaic_produit_locales pl
                        WHERE r.id_rubrique =
pr.id_rubrique
                        AND r.id_rubrique = rl.id_rubrique
                        AND rl.language = 'fr'
						AND p.id_produit = pr.id_produit
                        AND p.id_produit = pl.id_produit
                        AND pl.language = 'fr'  AND
pr.id_rubrique = '1' AND p.actif = '1' AND r.actif = '1' 
0.00033
27
SELECT pr.*, rl.slug  FROM oktopusV1_mod_mosaic_rubrique r,
oktopusV1_mod_mosaic_rubrique_locales rl,
oktopusV1_mod_mosaic_produit_rubrique pr,
oktopusV1_mod_mosaic_produit p,
oktopusV1_mod_mosaic_produit_locales pl
                        WHERE r.id_rubrique =
pr.id_rubrique
                        AND r.id_rubrique = rl.id_rubrique
                        AND rl.language = 'fr'
						AND p.id_produit = pr.id_produit
                        AND p.id_produit = pl.id_produit
                        AND pl.language = 'fr'  AND
pr.id_rubrique = '1' AND p.actif = '1' AND r.actif = '1' 
ORDER BY pr.position ASC LIMIT 0,20
0.00074
28
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00049
29
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '1' ORDER BY position 
0.00047
30
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00047
31
 SELECT pd.*, p.id_tva FROM
oktopusV1_mod_mosaic_produit_declinaison AS pd
                        LEFT JOIN
oktopusV1_mod_mosaic_produit as p ON p.id_produit =
pd.id_produit
						WHERE 1 AND pd.id_produit = '1' ORDER BY
pd.id_produit_declinaison 
0.00053
32
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '1'
0.00049
33

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='1'
0.00033
34
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '1'
0.00030
35
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '1'
0.00040
36

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='1'
0.00033
37
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '1'
0.00030
38
SELECT r.*, rl.*, COUNT(r.id_rubrique) AS num_posts FROM
oktopusV1_mod_mosaic_rubrique AS r LEFT JOIN
oktopusV1_mod_mosaic_rubrique_locales AS rl ON r.id_rubrique
= rl.id_rubrique WHERE 1 AND rl.language='fr' AND
r.id_parent = 1 AND r.actif = 1  GROUP BY r.id_rubrique
ORDER BY nleft asc 
0.00097
39
 SELECT DISTINCT m.nom AS nomMarque, m.image AS imageMarque,
mo.nom AS nomModele, p.*, pl.*, pr.position,
                            IF(1, promo, NOW() BETWEEN
debut_promo AND fin_promo) AS promo,
                            IF(1, nouveaute, NOW() BETWEEN
debut_nouveaute AND fin_nouveaute) AS nouveaute,
                            IF(1, phare, NOW() BETWEEN
debut_phare AND fin_phare) AS phare,
                            IF(1, solde, NOW() BETWEEN
debut_solde AND fin_solde) AS solde,
							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_mosaic_produit
p
                           JOIN
oktopusV1_mod_mosaic_produit_locales pl ON pl.id_produit =
p.id_produit AND pl.language = 'fr' LEFT JOIN
oktopusV1_mod_mosaic_marque m ON p.id_marque = m.id_marque
                           LEFT JOIN
oktopusV1_mod_mosaic_modele mo ON p.id_modele =
mo.id_modele
                           LEFT JOIN
oktopusV1_mod_mosaic_produit_rubrique pr ON pr.id_produit =
p.id_produit
                           WHERE pr.id_rubrique IN (1) AND
p.actif = '1' ORDER BY pr.position
0.00156
40
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '1'
0.00032
41
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 AND
actif = '1' ORDER BY position
0.00045
42
 SELECT dc.* 
                                FROM
oktopusV1_mod_mosaic_declinaison_champ AS dc 
                                WHERE 1 AND dc.actif = '1'
ORDER BY dc.position
0.00180
43
SELECT r.*, rl.*, COUNT(r.id_rubrique) AS num_posts FROM
oktopusV1_mod_mosaic_rubrique AS r LEFT JOIN
oktopusV1_mod_mosaic_rubrique_locales AS rl ON r.id_rubrique
= rl.id_rubrique WHERE 1 AND rl.language='fr' AND
r.id_parent = 1 AND r.actif = 1  GROUP BY r.id_rubrique
ORDER BY nleft asc 
0.00041
44
SELECT *, DATE_FORMAT(livraison_date, '%d/%m/%Y') AS
livraison_date_fr
                   FROM oktopusV1_mod_mosaic_panier WHERE
id_client = 'tmp_6472bb7b33950'
0.00051
45
SELECT p.date, pd.*, po.id_tva FROM
oktopusV1_mod_mosaic_panier AS p
                    LEFT JOIN
oktopusV1_mod_mosaic_panier_detail AS pd ON p.id_panier =
pd.id_panier
                    LEFT JOIN oktopusV1_mod_mosaic_produit
AS po ON pd.id_produit = po.id_produit WHERE p.id_client =
''
0.00033
46
 SELECT t.*,
                            DATE_FORMAT(t.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                            DATE_FORMAT(t.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
                       FROM oktopusV1_mod_slideshow_type t
                       WHERE 1 AND CASE 
                                       WHEN t.choix_rubrique
= 1 THEN
                                           t.rubrique LIKE
'%\'/bon-cadeau-1\'%'
                                       WHEN t.choix_rubrique
= 2 THEN
                                          
                   (  SELECT COUNT(t.id_type) FROM
oktopusV1_mod_slideshow_type t
                      WHERE t.choix_rubrique = 1 AND
t.rubrique LIKE '%\'/bon-cadeau-1\'%' AND t.actif = 1
                   ) = 0
                
                                           AND
                                           t.rubrique NOT
LIKE '%\'/bon-cadeau-1\'%'
                                       ELSE     
                                          
                   (  SELECT COUNT(t.id_type) FROM
oktopusV1_mod_slideshow_type t
                      WHERE t.choix_rubrique = 1 AND
t.rubrique LIKE '%\'/bon-cadeau-1\'%' AND t.actif = 1
                   ) = 0
                 
                                   END AND actif = '1' ORDER
BY nom 
0.00082
47
SELECT t.*, 
                        DATE_FORMAT(t.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                        DATE_FORMAT(t.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr 
                     FROM oktopusV1_mod_slideshow_type t
                     WHERE t.id_type = '2'
0.00034
48
 SELECT p.*, pl.valeur AS legende, pl.lien,
pl.contenu_titre,  pl.contenu_ss_titre,
pl.contenu_description, pl.primaire_texte,
pl.primaire_texte_mobile, pl.secondaire_texte,
pl.secondaire_texte_mobile, pl.primaire_slug,
pl.secondaire_slug, pl.lien2,  
                          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_slideshow p
                       LEFT JOIN
oktopusV1_mod_slideshow_locales pl ON pl.id_slideshow =
p.id_slideshow AND pl.language = 'fr'
                       WHERE 1 AND p.actif = '1' AND id_type
= '2' ORDER BY position
0.00039
49
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
0.00036
50
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
'%\'/bon-cadeau-1\'%') ORDER BY p.rubrique DESC
0.00065
51
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
'%\'/bon-cadeau-1\'%') ORDER BY p.rubrique DESC
0.00053
# type fichier ligne classe fonction message