{{#widget:Qwant}}
« Accueil:Formats film » : différence entre les versions
De MedFilm PPRD
Aucun résumé des modifications |
Aucun résumé des modifications |
||
| Ligne 1 : | Ligne 1 : | ||
__NOTOC__ | __NOTOC__ | ||
{{DISPLAYTITLE:{{tr|Formats film}}}} | {{DISPLAYTITLE:{{tr|Formats film}}}} | ||
{{#cargo_query:tables=Films|fields=formatFilm|where=formatFilm__full <> ''|limit=5000|group by=formatFilm|order by=formatFilm|format=template|template=formats-1}} | {{#cargo_query:tables=Films|fields=formatFilm,COUNT(DISTINCT _pageName)|where=formatFilm__full <> '' AND etatFiche="Validée"|limit=5000|group by=formatFilm|order by=formatFilm|format=template|template=formats-1}} | ||
Version du 16 mai 2023 à 14:59
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\xC2\xA0etatFiche="Valid\xC3\xA9e" GROUP BY `cargo__Films__formatFilm`.`_value`' at line 1
Function: CargoSQLQuery::run Query: SELECT `cargo__Films__formatFilm`.`_value` AS `formatFilm`,COUNT(DISTINCT _pageName) AS `COUNT(DISTINCT pageName)` FROM `cargo__Films` LEFT OUTER JOIN `cargo__Films__formatFilm` ON ((`cargo__Films`.`_ID`=`cargo__Films__formatFilm`.`_rowID`)) WHERE formatFilm__full <> AND etatFiche="Validée" GROUP BY `cargo__Films__formatFilm`.`_value` ORDER BY `cargo__Films__formatFilm`.`_value` LIMIT 5000
