query-cb3aeb697ab88b8ae7b5269be6fe07c3
Request to add statements for year in motorsport for country categories (2023-07-04) Lights and freedom: Request date: 5 July 2023, byTask description categories: year in motorsport for a countryThis is a request to add the following statements for all (if not already present; some countries use the word "motorsport", others use "motorsports").country - year (if not already present) and motorsport in (P971)category combines topics - the following year in motorsport category for that country(P156)followed by - the previous year in motorsport category for that country(P155)follows . history of the item "Category:2018 in Dutch motorsport"For example, see No urgency, this is just something that should be done. Licence of data to import (if relevant)Discussion statements. (P156)followed by . However, I wonder whether anybody actually uses (P156)followed by I have written the following query to find items lacking
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 bd: <http://www.bigdata.com/rdf#>
SELECT ?a ?b ?aLabel ?bLabel WHERE {
?y wdt:P31 wd:Q3186692.
?y ^wdt:P971 ?a.
?a wdt:P31 wd:Q4167836.
MINUS {?a wdt:P156 ?an}.
MINUS {?a wdt:P971 ?as. FILTER(?as != ?x && ?as != ?y).}.
?y wdt:P156 ?yy.
BIND(wd:Q10589714 AS ?x). # Modify this to another topic if finished
?a wdt:P971 ?x.
?b wdt:P971 ?x.
?yy ^wdt:P971 ?b.
?b wdt:P31 wd:Q4167836.
MINUS {?b wdt:P155 ?bn}.
MINUS {?b wdt:P971 ?bs. FILTER(?bs != ?x && ?bs != ?yy).}.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} LIMIT 100