Difference between revisions of "Talk:ArchiveBot/Wikidata lists"
Jump to navigation
Jump to search
Line 7: | Line 7: | ||
} | } | ||
ORDER BY ?twitter | ORDER BY ?twitter | ||
</pre> | |||
=== Sorted by followers === | |||
<pre> | |||
SELECT DISTINCT ?item ?twitter ?followers | |||
WHERE { | |||
?item wdt:P2002 ?twitter. | |||
?item p:P2002 [ pq:P3744 ?followers ]. | |||
} | |||
ORDER BY DESC(?followers) | |||
</pre> | </pre> | ||
Revision as of 23:20, 25 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)
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