EXPLAIN SELECT COUNT(*), publications.from AS `publications.from`, publications.till AS `publications.till` FROM content__places AS `content__places` RIGHT JOIN `publications` AS `publications` ON content__places.id = publications.table_id AND publications.table = 'content__places' AND publications.version = 'live' WHERE ((`content__places`.version = 'live') AND (`publications`.id_website = 1) AND ((`publications`.from <= '2025-07-11 11:20:06' AND `publications`.from IS NOT NULL)) AND (`content__places`.security != 3)) AND ((`publications`.till >= '2025-07-11 11:20:06' OR `publications`.till IS NULL));