Difference between revisions of "Talk:ArchiveBot/Wikidata lists"
Jump to navigation
Jump to search
Line 10: | Line 10: | ||
=== Sorted by followers === | === Sorted by followers === | ||
<pre> | <pre> | ||
SELECT DISTINCT ?item ?twitter ?followers | SELECT DISTINCT ?item ?twitter ?followers | ||
Line 18: | Line 17: | ||
} | } | ||
ORDER BY DESC(?followers) | ORDER BY DESC(?followers) | ||
</pre> | |||
== YouTube query == | |||
<pre> | |||
SELECT DISTINCT ?item ?youtube | |||
WHERE { | |||
?item wdt:P2397 ?youtube. | |||
} | |||
ORDER BY ?youtube | |||
</pre> | </pre> | ||
Revision as of 07:05, 26 May 2019
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