Here is the other fautly modules and the SQL request :
Briks Module
Time: 230712 2:06:44
SELECT a.id,a.title,a.alias,a.introtext,a.fulltext,a.checked_out,a.checked_out_time,a.catid,a.created,a.created_by,a.created_by_alias,a.modified,a.modified_by,CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END AS publish_up,a.publish_down,a.images,a.urls,a.attribs,a.metadata,a.metakey,a.metadesc,a.access,a.hits,a.featured,a.language,LENGTH(a.fulltext) AS readmore,a.ordering,fp.featured_up,fp.featured_down,CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END AS state,c.title AS category_title,c.path AS category_route,c.access AS category_access,c.alias AS category_alias,c.language AS category_language,c.published,c.published AS parents_published,c.lft,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,uam.name AS modified_by_name,parent.title AS parent_title,parent.id AS parent_id,parent.path AS parent_route,parent.alias AS parent_alias,parent.language AS parent_language
FROM s8c9k_content AS a
LEFT JOIN s8c9k_categories AS c ON c.id = a.catid
LEFT JOIN s8c9k_users AS ua ON ua.id = a.created_by
LEFT JOIN s8c9k_users AS uam ON uam.id = a.modified_by
LEFT JOIN s8c9k_categories AS parent ON parent.id = c.parent_id
LEFT JOIN s8c9k_content_frontpage AS fp ON fp.content_id = a.id
WHERE a.access IN (1,5,7) AND c.access IN (1,5,7) AND c.published = 1 AND a.state = 1 AND a.catid IN (263,72,73,102,90,91,75,76,92,93,94,95,96,98,99,101,103) AND a.created_by IN (62,724) AND (a.publish_up IS NULL OR a.publish_up <= '2023-07-11 23:56:35') AND (a.publish_down IS NULL OR a.publish_down >= '2023-07-11 23:56:35')
ORDER BY a.created DESC LIMIT 4;
Category 263,72,73,102,90,91,75,76,92,93,94,95,96,98,99,101,103
263 = Cuisine
72 = Cinéma
73 = Livres
102 = Musiques
90 = Actualités internationale
91 = Actualités Française
75 = Tutorial
76 = Astuces Logiciels
92 = Brèves
93 = Sécurité
94 = Jeux vidéo
95 = Actualités scientifiques
96 = Divers
98 = Actualités Higth Tech
99 = Dossiers
101 = NewsFlash
103 = Twilligth Zone
Slide midle Modules
SET timestamp=1689120524;
SELECT a.id,a.title,a.alias,a.introtext,a.fulltext,a.checked_out,a.checked_out_time,a.catid,a.created,a.created_by,a.created_by_alias,a.modified,a.modified_by,CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END AS publish_up,a.publish_down,a.images,a.urls,a.attribs,a.metadata,a.metakey,a.metadesc,a.access,a.hits,a.featured,a.language,LENGTH(a.fulltext) AS readmore,a.ordering,fp.featured_up,fp.featured_down,CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END AS state,c.title AS category_title,c.path AS category_route,c.access AS category_access,c.alias AS category_alias,c.language AS category_language,c.published,c.published AS parents_published,c.lft,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,uam.name AS modified_by_name,parent.title AS parent_title,parent.id AS parent_id,parent.path AS parent_route,parent.alias AS parent_alias,parent.language AS parent_language
FROM s8c9k_content AS a
LEFT JOIN s8c9k_categories AS c ON c.id = a.catid
LEFT JOIN s8c9k_users AS ua ON ua.id = a.created_by
LEFT JOIN s8c9k_users AS uam ON uam.id = a.modified_by
LEFT JOIN s8c9k_categories AS parent ON parent.id = c.parent_id
LEFT JOIN s8c9k_content_frontpage AS fp ON fp.content_id = a.id
WHERE a.access IN (1,5,7) AND c.access IN (1,5,7) AND c.published = 1 AND a.state = 1 AND a.catid IN (90,91,95,96,98,99) AND (a.publish_up IS NULL OR a.publish_up <= '2023-07-11 23:56:37') AND (a.publish_down IS NULL OR a.publish_down >= '2023-07-11 23:56:37')
ORDER BY a.hits DESC LIMIT 50;
90 = Actualités internationale
91 = Actualités Française
95 = Actualités scientifiques
96 = Divers
98 = Actualités Higth Tech
99 = Dossiers
who CRASH, and the team support are woke up in the middle of the nigth because the SQL server as crashed and that as crashed server of OTHER customer TOO !
We need a FIX !
Thanks,
