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=DATE_FORMAT(_pageData._creationDate, '%d %M %y')=publiée,DATEDIFF(NOW(),_pageData._creationDate)=Age,News._pageName=Page,News.Subtitle=Subtitle, DATE_FORMAT(News.Start, '%W %d %M %Y')=Start, DATE_FORMAT(News.End, '%W %d %M %Y')=End,Image
+
|fields=DATE_FORMAT(_pageData._creationDate, '%d %M %y')=publiée,DATEDIFF(NOW(),_pageData._creationDate)=Age,News._pageName=Page,News._pageTitle=Title,News.Subtitle=Subtitle, DATE_FORMAT(News.Start, '%W %d %M %Y')=Start, DATE_FORMAT(News.End, '%W %d %M %Y')=End,Image
 
|order by=_pageData._creationDate DESC
 
|order by=_pageData._creationDate DESC
 
|where=DATEDIFF(NOW(),_pageData._creationDate) <= 60
 
|where=DATEDIFF(NOW(),_pageData._creationDate) <= 60

Version du 16 avril 2018 à 12:47