Fonds : Différence entre versions
Ligne 2 : | Ligne 2 : | ||
{{Colonnes|taille=25|{{#cargo_query:table=Sequences | {{Colonnes|taille=25|{{#cargo_query:table=Sequences | ||
|fields=apercu,_pageName,titre,realisateurs,fonds,dateDebut,dateFin,resume{{int:lang}}, idSupport,timecode,duree,video,thematique | |fields=apercu,_pageName,titre,realisateurs,fonds,dateDebut,dateFin,resume{{int:lang}}, idSupport,timecode,duree,video,thematique | ||
− | |group by= | + | |group by=realisateurs |
− | |order by= | + | |order by=realisateurs,thematique, _ID asc |
|intro=---- | |intro=---- | ||
|format=template | |format=template |
Version du 2 octobre 2018 à 16:19
Query: SELECT `apercu` AS `apercu`,`_pageName` AS `_pageName`,`titre` AS `titre`,`A_cargo__Sequences__realisateurs`.`_value` AS `realisateurs`,`fonds` AS `fonds`,`dateDebut` AS `dateDebut`,`dateFin` AS `dateFin`,`resumefr` AS `resumefr`,`idSupport` AS `idSupport`,`timecode` AS `timecode`,`duree` AS `duree`,`video` AS `video`,`thematique__full` AS `thematique`,`dateDebut__precision` AS `dateDebut__precision`,`dateFin__precision` AS `dateFin__precision` FROM `A_cargo__Sequences` LEFT OUTER JOIN `A_cargo__Sequences__realisateurs` ON ((`A_cargo__Sequences`.`_ID`=`A_cargo__Sequences__realisateurs`.`_rowID`)) GROUP BY `A_cargo__Sequences__realisateurs`.`_value` ORDER BY `A_cargo__Sequences__realisateurs`.`_value`,`A_cargo__Sequences`.`thematique__full`,`_ID asc` LIMIT 100 Function: CargoSQLQuery::run Error: 1054 Unknown column '_ID asc' in 'order clause' (bdd10.u-strasbg.fr)