« NewsActivity » : différence entre les versions
De erg
Aucun résumé des modifications |
Aucun résumé des modifications |
||
| Ligne 6 : | Ligne 6 : | ||
|format=table | |format=table | ||
|limit=5 | |limit=5 | ||
|where=DATEDIFF(Date,NOW()) <= -14 | |||
|more results text= | |more results text= | ||
}} | }} | ||
Version du 20 mars 2018 à 13:13
Error 1054: Unknown column 'Date' 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`,`News`.`Image` AS `Image`,`News`.`Start` AS `Start`,`News`.`End` AS `End`,`News`.`Start__precision` AS `Start__precision`,`News`.`End__precision` AS `End__precision` FROM `mw_cargo__News` `News` LEFT OUTER JOIN `mw_cargo___pageData` `_pageData` ON ((`News`.`_pageName`=`_pageData`.`_pageName`)) WHERE DATEDIFF(Date,NOW()) <= -14 ORDER BY `_pageData`.`_creationDate` DESC LIMIT 100