User:MargaretRDonald/sandbox/Plants with SPRAT ids and no article

{{Wikidata list|sparql=# SPRAT wikidata items without an enwiki article SELECT ?item ?taxon_name ?sprat_ID ?spratLink ?APNILink WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }   ?item wdt:P2455 ?sprat_ID. ?item wdt:P225 ?taxon_name. bind(uri(concat("http://www.environment.gov.au/cgi-bin/sprat/public/publicspecies.pl?taxon_id=",?sprat_ID)) as ?spratLink)

OPTIONAL {?item wdt:P5984 ?APNI_ID. bind(uri(concat("https://biodiversity.org.au/nsl/services/rest/name/apni/",?APNI_ID)) as ?APNILink)} MINUS {?article schema:about ?item. # and have an article about them ?article schema:isPartOf . # on *English* Wikipedia} } } ORDER BY ?taxon_name ?item }} ... (This will be overwritten by ListeriaBot) ...
 * columns=label:Article,description,p131:Place,P580,P582,p625,P18
 * section=131
 * min_section=3
 * sort=label
 * links=text
 * thumb=128
 * autolist=fallback

Wikidata query URL

 * Wikidata Query: Australian Plants with no enwiki article - on SPRAT (with links to SPRAT & APNI)
 * Link to Wellington meetup

Kevin Thiele taxa with no enwiki article
{{Wikidata list ?item p:P225 ?stat. ?stat ps:P225 ?taxon. ?stat pq:P405 wd:Q547084. # Kevin Thiele MINUS { ?article schema:about ?item. # and have an article about them ?article schema:isPartOf . # on *English* Wikipedia} SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }    }  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY ?taxon ?item }}
 * sparql=SELECT ?itemLabel ?item ?taxon WHERE {
 * columns=label:name,item:Wikidata,?taxon
 * thumb=40
 * autolist=fallback
 * links=red
 * summary=itemnumber

&sum; 1 items.