query-fb8b6dfeab9051b5cc72802448bf6a93

rq turtle/ttl

added before 2016-10

SELECT ?prop (count(?prop) as ?counts) WHERE {SELECT DISTINCT ?item ?prop WHERE { ?item wdt:P279 wd:Q7187 ; wdt:P703 wd:Q5 ; ?prop ?statement . FILTER(!(regex(str(?prop), "http://www.wikidata.org/prop/direct/" ) )) FILTER(regex(str(?prop), "http://www.wikidata.org/prop/" ) ) FILTER NOT EXISTS { ?item ?prop ?statement . ?statement prov:wasDerivedFrom ?derivedFrom .} } } GROUP BY ?prop ORDER BY desc(?counts) added before 2016-10

SELECT ?prop (count(?prop) as ?counts) WHERE {SELECT DISTINCT ?item ?prop WHERE { ?item wdt:P279 wd:Q7187 ; wdt:P703 wd:Q5 ; ?prop ?statement . FILTER(!(regex(str(?prop), "http://www.wikidata.org/prop/direct/" ) )) FILTER(regex(str(?prop), "http://www.wikidata.org/prop/" ) ) FILTER NOT EXISTS { ?item ?prop ?statement . ?statement prov:wasDerivedFrom ?derivedFrom .} } } GROUP BY ?prop ORDER BY desc(?counts) added before 2016-10

SELECT ?prop (count(?prop) as ?counts) WHERE {SELECT DISTINCT ?item ?prop WHERE { ?item wdt:P279 wd:Q7187 ; wdt:P703 wd:Q5 ; ?prop ?statement . FILTER(!(regex(str(?prop), "http://www.wikidata.org/prop/direct/" ) )) FILTER(regex(str(?prop), "http://www.wikidata.org/prop/" ) ) FILTER NOT EXISTS { ?item ?prop ?statement . ?statement prov:wasDerivedFrom ?derivedFrom .} } } GROUP BY ?prop ORDER BY desc(?counts) added before 2016-10

SELECT ?prop (count(?prop) as ?counts) WHERE {SELECT DISTINCT ?item ?prop WHERE { ?item wdt:P279 wd:Q7187 ; wdt:P703 wd:Q5 ; ?prop ?statement . FILTER(!(regex(str(?prop), "http://www.wikidata.org/prop/direct/" ) )) FILTER(regex(str(?prop), "http://www.wikidata.org/prop/" ) ) FILTER NOT EXISTS { ?item ?prop ?statement . ?statement prov:wasDerivedFrom ?derivedFrom .} } } GROUP BY ?prop ORDER BY desc(?counts) added before 2016-10

SELECT ?prop (count(?prop) as ?counts) WHERE {SELECT DISTINCT ?item ?prop WHERE { ?item wdt:P279 wd:Q7187 ; wdt:P703 wd:Q5 ; ?prop ?statement . FILTER(!(regex(str(?prop), "http://www.wikidata.org/prop/direct/" ) )) FILTER(regex(str(?prop), "http://www.wikidata.org/prop/" ) ) FILTER NOT EXISTS { ?item ?prop ?statement . ?statement prov:wasDerivedFrom ?derivedFrom .} } } GROUP BY ?prop ORDER BY desc(?counts) added before 2016-10

SELECT ?prop (count(?prop) as ?counts) WHERE {SELECT DISTINCT ?item ?prop WHERE { ?item wdt:P279 wd:Q7187 ; wdt:P703 wd:Q5 ; ?prop ?statement . FILTER(!(regex(str(?prop), "http://www.wikidata.org/prop/direct/" ) )) FILTER(regex(str(?prop), "http://www.wikidata.org/prop/" ) ) FILTER NOT EXISTS { ?item ?prop ?statement . ?statement prov:wasDerivedFrom ?derivedFrom .} } } GROUP BY ?prop ORDER BY desc(?counts) added before 2016-10

