query-13f64b429b609f4b10b39c41204230e6
Propertiesinstance of (P31)subclass of (P279)sport (P641)point in time (P585)start time (P580)end time (P582)
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?P641 ?P641Label (COUNT(?P641) AS ?ct) WHERE {
{ ?item wdt:P31 wd:Q1194951. }
UNION
{
?item wdt:P31 ?mm.
?mm wdt:P279 wd:Q8031011.
}
UNION
{
?item (wdt:P31/(wdt:P279*)) ?P279.
?P279 wdt:P279 wd:Q1194951.
}
?item wdt:P641 ?P641.
FILTER(NOT EXISTS { ?item wdt:P31 wd:Q23726798. })
FILTER(NOT EXISTS { ?item wdt:P31 wd:Q1477115. })
FILTER(NOT EXISTS { ?item wdt:P585 ?P585. })
FILTER(NOT EXISTS { ?item wdt:P580 ?P585. })
FILTER(NOT EXISTS { ?item wdt:P582 ?P585. })
?item wikibase:sitelinks ?sl.
FILTER(NOT EXISTS {
_:b2 schema:about ?item;
schema:isPartOf <https://ar.wikipedia.org/>.
})
?item rdfs:label ?arabicc.
FILTER((LANG(?arabicc)) = "ar")
SERVICE wikibase:label { bd:serviceParam wikibase:language "ar,en". }
FILTER(?sl > 0 )
}
GROUP BY ?P641 ?P641Label
ORDER BY DESC (?ct)
LIMIT 1000
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v7("?P279")
v5("?P585")
v8("?P641"):::projected
v3("?arabicc")
v9("?ct")
v4("?item")
v6("?mm")
v2("?sl")
a1((" "))
a2((" "))
c10(["wd:Q1477115"]):::iri
c11(["wd:Q23726798"]):::iri
c12(["wd:Q1194951"]):::iri
c14(["wd:Q8031011"]):::iri
c21(["ar,en"]):::literal
c19(["bd:serviceParam"]):::iri
c5([https://ar.wikipedia.org/]):::iri
f0[["?sl > '0^^xsd:integer'"]]
f0 --> v2
f1[["?arabicc = 'ar'"]]
f1 --> v3
f2[["not "]]
subgraph f2e0["Exists Clause"]
e0a1 --"schema:about"--> e0v1
e0a1 --"schema:isPartOf"--> e0c3
e0v1("?item"):::projected
e0a1((" ")):::projected
e0c3([https://ar.wikipedia.org/]):::iri
end
f2--EXISTS--> f2e0
f2 --> a1
f2 --> c3
f2 --> v4
f2 --> c4
f2 --> c5
a1 --"schema:about"--> v4
a1 --"schema:isPartOf"--> c5
f3[["not "]]
subgraph f3e1["Exists Clause"]
e1v1 --"wdt:P582"--> e1v2
e1v2("?P585"):::projected
e1v1("?item"):::projected
end
f3--EXISTS--> f3e1
f3 --> v4
f3 --> c6
f3 --> v5
v4 --"wdt:P582"--> v5
f4[["not "]]
subgraph f4e2["Exists Clause"]
e2v1 --"wdt:P580"--> e2v2
e2v2("?P585"):::projected
e2v1("?item"):::projected
end
f4--EXISTS--> f4e2
f4 --> v4
f4 --> c7
f4 --> v5
v4 --"wdt:P580"--> v5
f5[["not "]]
subgraph f5e3["Exists Clause"]
e3v1 --"wdt:P585"--> e3v2
e3v2("?P585"):::projected
e3v1("?item"):::projected
end
f5--EXISTS--> f5e3
f5 --> v4
f5 --> c8
f5 --> v5
v4 --"wdt:P585"--> v5
f6[["not "]]
subgraph f6e4["Exists Clause"]
e4v1 --"wdt:P31"--> e4c2
e4v1("?item"):::projected
e4c2(["wd:Q1477115"]):::iri
end
f6--EXISTS--> f6e4
f6 --> v4
f6 --> c9
f6 --> c10
v4 --"wdt:P31"--> c10
f7[["not "]]
subgraph f7e5["Exists Clause"]
e5v1 --"wdt:P31"--> e5c2
e5v1("?item"):::projected
e5c2(["wd:Q23726798"]):::iri
end
f7--EXISTS--> f7e5
f7 --> v4
f7 --> c9
f7 --> c11
v4 --"wdt:P31"--> c11
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
subgraph union1[" Union "]
subgraph union1l[" "]
style union1l fill:#abf,stroke-dasharray: 3 3;
v4 --"wdt:P31"--> a2
a2 --"wdt:P279"--> v7
v7 --"wdt:P279"--> c12
end
subgraph union1r[" "]
style union1r fill:#abf,stroke-dasharray: 3 3;
v4 --"wdt:P31"--> v6
v6 --"wdt:P279"--> c14
end
union1r <== or ==> union1l
end
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v4 --"wdt:P31"--> c12
end
union0r <== or ==> union0l
end
v4 --"wdt:P641"--> v8
v4 --"wikibase:sitelinks"--> v2
v4 --"rdfs:label"--> v3
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c19 --"wikibase:language"--> c21
end
bind9[/"count(?P641)"/]
v8 --o bind9
bind9 --as--o v9