query-e8bd7969320a1eb2ac2bdc23a5dcb481

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 ?sitelinks ?itemLabel ?itemDescription ?item
                  where {
             {
            select distinct $item
            where {
               values ?item_class {wd:Q33999 wd:Q191796 wd:Q281525 wd:Q465501 wd:Q622807 wd:Q658371 wd:Q674067 wd:Q850978 wd:Q851903 wd:Q895818 wd:Q948329 wd:Q1148872 wd:Q1314140 wd:Q1381612 wd:Q1416106 wd:Q1425448 wd:Q1707847 wd:Q1765879 wd:Q2405480 wd:Q2479076 wd:Q2782358 wd:Q2833480 wd:Q3178518 wd:Q3437937 wd:Q3446340 wd:Q3625363 wd:Q3775957 wd:Q4388180 wd:Q4677709 wd:Q4789398 wd:Q4881007 wd:Q4961740 wd:Q5160063 wd:Q6508764 wd:Q7244915 wd:Q10798782 wd:Q11481802 wd:Q14786283 wd:Q16078681 wd:Q16830339 wd:Q18086706 wd:Q18706995 wd:Q19708268 wd:Q20856740 wd:Q21280562 wd:Q22343421 wd:Q24641989 wd:Q25229942 wd:Q25970041 wd:Q28806161 wd:Q28806402 wd:Q28806737 wd:Q30184815 wd:Q42273048 wd:Q50236774}
               ?item wdt:P106 ?item_class; wdt:P21 wd:Q6581072; wdt:P31 wd:Q5.
               minus {
                  ?article schema:about ?item; schema:isPartOf <https://de.wikipedia.org/>.
               }
                    minus {?item wdt:P106 wd:Q488111.}
                    minus {?item wdt:P106 wd:Q852857.}
            }
         }            bind(xsd:integer(substr(str(?item), 33)) as ?num).
            ?item wikibase:sitelinks ?sitelinks
            service wikibase:label {bd:serviceParam wikibase:language 'de'.}
         }
         order by desc(?sitelinks) asc(?num)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?article") v4("?item"):::projected v3("?item_class") v6("?num") v1("?sitelinks"):::projected c8([https://de.wikipedia.org/]):::iri c15(["de"]):::literal c3(["wd:Q6581072"]):::iri c13(["bd:serviceParam"]):::iri c10(["wd:Q852857"]):::iri c9(["wd:Q488111"]):::iri c5(["wd:Q5"]):::iri bind0[/VALUES ?item_class/] bind0-->v3 bind00(["wd:Q33999"]) bind00 --> bind0 bind01(["wd:Q191796"]) bind01 --> bind0 bind02(["wd:Q281525"]) bind02 --> bind0 bind03(["wd:Q465501"]) bind03 --> bind0 bind04(["wd:Q622807"]) bind04 --> bind0 bind05(["wd:Q658371"]) bind05 --> bind0 bind06(["wd:Q674067"]) bind06 --> bind0 bind07(["wd:Q850978"]) bind07 --> bind0 bind08(["wd:Q851903"]) bind08 --> bind0 bind09(["wd:Q895818"]) bind09 --> bind0 bind010(["wd:Q948329"]) bind010 --> bind0 bind011(["wd:Q1148872"]) bind011 --> bind0 bind012(["wd:Q1314140"]) bind012 --> bind0 bind013(["wd:Q1381612"]) bind013 --> bind0 bind014(["wd:Q1416106"]) bind014 --> bind0 bind015(["wd:Q1425448"]) bind015 --> bind0 bind016(["wd:Q1707847"]) bind016 --> bind0 bind017(["wd:Q1765879"]) bind017 --> bind0 bind018(["wd:Q2405480"]) bind018 --> bind0 bind019(["wd:Q2479076"]) bind019 --> bind0 bind020(["wd:Q2782358"]) bind020 --> bind0 bind021(["wd:Q2833480"]) bind021 --> bind0 bind022(["wd:Q3178518"]) bind022 --> bind0 bind023(["wd:Q3437937"]) bind023 --> bind0 bind024(["wd:Q3446340"]) bind024 --> bind0 bind025(["wd:Q3625363"]) bind025 --> bind0 bind026(["wd:Q3775957"]) bind026 --> bind0 bind027(["wd:Q4388180"]) bind027 --> bind0 bind028(["wd:Q4677709"]) bind028 --> bind0 bind029(["wd:Q4789398"]) bind029 --> bind0 bind030(["wd:Q4881007"]) bind030 --> bind0 bind031(["wd:Q4961740"]) bind031 --> bind0 bind032(["wd:Q5160063"]) bind032 --> bind0 bind033(["wd:Q6508764"]) bind033 --> bind0 bind034(["wd:Q7244915"]) bind034 --> bind0 bind035(["wd:Q10798782"]) bind035 --> bind0 bind036(["wd:Q11481802"]) bind036 --> bind0 bind037(["wd:Q14786283"]) bind037 --> bind0 bind038(["wd:Q16078681"]) bind038 --> bind0 bind039(["wd:Q16830339"]) bind039 --> bind0 bind040(["wd:Q18086706"]) bind040 --> bind0 bind041(["wd:Q18706995"]) bind041 --> bind0 bind042(["wd:Q19708268"]) bind042 --> bind0 bind043(["wd:Q20856740"]) bind043 --> bind0 bind044(["wd:Q21280562"]) bind044 --> bind0 bind045(["wd:Q22343421"]) bind045 --> bind0 bind046(["wd:Q24641989"]) bind046 --> bind0 bind047(["wd:Q25229942"]) bind047 --> bind0 bind048(["wd:Q25970041"]) bind048 --> bind0 bind049(["wd:Q28806161"]) bind049 --> bind0 bind050(["wd:Q28806402"]) bind050 --> bind0 bind051(["wd:Q28806737"]) bind051 --> bind0 bind052(["wd:Q30184815"]) bind052 --> bind0 bind053(["wd:Q42273048"]) bind053 --> bind0 bind054(["wd:Q50236774"]) bind054 --> bind0 v4 --"wdt:P106"--> v3 v4 --"wdt:P21"--> c3 v4 --"wdt:P31"--> c5 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v5 --"schema:about"--> v4 v5 --"schema:isPartOf"--> c8 end subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; v4 --"wdt:P106"--> c9 end subgraph minus3["MINUS"] style minus3 stroke-width:6px,fill:pink,stroke:red; v4 --"wdt:P106"--> c10 end bind4[/"http://www.w3.org/2001/XMLSchema#integer(substring(str(?item),'33^^xsd:integer'))"/] v4 --o bind4 bind4 --as--o v6 v4 --"wikibase:sitelinks"--> v1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end