|
|
| (6 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>}} |
| − | {{#invoke:Liste2|main | + | {{#invoke:Liste3|main |
| | |q?tables=Sequences | | |q?tables=Sequences |
| − | |q?fields=apercu,_pageName,titre,realisateurs,fonds,dateDebut,dateFin,annee,resumefr,resumeen,resumede,idSupport,timecode,duree,video,thematique | + | |q?fields=apercu,_pageName,titre,realisateurs,dateDebut,dateFin,annee,resumefr,resumeen,resumede,idSupport,timecode,duree,video,thematique |
| | |q?groupBy=_pageName | | |q?groupBy=_pageName |
| | |q?orderBy=annee,_pageName | | |q?orderBy=annee,_pageName |
| | |q?limit=5000 | | |q?limit=5000 |
| | |format=template | | |format=template |
| − | |template=LigneVid | + | |template=LigneVideo |
| | |q?intro= | | |q?intro= |
| | }} | | }} |
| − | <br>
| |
| − |
| |
| − | <div class="collapsible">{{#cargo_query:table=Sequences
| |
| − | |fields=CONCAT(COUNT(*)-1)
| |
| − | |where= CONCAT(YEAR(dateDebut)+YEAR(dateFin)) >= 3860 AND CONCAT(YEAR(dateDebut)+YEAR(dateFin)) < 3880 }} séquences filmées 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,CONCAT(ROUND((YEAR(dateDebut)+YEAR(dateFin))/2))=annee
| |
| − | |where= CONCAT(YEAR(dateDebut)+YEAR(dateFin)) >= 3860 AND CONCAT(YEAR(dateDebut)+YEAR(dateFin)) < 3880
| |
| − | |group by=_pageName
| |
| − | |order by=annee,_pageName
| |
| − | |format=template
| |
| − | |template=LigneVideo
| |
| − | |named args=yes
| |
| − | |intro=----
| |
| − | |limit=1000
| |
| − | }}
| |
| − | </div>
| |
| − | <br>
| |
| − |
| |
| − | <div class="collapsible">{{#cargo_query:table=Sequences
| |
| − | |fields=CONCAT(COUNT(*)-1)
| |
| − | |where= CONCAT(YEAR(dateDebut)+YEAR(dateFin)) >= 3880 AND CONCAT(YEAR(dateDebut)+YEAR(dateFin)) < 3900 }} séquences filmées 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,CONCAT(ROUND((YEAR(dateDebut)+YEAR(dateFin))/2))=annee
| |
| − | |where= CONCAT(YEAR(dateDebut)+YEAR(dateFin)) >= 3880 AND CONCAT(YEAR(dateDebut)+YEAR(dateFin)) < 3900
| |
| − | |group by=_pageName
| |
| − | |order by=annee,_pageName
| |
| − | |format=template
| |
| − | |template=LigneVideo
| |
| − | |named args=yes
| |
| − | |intro=----
| |
| − | |limit=1000
| |
| − | }}
| |
| − | </div>
| |
| − | <br>
| |
| − |
| |
| − | <div class="collapsible">{{#cargo_query:table=Sequences
| |
| − | |fields=CONCAT(COUNT(*)-1)
| |
| − | |where= CONCAT(YEAR(dateDebut)+YEAR(dateFin)) >= 3900 AND CONCAT(YEAR(dateDebut)+YEAR(dateFin)) < 3920 }} séquences filmées 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,CONCAT(ROUND((YEAR(dateDebut)+YEAR(dateFin))/2))=annee
| |
| − | |where= CONCAT(YEAR(dateDebut)+YEAR(dateFin)) >= 3900 AND CONCAT(YEAR(dateDebut)+YEAR(dateFin)) < 3920
| |
| − | |group by=_pageName
| |
| − | |order by=annee,_pageName
| |
| − | |format=template
| |
| − | |template=LigneVideo
| |
| − | |named args=yes
| |
| − | |intro=----
| |
| − | |limit=1000
| |
| − | }}
| |
| − | </div>
| |
| − | <br>
| |
| − |
| |
| − | <div class="collapsible">{{#cargo_query:table=Sequences
| |
| − | |fields=CONCAT(COUNT(*)-1)
| |
| − | |where= CONCAT(YEAR(dateDebut)+YEAR(dateFin)) >= 3920 }} séquences filmées 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,CONCAT(ROUND((YEAR(dateDebut)+YEAR(dateFin))/2))=annee
| |
| − | |where= CONCAT(YEAR(dateDebut)+YEAR(dateFin)) >= 3920
| |
| − | |group by=_pageName
| |
| − | |order by=annee,_pageName
| |
| − | |format=template
| |
| − | |template=LigneVideo
| |
| − | |named args=yes
| |
| − | |intro=----
| |
| − | |limit=1000
| |
| − | }}
| |
| − | </div>
| |
