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=Diff<=-15 AND Diff>=-30 | ||
|order by=_pageData._creationDate DESC | |order by=_pageData._creationDate DESC | ||
|format=table | |format=table | ||
Version du 10 avril 2018 à 11:00
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `mw_cargo___pageData`.`_pageName` AS `Page`,DATE_FORMAT(`mw_cargo__News`.`Start`, '%W %d %M %Y') AS `Start`,DATE_FORMAT(`mw_cargo__News`.`End`, '%W %d %M %Y') AS `End`,DATEDIFF(`mw_cargo__News`.`Start`,NOW()) AS `Diff` FROM `mw_cargo__News` LEFT OUTER JOIN `mw_cargo___pageData` ON ((`mw_cargo__News`.`_pageName`=`mw_cargo___pageData`.`_pageName`)) WHERE Diff<=-15 AND Diff>=-30 ORDER BY `mw_cargo___pageData`.`_creationDate` DESC LIMIT 5 Function: CargoSQLQuery::run Error: 1054 Unknown column 'Diff' in 'where clause' (localhost)