SET NAMES utf8mb4

SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV2_core_users AS u INNER JOIN
oktopusV2_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV2_core_users_online AS o ON
o.ident='3.233.219.103' WHERE u.id=1

UPDATE oktopusV2_core_users_online SET logged=1686095232,
prev_url='https://www.lumiere-vitale.eu/panier' WHERE
ident='3.233.219.103'

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

SELECT * FROM oktopusV2_mod_mosaic_declinaison WHERE 1 ORDER
BY position

SELECT MIN(total_minimum) FROM
oktopusV2_mod_mosaic_transporteur WHERE actif = 1

SELECT p.date, pd.*, po.id_tva FROM
oktopusV2_mod_mosaic_panier AS p
                    LEFT JOIN
oktopusV2_mod_mosaic_panier_detail AS pd ON p.id_panier =
pd.id_panier
                    LEFT JOIN oktopusV2_mod_mosaic_produit
AS po ON pd.id_produit = po.id_produit WHERE p.id_client =
''

 SELECT r.*, rl.*, 
                        DATE_FORMAT(r.date_debut_validite,
'%d/%m/%Y') AS date_debut_validite_fr, 
                        DATE_FORMAT(r.date_fin_validite,
'%d/%m/%Y') AS date_fin_validite_fr
                        FROM
oktopusV2_mod_mosaic_regle_panier r
                        JOIN
oktopusV2_mod_mosaic_regle_panier_locales rl ON
rl.id_regle_panier = r.id_regle_panier AND rl.language =
'fr'  
                        WHERE 1 AND IF(date_debut_validite =
'0000-00-00', 1 , CURDATE() BETWEEN date_debut_validite AND
date_fin_validite) AND IF(type_client = 0, 1, type_client =
'4')  AND IF(id_client = 0, 1, id_client =
'tmp_647fc580505bd')   AND IF(montant_minimum = 0, 1,
montant_minimum <= '0') AND IF(type_reduction <> '€', 1,
valeur <= '0') AND r.id_regle_panier IN(SELECT
id_regle_panier FROM oktopusV2_mod_mosaic_panier_regle WHERE
id_panier = '') ORDER BY priorite, code

 SELECT r.*, rl.*, 
                        DATE_FORMAT(r.date_debut_validite,
'%d/%m/%Y') AS date_debut_validite_fr, 
                        DATE_FORMAT(r.date_fin_validite,
'%d/%m/%Y') AS date_fin_validite_fr
                        FROM
oktopusV2_mod_mosaic_regle_panier r
                        JOIN
oktopusV2_mod_mosaic_regle_panier_locales rl ON
rl.id_regle_panier = r.id_regle_panier AND rl.language =
'fr'  
                        WHERE 1 AND r.id_regle_panier
IN(SELECT id_regle_panier FROM
oktopusV2_mod_mosaic_panier_regle WHERE id_panier = '')
ORDER BY priorite, code

SELECT p.date, pd.*, po.id_tva FROM
oktopusV2_mod_mosaic_panier AS p
                    LEFT JOIN
oktopusV2_mod_mosaic_panier_detail AS pd ON p.id_panier =
pd.id_panier
                    LEFT JOIN oktopusV2_mod_mosaic_produit
AS po ON pd.id_produit = po.id_produit WHERE p.id_client =
''

 SELECT r.*, rl.*, 
                        DATE_FORMAT(r.date_debut_validite,
'%d/%m/%Y') AS date_debut_validite_fr, 
                        DATE_FORMAT(r.date_fin_validite,
'%d/%m/%Y') AS date_fin_validite_fr
                        FROM
oktopusV2_mod_mosaic_regle_panier r
                        JOIN
oktopusV2_mod_mosaic_regle_panier_locales rl ON
rl.id_regle_panier = r.id_regle_panier AND rl.language =
'fr'  
                        WHERE 1 AND IF(date_debut_validite =
'0000-00-00', 1 , CURDATE() BETWEEN date_debut_validite AND
date_fin_validite) AND IF(type_client = 0, 1, type_client =
'4')  AND IF(id_client = 0, 1, id_client =
'tmp_647fc580505bd')   AND code = '' AND IF(montant_minimum
= 0, 1, montant_minimum <= '0') AND IF(type_reduction <>
'€', 1, valeur <= '0') AND r.id_regle_panier NOT IN(SELECT
id_regle_panier FROM oktopusV2_mod_mosaic_panier_regle WHERE
id_panier = '') AND r.apply_reduction <> 'CA' ORDER BY
priorite, code

 SELECT r.*, rl.*, 
                        DATE_FORMAT(r.date_debut_validite,
'%d/%m/%Y') AS date_debut_validite_fr, 
                        DATE_FORMAT(r.date_fin_validite,
'%d/%m/%Y') AS date_fin_validite_fr
                        FROM
oktopusV2_mod_mosaic_regle_panier r
                        JOIN
oktopusV2_mod_mosaic_regle_panier_locales rl ON
rl.id_regle_panier = r.id_regle_panier AND rl.language =
'fr'  
                        WHERE 1 AND r.id_regle_panier
IN(SELECT id_regle_panier FROM
oktopusV2_mod_mosaic_panier_regle WHERE id_panier = '') AND
r.code <> '' ORDER BY priorite, code

 SELECT r.*, rl.*, 
                        DATE_FORMAT(r.date_debut_validite,
'%d/%m/%Y') AS date_debut_validite_fr, 
                        DATE_FORMAT(r.date_fin_validite,
'%d/%m/%Y') AS date_fin_validite_fr
                        FROM
oktopusV2_mod_mosaic_regle_panier r
                        JOIN
oktopusV2_mod_mosaic_regle_panier_locales rl ON
rl.id_regle_panier = r.id_regle_panier AND rl.language =
'fr'  
                        WHERE 1 AND r.id_regle_panier
IN(SELECT id_regle_panier FROM
oktopusV2_mod_mosaic_panier_regle WHERE id_panier = '')
ORDER BY priorite, code

SELECT COUNT(id_panier) FROM oktopusV2_mod_mosaic_panier
WHERE id_client = 'tmp_647fc580505bd'  

SELECT DISTINCT sn.*, snl.*
                      FROM oktopusV2_mod_social_network sn
                      JOIN
oktopusV2_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 f.id, f.active, f.type, f.category, f.ord, f.html_id,
f.colonne, f.picto, f.options, f.info_personnelle, fl.title,
fl.legend, fl.description, fl.value FROM
oktopusV2_mod_contact_fields f LEFT JOIN
oktopusV2_mod_contact_fields_locales AS fl ON
fl.field_id=f.id AND fl.category=f.category WHERE 1  AND
f.active>0  AND f.category = "insert" AND fl.language='fr'
ORDER BY ord ASC 

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 oktopusV2_mod_home_popup p
                      LEFT JOIN
oktopusV2_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 '%\'/panier\'%')
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 oktopusV2_mod_home_popup p
                      LEFT JOIN
oktopusV2_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 '%\'/panier\'%')
ORDER BY p.rubrique DESC