Pāriet uz saturu

Dalībnieks:Edgars2007/VKPAI WD

Vikipēdijas lapa

Citu valstu prakse

[labot šo sadaļu | labot pirmkodu]
 

SELECT ?one ?oneLabel (COUNT(?one) AS ?number) WHERE {
  ?item wdt:P1435 ?one
        
     SERVICE wikibase:label {
         bd:serviceParam wikibase:language "lv,en" .
     }

} GROUP BY ?one ?oneLabel ORDER BY DESC(?number)
limit 1000

Izmēģini!

 
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX ps: <http://www.wikidata.org/prop/statement/>
SELECT ?qual ?qualLabel (COUNT(DISTINCT ?item) AS ?count) WHERE {

     hint:Query hint:optimizer "None" .
     ?item p:P1435 ?statement .
     ?statement ?pq_qual ?pq_obj .
     ?qual wikibase:qualifier ?pq_qual .

     SERVICE wikibase:label {
         bd:serviceParam wikibase:language "lv,en" .
     }

}  GROUP BY ?qual ?qualLabel
ORDER BY DESC (?count)
limit 1000

Izmēģini!