« NewsActivity » : différence entre les versions
De erg
Aucun résumé des modifications |
Aucun résumé des modifications |
||
| 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=DATEDIFF(News.Start,NOW()) <=- 15 | |where=DATEDIFF(News.Start,NOW()) <=- 15 AND DATEDIFF(News.Start,NOW()) >=- 30 | ||
|order by=_pageData._creationDate DESC | |order by=_pageData._creationDate DESC | ||
|format=table | |format=table | ||
|limit= | |limit=100 | ||
|more results text= | |more results text= | ||
}} | }} | ||
Version du 10 avril 2018 à 12:01
Aucun résultat