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

From Archiveteam
Jump to navigation Jump to search
Line 8: Line 8:
}
}
ORDER BY ?facebook
ORDER BY ?facebook
</pre>
== Telegram query ==
<pre>
SELECT DISTINCT ?item ?telegram
WHERE {
    ?item wdt:P3789 ?telegram.
}
ORDER BY ?telegram
</pre>
</pre>



Revision as of 11:24, 28 December 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

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