Talk:ArchiveBot/Wikidata lists
Jump to navigation
Jump to search
You can run these queries in https://query.wikidata.org/
Facebook query
SELECT DISTINCT ?item ?facebook WHERE { { ?item wdt:P4003 ?facebook. } UNION { ?item wdt:P2013 ?facebook. } } ORDER BY ?facebook
Telegram query
SELECT DISTINCT ?item ?telegram WHERE { ?item wdt:P3789 ?telegram. } ORDER BY ?telegram
Twitter query
SELECT DISTINCT ?item ?twitter WHERE { ?item wdt:P2002 ?twitter. } ORDER BY ?twitter
Sorted by followers
SELECT DISTINCT ?item ?twitter ?followers WHERE { ?item wdt:P2002 ?twitter. ?item p:P2002 [ pq:P3744 ?followers ]. } ORDER BY DESC(?followers)
YouTube query
SELECT DISTINCT ?item ?youtube WHERE { ?item wdt:P2397 ?youtube. } ORDER BY ?youtube
Museums query
SELECT DISTINCT ?item ?website WHERE { ?item wdt:P31/wdt:P279* wd:Q33506. ?item wdt:P856 ?website. } ORDER BY ?website
Cities query
SELECT DISTINCT ?website WHERE { ?item wdt:P31/wdt:P279* wd:Q486972. ?item wdt:P856 ?website. } ORDER BY ?website
Archives query
SELECT DISTINCT ?website WHERE { ?item wdt:P31/wdt:P279* wd:Q166118. ?item wdt:P856 ?website. } ORDER BY ?website
Sport events
SELECT DISTINCT ?website WHERE { ?item wdt:P31/wdt:P279* wd:Q13406554. ?item wdt:P856 ?website. } ORDER BY ?website
Newspapers
Sorted by number of wikipedia languages for each newspaper.
Wikidata query: SELECT DISTINCT ?web WHERE { ?item wdt:P31/wdt:P279* wd:Q11032. ?item wdt:P856 ?web. ?item wikibase:sitelinks ?sitelinks. } ORDER BY DESC(?sitelinks) LIMIT 1000
- https://transfer.notkiska.pw/PTUBR/newspapers-top-100.txt
- https://transfer.notkiska.pw/qORue/newspapers-top-500.txt
- https://transfer.notkiska.pw/5HnU0/newspapers-top-1000.txt
- https://transfer.notkiska.pw/scnOs/newspapers-top-5000.txt
Government bodies
SELECT DISTINCT ?web WHERE { ?item wdt:P31/wdt:P279* wd:Q2659904. ?item wdt:P856 ?web. ?item wikibase:sitelinks ?sitelinks. } ORDER BY DESC(?sitelinks) LIMIT 25000