Difference between revisions of "Talk:ArchiveBot/Wikidata lists"

From Archiveteam
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