User:SM5POR/Queries

Server access

{{}}= Templates = Template:Item documentation Template:Item classification Template:Class reports

wd:P31 wd:P279 wd:P1963 wd:P2308 wd:P2445 wd:P2670 wd:P2737 wd:P2738 wd:P5852 wd:P6609 wd:P8225 wd:P10726 wd:P11260

wd:P17 wd:P27 wd:P31 wd:P39 wd:P101 wd:P106 wd:P108 wd:P276 wd:P279 wd:P360 wd:P361 wd:P366 wd:P518 wd:P527 wd:P531 wd:P642 wd:P749 wd:P793 wd:P825 wd:P921 wd:P1001 wd:P1013 wd:P1268 wd:P1269 wd:P1416 wd:P1542 wd:P1545 wd:P1552 wd:P1875 wd:P2012 wd:P2348 wd:P2596 wd:P2737 wd:P2738 wd:P2868 wd:P3712 wd:P3831 wd:P4224 wd:P7084 wd:P8225 wd:P10751 wd:P10752 wd:P11260 wd:P11279

Template:Replace

Debugging may be required:

• exonym (Q81639)

{ {Class reports/sandbox|Q81639}}

{ {Item documentation|Q81639}}

{ {Item documentation/sandbox|Q81639}}

Template:Item documentation/sandbox

{ {#invoke:Requests/sandbox|put_queries|id=Q188745}}

SPARQL sandbox

SELECT ?sample ?sampleLabel ?property ?propertyLabel ?qualifiers ?statements WHERE {
  {
    SELECT DISTINCT ?p ?qualifiers (SAMPLE(?item) AS ?sample) (COUNT(?stmt) AS ?statements) WHERE {
      {
        SELECT ?item ?p ?stmt (GROUP_CONCAT(?kv) AS ?qualifiers) WHERE {
          {
            SELECT ?item ?p ?stmt ?str ?kv WHERE {
              {
                SELECT ?item ?p ?stmt ?str (COUNT(?qval) AS ?values) WHERE {
                  VALUES ?p {p:P1359}
                  ?item ?p ?stmt .
                  #?stmt pq:P642 ?qval0 .
                  ?stmt ?pq ?qval .
                  ?wdq wikibase:qualifier ?pq .
                  BIND(STRAFTER(STR(?pq), "/P") AS ?str)
                }
                GROUP BY ?item ?p ?stmt ?str
              }
              BIND(CONCAT(?str, ":", STR(?values)) AS ?kv)
            }
            ORDER BY DESC(STRLEN(?str)) DESC(?str) ?kv ?stmt ?p
          }
        }
        GROUP BY ?item ?p ?stmt
      }
    }
    GROUP BY ?p ?qualifiers
  }
  ?property wikibase:claim ?p .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY ?property DESC(?statements)

Try it!

Property constraints

SELECT ?property ?propertyLabel WHERE {
  {
    SELECT DISTINCT ?property WHERE {
      ?property wikibase:propertyType wikibase:WikibaseItem .
      FILTER(NOT EXISTS {?property p:P2302 ?sstmt .
                     ?sstmt ps:P2302 wd:Q21503250 .})
      FILTER(NOT EXISTS {?property p:P2302 ?vstmt .
                     ?vstmt ps:P2302 wd:Q21510865 .})
    }
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

Try it!