Modèle:Thematiques-old : Différence entre versions
(Page créée avec « {{{Texte_intro|}}} <div class="thema"> [[{{{Th1}}}|<big>'''{{couleur|#00a2e5;|{{TitreThematique|{{{Th1}}}}}}}'''</big>]]<br><br> {{#cargo_query:table=Sequences |fields=_p... ») |
|||
| Ligne 1 : | Ligne 1 : | ||
| − | {{{Texte_intro|}}} | + | <div class="intro">{{{Texte_intro|}}}</div> |
<div class="thema"> | <div class="thema"> | ||
[[{{{Th1}}}|<big>'''{{couleur|#00a2e5;|{{TitreThematique|{{{Th1}}}}}}}'''</big>]]<br><br> | [[{{{Th1}}}|<big>'''{{couleur|#00a2e5;|{{TitreThematique|{{{Th1}}}}}}}'''</big>]]<br><br> | ||
Version du 29 novembre 2018 à 12:30
[[{{{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`,`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`,`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`,`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)
