0 article(s)

0 article(s)

0.00 €

Le produit a été ajouté au panier

Total : 0.00 €

  • Oeno Mélo
  • Oeno Mélo

ÉVÉNEMENT ÉPHÉMÈRE - La journée

Rando en mobylette guidée à la découverte du vignoble Auxerrois

Partons à l'aventure avec les Mobs à Manu !!!! 🛵

Seriez-vous vous prêt à vivre 1 demi-journée ou entière riche en découverte du patrimoine viticoles, rencontres humaines, paysage de folie, Gastromie et vins... le tout en remontant le temps au guidon d'une ....

⚠️ Proposer sur seulement 3 jours en Avril !!!! Places limitées alors donnez rdv avec vos potes et venez passer un moment en Bourgogne inoubliable. 

Au Programme : 

🌱Visite pépinière Chalmeau à Chitry 

✂️🍇🍷Découverte des travaux de la vigne avec Antoine à Chitry dégustation de ses vins puis repas côte de Bœuf à la Chaufferette 

Visite des caves historique du XIIe siècle du Domaine Bersan et dégustation à Saint Bris le Vineux. 

Visite des caves souterraines de Crémant de Bourgogne, découverte du musée du vieux pressoir à Coulanges la vineuse puis dégustation de planches du Terroir au Clos du roi

180,00 €
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,89 Mo
  • Pic mémoire allouée par PHP : 5,10 Mo
  • Temps d'execution du script : 0.536 s
  • Lang :
  • Path : evenement-2/evenement-ephemere-la-journee-7
  • Route : mosaicProduit
  • $okt->page->module : mosaic
  • $okt->page->action :
  • Title tag : ÉVÉNEMENT ÉPHÉMÈRE - la journée - Événement - Oeno Mélo
  • Title:
  • H1:
  • Meta description: ÉVÉNEMENT ÉPHÉMÈRE - La journée Rando en mobylette guidée à la découverte du vignoble Auxerrois Partons à l'aventure avec les Mobs
  • 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.00035
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.00080
3
UPDATE oktopusV1_core_users_online SET logged=1685239832,
prev_url='https://www.oeno-melo.fr/evenement-2/evenement-ephemere-la-journee-7'
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.00050
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.00037
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.00038
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.00048
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.00041
10
UPDATE oktopusV1_mod_news SET active = 1
                           WHERE active = 3 AND NOW() >
created_at 
0.00056
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.00041
12

            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='2'
0.00047
13
SELECT m.nom AS nomMarque, m.image AS imageMarque, mo.nom AS
nomModele, p.*, pl.*,
						DATE_FORMAT(p.debut_promo, '%d/%m/%Y') as
debut_promo_fr,
						DATE_FORMAT(p.fin_promo, '%d/%m/%Y') as fin_promo_fr,
						DATE_FORMAT(p.debut_nouveaute, '%d/%m/%Y') as
debut_nouveaute_fr,
						DATE_FORMAT(p.fin_nouveaute, '%d/%m/%Y') as
fin_nouveaute_fr,
						DATE_FORMAT(p.debut_phare, '%d/%m/%Y') as
debut_phare_fr,
						DATE_FORMAT(p.fin_phare, '%d/%m/%Y') as fin_phare_fr,
						DATE_FORMAT(p.debut_solde, '%d/%m/%Y') as
debut_solde_fr,
						DATE_FORMAT(p.fin_solde, '%d/%m/%Y') as fin_solde_fr,
						DATE_FORMAT(p.debut_commande, '%d/%m/%Y') as
debut_commande_fr,
						DATE_FORMAT(p.fin_commande, '%d/%m/%Y') as
fin_commande_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,
                        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
     				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
					WHERE p.id_produit = '7'
0.00105
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.00043
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.00092
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.00038
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.00032
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.00036
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.00073
20
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '7'
0.00055
21

            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='2'
0.00032
22
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00030
23
SELECT COUNT(id_produit) FROM oktopusV1_mod_mosaic_produit
WHERE id_produit = '7' 
0.00042
24
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00035
25
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '7' ORDER BY position 
0.00050
26
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00036
27
 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 = '7' AND pd.actif = '1'
ORDER BY pd.id_produit_declinaison 
0.00051
28
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '7'
0.00038
29

            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='2'
0.00034
30
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00030
31
SELECT ca.*, p.nom as nomPays, p.id_pays, p.id_zone, p.code,
p.code_num 
                     FROM oktopusV1_mod_address_book ca,
oktopusV1_mod_geographie_pays p
                     WHERE ca.pays_id = p.id_pays AND
ca.facturation=1 AND ca.user_id='1'
0.00041
32
SELECT *, DATE_FORMAT(livraison_date, '%d/%m/%Y') AS
livraison_date_fr
                   FROM oktopusV1_mod_mosaic_panier WHERE
id_client = 'tmp_6472b81856d0c'
0.00053
33
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.00034
34
 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
'%\'/evenement-2/evenement-ephemere-la-journee-7\'%'
                                       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
'%\'/evenement-2/evenement-ephemere-la-journee-7\'%' AND
t.actif = 1
                   ) = 0
                
                                           AND
                                           t.rubrique NOT
LIKE '%\'/evenement-2/evenement-ephemere-la-journee-7\'%'
                                       ELSE     
                                          
                   (  SELECT COUNT(t.id_type) FROM
oktopusV1_mod_slideshow_type t
                      WHERE t.choix_rubrique = 1 AND
t.rubrique LIKE
'%\'/evenement-2/evenement-ephemere-la-journee-7\'%' AND
t.actif = 1
                   ) = 0
                 
                                   END AND actif = '1' ORDER
BY nom 
0.00082
35
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.00033
36
 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.00097
37
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.00034
38
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
'%\'/evenement-2/evenement-ephemere-la-journee-7\'%') ORDER
BY p.rubrique DESC
0.00060
39
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
'%\'/evenement-2/evenement-ephemere-la-journee-7\'%') ORDER
BY p.rubrique DESC
0.00057
# type fichier ligne classe fonction message