Utilisateur:L.strappazon/test : Différence entre versions

< Utilisateur:L.strappazon
Ligne 14 : Ligne 14 :
  
 
{{#cargo_query:table=Sequences
 
{{#cargo_query:table=Sequences
−
|fields=count(*)
+
|fields=_pageName,sum(count(*))
 
|where=thematique HOLDS WITHIN 'Identity'
 
|where=thematique HOLDS WITHIN 'Identity'
 
|group by=_pageName
 
|group by=_pageName
 
|order by=count(*) desc
 
|order by=count(*) desc
−
|limit=1
+
|limit=10
 
|default=0
 
|default=0
 
|more results text=
 
|more results text=

Version du 18 septembre 2018 à 13:39

(suite)

  • 224

A

B

C

E

F

G

H

I

L

M

N

O

P

  • Places (COUNT( pageName): 19)

R

S

S (suite)

T

V

W

Y



2

A

B

C

C (suite)

D

E

F

G

H

I

J

K

L

L (suite)

M

O

P

Q

R

S

T


Plus...

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

Query: SELECT `_pageName` AS `_pageName`,sum(count(*)) 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 count(*) desc LIMIT 10 Function: CargoSQLQuery::run Error: 1111 Invalid use of group function (bdd10.u-strasbg.fr)

Identité

Seconde Guerre mondiale : après-guerre Seconde Guerre mondiale : cérémonies - commémorations - lieux de mémoire

Récupérée de « https://rhinedits.u-strasbg.fr/w/index.php?title=Utilisateur:L.strappazon/test&oldid=3612 »