Thematiques : Différence entre versions

Ligne 7 : Ligne 7 :
 
|group by=_pageName
 
|group by=_pageName
 
|order by=dateDebut,dateFin,_ID asc
 
|order by=dateDebut,dateFin,_ID asc
|intro=
+
|limit=500
 
|format=template
 
|format=template
 
|template=RepThema
 
|template=RepThema
Ligne 20 : Ligne 20 :
 
|group by=_pageName
 
|group by=_pageName
 
|order by=dateDebut,dateFin,_ID asc
 
|order by=dateDebut,dateFin,_ID asc
|limit=5
+
|limit=500
 
|format=template
 
|format=template
 
|template=RepThema
 
|template=RepThema
Ligne 33 : Ligne 33 :
 
|group by=_pageName
 
|group by=_pageName
 
|order by=dateDebut,dateFin,_ID asc
 
|order by=dateDebut,dateFin,_ID asc
|intro=
+
|limit=500
 
|format=template
 
|format=template
 
|template=RepThema
 
|template=RepThema

Version du 28 novembre 2018 à 11:06

Corps et santé

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 500 Function: CargoSQLQuery::run Error: 1054 Unknown column '_ID asc' in 'order clause' (bdd10.u-strasbg.fr)

Frontières

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 500 Function: CargoSQLQuery::run Error: 1054 Unknown column '_ID asc' in 'order clause' (bdd10.u-strasbg.fr)

Identité

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 500 Function: CargoSQLQuery::run Error: 1054 Unknown column '_ID asc' in 'order clause' (bdd10.u-strasbg.fr)