Properties
Edit
Constraints
Edit
|
SELECT DISTINCT ?item ?itemLabel WHERE {
?item wdt:P31/wdt:P279* wd:Q3947.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
} LIMIT 5
SELECT DISTINCT ?item ?itemLabel WHERE {
?item p:P794 ?x .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}
SELECT DISTINCT ?item ?itemLabel WHERE {
?item p:P106 [
pq:P794 ?x].
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
SELECT DISTINCT ?item ?itemLabel ?val WHERE {
?item ?x [pq:P1480 wd:Q21067468].
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
#Items with "instance of" wd
SELECT DISTINCT ?item ?itemLabel WHERE {
?item wdt:P31 wd:Q27949697 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
#A UNION
SELECT DISTINCT ?item ?itemLabel ?val WHERE {
{?item ?x [pq:P1480 wd:Q4895105]}
UNION {?item ?x [pq:P1480 wd:Q4676846]}.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
SELECT DISTINCT ?item ?itemLabel ?pq WHERE {
?item ?x [?pq wd:Q4676846].
FILTER ( ?pq != pq:P3831 )
FILTER ( ?pq != pq:P2868 )
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
SELECT DISTINCT ?item ?itemLabel
WHERE
{
{
?item wdt:P279 wd:Q52161601.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} UNION {
?item wdt:P366 wd:Q52161601.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
}
SELECT DISTINCT ?item ?itemLabel ?val WHERE {
?item ?x [pq:P5102 wd:Q41719].
FILTER NOT EXISTS {
?item wdt:P1148 ?number.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
# Multiple values of same property:
SELECT DISTINCT ?item ?itemLabel WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
{
SELECT DISTINCT ?item WHERE {
?item p:P461 ?x.
?item p:P461 ?y.
FILTER (?x != ?y)
}
}
}
#Statement with qualifier
SELECT DISTINCT ?item ?itemLabel WHERE {
?item p:P2302 ?statement1.
?statement1 ps:P2302 wd:Q21510856.
?statement1 pq:P2306 wd:P642.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
#One of several values:
SELECT DISTINCT ?item ?itemLabel WHERE {
VALUES ?nature {wd:Q110143752 wd:Q28962312 wd:Q28962310}
?item p:P279 [pq:P5102 ?nature].
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
#Multiple statement values:
SELECT DISTINCT ?item ?itemLabel WHERE {
{
SELECT ?item WHERE { ?item (wdt:P279/wdt:P279/(wdt:P279?)/(wdt:P279?)/(wdt:P279?)) wd:Q7048977, wd:Q112276019. }
LIMIT 300
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,es,fr,de". }
}
#Frequency of different values:
SELECT ?val ?valLabel (COUNT(?item) AS ?count) WHERE {
{?item wdt:P5135 ?val.}
UNION
{?item wdt:P5136 ?val.}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # Helps get the label in your language, if not, then en language
}
GROUP BY ?val ?valLabel
ORDER BY DESC(?count)
|
|
|