User:PAC2/Wikiquote

SELECT ?instance ?instanceLabel  (COUNT(*) AS ?count) WHERE {
  ?sitelink schema:about ?item;
    schema:isPartOf <https://fr.wikiquote.org/>;
    schema:name ?string.
  ?item wdt:P31 ?instance .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
GROUP BY  ?instance ?instanceLabel 
ORDER BY DESC(?count)

Try it!

SELECT ?county ?countryLabel (COUNT(*) AS ?count) WHERE {
  ?sitelink schema:about ?item;
    schema:isPartOf <https://fr.wikiquote.org/>;
    schema:name ?string.
  ?item wdt:P17 ?country.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
GROUP BY  ?county ?countryLabel 
ORDER BY DESC(?count)

Try it!

SELECT ?gender ?genderLabel (COUNT(*) AS ?count) WHERE {
  ?sitelink schema:about ?item;
    schema:isPartOf <https://fr.wikiquote.org/>;
    schema:name ?string.
  ?item wdt:P31  wd:Q5 ;
        wdt:P21 ?gender.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
GROUP BY  ?gender ?genderLabel
ORDER BY DESC(?count)

Try it!

SELECT ?citizenship ?citizenshipLabel (COUNT(*) AS ?count) WHERE {
  ?sitelink schema:about ?item;
    schema:isPartOf <https://fr.wikiquote.org/>;
    schema:name ?string.
  ?item wdt:P31  wd:Q5 ;
        wdt:P27 ?citizenship.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
GROUP BY ?citizenship ?citizenshipLabel 
ORDER BY DESC(?count)

Try it!