Utilisateur:L.strappazon/test : Différence entre versions
| Ligne 1 : | Ligne 1 : | ||
{{#cargo_query:table=Sequences | {{#cargo_query:table=Sequences | ||
| − | |fields=CONCAT(((YEAR(dateDebut)+YEAR(dateDebut) | + | |fields=CONCAT(((YEAR(dateDebut)+YEAR(dateDebut))/2),apercu,_pageName,titre,realisateurs,fonds,dateDebut,dateFin,resumefr,resumeen,resumede,idSupport,timecode,duree,video,thematique |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|group by=_pageName | |group by=_pageName | ||
|order by=dateDebut,dateFin,_pageName | |order by=dateDebut,dateFin,_pageName | ||
}} | }} | ||
Version du 6 décembre 2018 à 16:24
Query: SELECT CONCAT(((YEAR(dateDebut)+YEAR(dateDebut))/2),apercu,_pageName,titre,realisateurs,fonds,dateDebut,dateFin,resumefr,resumeen,resumede,idSupport,timecode,duree,video,thematique AS `CONCAT(((YEAR(dateDebut)+YEAR(dateDebut))/2),apercu, pageName,titre,realisateurs,fonds,dateDebut,dateFin,resumefr,resumeen,resumede,idSupport,timecode,duree,video,thematique` FROM `A_cargo__Sequences` GROUP BY `_pageName` ORDER BY `dateDebut`,`dateFin`,`_pageName` LIMIT 100 Function: CargoSQLQuery::run 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 'FROM `A_cargo__Sequences` GROUP BY `_pageName` ORDER BY `dateDebut`,`dateFin' at line 1 (bdd10.u-strasbg.fr)
