User:Daniel Mietchen/Wikidata lists/Politicians that are authors
Jump to navigation
Jump to search
Listeria table[edit]
This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!
WDQS | PetScan | TABernacle | Find images | Recent changes | Query:SELECT DISTINCT ?item ?count (REPLACE(STR(?item), ".*Q", "Q") AS ?qid) (CONCAT("[https://scholia.toolforge.org/author/", ENCODE_FOR_URI(?qid), " 🙋]") AS ?ScholiaURL) WITH { SELECT ?item WHERE { ?item wdt:P106 wd:Q82955 . # politicians } } AS %politicians WITH { SELECT ?item (COUNT(DISTINCT ?publication) AS ?count) WHERE { INCLUDE %politicians ?publication wdt:P50 ?item . #authors } GROUP BY ?item ?count HAVING (?count > 200) } AS %publications WHERE { INCLUDE %publications SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?item ?count ?qid ?ScholiaURL ORDER BY DESC(?count) LIMIT 300
∑ 300 items.
End of automatically generated list.