« NewsActivity » : différence entre les versions
De erg
Aucun résumé des modifications |
Aucun résumé des modifications |
||
| Ligne 2 : | Ligne 2 : | ||
tables=News,_pageData | tables=News,_pageData | ||
|join on=News._pageName=_pageData._pageName | |join on=News._pageName=_pageData._pageName | ||
|fields=DATE_FORMAT(_pageData._creationDate, '%d %M %y')=publiée,_pageData._pageName=Page, DATE_FORMAT(News.Start, '%W %d %M %Y')=Start, DATE_FORMAT(News.End, '%W %d %M %Y')=End | |fields=DATE_FORMAT(_pageData._creationDate, '%d %M %y')=publiée,DATEDIFF(NOW(),_pageData._createDate)=Age,_pageData._pageName=Page, DATE_FORMAT(News.Start, '%W %d %M %Y')=Start, DATE_FORMAT(News.End, '%W %d %M %Y')=End,Image | ||
|order by=_pageData._creationDate DESC | |order by=_pageData._creationDate DESC | ||
|format=table | |format=table | ||
Version du 10 avril 2018 à 12:13
Error 1054: Unknown column '_pageData._createDate' in 'SELECT'
Function: CargoSQLQuery::run Query: SELECT `_pageData`.`_pageID` AS `cargo_backlink_page_id__pageData`,`News`.`_pageID` AS `cargo_backlink_page_id_News`,DATE_FORMAT(`_pageData`.`_creationDate`, '%d %M %y') AS `publiée`,DATEDIFF(NOW(),`_pageData`.`_createDate`) AS `Age`,`_pageData`.`_pageName` AS `Page`,DATE_FORMAT(`News`.`Start`, '%W %d %M %Y') AS `Start`,DATE_FORMAT(`News`.`End`, '%W %d %M %Y') AS `End`,`Image` AS `Image` FROM `mw_cargo__News` `News` LEFT OUTER JOIN `mw_cargo___pageData` `_pageData` ON ((`News`.`_pageName`=`_pageData`.`_pageName`)) ORDER BY `_pageData`.`_creationDate` DESC LIMIT 100