Modèle:Thematiques-old : Différence entre versions
| Ligne 7 : | Ligne 7 : | ||
{{#cargo_query:table=Sequences | {{#cargo_query:table=Sequences | ||
| − | |fields=_pageName,titre,realisateurs,fonds,dateDebut,dateFin, idSupport,timecode,duree,video,thematique,apercu | + | |fields=_pageName,titre,realisateurs,fonds,dateDebut,dateFin, idSupport,timecode,duree,video,thematique,apercu,resumefr,resumeen,resumede |
|where=thematique HOLDS WITHIN '{{{Th1}}}' | |where=thematique HOLDS WITHIN '{{{Th1}}}' | ||
|group by=_pageName | |group by=_pageName | ||
| Ligne 20 : | Ligne 20 : | ||
[[{{{Th2}}}|<big>'''{{couleur|#00a2e5;|{{TitreThematique|{{{Th2}}}}}}}'''</big>]]<br><br> | [[{{{Th2}}}|<big>'''{{couleur|#00a2e5;|{{TitreThematique|{{{Th2}}}}}}}'''</big>]]<br><br> | ||
{{#cargo_query:table=Sequences | {{#cargo_query:table=Sequences | ||
| − | |fields=_pageName,titre,realisateurs,fonds,dateDebut,dateFin, idSupport,timecode,duree,video,thematique,apercu | + | |fields=_pageName,titre,realisateurs,fonds,dateDebut,dateFin, idSupport,timecode,duree,video,thematique,apercu,resumefr,resumeen,resumede |
|where=thematique HOLDS WITHIN '{{{Th2}}}' | |where=thematique HOLDS WITHIN '{{{Th2}}}' | ||
|group by=_pageName | |group by=_pageName | ||
| Ligne 34 : | Ligne 34 : | ||
[[{{{Th3}}}|<big>'''{{couleur|#00a2e5;|{{TitreThematique|{{{Th3}}}}}}}'''</big>]]<br><br> | [[{{{Th3}}}|<big>'''{{couleur|#00a2e5;|{{TitreThematique|{{{Th3}}}}}}}'''</big>]]<br><br> | ||
{{#cargo_query:table=Sequences | {{#cargo_query:table=Sequences | ||
| − | |fields=_pageName,titre,realisateurs,fonds,dateDebut,dateFin, idSupport,timecode,duree,video,thematique,apercu | + | |fields=_pageName,titre,realisateurs,fonds,dateDebut,dateFin, idSupport,timecode,duree,video,thematique,apercu,resumefr,resumeen,resumede |
|where=thematique HOLDS WITHIN '{{{Th3}}}' | |where=thematique HOLDS WITHIN '{{{Th3}}}' | ||
|group by=_pageName | |group by=_pageName | ||
Version du 29 novembre 2018 à 12:48
[[{{{Th1}}}|{{{Th1}}}]]
Query: SELECT `_pageName` AS `_pageName`,`titre` AS `titre`,`realisateurs__full` AS `realisateurs`,`fonds` AS `fonds`,`dateDebut` AS `dateDebut`,`dateFin` AS `dateFin`,`idSupport` AS `idSupport`,`timecode` AS `timecode`,`duree` AS `duree`,`video` AS `video`,`thematique__full` AS `thematique`,`apercu` AS `apercu`,`resumefr` AS `resumefr`,`resumeen` AS `resumeen`,`resumede` AS `resumede`,`dateDebut__precision` AS `dateDebut__precision`,`dateFin__precision` AS `dateFin__precision` FROM `A_cargo__Sequences` WHERE `A_cargo__Sequences`.`_ID` IN ( SELECT DISTINCT( _rowID ) FROM `A_cargo__Sequences__thematique` WHERE _value IN ( SELECT _value FROM `A_cargo__Sequences__thematique__hierarchy` WHERE _left >= ( SELECT _left FROM `A_cargo__Sequences__thematique__hierarchy` WHERE _value = '{{{Th1}}}' ) AND _right <= ( SELECT _right FROM `A_cargo__Sequences__thematique__hierarchy` WHERE _value = '{{{Th1}}}' ) ) ) GROUP BY `_pageName` ORDER BY `dateDebut`,`dateFin`,`_ID asc` LIMIT 500 Function: CargoSQLQuery::run Error: 1054 Unknown column '_ID asc' in 'order clause' (bdd10.u-strasbg.fr)
[[{{{Th2}}}|{{{Th2}}}]]
Query: SELECT `_pageName` AS `_pageName`,`titre` AS `titre`,`realisateurs__full` AS `realisateurs`,`fonds` AS `fonds`,`dateDebut` AS `dateDebut`,`dateFin` AS `dateFin`,`idSupport` AS `idSupport`,`timecode` AS `timecode`,`duree` AS `duree`,`video` AS `video`,`thematique__full` AS `thematique`,`apercu` AS `apercu`,`resumefr` AS `resumefr`,`resumeen` AS `resumeen`,`resumede` AS `resumede`,`dateDebut__precision` AS `dateDebut__precision`,`dateFin__precision` AS `dateFin__precision` FROM `A_cargo__Sequences` WHERE `A_cargo__Sequences`.`_ID` IN ( SELECT DISTINCT( _rowID ) FROM `A_cargo__Sequences__thematique` WHERE _value IN ( SELECT _value FROM `A_cargo__Sequences__thematique__hierarchy` WHERE _left >= ( SELECT _left FROM `A_cargo__Sequences__thematique__hierarchy` WHERE _value = '{{{Th2}}}' ) AND _right <= ( SELECT _right FROM `A_cargo__Sequences__thematique__hierarchy` WHERE _value = '{{{Th2}}}' ) ) ) GROUP BY `_pageName` ORDER BY `dateDebut`,`dateFin`,`_ID asc` LIMIT 500 Function: CargoSQLQuery::run Error: 1054 Unknown column '_ID asc' in 'order clause' (bdd10.u-strasbg.fr)
[[{{{Th3}}}|{{{Th3}}}]]
Query: SELECT `_pageName` AS `_pageName`,`titre` AS `titre`,`realisateurs__full` AS `realisateurs`,`fonds` AS `fonds`,`dateDebut` AS `dateDebut`,`dateFin` AS `dateFin`,`idSupport` AS `idSupport`,`timecode` AS `timecode`,`duree` AS `duree`,`video` AS `video`,`thematique__full` AS `thematique`,`apercu` AS `apercu`,`resumefr` AS `resumefr`,`resumeen` AS `resumeen`,`resumede` AS `resumede`,`dateDebut__precision` AS `dateDebut__precision`,`dateFin__precision` AS `dateFin__precision` FROM `A_cargo__Sequences` WHERE `A_cargo__Sequences`.`_ID` IN ( SELECT DISTINCT( _rowID ) FROM `A_cargo__Sequences__thematique` WHERE _value IN ( SELECT _value FROM `A_cargo__Sequences__thematique__hierarchy` WHERE _left >= ( SELECT _left FROM `A_cargo__Sequences__thematique__hierarchy` WHERE _value = '{{{Th3}}}' ) AND _right <= ( SELECT _right FROM `A_cargo__Sequences__thematique__hierarchy` WHERE _value = '{{{Th3}}}' ) ) ) GROUP BY `_pageName` ORDER BY `dateDebut`,`dateFin`,`_ID asc` LIMIT 500 Function: CargoSQLQuery::run Error: 1054 Unknown column '_ID asc' in 'order clause' (bdd10.u-strasbg.fr)
