Restaurant des îles à Pithiviers, Malesherbes et Chilleurs-aux-Bois

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='3.235.101.141' WHERE u.id=1

UPDATE oktopusV1_core_users_online SET logged=1603378697,
prev_url='https://www.le-manoa-restaurant.com/avis-client'
WHERE ident='3.235.101.141'

SELECT COUNT(id) AS num_sig FROM oktopusV1_mod_guestbook
WHERE 1 AND type='1' AND visible=1 AND spam_status IS NULL
AND language='fr' ORDER BY date_sign DESC 

SELECT id, language, message, nom, email, url, note, ip,
date_sign, visible, spam_status, spam_filter, date_reponse,
reponse,type,element,id_user, DATE_FORMAT(date_sign,
"%d/%m/%Y %Hh%i") AS date_sign_fr, DATE_FORMAT(date_reponse,
"%d/%m/%Y %Hh%i") AS date_reponse_fr FROM
oktopusV1_mod_guestbook WHERE 1 AND type='1' AND visible=1
AND spam_status IS NULL AND language='fr' ORDER BY date_sign
DESC LIMIT 0,5 

SELECT COUNT(id) AS num_sig, AVG(note) AS avg_note FROM
oktopusV1_mod_guestbook WHERE 1 AND visible=1 AND
spam_status IS NULL AND language='fr' 

SELECT *, DATE_FORMAT(livraison_date, '%d/%m/%Y') AS
livraison_date_fr
                   FROM oktopusV1_mod_mosaic_panier WHERE
id_client = 'tmp_5f919e0975d35'

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 =
''