User:Mr. Ibrahem/queries

category combines topics (P971)

The following query uses these:

P641Edit

The following query uses these:

  • 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