Difference between revisions of "Talk:ArchiveBot/Wikidata lists"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
You can run these queries in https://query.wikidata.org/ | You can run these queries in https://query.wikidata.org/ | ||
== Facebook query == | |||
<pre> | |||
SELECT DISTINCT ?item ?facebook | |||
WHERE { | |||
{ ?item wdt:P4003 ?facebook. } UNION { ?item wdt:P2013 ?facebook. } | |||
} | |||
ORDER BY ?facebook | |||
</pre> | |||
== Twitter query == | == Twitter query == |
Revision as of 09:41, 26 May 2019
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
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