User:PAC2/Medias by country

My goal is to quickly map the list of medias in a country.

I include newspaper (Q11032), television and radio channels.

List of newspaper (Q11032) by country edit

The following query uses these:

Items: newspaper (Q11032)   , France (Q142)

Properties: instance of (P31)   , subclass of (P279)   , country (P17)   , dissolved, abolished or demolished date (P576)  
```
SELECT DISTINCT ?item ?itemLabel ?sitelinks WHERE {
  ?item (wdt:P31/(wdt:P279*)) wd:Q11032;
    wdt:P17 wd:Q142;
    wikibase:sitelinks ?sitelinks.
  MINUS { ?item wdt:P576 _:b1. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
ORDER BY DESC (?sitelinks)
LIMIT 100
```

Miscellaneous queries edit

ASK WHERE { wd:Q1616075 (wdt:P279*) wd:Q2001305. }

Try it!

SELECT DISTINCT ?item ?itemLabel ?sitelinks WHERE {
  ?item (wdt:P31/(wdt:P279*)) wd:Q1193236;
    wdt:P17 wd:Q142;
    wikibase:sitelinks ?sitelinks.
  MINUS { ?item wdt:P576 _:b1. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
ORDER BY DESC (?sitelinks)
LIMIT 100

Try it!