query-a846d94682edcc7e3d024f5c715387cd

rq turtle/ttl

15:04, 23 December 2016 (UTC)) talk (ValterVB--

Use at

• https://query.wikidata.org/sparql

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 prov: <http://www.w3.org/ns/prov#>
SELECT ?item (COUNT(DISTINCT ?p) as ?ct) 
{  
    { SELECT ?item {    ?item wikibase:statements 2 
                              ; wikibase:sitelinks 0 
                              ; wdt:P31 wd:Q5 
                              ; wdt:P21 [] 
                   } LIMIT 1000 }
        # avoid timeout on wikibase:claim / ?sp 
    ?item ?sp ?claim .                  # double-check wikibase:statements
    ?p wikibase:claim ?sp .             # double-check wikibase:statements
    OPTIONAL{ ?backlink ?s ?item }                  FILTER(!BOUND(?backlink)) 
    OPTIONAL{ ?claim prov:wasDerivedFrom ?ref . ?ref ?p ?v . FILTER NOT EXISTS { ?v wdt:P31 wd:Q10876391 } }    FILTER(!BOUND(?ref)) # exclude no source and wikipedia only source
    # OPTIONAL{ ?claim prov:wasDerivedFrom ?ref }   FILTER(!BOUND(?ref)) # exclude any reference
    OPTIONAL{ ?art schema:about ?item }             FILTER(!BOUND(?art))    # double-check wikibase:sitelinks
}
GROUP BY ?item
HAVING (?ct = 2)    # double-check wikibase:statements

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2016/12