User:PAC2/Tintindata
Jump to navigation
Jump to search
List of books
List of characters in Tintin
List of characters in Tintin
List of places in Tintin
List of queries about The Adventures of Tintin (Q744536).
TABernacle of albums with rank
#title: List of books
SELECT ?book ?bookLabel ?rk WHERE {
?book wdt:P179 wd:Q744536;
wdt:P1545 ?rank.
BIND(xsd:integer(?rank) AS ?rk)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY (?rk)
Characters
[edit]#title: List of characters in Tintin
SELECT ?character ?characterLabel ?book ?bookLabel ?rk WHERE {
?book wdt:P179 wd:Q744536.
OPTIONAL {
?book wdt:P1545 ?rank.
BIND(xsd:integer(?rank) AS ?rk)
}
OPTIONAL {?book wdt:P674 ?character.}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY (?rk) (?characterLabel)
#title: List of characters in Tintin
SELECT ?character ?characterLabel (COUNT(*) AS ?count) WHERE {
?book wdt:P179 wd:Q744536;
wdt:P674 ?character.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?character ?characterLabel
ORDER BY DESC(?count)
Places
[edit]#title: List of places in Tintin
SELECT ?place ?placeLabel ?book ?bookLabel ?rk WHERE {
?book wdt:P179 wd:Q744536;
wdt:P1545 ?rank.
BIND(xsd:integer(?rank) AS ?rk)
OPTIONAL { ?book wdt:P840 ?place. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY (?rk) (?placeLabel)