Movatterモバイル変換

[0]ホーム
URL:

Jump to content
Wikidata
Search

User:Theklan

From Wikidata
Babel user information
eu-NErabiltzaile haueuskaldun zaharra da (euskara du ama hizkuntza).
es-NEsta persona tiene una comprensiónnativa delespañol.
en-3This user hasadvanced knowledge ofEnglish.
fr-1Cet·te utilisateur·rice dispose de connaissancesde base enfrançais.
ca-1Aquest usuari té un coneixementbàsic decatalà.
Users by language

Queries

[edit]

Parlamentarioak legegintzaldiaren arabera antolatzeko

[edit]
SELECT?article("+Category:Nafarroako Parlamentuko parlamentariak IV. legealdian"AS?command)WHERE{SERVICEwikibase:label{bd:serviceParamwikibase:language"eu,en".}?itemwdt:P39wd:Q60226157.VALUES?legealdia{wd:Q117822847}?itemp:P39?kargua.?karguaps:P39?kargua_;pq:P2937?legealdia.?articleschema:about?item.?articleschema:inLanguage"eu".?articleschema:isPartOf<https://eu.wikipedia.org/>}
Try it!

Mammals that are in catalan Wikipedia but not in Basque

[edit]
PREFIXschema:<http://schema.org/>SELECTDISTINCT?item?taxonname?familyLabel?orderLabel?sitelinks?itemLabelWHERE{?itemwdt:P31wd:Q16521.?itemwdt:P105wd:Q7432.?itemwdt:P225?taxonname.?itemwdt:P171+wd:Q7377.?itemwdt:P171+?family.?familywdt:P105wd:Q35409.?familywdt:P171+?order.?orderwdt:P105wd:Q36602.?itemwikibase:sitelinks?sitelinks.?catschema:about?item.?catschema:isPartOf<https://ca.wikipedia.org/>.SERVICEwikibase:label{bd:serviceParamwikibase:language"la,eu".}FILTER(NOT EXISTS{?wenschema:about?item.?wenschema:inLanguage"eu".})MINUS{?itemwdt:P141wd:Q237350.}}ORDER BYDESC(?sitelinks)LIMIT1000
Try it!

Butterfly genus at enwiki but not at euwiki

[edit]
SELECTDISTINCT?item?taxonname?familyLabel?itemLabel?taxonomic_typeLabelWHERE{?itemwdt:P31wd:Q16521;wdt:P105wd:Q34740;wdt:P225?taxonname;(wdt:P171+)wd:Q28319;(wdt:P171+)?family.?familywdt:P105wd:Q35409.?catschema:about?item;schema:isPartOf<https://en.wikipedia.org/>.SERVICEwikibase:label{bd:serviceParamwikibase:language"la,eu".}FILTER(NOT EXISTS{?wenschema:about?item;schema:inLanguage"eu".})?itemwdt:P427?taxonomic_type.}LIMIT300
Try it!

Fungi with image not present at Basque Wikipedia ordered by number of sitelinks

[edit]
PREFIXschema:<http://schema.org/>SELECTDISTINCT?item?taxonname?itemLabel?irudia?sitelinksWHERE{?itemwdt:P31wd:Q16521.?itemwdt:P105wd:Q7432.?itemwdt:P225?taxonname.?itemwdt:P171+wd:Q27720.?itemwdt:P171+?family.?familywdt:P105wd:Q37517.?itemwdt:P18?irudia.?itemwikibase:sitelinks?sitelinks.?wenschema:about?item.?wenschema:isPartOf<https://en.wikipedia.org/>.SERVICEwikibase:label{bd:serviceParamwikibase:language"la,eu".}FILTER(NOT EXISTS{?weuschema:about?item.?weuschema:inLanguage"eu".})}ORDER BYDESC(?sitelinks)LIMIT100
Try it!

Donemiliagako goldea

[edit]
#defaultView:MapSELECT?goldea?goldeaLabel?antzinako_izenaL?layerLabel?barrutiaL?koordWHERE{?goldeawdt:P1343wd:Q559998;p:P1343[pq:P1932?antzinako_izena;pq:P361?barrutia].?goldeawdt:P625?koord.SERVICEwikibase:label{bd:serviceParamwikibase:language"[AUTO_LANGUAGE],eu,es,mul".}BIND(?barrutiaas?layer)BIND(CONCAT("Antzinako izena: ",?antzinako_izena)as?antzinako_izenaL)}
Try it!

Wikidata Query Service + QuickCategories = ♥

[edit]
SELECT?titleEu("+Category:Alemaniako futbolariak"AS?command)WHERE{hint:Queryhint:optimizer"None".SERVICEwikibase:mwapi{bd:serviceParamwikibase:api"Generator";wikibase:endpoint"en.wikipedia.org";mwapi:generator"categorymembers";mwapi:gcmtitle"Category:German_footballers";mwapi:gcmnamespace0;mwapi:gcmprop"title";mwapi:gcmlimit"max".?titleEn_wikibase:apiOutputmwapi:title.}BIND(STRLANG(?titleEn_,"en")AS?titleEn)?articleEnschema:name?titleEn;schema:isPartOf<https://en.wikipedia.org/>;schema:about?item.?articleEuschema:about?item;schema:isPartOf<https://eu.wikipedia.org/>;schema:name?titleEu.}

Copy the result, paste it intoQuickCategories, 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:Queryhint:optimizer"None".SERVICE<https://query.wikidata.org/bigdata/namespace/categories/sparql>{SERVICEmediawiki:categoryTree{bd:serviceParammediawiki:start<https://en.wikipedia.org/wiki/Category:ENGLISH_CATEGORY_URL_HERE>;mediawiki:direction"Reverse";mediawiki:depth5.# change this if needed}}?outschema:name?categoryEn.SERVICEwikibase:mwapi{bd:serviceParamwikibase:api"Generator";wikibase:endpoint"en.wikipedia.org";mwapi:generator"categorymembers";mwapi:gcmtitle?categoryEn;mwapi:gcmnamespace0;mwapi:gcmprop"title";mwapi:gcmlimit"max".?titleEn_wikibase:apiOutputmwapi:title.}BIND(STRLANG(?titleEn_,"en")AS?titleEn)?articleEnschema:name?titleEn;schema:isPartOf<https://en.wikipedia.org/>;schema:about?item.?articleEuschema:about?item;schema:isPartOf<https://eu.wikipedia.org/>;schema:name?titleEu.}LIMIT100

People born by year

[edit]
SELECT?year(COUNT(?item)AS?count)WHERE{?itemwdt:P19wd:Q1598962.?itemwdt:P569?data.BIND(YEAR(?data)as?year)}GROUP BY?year

Veterans and battles

[edit]

Beteranoan jaio-heriotza lekuak, guduak eta gurasoak

[edit]
#defaultView:Map{"hide":["?rgb"],"?rgb"}SELECT?veteran?veteranLabel?veteran_?layer?aita?aitaLabel?aita_?jaiolekua_aita_?ama?amaLabel?ama_?jaiolekua_ama_?aitona?aitonaLabel?aitona_?jaiolekua_aitona_?gatazkaLabel?coord?rgbWITH{SELECT?veteran?jaiolekua?heriotza?ama?aita?aitonaWHERE{?veteranwdt:P241wd:Q11218.?veteranwdt:P172wd:Q126756.?veteranwdt:P19?jaiolekua.?veteranwdt:P20?heriotza.?veteranwdt:P25?ama.?veteranwdt:P22?aita.OPTIONAL{?aitawdt:P22?aitona.}}}as%iwith{select?veteran?veteran_?layer?ama?jaiolekua_ama_?coord?rgbWHERE{INCLUDE%i?amawdt:P19?jaiolekua_ama.?jaiolekua_amawdt:P625?coord.?veteranrdfs:label?veteranL.FILTER(LANG(?veteranL)="eu")BIND(CONCAT("Beteranoa: ",?veteranL)as?veteran_)?jaiolekua_amardfs:label?jaiolekua_amaL.FILTER(LANG(?jaiolekua_amaL)="eu")BIND(CONCAT("Amaren jaiolekua: ",?jaiolekua_amaL)as?jaiolekua_ama_)BIND("3366CC"as?rgb)BIND("Ama"as?layer)}}as%jwith{select?veteran?veteran_?layer?jaiolekua_aita_?aita?coord?rgbWHERE{INCLUDE%i?aitawdt:P19?jaiolekua_aita.?jaiolekua_aitawdt:P625?coord.?veteranrdfs:label?veteranL.FILTER(LANG(?veteranL)="eu")BIND(CONCAT("Beteranoa: ",?veteranL)as?veteran_)?jaiolekua_aitardfs:label?jaiolekua_aitaL.FILTER(LANG(?jaiolekua_aitaL)="eu")BIND(CONCAT("Aitaren jaiolekua: ",?jaiolekua_aitaL)as?jaiolekua_aita_)BIND("FFCC33"as?rgb)BIND("Aita"as?layer)}}as%kwith{select?veteran?veteran_?heriotza?ama_?aita_?coord?layer?rgbWHERE{INCLUDE%i?heriotzawdt:P625?coord.?veteranrdfs:label?veteranL.FILTER(LANG(?veteranL)="eu")BIND(CONCAT("Beteranoa: ",?veteranL)as?veteran_)?aitardfs:label?aitaL.FILTER(LANG(?aitaL)="eu")BIND(CONCAT("Aita: ",?aitaL)as?aita_)?amardfs:label?amaL.FILTER(LANG(?amaL)="eu")BIND(CONCAT("Ama: ",?amaL)as?ama_)BIND("b32425"as?rgb)BIND("Heriotza lekua"as?layer)}}as%lwith{select?veteran?veteran_?jaiolekua?heriotza?ama_?aita_?coord?layer?rgbWHERE{INCLUDE%i?jaiolekuawdt:P625?coord.?veteranrdfs:label?veteranL.FILTER(LANG(?veteranL)="eu")BIND(CONCAT("Beteranoa: ",?veteranL)as?veteran_)?aitardfs:label?aitaL.FILTER(LANG(?aitaL)="eu")BIND(CONCAT("Aita: ",?aitaL)as?aita_)?amardfs:label?amaL.FILTER(LANG(?amaL)="eu")BIND(CONCAT("Ama: ",?amaL)as?ama_)BIND("00af89"as?rgb)BIND("Jaiolekua"as?layer)}}as%mwith{select?veteran?gatazka?coord?layer?rgbWHERE{INCLUDE%i?veteranwdt:P607?gatazka.?gatazkawdt:P625?coord.BIND("72777d"as?rgb)BIND("Gudua"as?layer)}}as%nwith{select?veteran?veteran_?layer?jaiolekua_aitona_?aitona_?coord?rgbWHERE{INCLUDE%i?veteranwdt:P22?aita.?aitawdt:P22?aitona.?aitonawdt:P19?jaiolekua_aitona.?jaiolekua_aitonawdt:P625?coord.?veteranrdfs:label?veteranL.FILTER(LANG(?veteranL)="eu")BIND(CONCAT("Beteranoa: ",?veteranL)as?veteran_)?jaiolekua_aitonardfs:label?jaiolekua_aitonaL.FILTER(LANG(?jaiolekua_aitonaL)="eu")BIND(CONCAT("Aitonaren jaiolekua: ",?jaiolekua_aitonaL)as?jaiolekua_aitona_)BIND("FFCC00"as?rgb)BIND("Aitona"as?layer)}}as%oWHERE{{INCLUDE%j}UNION{INCLUDE%k}UNION{INCLUDE%l}UNION{INCLUDE%m}UNION{INCLUDE%n}UNION{INCLUDE%o}SERVICEwikibase:label{bd:serviceParamwikibase:language"eu,en,es".}}
Try it!

Alemaniako herriak estatuka

[edit]
SELECTDISTINCT?germany?germanyLabel?popWHERE{SERVICEwikibase:label{bd:serviceParamwikibase:language"[AUTO_LANGUAGE],en".}?germanywdt:P31wd:Q42744322;wdt:P1082?pop;(wdt:P131*)wd:Q1202.hint:Priorhint:gearing"forward".?germanywikibase:sitelinks?linkcount.FILTER(?linkcount>=10)FILTER(NOT EXISTS{?articleschema:about?germany;schema:inLanguage"eu";schema:isPartOf<https://eu.wikipedia.org/>.})}
Try it!
Retrieved from "https://www.wikidata.org/w/index.php?title=User:Theklan&oldid=2391523803"
Categories:
[8]ページ先頭
©2009-2025 Movatter.jp