Home    |    A propos    |    Terms & conditions    |    Contact    |    Sitemap       

new DataSet({"query": "SELECT * FROM (SELECT laure_alek_pages.*, MAX(CASE WHEN laure_alek_content.var_id = 4 THEN laure_alek_content.value ELSE NULL END) AS variable_4 FROM laure_alek_pages LEFT JOIN laure_alek_content ON (laure_alek_content.page_id = laure_alek_pages.id AND laure_alek_content.lang_id = laure_alek_pages.lang_id) WHERE status = 1 AND parent_id > -1 AND laure_alek_pages.lang_id IN (1) AND (template_id = 3) AND (visibility = 0) AND ((time_published <= '2026-08-03 21:06:49') AND (time_archived IS NULL OR time_archived = 0 OR time_archived > '2026-08-03 21:06:49')) GROUP BY laure_alek_pages.id) t WHERE (CAST(variable_4 AS UNSIGNED) > '0') ORDER BY time_created DESC, ABS(t.lang_id - 1) ASC LIMIT 9", "debug": false})
SELECT * FROM (SELECT laure_alek_pages.*, MAX(CASE WHEN laure_alek_content.var_id = 4 THEN laure_alek_content.value ELSE NULL END) AS variable_4 FROM laure_alek_pages LEFT JOIN laure_alek_content ON (laure_alek_content.page_id = laure_alek_pages.id AND laure_alek_content.lang_id = laure_alek_pages.lang_id) WHERE status = 1 AND parent_id > -1 AND laure_alek_pages.lang_id IN (1) AND (template_id = 3) AND (visibility = 0) AND ((time_published <= '2026-08-03 21:06:49') AND (time_archived IS NULL OR time_archived = 0 OR time_archived > '2026-08-03 21:06:49')) GROUP BY laure_alek_pages.id) t WHERE (CAST(variable_4 AS UNSIGNED) > '0') ORDER BY time_created DESC, ABS(t.lang_id - 1) ASC LIMIT 9