Difference between revisions of "Thematiques"

Line 7: Line 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
Line 20: Line 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
Line 33: Line 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

Revision as of 11:06, 28 November 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 500 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 500 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 500 Function: CargoSQLQuery::run Error: 1054 Unknown column '_ID asc' in 'order clause' (bdd10.u-strasbg.fr)