User:PAC2/Tintindata

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)

List of books

Characters

#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)

List of characters in Tintin

#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)

List of characters in Tintin

Places

#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)

List of places in Tintin