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 | ||
