|
|
| (12 révisions intermédiaires par le même utilisateur non affichées) |
| Ligne 1 : |
Ligne 1 : |
| | {{DISPLAYTITLE:<span style="position:absolute; top: -9999px">...</span>}} | | {{DISPLAYTITLE:<span style="position:absolute; top: -9999px">...</span>}} |
| − | <div class="collapsible">Avant 1930</div>
| + | {{#invoke:Liste3|main |
| − | <div class="content">
| + | |q?tables=Sequences |
| − | {{#cargo_query:table=Sequences | + | |q?fields=apercu,_pageName,titre,realisateurs,dateDebut,dateFin,annee,resumefr,resumeen,resumede,idSupport,timecode,duree,video,thematique |
| − | |fields=apercu,_pageName,titre,realisateurs,fonds,dateDebut,dateFin,resumefr,resumeen,resumede,idSupport,timecode,duree,video,thematique | + | |q?groupBy=_pageName |
| − | |where= CONCAT(YEAR(dateDebut)+YEAR(dateFin)) < 3860 | + | |q?orderBy=annee,_pageName |
| − | |group by=_pageName | + | |q?limit=5000 |
| − | |order by=dateDebut,dateFin,_pageName | |
| | |format=template | | |format=template |
| | |template=LigneVideo | | |template=LigneVideo |
| − | |named args=yes | + | |q?intro= |
| − | |intro=----
| |
| − | |limit=1000
| |
| | }} | | }} |
| − | </div>
| |
| − | <br>
| |
| − |
| |
| − | <div class="collapsible">Entre 1930 et 1940</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= CONCAT(YEAR(dateDebut)+YEAR(dateFin)) >= 3860 AND CONCAT(YEAR(dateDebut)+YEAR(dateDebut)) < 3880
| |
| − | |group by=_pageName
| |
| − | |order by=dateDebut,dateFin,_pageName
| |
| − | |format=template
| |
| − | |template=LigneVideo
| |
| − | |named args=yes
| |
| − | |intro=----
| |
| − | |limit=1000
| |
| − | }}
| |
| − | </div>
| |
| − | <br>
| |
| − |
| |
| − | <div class="collapsible">Entre 1940 et 1950</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= CONCAT(YEAR(dateDebut)+YEAR(dateFin)) >= 3880 AND CONCAT(YEAR(dateDebut)+YEAR(dateDebut)) < 3900
| |
| − | |group by=_pageName
| |
| − | |order by=dateDebut,dateFin,_pageName
| |
| − | |format=template
| |
| − | |template=LigneVideo
| |
| − | |named args=yes
| |
| − | |intro=----
| |
| − | |limit=1000
| |
| − | }}
| |
| − | </div>
| |
| − | <br>
| |
| − |
| |
| − | <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= CONCAT(YEAR(dateDebut)+YEAR(dateFin)) >= 3900 AND CONCAT(YEAR(dateDebut)+YEAR(dateDebut)) < 3920
| |
| − | |group by=_pageName
| |
| − | |order by=dateDebut,dateFin,_pageName
| |
| − | |format=template
| |
| − | |template=LigneVideo
| |
| − | |named args=yes
| |
| − | |intro=----
| |
| − | |limit=1000
| |
| − | }}
| |
| − | </div>
| |
| − | <br>
| |
| − |
| |
| − | <div class="collapsible">Après 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= CONCAT(YEAR(dateDebut)+YEAR(dateFin)) >= 3920
| |
| − | |group by=_pageName
| |
| − | |order by=dateDebut,dateFin,_pageName
| |
| − | |format=template
| |
| − | |template=LigneVideo
| |
| − | |named args=yes
| |
| − | |intro=----
| |
| − | |limit=1000
| |
| − | }}
| |
| − | </div>
| |
