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-06-19 21:56' OR date_par='0000-00-00 00:00:00') AND (date_for >= '2019-06-19 21:56' OR date_for='0000-00-00 00:00:00') AND (b.id_theme = '119') ORDER BY date_crea DESC LIMIT 5,5
2 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-06-19 21:56' OR date_par='0000-00-00 00:00:00') AND (date_for >= '2019-06-19 21:56' OR date_for='0000-00-00 00:00:00') AND (b.id_theme = '119') ORDER BY date_crea DESC LIMIT 5,5
2 responses

Un blog de la Ville des Lilas

Catégories

Dernières photos

  • Marcelo TNS remporte le prix coup de coeur de Lil'Art 2019 !
  • Retrouvez Lil'Art 2019 en images !
  • Découvrez le plan des Portes Ouvertes des ateliers d'artistes des Lilas 2019 !
  • MOINS D'UNE SEMAINE À L'INAUGURATION DE LIL'ART 2019 ! #Yarn Bombing aux Lilas
  • LIL'ART 2019 : découvrez le plan du théâtre !
  • LIL'ART 2019 : découvrez le plan du marché !
  • EMILIE THIEVENAZ
  • ELSA LETELLIER
  • ORIANE WETZEL
  • MARCELO TNS
  • CATHERINE MASSON
  • COLLECTIF CARACTERRES

Archives

Publications

Direction de l'action culturelle