query-13f64b429b609f4b10b39c41204230e6

rq turtle/ttl

Propertiesinstance of (P31)subclass of (P279)sport (P641)point in time (P585)start time (P580)end time (P582)

Use at

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