Theklan
Joined 12 March 2013
Babel user information | ||
---|---|---|
| ||
Users by language |
QueriesEdit
Mammals that are in catalan Wikipedia but not in BasqueEdit
PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?item ?taxonname ?familyLabel ?orderLabel ?sitelinks ?itemLabel WHERE {
?item wdt:P31 wd:Q16521.
?item wdt:P105 wd:Q7432.
?item wdt:P225 ?taxonname.
?item wdt:P171+ wd:Q7377.
?item wdt:P171+ ?family.
?family wdt:P105 wd:Q35409.
?family wdt:P171+ ?order.
?order wdt:P105 wd:Q36602.
?item wikibase:sitelinks ?sitelinks.
?cat schema:about ?item.
?cat schema:isPartOf <https://ca.wikipedia.org/>.
SERVICE wikibase:label { bd:serviceParam wikibase:language "la,eu". }
FILTER(NOT EXISTS {
?wen schema:about ?item.
?wen schema:inLanguage "eu".
})
MINUS {?item wdt:P141 wd:Q237350.}
}
ORDER BY DESC(?sitelinks)
LIMIT 1000
Wikidata Query Service + QuickCategories = ♥Edit
SELECT ?titleEu ("+Category:Alemaniako futbolariak" AS ?command) WHERE {
hint:Query hint:optimizer "None".
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:api "Generator";
wikibase:endpoint "en.wikipedia.org";
mwapi:generator "categorymembers";
mwapi:gcmtitle "Category:German_footballers";
mwapi:gcmnamespace 0;
mwapi:gcmprop "title";
mwapi:gcmlimit "max".
?titleEn_ wikibase:apiOutput mwapi:title.
}
BIND(STRLANG(?titleEn_, "en") AS ?titleEn)
?articleEn schema:name ?titleEn;
schema:isPartOf <https://en.wikipedia.org/>;
schema:about ?item.
?articleEu schema:about ?item;
schema:isPartOf <https://eu.wikipedia.org/>;
schema:name ?titleEu.
}
Copy the result, paste it into QuickCategories, submit the batch and run the commands. Try it out! --Lucas Werkmeister (eztabaida) 20:19, 29 martxoa 2019 (UTC)
- With subcategory support:
SELECT ?titleEu ("+Category:BASQUE CATEGORY HERE" AS ?command) WHERE {
hint:Query hint:optimizer "None".
SERVICE <https://query.wikidata.org/bigdata/namespace/categories/sparql> {
SERVICE mediawiki:categoryTree {
bd:serviceParam mediawiki:start <https://en.wikipedia.org/wiki/Category:ENGLISH_CATEGORY_URL_HERE>;
mediawiki:direction "Reverse";
mediawiki:depth 5 . # change this if needed
}
}
?out schema:name ?categoryEn.
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:api "Generator";
wikibase:endpoint "en.wikipedia.org";
mwapi:generator "categorymembers";
mwapi:gcmtitle ?categoryEn;
mwapi:gcmnamespace 0;
mwapi:gcmprop "title";
mwapi:gcmlimit "max".
?titleEn_ wikibase:apiOutput mwapi:title.
}
BIND(STRLANG(?titleEn_, "en") AS ?titleEn)
?articleEn schema:name ?titleEn;
schema:isPartOf <https://en.wikipedia.org/>;
schema:about ?item.
?articleEu schema:about ?item;
schema:isPartOf <https://eu.wikipedia.org/>;
schema:name ?titleEu.
}
LIMIT 100
People born by yearEdit
SELECT ?year (COUNT(?item) AS ?count)
WHERE
{
?item wdt:P19 wd:Q1598962.
?item wdt:P569 ?data.
BIND(YEAR(?data) as ?year)
}
GROUP BY ?year