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

REPLACE INTO oktopusV1_core_users_online (user_id, ident,
logged, csrf_token, prev_url) VALUES
(1,'7e755446c317f34f20dbbab2c8ce9489e9d4716bcf0966ce2fbcee8c2009ffd0',
1722078596, '6289db2857009c1e4099d880134ec3c6b1a76857',
'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 =
'YTo3OntzOjEyOiJhY2Nlc3NfdG9rZW4iO3M6MjIxOiJ5YTI5LmEwQVhvb0Nnc1c4UkhvX1FhRWg4bDZxaXBJOE5PcTBiMEstRVUxb1pvZlBJSDdoVDhMRHVockt4bFh3ZmV3czdSOThqODhma3V2REhpeEhmTWVaZ0paWlNRa1FnWU9uamZFRmNNc3ZWdldiTDBhc2NHQXVxS0NhcnJ0OXRuay1wN0t3TXlVVTNENDJ3WFNNUzRGUUFDclkwc1RsMG5FQnhyUXF0Y1lYOHNhQ2dZS0Fja1NBUkVTRlFIR1gyTWllOUlKbmhvanUwSTV5dWhEb2dsemdnMDE3NCI7czoxMDoiZXhwaXJlc19pbiI7aTozNTk5O3M6NToic2NvcGUiO3M6OTY6Imh0dHBzOi8vd3d3Lmdvb2dsZWFwaXMuY29tL2F1dGgvdXNlcmluZm8ucHJvZmlsZSBodHRwczovL3d3dy5nb29nbGVhcGlzLmNvbS9hdXRoL2J1c2luZXNzLm1hbmFnZSI7czoxMDoidG9rZW5fdHlwZSI7czo2OiJCZWFyZXIiO3M6ODoiaWRfdG9rZW4iO3M6ODQxOiJleUpoYkdjaU9pSlNVekkxTmlJc0ltdHBaQ0k2SW1ZeVpURXhPVGcyTWpneVpHVTVNMll5TjJJeU5qUm1aREpoTkdSbE1Ua3lPVGt6WkdOaU9HTWlMQ0owZVhBaU9pSktWMVFpZlEuZXlKcGMzTWlPaUpvZEhSd2N6b3ZMMkZqWTI5MWJuUnpMbWR2YjJkc1pTNWpiMjBpTENKaGVuQWlPaUl4TVRRNU5qVXpNakUyT1MxMVpEaG1iRGR1YzJoMWJtRnlaSFUzYkdJd2EzWjFNMmMzT0RGcVkzSXhieTVoY0hCekxtZHZiMmRzWlhWelpYSmpiMjUwWlc1MExtTnZiU0lzSW1GMVpDSTZJakV4TkRrMk5UTXlNVFk1TFhWa09HWnNOMjV6YUhWdVlYSmtkVGRzWWpCcmRuVXpaemM0TVdwamNqRnZMbUZ3Y0hNdVoyOXZaMnhsZFhObGNtTnZiblJsYm5RdVkyOXRJaXdpYzNWaUlqb2lNVEE1TmpjNE5ERXdPREk1TXpjNU56QXlPVFV5SWl3aVlYUmZhR0Z6YUNJNklrNW1TMDAwYmtOU1EwRk5ORmQ0WlU1MVJIZERSMmNpTENKcFlYUWlPakUzTWpJd056ZzFPVFlzSW1WNGNDSTZNVGN5TWpBNE1qRTVObjAuaXdqRnFpRzJYLW9IQ1pRRzZlcTdrVlJ1aV9PUUlNR2ZhamtFM0dUUUNXLTNpQmFJOGVPcGdEeHRhemI4WnlHX2gzLWpIbTJQcjRqenl0Y3pKOEIyVW9TcHRkdnNfZ2NxWloxb2VnTW5MSlBoNHZzYkVPbTNlNE9hYS10cDdmNEJ3UFI4Vk1yUXBNUmlMQzNZYVRYZ3hiSmRRWlBWS1BxRlJlNlJrYUZQMFlTenVNRG1XZU9tWVlqUlBtaExfWFdmTWdkaEVUajBJaHVlT0dyTTNidS00RkZVZEFXZVJtdEItRHU2cXo4ZkFVb280QW9ITUxjVVlVME9GWWdLcjlZZWpRQ1pFYkp1bTNXOEUzbjEydE1Vd3V5VHgtMGJRTWphOG5xdXI2eGViRzdfek9Nb0NsaEFMR0JzY3lBQkN6UkhRanNwZDU4VTQxQ002WjdfZG5XeTZRIjtzOjc6ImNyZWF0ZWQiO2k6MTcyMjA3ODU5NjtzOjEzOiJyZWZyZXNoX3Rva2VuIjtzOjEwMzoiMS8vMDNjMW52dDY1ZnZWdkNnWUlBUkFBR0FNU053Ri1MOUlyQUNZXy1CM19XdC01bzZwNjR5U2Zfd1Noa2VfbkhBMHRub2NhNzBETTBCM25vY001UzJBNGk4X0JaamJVU2h0UHVkVSI7fQ=='
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