Query: SELECT `apercu` AS `apercu`,`_pageName` AS `_pageName`,`titre` AS `titre`,`realisateurs__full` AS `realisateurs`,`fonds` AS `fonds`,`dateDebut` AS `dateDebut`,`dateFin` AS `dateFin`,`resumefr` AS `resumefr`,`resumeen` AS `resumeen`,`resumede` AS `resumede`,`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` WHERE SUM(dateDebut, dateFin) > '3900' and SUM(dateDebut,dateFin) < '3920' GROUP BY `_pageName` ORDER BY `dateDebut`,`dateFin`,`_pageName` LIMIT 1000 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 ' dateFin) > '3900' and SUM(dateDebut,dateFin) < '3920' GROUP BY `_pageName` ORD' at line 1 (bdd10.u-strasbg.fr)
Utilisateur:L.strappazon/test : Différence entre versions
m (Remplacement de texte — « id_support » par « idSupport ») |
|||
| Ligne 1 : | Ligne 1 : | ||
| − | + | <div class="collapsible">Entre 1950 et 1960</div> | |
| − | + | <div class="content"> | |
| − | + | {{#cargo_query:table=Sequences | |
| − | + | |fields=apercu,_pageName,titre,realisateurs,fonds,dateDebut,dateFin,resumefr,resumeen,resumede,idSupport,timecode,duree,video,thematique | |
| − | + | |where=SUM(dateDebut, dateFin) > '3900' and SUM(dateDebut,dateFin) < '3920' | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|group by=_pageName | |group by=_pageName | ||
|order by=dateDebut,dateFin,_pageName | |order by=dateDebut,dateFin,_pageName | ||
| Ligne 24 : | Ligne 9 : | ||
|template=LigneVideo | |template=LigneVideo | ||
|named args=yes | |named args=yes | ||
| + | |intro=---- | ||
| + | |limit=1000 | ||
}} | }} | ||
| − | + | </div> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Version du 6 décembre 2018 à 12:56
Entre 1950 et 1960
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
