User:Mr. Ibrahem/queries

category combines topics (P971)

The following query uses these:

• Items: sport (Q349)   , occurrence (Q1190554)   , sporting event (Q16510064)   

• Properties: category combines topics (P971)   

  SELECT ?item WHERE {
    ?item wdt:P971 wd:Q349.
    ?item wdt:P971 wd:Q1190554.
    ?item wdt:P971 wd:Q16510064.
  }
  

Try it!

P641

The following query uses these:

• Items: national sports team (Q1194951)   , women's national team (Q8031011)   , elite national cycling team (Q23726798)   , National team appearances in the FIFA World Cup (Q1477115)   

• Properties: instance of (P31)   , subclass of (P279)   , sport (P641)   , point in time (P585)   , start time (P580)   , end time (P582)   

  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
  

Try it!