Utilisateur:Gz260/Routes/A (F)/Wikidata/SPARQL/Propriétés

Propriétés les plus utilisées

SELECT ?property ?propertyLabel ?propertyDescription ?count WHERE { 
	{
		select ?propertyclaim (COUNT(*) AS ?count) where {
			?item wdt:P31/wdt:P279* wd:Q34442 ; p:P16/ps:P16 wd:Q3456602 .
			?item ?propertyclaim [] .
		} group by ?propertyclaim 
	}
	?property wikibase:claim ?propertyclaim .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en" . }
} ORDER BY DESC (?count)

Cliquez pour essayer !

P126 : maintenance assurée par

P126

SELECT DISTINCT ?item ?itemLabel ?p126 ?p126Label WHERE {
  ?item wdt:P31/wdt:P279* wd:Q34442 ; p:P16/ps:P16 wd:Q3456602 ; wdt:P126 ?p126 .
  OPTIONAL { ?item wdt:P1824 ?p1824 }
  BIND(STRLEN(str(?p1824)) as ?longp1824)
  BIND(SUBSTR(str(?p1824),1,1) as ?statut)
  BIND(SUBSTR(str(?p1824),2,(?longp1824 - 1)) as ?numero)
  BIND(REPLACE(SUBSTR(str(?numero),1,4),"[A-Za-z ]","") as ?num)
  BIND(STRLEN(str(?num)) as ?longnum)
  BIND(CONCAT(IF(?longnum=1,"000",IF(?longnum=2,"00",IF(?longnum=3,"0",""))), str(?num)) as ?numz)
  BIND(CONCAT(str(?statut),str(?num)) as ?numsp)
  BIND(STRLEN(str(?numsp)) as ?longnumsp)
  BIND((?longp1824 - ?longnumsp) as ?longprefixe)
  BIND(SUBSTR(str(?p1824),(?longnumsp + 1),?longprefixe) as ?prefixe)
  BIND(CONCAT(str(?statut),str(?numz),str(?prefixe)) as ?cledetri)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri

Cliquez pour essayer !

P373 : catégorie Commons

P373

SELECT DISTINCT ?item ?itemLabel ?p373 WHERE {
  ?item wdt:P31/wdt:P279* wd:Q34442 ; p:P16/ps:P16 wd:Q3456602 ; wdt:P373 ?p373 .
  OPTIONAL { ?item wdt:P1824 ?p1824 }
  BIND(STRLEN(str(?p1824)) as ?longp1824)
  BIND(SUBSTR(str(?p1824),1,1) as ?statut)
  BIND(SUBSTR(str(?p1824),2,(?longp1824 - 1)) as ?numero)
  BIND(REPLACE(SUBSTR(str(?numero),1,4),"[A-Za-z ]","") as ?num)
  BIND(STRLEN(str(?num)) as ?longnum)
  BIND(CONCAT(IF(?longnum=1,"000",IF(?longnum=2,"00",IF(?longnum=3,"0",""))), str(?num)) as ?numz)
  BIND(CONCAT(str(?statut),str(?num)) as ?numsp)
  BIND(STRLEN(str(?numsp)) as ?longnumsp)
  BIND((?longp1824 - ?longnumsp) as ?longprefixe)
  BIND(SUBSTR(str(?p1824),(?longnumsp + 1),?longprefixe) as ?prefixe)
  BIND(CONCAT(str(?statut),str(?numz),str(?prefixe)) as ?cledetri)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri

Cliquez pour essayer !

P910 : catégorie

P910

SELECT DISTINCT ?item ?itemLabel ?p910 ?p910Label WHERE {
  ?item wdt:P31/wdt:P279* wd:Q34442 ; p:P16/ps:P16 wd:Q3456602 ; wdt:P910 ?p910 .
  OPTIONAL { ?item wdt:P1824 ?p1824 }
  BIND(STRLEN(str(?p1824)) as ?longp1824)
  BIND(SUBSTR(str(?p1824),1,1) as ?statut)
  BIND(SUBSTR(str(?p1824),2,(?longp1824 - 1)) as ?numero)
  BIND(REPLACE(SUBSTR(str(?numero),1,4),"[A-Za-z ]","") as ?num)
  BIND(STRLEN(str(?num)) as ?longnum)
  BIND(CONCAT(IF(?longnum=1,"000",IF(?longnum=2,"00",IF(?longnum=3,"0",""))), str(?num)) as ?numz)
  BIND(CONCAT(str(?statut),str(?num)) as ?numsp)
  BIND(STRLEN(str(?numsp)) as ?longnumsp)
  BIND((?longp1824 - ?longnumsp) as ?longprefixe)
  BIND(SUBSTR(str(?p1824),(?longnumsp + 1),?longprefixe) as ?prefixe)
  BIND(CONCAT(str(?statut),str(?numz),str(?prefixe)) as ?cledetri)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri

Cliquez pour essayer !