Actions

Modèle

NewsActivity : Différence entre versions

De erg

Ligne 3 : Ligne 3 :
 
|join on=News._pageName=_pageData._pageName
 
|join on=News._pageName=_pageData._pageName
 
|fields=_pageData._pageName=Page, DATE_FORMAT(News.Start, '%W %d %M %Y')=Start, DATE_FORMAT(News.End, '%W %d %M %Y')=End,DATEDIFF(News.Start,NOW())=Diff
 
|fields=_pageData._pageName=Page, DATE_FORMAT(News.Start, '%W %d %M %Y')=Start, DATE_FORMAT(News.End, '%W %d %M %Y')=End,DATEDIFF(News.Start,NOW())=Diff
|where=Diff <=- 15
+
|where=DATEDIFF(News.Start,NOW()) <=- 15
 
|order by=_pageData._creationDate DESC
 
|order by=_pageData._creationDate DESC
 
|format=table
 
|format=table

Version du 10 avril 2018 à 10:01

Page Start End Diff
Material Girl - Master Installation/Performance Thursday 13 June 2019 Saturday 29 June 2019 -693
Kiosk Wednesday 24 October 2018 Thursday 25 October 2018 -925
L'ICEBERG accueille Marie Voignier Wednesday 24 October 2018 Wednesday 24 October 2018 -925
Workshop avec Gustave Fundi, Glodie Mubikay, Lucile Desamory Tuesday 27 November 2018 Friday 30 November 2018 -891
BELLES TRACES etcetera Friday 24 May 2019 Friday 24 May 2019 -713