Difference between revisions of "Thematiques"

m (Remplacement de texte — « date_fin » par « dateFin »)
m (Remplacement de texte — « id_support » par « idSupport »)
Line 3: Line 3:
 
[[Body and Health|<big>'''{{couleur|#00a2e5;|{{TitreThematique|Body and Health}}}}'''</big>]]<br><br>
 
[[Body and Health|<big>'''{{couleur|#00a2e5;|{{TitreThematique|Body and Health}}}}'''</big>]]<br><br>
 
{{#cargo_query:table=Sequences
 
{{#cargo_query:table=Sequences
|fields=_pageName,titre,realisateurs,fonds,dateDebut,dateFin, id_support,timecode,duree,video,thematique,apercu
+
|fields=_pageName,titre,realisateurs,fonds,dateDebut,dateFin, idSupport,timecode,duree,video,thematique,apercu
 
|where=thematique HOLDS WITHIN 'Body and health'
 
|where=thematique HOLDS WITHIN 'Body and health'
 
|group by=_pageName
 
|group by=_pageName
Line 16: Line 16:
 
[[Borders|<big>'''{{couleur|#00a2e5;|{{TitreThematique|Borders}}}}'''</big>]]<br><br>
 
[[Borders|<big>'''{{couleur|#00a2e5;|{{TitreThematique|Borders}}}}'''</big>]]<br><br>
 
{{#cargo_query:table=Sequences
 
{{#cargo_query:table=Sequences
|fields=_pageName,titre,realisateurs,fonds,dateDebut,dateFin, id_support,timecode,duree,video,thematique,apercu
+
|fields=_pageName,titre,realisateurs,fonds,dateDebut,dateFin, idSupport,timecode,duree,video,thematique,apercu
 
|where=thematique HOLDS WITHIN 'Borders'
 
|where=thematique HOLDS WITHIN 'Borders'
 
|group by=_pageName
 
|group by=_pageName
Line 29: Line 29:
 
[[Identity|<big>'''{{couleur|#00a2e5;|{{TitreThematique|Identity}}}}'''</big>]]<br><br>
 
[[Identity|<big>'''{{couleur|#00a2e5;|{{TitreThematique|Identity}}}}'''</big>]]<br><br>
 
{{#cargo_query:table=Sequences
 
{{#cargo_query:table=Sequences
|fields=_pageName,titre,realisateurs,fonds,dateDebut,dateFin, id_support,timecode,duree,video,thematique,apercu
+
|fields=_pageName,titre,realisateurs,fonds,dateDebut,dateFin, idSupport,timecode,duree,video,thematique,apercu
 
|where=thematique HOLDS WITHIN 'Identity'
 
|where=thematique HOLDS WITHIN 'Identity'
 
|group by=_pageName
 
|group by=_pageName

Revision as of 14:45, 26 September 2018

Body and Health

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

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 = 'Body and health' ) AND _right <= ( SELECT _right FROM `A_cargo__Sequences__thematique__hierarchy` WHERE _value = 'Body and health' ) ) ) GROUP BY `_pageName` ORDER BY `dateDebut`,`dateFin`,`_ID asc` LIMIT 100 Function: CargoSQLQuery::run Error: 1054 Unknown column '_ID asc' in 'order clause' (bdd10.u-strasbg.fr)

Borders

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

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 = 'Borders' ) AND _right <= ( SELECT _right FROM `A_cargo__Sequences__thematique__hierarchy` WHERE _value = 'Borders' ) ) ) GROUP BY `_pageName` ORDER BY `dateDebut`,`dateFin`,`_ID asc` LIMIT 5 Function: CargoSQLQuery::run Error: 1054 Unknown column '_ID asc' in 'order clause' (bdd10.u-strasbg.fr)

Identity

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

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 = 'Identity' ) AND _right <= ( SELECT _right FROM `A_cargo__Sequences__thematique__hierarchy` WHERE _value = 'Identity' ) ) ) GROUP BY `_pageName` ORDER BY `dateDebut`,`dateFin`,`_ID asc` LIMIT 100 Function: CargoSQLQuery::run Error: 1054 Unknown column '_ID asc' in 'order clause' (bdd10.u-strasbg.fr)