« 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=Diff<=-15 AND Diff>=-30 | |||
|order by=_pageData._creationDate DESC | |order by=_pageData._creationDate DESC | ||
|format=table | |format=table | ||
Version du 10 avril 2018 à 12:00
Error 1054: Unknown column 'Diff' in 'WHERE'
Function: CargoSQLQuery::run Query: SELECT `_pageData`.`_pageID` AS `cargo_backlink_page_id__pageData`,`News`.`_pageID` AS `cargo_backlink_page_id_News`,`_pageData`.`_pageName` AS `Page`,DATE_FORMAT(`News`.`Start`, '%W %d %M %Y') AS `Start`,DATE_FORMAT(`News`.`End`, '%W %d %M %Y') AS `End`,DATEDIFF(`News`.`Start`,NOW()) AS `Diff` FROM `mw_cargo__News` `News` LEFT OUTER JOIN `mw_cargo___pageData` `_pageData` ON ((`News`.`_pageName`=`_pageData`.`_pageName`)) WHERE Diff<=-15 AND Diff>=-30 ORDER BY `_pageData`.`_creationDate` DESC LIMIT 100