SET NAMES utf8mb4

SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV3_core_users AS u INNER JOIN
oktopusV3_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV3_core_users_online AS o ON
o.ident='2e0b87a94187d9b0cf1829ee5190ae3e21f76df1088a2e931b851d5d69d49795'
WHERE u.id=1

UPDATE oktopusV3_core_users_online SET logged=1701345776,
prev_url='https://www.yoga-ayurveda-63.com/g-vos-avis' WHERE
ident='2e0b87a94187d9b0cf1829ee5190ae3e21f76df1088a2e931b851d5d69d49795'

UPDATE oktopusV3_mod_news SET active = 1
                           WHERE active = 3 AND NOW() >
created_at 

UPDATE oktopusV3_mod_news SET active = 0
                              WHERE active = 1 AND end_at !=
"0000-00-00 00:00:00" 
                              AND NOW() > end_at 

            SELECT 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 oktopusV3_mod_social_network_reseau snr
            JOIN oktopusV3_mod_social_network_reseau_locales
snrl ON snrl.id_reseau = snr.id_reseau AND snrl.language =
'fr'
            WHERE 1 AND snrl.slug ='vos-avis'

UPDATE oktopusV3_mod_social_network_reseau SET token =
'YTo3OntzOjEyOiJhY2Nlc3NfdG9rZW4iO3M6MjIxOiJ5YTI5LmEwQWZCX2J5QlRBbjYxdFBIUkQtNm5qMmdiNS1QaVBfVXhUWG5Na0hSMGpqWlQ0Y3VUdXBfRkNjR1dhY0JhVTR6cHAwWDR2UzJydmh5Q0RnWnNEcVhJZUVxeFpUa1dGeldIVXBEWmVVZDEta1JNS3ZXRjRwLWNwTDNFY2ZmQXZtQU1HSEI0b185dkY4djhtbzVBcy10aXNxbTA4a0lQdi1Nc2lKTmtOQmNhQ2dZS0FZZ1NBUkFTRlFIR1gyTWk3RlhXcnlkNDZYak5OLS14QVcyMXZ3MDE3NCI7czoxMDoiZXhwaXJlc19pbiI7aTozNTk5O3M6NToic2NvcGUiO3M6OTY6Imh0dHBzOi8vd3d3Lmdvb2dsZWFwaXMuY29tL2F1dGgvdXNlcmluZm8ucHJvZmlsZSBodHRwczovL3d3dy5nb29nbGVhcGlzLmNvbS9hdXRoL2J1c2luZXNzLm1hbmFnZSI7czoxMDoidG9rZW5fdHlwZSI7czo2OiJCZWFyZXIiO3M6ODoiaWRfdG9rZW4iO3M6MTA5NzoiZXlKaGJHY2lPaUpTVXpJMU5pSXNJbXRwWkNJNklqQmxOekprWVRGa1pqVXdNV05oTm1ZM05UWmlaakV3TTJaa04yTTNNakF5T1RRM056STFNRFlpTENKMGVYQWlPaUpLVjFRaWZRLmV5SnBjM01pT2lKb2RIUndjem92TDJGalkyOTFiblJ6TG1kdmIyZHNaUzVqYjIwaUxDSmhlbkFpT2lJeE1UUTVOalV6TWpFMk9TMTFaRGhtYkRkdWMyaDFibUZ5WkhVM2JHSXdhM1oxTTJjM09ERnFZM0l4Ynk1aGNIQnpMbWR2YjJkc1pYVnpaWEpqYjI1MFpXNTBMbU52YlNJc0ltRjFaQ0k2SWpFeE5EazJOVE15TVRZNUxYVmtPR1pzTjI1emFIVnVZWEprZFRkc1lqQnJkblV6WnpjNE1XcGpjakZ2TG1Gd2NITXVaMjl2WjJ4bGRYTmxjbU52Ym5SbGJuUXVZMjl0SWl3aWMzVmlJam9pTVRFM09Ua3pOVFkwT0RJMk16VTNNVFl4Tmpnd0lpd2lZWFJmYUdGemFDSTZJbG94Vm5waE5uZE9TRUpFU0RjNWEwWTNiM1JDUzNjaUxDSnVZVzFsSWpvaVVHaHBiR2x3Y0dVZ1JuSmhaR2x1SWl3aWNHbGpkSFZ5WlNJNkltaDBkSEJ6T2k4dmJHZ3pMbWR2YjJkc1pYVnpaWEpqYjI1MFpXNTBMbU52YlM5aEwwRkRaemh2WTBsMVZWbHpObFIwVTNwUlVqVlpkV1F4UjFKeU1VZzNiVkJ6Y1hGRGFHcDNURmx5VFhOclQwVmFTblU0U1Qxek9UWXRZeUlzSW1kcGRtVnVYMjVoYldVaU9pSlFhR2xzYVhCd1pTSXNJbVpoYldsc2VWOXVZVzFsSWpvaVJuSmhaR2x1SWl3aWJHOWpZV3hsSWpvaVpuSWlMQ0pwWVhRaU9qRTNNREV6TkRVM056WXNJbVY0Y0NJNk1UY3dNVE0wT1RNM05uMC5ZVjgyTzlMczlrSFUyWWRyQzZtRHVyRXcwUkVqbWFfOXFmb3pmUUtiLXRQYVpZZURBZWwtVnF1RVBBR1EyUU93QTRVMHB5MFRwd0RtMHI5dzRtSDNicjdVUTg1YVVVVXh1YjMtZDJIXzNXaDdQTVBYaGlQMFRVeElZazZ0NzFid3MzelJLcUhNclpvbUZXYWNIV0IyLVUzWFVhRm1nUFg2MzJEZ3pzNElfdVBfVmNyTnl0UUs0bmx5TTFmQUpVNm9NMVdoaTVkTFZISnRpekNFaWY5clRHZE9sMjdqdW9HWjUwaXJNZ3VVb3djMHdqRDFwOXAyZUZBb3RqYlZYaENLSnBmTFhoYnpucTdRZTBIMWEzdmtDbl9QM3pDTXh1dEt0cUJla1ZTOFlUYWI1X2hTaEUwOFhNNlBGUXk0cDAtb0w2dldPTEYwRll0QUMxam1ReW0zQnciO3M6NzoiY3JlYXRlZCI7aToxNzAxMzQ1Nzc3O3M6MTM6InJlZnJlc2hfdG9rZW4iO3M6MTAzOiIxLy8wMzJsWnRRZjVBVm9mQ2dZSUFSQUFHQU1TTndGLUw5SXJFQlh0VTNvQnRaQVl4RDB5RGFKenhXb3UwX2RnU1NnRTVzNDBmVTlqQ0NZSUZKdmhxMGFjWXhBM055OV9jNVE0V0tvIjt9'
WHERE id_reseau=1

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

SELECT p.date, pd.*, po.id_tva FROM
oktopusV3_mod_mosaic_panier AS p
                    LEFT JOIN
oktopusV3_mod_mosaic_panier_detail AS pd ON p.id_panier =
pd.id_panier
                    LEFT JOIN oktopusV3_mod_mosaic_produit
AS po ON pd.id_produit = po.id_produit WHERE p.id_client =
''