SELECT b.*, 'blog' AS type_content,t.theme, (SELECT COUNT(*) FROM blog_lilart_comment WHERE id_post=b.id_unique) AS nb_comments, u.email AS admin FROM blog_lilart AS b LEFT OUTER JOIN blogs_themes AS t ON (t.id_unique=b.id_theme) LEFT OUTER JOIN annu_users AS u ON (b.id_admin=u.id_unique) WHERE valid LIKE 'ok' AND (type_content LIKE 'news' OR type_content NOT LIKE 'off') AND (date_par <= '2019-03-20 19:12' OR date_par='0000-00-00 00:00:00') AND (date_for >= '2019-03-20 19:12' OR date_for='0000-00-00 00:00:00') AND (b.id_theme = '119') ORDER BY date_crea DESC LIMIT 5,5
1 responses
Ville des Lilas - blog lil'art

Catégorie // LIL'ART 2018

SHOW COLUMNS FROM blog_lilart
20 responses
SELECT b.*, 'blog' AS type_content,t.theme, (SELECT COUNT(*) FROM blog_lilart_comment WHERE id_post=b.id_unique) AS nb_comments, u.email AS admin FROM blog_lilart AS b LEFT OUTER JOIN blogs_themes AS t ON (t.id_unique=b.id_theme) LEFT OUTER JOIN annu_users AS u ON (b.id_admin=u.id_unique) WHERE valid LIKE 'ok' AND (type_content LIKE 'news' OR type_content NOT LIKE 'off') AND (date_par <= '2019-03-20 19:12' OR date_par='0000-00-00 00:00:00') AND (date_for >= '2019-03-20 19:12' OR date_for='0000-00-00 00:00:00') AND (b.id_theme = '119') ORDER BY date_crea DESC LIMIT 5,5
1 responses

Un blog de la Ville des Lilas

Dernières photos

  • Encore 10 jours pour s'inscrire à l'oeuvre thématique de Lil'Art 2019 !
  • INSCRIPTION PORTES OUVERTES  DES ATELIERS D'ARTISTES 2019
  • INSCRIPTIONS LIL'ART 2019
  • A la découverte de l'autre, une fresque pour Lil'Art 2018.
  • Clémentin Vauchelet, prix coup de coeur de Lil'Art 2018 !
  • Découvrez la programmation de Lil'Art 2018 !
  • Lil'Art approche !
  • Venez nombreux aux Portes ouvertes des ateliers d'artistes de la ville !
  • PLAN DU THEÂTRE
  • PLAN DU MARCHE
  • PLAN DU MARCHÉ
  • Cécile Basecq - Atelier C6L

Archives

Publications

Direction de l'action culturelle