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= | + | |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 à 11:01
| Page | Start | End | Diff |
|---|---|---|---|
| Craig Havens | Wednesday 04 April 2018 | -2810 | |
| Le rideau de perles | Thursday 20 December 2018 | Thursday 20 December 2018 | -2550 |
| Erg Winter School 2019 | Monday 21 January 2019 | Thursday 31 January 2019 | -2518 |
| Bo Wang : rencontre | Monday 15 October 2018 | Monday 15 October 2018 | -2616 |
| Sarah Schulman : rencontre | Wednesday 17 October 2018 | Wednesday 17 October 2018 | -2614 |