Actions

Modèle

NewsActivity : Différence entre versions

De erg

Ligne 2 : Ligne 2 :
 
tables=News,_pageData
 
tables=News,_pageData
 
|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
+
|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
 
|order by=_pageData._creationDate DESC
 
|order by=_pageData._creationDate DESC
 
|format=table
 
|format=table

Version du 10 avril 2018 à 09:59