SELECT ?prop (count(?prop) as ?counts) WHERE {SELECT DISTINCT ?item ?prop WHERE { ?item wdt:P279 wd:Q7187 ; wdt:P703 wd:Q5 ; ?prop ?statement . FILTER(!(regex(str(?prop), "http://www.wikidata.org/prop/direct/" ) )) FILTER(regex(str(?prop), "http://www.wikidata.org/prop/" ) ) FILTER NOT EXISTS { ?item ?prop ?statement . ?statement prov:wasDerivedFrom ?derivedFrom .} } } GROUP BY ?prop ORDER BY desc(?counts) added before 2016-10

SELECT ?prop (count(?prop) as ?counts) WHERE {SELECT DISTINCT ?item ?prop WHERE { ?item wdt:P279 wd:Q7187 ; wdt:P703 wd:Q5 ; ?prop ?statement . FILTER(!(regex(str(?prop), "http://www.wikidata.org/prop/direct/" ) )) FILTER(regex(str(?prop), "http://www.wikidata.org/prop/" ) ) FILTER NOT EXISTS { ?item ?prop ?statement . ?statement prov:wasDerivedFrom ?derivedFrom .} } } GROUP BY ?prop ORDER BY desc(?counts) added before 2016-10

SELECT ?prop (count(?prop) as ?counts) WHERE {SELECT DISTINCT ?item ?prop WHERE { ?item wdt:P279 wd:Q7187 ; wdt:P703 wd:Q5 ; ?prop ?statement . FILTER(!(regex(str(?prop), "http://www.wikidata.org/prop/direct/" ) )) FILTER(regex(str(?prop), "http://www.wikidata.org/prop/" ) ) FILTER NOT EXISTS { ?item ?prop ?statement . ?statement prov:wasDerivedFrom ?derivedFrom .} } } GROUP BY ?prop ORDER BY desc(?counts) added before 2016-10

SELECT ?prop (count(?prop) as ?counts) WHERE {SELECT DISTINCT ?item ?prop WHERE { ?item wdt:P279 wd:Q7187 ; wdt:P703 wd:Q5 ; ?prop ?statement . FILTER(!(regex(str(?prop), "http://www.wikidata.org/prop/direct/" ) )) FILTER(regex(str(?prop), "http://www.wikidata.org/prop/" ) ) FILTER NOT EXISTS { ?item ?prop ?statement . ?statement prov:wasDerivedFrom ?derivedFrom .} } } GROUP BY ?prop ORDER BY desc(?counts)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX prov: <http://www.w3.org/ns/prov#>
#added before 2016-10

SELECT ?prop (count(?prop) as ?counts) WHERE
{SELECT DISTINCT ?item ?prop WHERE {
   ?item wdt:P279 wd:Q7187 ;
         wdt:P703 wd:Q5 ;
         ?prop ?statement .
  FILTER(!(regex(str(?prop), "http://www.wikidata.org/prop/direct/" ) ))
  FILTER(regex(str(?prop), "http://www.wikidata.org/prop/" ) )
  FILTER NOT EXISTS {
               ?item ?prop ?statement .
               ?statement prov:wasDerivedFrom ?derivedFrom  .}
}
}
GROUP BY ?prop
ORDER BY desc(?counts)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?counts") v5("?derivedFrom") v2("?item") v3("?prop"):::projected v4("?statement") c5(["wd:Q7187"]):::iri c7(["wd:Q5"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 -->e0v2--> e0v3 e0v3 --"prov:wasDerivedFrom"--> e0v4 e0v4("?derivedFrom"):::projected e0v1("?item"):::projected e0v2("?prop"):::projected e0v3("?statement"):::projected end f0--EXISTS--> f0e0 f0 --> v2 f0 --> v3 f0 --> v4 f0 --> c1 f0 --> v5 v2 -->v3--> v4 v4 --"prov:wasDerivedFrom"--> v5 f1[["regex(str(?prop),'http://www.wikidata.org/prop/')"]] f1 --> v3 f2[["not regex(str(?prop),'http://www.wikidata.org/prop/direct/')"]] f2 --> v3 v2 --"wdt:P279"--> c5 v2 --"wdt:P703"--> c7 v2 -->v3--> v4 bind4[/"count(?prop)"/] v3 --o bind4 bind4 --as--o v6