query-718d8b3a5585c8f0751d2be45e947d99
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select ?item ?itemLabel ?sitelinks
where {
{
select distinct ?item
where {
values ?item_class {wd:Q34 wd:Q183}
?item wdt:P27 ?item_class; wdt:P21 wd:Q6581072; wdt:P31 wd:Q5.
filter not exists {[] schema:about ?item; schema:isPartOf <https://de.wikipedia.org/>}
}
}
bind(xsd:integer(substr(str(?item), 33)) as ?num).
?item wikibase:sitelinks ?sitelinks
service wikibase:label {bd:serviceParam wikibase:language "de,en,ceb,sv,fr,nl,ru,it,es,pl,war,vi,ja,zh,pt,uk,sr,fa,ca,ar,no,sh,fi,hu,id,ko,cs,ro,ms,tr,eu,eo,bg,hy,da,zh-min-nan,sk,min,kk,he,lt,hr,et,ce,sl,be,gl,el,nn,az,simple,uz,ur,la,hi,th,vo,ka,ta,cy,tg,mk,tl,mg,oc,lv,ky,bs,tt,sq,new,te,azb,zh-yue,pms,br,be-tarask,ast,bn,ml,jv,ht,lb,mr,sco,af,ga,pnb,is,ba,cv,fy,su,sw,my,lmo,an,yo,ne,nds,pa,gu,io,scn,bar,bpy,als,ku,kn,ckb,ia,qu,arz,mn,bat-smg,gd,wa,nap,si,yi,am,bug,cdo,or,map-bms,fo,mzn,hsb,xmf,mai,li,sah,sa,vec,ilo,os,mrj,hif,mhr,eml,bh,roa-tara,ps,diq,myv,pam,sd,hak,nso,zh-classical,se,bcl,ace,mi,wuu,nah,szl,nds-nl,frr,rue,gan,vls,km,bo,vep,crh,sc,glk,fiu-vro,co,lrc,tk,kv,csb,gv,as,lad,so,zea,nv,udm,ay,lez,stq,ie,kw,nrm,pcd,mwl,ug,rm,koi,ab,gn,gom,lij,mt,fur,dsb,sn,dv,ang,ln,ext,kab,cbk-zam,ksh,frp,lo,gag,dty,pag,olo,pi,av,bxr,pfl,xal,haw,krc,pap,kaa,rw,pdc,bjn,to,ha,nov,kl,arc,jam,kbd,tyv,tpi,tet,ki,ig,na,kbp,roa-rup,lbe,jbo,ty,mdf,za,kg,lg,wo,bi,srn,tcy,zu,chr,ltg,sm,om,xh,rmy,tn,cu,pih,rn,chy,tw,ts,tum,got,st,pnt,ss,bm,ch,fj,atj,ady,iu,ny,ee,ak,ks,ik,ve,sg,ff,dz,ti,cr,din,ng,cho,kj,mh,ho,ii,aa,mus,hz,kr".}
}
order by desc(?sitelinks) asc(?num)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?item"):::projected
v4("?item_class")
v5("?num")
v1("?sitelinks"):::projected
a1((" "))
c3([https://de.wikipedia.org/]):::iri
c6(["wd:Q6581072"]):::iri
c11(["bd:serviceParam"]):::iri
c8(["wd:Q5"]):::iri
c13(["de,en,ceb,sv,fr,nl,ru,it,es,pl,war,vi,ja,zh,pt,uk,sr,fa,ca,ar,no,sh,fi,hu,id,ko,cs,ro,ms,tr,eu,eo,bg,hy,da,zh-min-nan,sk,min,kk,he,lt,hr,et,ce,sl,be,gl,el,nn,az,simple,uz,ur,la,hi,th,vo,ka,ta,cy,tg,mk,tl,mg,oc,lv,ky,bs,tt,sq,new,te,azb,zh-yue,pms,br,be-tarask,ast,bn,ml,jv,ht,lb,mr,sco,af,ga,pnb,is,ba,cv,fy,su,sw,my,lmo,an,yo,ne,nds,pa,gu,io,scn,bar,bpy,als,ku,kn,ckb,ia,qu,arz,mn,bat-smg,gd,wa,nap,si,yi,am,bug,cdo,or,map-bms,fo,mzn,hsb,xmf,mai,li,sah,sa,vec,ilo,os,mrj,hif,mhr,eml,bh,roa-tara,ps,diq,myv,pam,sd,hak,nso,zh-classical,se,bcl,ace,mi,wuu,nah,szl,nds-nl,frr,rue,gan,vls,km,bo,vep,crh,sc,glk,fiu-vro,co,lrc,tk,kv,csb,gv,as,lad,so,zea,nv,udm,ay,lez,stq,ie,kw,nrm,pcd,mwl,ug,rm,koi,ab,gn,gom,lij,mt,fur,dsb,sn,dv,ang,ln,ext,kab,cbk-zam,ksh,frp,lo,gag,dty,pag,olo,pi,av,bxr,pfl,xal,haw,krc,pap,kaa,rw,pdc,bjn,to,ha,nov,kl,arc,jam,kbd,tyv,tpi,tet,ki,ig,na,kbp,roa-rup,lbe,jbo,ty,mdf,za,kg,lg,wo,bi,srn,tcy,zu,chr,ltg,sm,om,xh,rmy,tn,cu,pih,rn,chy,tw,ts,tum,got,st,pnt,ss,bm,ch,fj,atj,ady,iu,ny,ee,ak,ks,ik,ve,sg,ff,dz,ti,cr,din,ng,cho,kj,mh,ho,ii,aa,mus,hz,kr"]):::literal
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0a1 --"schema:about"--> e0v1
e0a1 --"schema:isPartOf"--> e0c3
e0v1("?item"):::projected
e0a1((" ")):::projected
e0c3([https://de.wikipedia.org/]):::iri
end
f0--EXISTS--> f0e0
f0 --> a1
f0 --> c1
f0 --> v3
f0 --> c2
f0 --> c3
a1 --"schema:about"--> v3
a1 --"schema:isPartOf"--> c3
bind1[/VALUES ?item_class/]
bind1-->v4
bind10(["wd:Q34"])
bind10 --> bind1
bind11(["wd:Q183"])
bind11 --> bind1
v3 --"wdt:P27"--> v4
v3 --"wdt:P21"--> c6
v3 --"wdt:P31"--> c8
bind2[/"http://www.w3.org/2001/XMLSchema#integer(substring(str(?item),'33^^xsd:integer'))"/]
v3 --o bind2
bind2 --as--o v5
v3 --"wikibase:sitelinks"--> v1
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c11 --"wikibase:language"--> c13
end