SELECT b.*, 'blog' AS type_content,t.theme, u.email AS admin, (SELECT COUNT(*) FROM blog_centredeloisirs_comment WHERE id_post=b.id_unique) AS nb_comments FROM blog_centredeloisirs AS b LEFT OUTER JOIN blogs_themes AS t ON (t.id_unique=b.id_theme) LEFT OUTER JOIN annu_admin AS u ON (b.id_admin=u.id_unique) WHERE 1 AND (b.date_crea <= NOW() OR b.date_crea IS NULL) AND (date_par <= NOW() OR date_par IS NULL) AND (valid LIKE 'ok' OR display LIKE 'ok')AND (b.id_theme = '17') ORDER BY date_crea DESC LIMIT 0,5
5 responses
Ville des Lilas - blog centre de loisirs

Catégorie // Activités


Un blog de la Ville des Lilas

Pages

Archives