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

REPLACE INTO oktopusV1_core_users_online (user_id, ident,
logged, csrf_token, prev_url) VALUES
(1,'d9d4c7468dd26f6615ff10d7d44007539e26d8fdd4d07bc3610431ab1ad9fe0e',
1715865587, '27a3b928d7dd663a422acb860a2209285e39f976',
'https://www.youlead-tours.fr/g-temoignages')

            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 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 snrl.slug ='temoignages'

UPDATE oktopusV1_mod_social_network_reseau SET token =
'YTo3OntzOjEyOiJhY2Nlc3NfdG9rZW4iO3M6MjIxOiJ5YTI5LmEwQVhvb0NndmRwanFKQ2NER2pLVkdDQVlCQ2xmSWVtQm54TUJPcUhPR1J4Y1JKTXNJTXVHY3plR2lfYUpCUG80dWhTcEZvTFlaWHg3bWVtSXVNQVhVWVNINmczcVlzb1JUbHpqTi1mQmY2czlDSDBlZWtQUzd3aE9KWFBGem1JbzE4VEtoR3ZOVVRQUUFMRG1URmphTkhrT2c4WXl6Z0RmLU5USUk5WGNhQ2dZS0FTb1NBUkVTRlFIR1gyTWlfTkg0eDZETXNMSkJLUC1fcDJWRnFBMDE3NCI7czoxMDoiZXhwaXJlc19pbiI7aTozNTk5O3M6NToic2NvcGUiO3M6OTY6Imh0dHBzOi8vd3d3Lmdvb2dsZWFwaXMuY29tL2F1dGgvYnVzaW5lc3MubWFuYWdlIGh0dHBzOi8vd3d3Lmdvb2dsZWFwaXMuY29tL2F1dGgvdXNlcmluZm8ucHJvZmlsZSI7czoxMDoidG9rZW5fdHlwZSI7czo2OiJCZWFyZXIiO3M6ODoiaWRfdG9rZW4iO3M6ODQxOiJleUpoYkdjaU9pSlNVekkxTmlJc0ltdHBaQ0k2SW1FellqYzJNbVk0TnpGalpHSXpZbUZsTURBME5HTTJORGsyTWpKbVl6RXpPVFpsWkdFelpUTWlMQ0owZVhBaU9pSktWMVFpZlEuZXlKcGMzTWlPaUpvZEhSd2N6b3ZMMkZqWTI5MWJuUnpMbWR2YjJkc1pTNWpiMjBpTENKaGVuQWlPaUl4TVRRNU5qVXpNakUyT1MxMVpEaG1iRGR1YzJoMWJtRnlaSFUzYkdJd2EzWjFNMmMzT0RGcVkzSXhieTVoY0hCekxtZHZiMmRzWlhWelpYSmpiMjUwWlc1MExtTnZiU0lzSW1GMVpDSTZJakV4TkRrMk5UTXlNVFk1TFhWa09HWnNOMjV6YUhWdVlYSmtkVGRzWWpCcmRuVXpaemM0TVdwamNqRnZMbUZ3Y0hNdVoyOXZaMnhsZFhObGNtTnZiblJsYm5RdVkyOXRJaXdpYzNWaUlqb2lNVEE1TmpjNE5ERXdPREk1TXpjNU56QXlPVFV5SWl3aVlYUmZhR0Z6YUNJNklsVTVhR0YxTkZsMU5UQkJNREpEY0c1Tk5YaG1VV2NpTENKcFlYUWlPakUzTVRVNE5qVTFPRGNzSW1WNGNDSTZNVGN4TlRnMk9URTROMzAuWVB2WENUa2lkREt1N2dMa05LR0c1R3NjWllZVjJxNk5KRlFKLXZRUF8tZTFXTmZRTzE0M3FPbVpvTm92LUwxbzdmVUgtbklhUW5fM2QwdjN6U0FfREVQNnpNQkRtT0h3NnF2aFBNRjJNcXJhRHc0REFNMUE3c21XRkZ6V1hkY290UDhWZk0xVVJDSGJVMGtTenppeUtva1I3M1BFamRnamVHU0RzcVhhcEY5NXVLXzJCcldEc0pWTmtTNlc4bGl5Z3dTc3RGLXY4aWdyZENWUkZtaDF3OFJFYmpZcVhRb3JjM2dubVhjZnJVMVp1MUlieEtrY0gzdmtCWVpnOEpFa1dSWm9ic2w5aTRLTm01YzZ1SDVWa25jbnBOZ09VbE5hckE4cVJveWxpaklXaVVDSVZsOGd1TVJJdUQ2R2c3dUx6Zm5ncU1UdGE4azVCMTMzTV82SlhnIjtzOjc6ImNyZWF0ZWQiO2k6MTcxNTg2NTU4NztzOjEzOiJyZWZyZXNoX3Rva2VuIjtzOjEwMzoiMS8vMDNjMW52dDY1ZnZWdkNnWUlBUkFBR0FNU053Ri1MOUlyQUNZXy1CM19XdC01bzZwNjR5U2Zfd1Noa2VfbkhBMHRub2NhNzBETTBCM25vY001UzJBNGk4X0JaamJVU2h0UHVkVSI7fQ=='
WHERE id_reseau=3

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

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

 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
'%\'/g-temoignages\'%'
                                       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 '%\'/g-temoignages\'%' AND t.actif = 1
                   ) = 0
                
                                           AND
                                           t.rubrique NOT
LIKE '%\'/g-temoignages\'%'
                                       ELSE     
                                          
                   (  SELECT COUNT(t.id_type) FROM
oktopusV1_mod_slideshow_type t
                      WHERE t.choix_rubrique = 1 AND
t.rubrique LIKE '%\'/g-temoignages\'%' AND t.actif = 1
                   ) = 0
                 
                                   END AND actif = '1' ORDER
BY nom 

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'

 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

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

SELECT p.id, p.active, p.category_id, p.name, p.logo,
p.created_at, p.updated_at, p.bookmark, pl.description,
pl.url, pl.url_title, cl.name AS category_name FROM
oktopusV1_mod_partners AS p LEFT JOIN
oktopusV1_mod_partners_categories AS c ON p.category_id=c.id
LEFT JOIN oktopusV1_mod_partners_categories_locales AS cl ON
cl.category_id=c.id LEFT JOIN oktopusV1_mod_partners_locales
AS pl ON pl.partner_id=p.id WHERE 1 AND pl.language='fr' AND
(cl.language='fr' OR c.id IS NULL) AND p.active=1 ORDER BY
p.bookmark DESC, p.ord DESC