SELECT b.*, 'blog' AS type_content,t.theme, u.email AS admin, (SELECT COUNT(*) FROM blog_lilart_comment WHERE id_post=b.id_unique) AS nb_comments FROM blog_lilart 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 = '8') ORDER BY date_crea DESC LIMIT 15,5
5 responses
Ville des Lilas - blog lil'art

Catégorie // LIL'ART 2011

SHOW COLUMNS FROM blog_lilart
20 responses
SELECT b.*, 'blog' AS type_content,t.theme, u.email AS admin, (SELECT COUNT(*) FROM blog_lilart_comment WHERE id_post=b.id_unique) AS nb_comments FROM blog_lilart 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 = '8') ORDER BY date_crea DESC LIMIT 15,5
5 responses

Un blog de la Ville des Lilas

Archives