query-9de14cff527a5cbd0ab6ea9190ae5cb3

Query

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT
  (COUNT(?viaf) AS ?cnt)
  (GROUP_CONCAT(?raw_viaf; separator='<br />') AS ?viaf_ids)
  ?item
  ?itemDescription
WHERE {
   {
  SELECT
    DISTINCT ?item
  WHERE {
    ?item p:P106/ps:P106/wdt:P279* wd:Q26270618; p:P214 [] .
    FILTER(?item NOT IN ( wd:Q52679, wd:Q52680, wd:Q70521, wd:Q77792, wd:Q78343, wd:Q86299, wd:Q90339, wd:Q90367, wd:Q91303, wd:Q91305, wd:Q92441, wd:Q98971, wd:Q99345, wd:Q99411, wd:Q107700, wd:Q102457, wd:Q109259, wd:Q129679, wd:Q169044, wd:Q173328, wd:Q177039, wd:Q198021, wd:Q210852, wd:Q274232, wd:Q310694, wd:Q333887, wd:Q349970, wd:Q373892, wd:Q377053, wd:Q433309, wd:Q435707, wd:Q438702, wd:Q457058, wd:Q475791, wd:Q505165, wd:Q509774, wd:Q512148, wd:Q512638, wd:Q520395, wd:Q522909, wd:Q527992, wd:Q529946, wd:Q530559, wd:Q530803, wd:Q532644, wd:Q534063, wd:Q563810, wd:Q598182, wd:Q674112, wd:Q685669, wd:Q699844, wd:Q704436, wd:Q771696, wd:Q775598, wd:Q785494, wd:Q819948, wd:Q822490, wd:Q823476, wd:Q827878, wd:Q830003, wd:Q831193, wd:Q831655, wd:Q870752, wd:Q887087, wd:Q930268, wd:Q940463, wd:Q948287, wd:Q970076, wd:Q1026509, wd:Q1068577, wd:Q1078933, wd:Q1099445, wd:Q1104100, wd:Q1123980, wd:Q1222490, wd:Q1236699, wd:Q1304236, wd:Q1351518, wd:Q1369135, wd:Q1369693, wd:Q1388615, wd:Q1462959, wd:Q1506667, wd:Q1521436, wd:Q1532332, wd:Q1538010, wd:Q1545412, wd:Q1559066, wd:Q1580073, wd:Q1600812, wd:Q1603859, wd:Q1629733, wd:Q1680215, wd:Q1682360, wd:Q1682727, wd:Q1754999, wd:Q1804470, wd:Q1948441, wd:Q1962463, wd:Q1974390, wd:Q2007313, wd:Q2040195, wd:Q2077287, wd:Q2140399, wd:Q2143706, wd:Q2146223, wd:Q2176533, wd:Q2231989, wd:Q2338109, wd:Q2429244, wd:Q2447527, wd:Q2469697, wd:Q2479548, wd:Q2546191, wd:Q2546830, wd:Q2678718, wd:Q2741085, wd:Q2835412, wd:Q2836621, wd:Q2837163, wd:Q2849386, wd:Q2863319, wd:Q2959331, wd:Q3072258, wd:Q3079136, wd:Q3109829, wd:Q3129842, wd:Q3181856, wd:Q3353094, wd:Q3353097, wd:Q3419243, wd:Q3433775, wd:Q3441227, wd:Q3505507, wd:Q3505616, wd:Q3505706, wd:Q3508391, wd:Q3569517, wd:Q3655327, wd:Q3701746, wd:Q3750942, wd:Q3837055, wd:Q4101599, wd:Q4196418, wd:Q4314049, wd:Q4493831, wd:Q4684912, wd:Q4717717, wd:Q4727079, wd:Q4762703, wd:Q4773386, wd:Q4786402, wd:Q4898905, wd:Q4945362, wd:Q5056340, wd:Q5075547, wd:Q5077072, wd:Q5081739, wd:Q5134482, wd:Q5214413, wd:Q5234612, wd:Q5248512, wd:Q5290604, wd:Q5344452, wd:Q5346263, wd:Q5490368, wd:Q5492580, wd:Q5538488, wd:Q5546052, wd:Q5667943, wd:Q5719475, wd:Q5728455, wd:Q5769054, wd:Q6131978, wd:Q6182404, wd:Q6198070, wd:Q6226243, wd:Q6231235, wd:Q6235627, wd:Q6254892, wd:Q6287965, wd:Q6348919, wd:Q6383802, wd:Q6526356, wd:Q6699144, wd:Q6742179, wd:Q6765753, wd:Q6769287, wd:Q6775232, wd:Q6780285, wd:Q6820893, wd:Q6835229, wd:Q6836986, wd:Q6985998, wd:Q7036768, wd:Q7141742, wd:Q7146258, wd:Q7153995, wd:Q7273520, wd:Q7323790, wd:Q7341229, wd:Q7358397, wd:Q7375304, wd:Q7422665, wd:Q7702006, wd:Q7789938, wd:Q7790851, wd:Q7803375, wd:Q7803521, wd:Q7809280, wd:Q7818478, wd:Q7851269, wd:Q7878908, wd:Q7926895, wd:Q7965254, wd:Q8007298, wd:Q8020115, wd:Q9152652, wd:Q9191156, wd:Q9368612, wd:Q9388286, wd:Q11730933, wd:Q11973447, wd:Q12025112, wd:Q12025260, wd:Q12369736, wd:Q13424191, wd:Q13578750, wd:Q14291996, wd:Q14545273, wd:Q15043735, wd:Q15070053, wd:Q15070966, wd:Q15441916, wd:Q15460907, wd:Q15974165, wd:Q15978553, wd:Q15989862, wd:Q15996947, wd:Q16008101, wd:Q16031643, wd:Q16066519, wd:Q16107501, wd:Q16115555, wd:Q16196573, wd:Q16556667, wd:Q16944187, wd:Q17217406, wd:Q17421365, wd:Q18027097, wd:Q18608890, wd:Q18642000, wd:Q18752972, wd:Q19826246, wd:Q20712225, wd:Q21183725, wd:Q21605386, wd:Q23683405, wd:Q24192149, wd:Q24540136, wd:Q24545965, wd:Q24546031, wd:Q26267171, wd:Q28870200, wd:Q29429584, wd:Q30083528, wd:Q47452757, wd:Q47454902, wd:Q47455082, wd:Q55426206, wd:Q56085746, wd:Q61721789, wd:Q61740974, wd:Q81550282 )) . # whitelist, comma-separated Q-items with wd: prefix
    FILTER(?item NOT IN ( wd:Q7351155, wd:Q16105518, wd:Q1444024, wd:Q1901850, wd:Q827116, wd:Q8048499, wd:Q3503152, wd:Q119685, wd:Q4760368, wd:Q276131, wd:Q532334, wd:Q4953772, wd:Q1806150, wd:Q2146223, wd:Q5934588, wd:Q3118308, wd:Q9324017 )) . # blacklist, comma-separated Q-items with wd: prefix
  }
}
  ?item p:P214 [ ps:P214 ?viaf; wikibase:rank ?rank ] .
  BIND(CONCAT(SUBSTR(STR(?rank), 27), ': [https://viaf.org/viaf/', STR(?viaf), '/ ', STR(?viaf), ']') AS ?raw_viaf) .
  BIND(xsd:integer(SUBSTR(STR(?item), 33)) AS ?num_id).
  SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}
GROUP BY ?item ?itemDescription
ORDER BY ASC(?num_id)

Query found at

https://www.wikidata.org/wiki/User:MisterSynergy/rowing/P214_for_rowers

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?cnt") v2("?item"):::projected v6("?num_id") v4("?rank") v5("?raw_viaf"):::projected v3("?viaf"):::projected v7("?viaf_ids") a3((" ")) a1((" ")) a2((" ")) a4((" ")) c299(["bd:serviceParam"]):::iri c301(["en"]):::literal c294(["wd:Q26270618"]):::iri f0[["?item != 'wd:Q7351155'?item != 'wd:Q16105518'?item != 'wd:Q1444024'?item != 'wd:Q1901850'?item != 'wd:Q827116'?item != 'wd:Q8048499'?item != 'wd:Q3503152'?item != 'wd:Q119685'?item != 'wd:Q4760368'?item != 'wd:Q276131'?item != 'wd:Q532334'?item != 'wd:Q4953772'?item != 'wd:Q1806150'?item != 'wd:Q2146223'?item != 'wd:Q5934588'?item != 'wd:Q3118308'?item != 'wd:Q9324017'"]] f0 --> v2 f1[["?item != 'wd:Q52679'?item != 'wd:Q52680'?item != 'wd:Q70521'?item != 'wd:Q77792'?item != 'wd:Q78343'?item != 'wd:Q86299'?item != 'wd:Q90339'?item != 'wd:Q90367'?item != 'wd:Q91303'?item != 'wd:Q91305'?item != 'wd:Q92441'?item != 'wd:Q98971'?item != 'wd:Q99345'?item != 'wd:Q99411'?item != 'wd:Q107700'?item != 'wd:Q102457'?item != 'wd:Q109259'?item != 'wd:Q129679'?item != 'wd:Q169044'?item != 'wd:Q173328'?item != 'wd:Q177039'?item != 'wd:Q198021'?item != 'wd:Q210852'?item != 'wd:Q274232'?item != 'wd:Q310694'?item != 'wd:Q333887'?item != 'wd:Q349970'?item != 'wd:Q373892'?item != 'wd:Q377053'?item != 'wd:Q433309'?item != 'wd:Q435707'?item != 'wd:Q438702'?item != 'wd:Q457058'?item != 'wd:Q475791'?item != 'wd:Q505165'?item != 'wd:Q509774'?item != 'wd:Q512148'?item != 'wd:Q512638'?item != 'wd:Q520395'?item != 'wd:Q522909'?item != 'wd:Q527992'?item != 'wd:Q529946'?item != 'wd:Q530559'?item != 'wd:Q530803'?item != 'wd:Q532644'?item != 'wd:Q534063'?item != 'wd:Q563810'?item != 'wd:Q598182'?item != 'wd:Q674112'?item != 'wd:Q685669'?item != 'wd:Q699844'?item != 'wd:Q704436'?item != 'wd:Q771696'?item != 'wd:Q775598'?item != 'wd:Q785494'?item != 'wd:Q819948'?item != 'wd:Q822490'?item != 'wd:Q823476'?item != 'wd:Q827878'?item != 'wd:Q830003'?item != 'wd:Q831193'?item != 'wd:Q831655'?item != 'wd:Q870752'?item != 'wd:Q887087'?item != 'wd:Q930268'?item != 'wd:Q940463'?item != 'wd:Q948287'?item != 'wd:Q970076'?item != 'wd:Q1026509'?item != 'wd:Q1068577'?item != 'wd:Q1078933'?item != 'wd:Q1099445'?item != 'wd:Q1104100'?item != 'wd:Q1123980'?item != 'wd:Q1222490'?item != 'wd:Q1236699'?item != 'wd:Q1304236'?item != 'wd:Q1351518'?item != 'wd:Q1369135'?item != 'wd:Q1369693'?item != 'wd:Q1388615'?item != 'wd:Q1462959'?item != 'wd:Q1506667'?item != 'wd:Q1521436'?item != 'wd:Q1532332'?item != 'wd:Q1538010'?item != 'wd:Q1545412'?item != 'wd:Q1559066'?item != 'wd:Q1580073'?item != 'wd:Q1600812'?item != 'wd:Q1603859'?item != 'wd:Q1629733'?item != 'wd:Q1680215'?item != 'wd:Q1682360'?item != 'wd:Q1682727'?item != 'wd:Q1754999'?item != 'wd:Q1804470'?item != 'wd:Q1948441'?item != 'wd:Q1962463'?item != 'wd:Q1974390'?item != 'wd:Q2007313'?item != 'wd:Q2040195'?item != 'wd:Q2077287'?item != 'wd:Q2140399'?item != 'wd:Q2143706'?item != 'wd:Q2146223'?item != 'wd:Q2176533'?item != 'wd:Q2231989'?item != 'wd:Q2338109'?item != 'wd:Q2429244'?item != 'wd:Q2447527'?item != 'wd:Q2469697'?item != 'wd:Q2479548'?item != 'wd:Q2546191'?item != 'wd:Q2546830'?item != 'wd:Q2678718'?item != 'wd:Q2741085'?item != 'wd:Q2835412'?item != 'wd:Q2836621'?item != 'wd:Q2837163'?item != 'wd:Q2849386'?item != 'wd:Q2863319'?item != 'wd:Q2959331'?item != 'wd:Q3072258'?item != 'wd:Q3079136'?item != 'wd:Q3109829'?item != 'wd:Q3129842'?item != 'wd:Q3181856'?item != 'wd:Q3353094'?item != 'wd:Q3353097'?item != 'wd:Q3419243'?item != 'wd:Q3433775'?item != 'wd:Q3441227'?item != 'wd:Q3505507'?item != 'wd:Q3505616'?item != 'wd:Q3505706'?item != 'wd:Q3508391'?item != 'wd:Q3569517'?item != 'wd:Q3655327'?item != 'wd:Q3701746'?item != 'wd:Q3750942'?item != 'wd:Q3837055'?item != 'wd:Q4101599'?item != 'wd:Q4196418'?item != 'wd:Q4314049'?item != 'wd:Q4493831'?item != 'wd:Q4684912'?item != 'wd:Q4717717'?item != 'wd:Q4727079'?item != 'wd:Q4762703'?item != 'wd:Q4773386'?item != 'wd:Q4786402'?item != 'wd:Q4898905'?item != 'wd:Q4945362'?item != 'wd:Q5056340'?item != 'wd:Q5075547'?item != 'wd:Q5077072'?item != 'wd:Q5081739'?item != 'wd:Q5134482'?item != 'wd:Q5214413'?item != 'wd:Q5234612'?item != 'wd:Q5248512'?item != 'wd:Q5290604'?item != 'wd:Q5344452'?item != 'wd:Q5346263'?item != 'wd:Q5490368'?item != 'wd:Q5492580'?item != 'wd:Q5538488'?item != 'wd:Q5546052'?item != 'wd:Q5667943'?item != 'wd:Q5719475'?item != 'wd:Q5728455'?item != 'wd:Q5769054'?item != 'wd:Q6131978'?item != 'wd:Q6182404'?item != 'wd:Q6198070'?item != 'wd:Q6226243'?item != 'wd:Q6231235'?item != 'wd:Q6235627'?item != 'wd:Q6254892'?item != 'wd:Q6287965'?item != 'wd:Q6348919'?item != 'wd:Q6383802'?item != 'wd:Q6526356'?item != 'wd:Q6699144'?item != 'wd:Q6742179'?item != 'wd:Q6765753'?item != 'wd:Q6769287'?item != 'wd:Q6775232'?item != 'wd:Q6780285'?item != 'wd:Q6820893'?item != 'wd:Q6835229'?item != 'wd:Q6836986'?item != 'wd:Q6985998'?item != 'wd:Q7036768'?item != 'wd:Q7141742'?item != 'wd:Q7146258'?item != 'wd:Q7153995'?item != 'wd:Q7273520'?item != 'wd:Q7323790'?item != 'wd:Q7341229'?item != 'wd:Q7358397'?item != 'wd:Q7375304'?item != 'wd:Q7422665'?item != 'wd:Q7702006'?item != 'wd:Q7789938'?item != 'wd:Q7790851'?item != 'wd:Q7803375'?item != 'wd:Q7803521'?item != 'wd:Q7809280'?item != 'wd:Q7818478'?item != 'wd:Q7851269'?item != 'wd:Q7878908'?item != 'wd:Q7926895'?item != 'wd:Q7965254'?item != 'wd:Q8007298'?item != 'wd:Q8020115'?item != 'wd:Q9152652'?item != 'wd:Q9191156'?item != 'wd:Q9368612'?item != 'wd:Q9388286'?item != 'wd:Q11730933'?item != 'wd:Q11973447'?item != 'wd:Q12025112'?item != 'wd:Q12025260'?item != 'wd:Q12369736'?item != 'wd:Q13424191'?item != 'wd:Q13578750'?item != 'wd:Q14291996'?item != 'wd:Q14545273'?item != 'wd:Q15043735'?item != 'wd:Q15070053'?item != 'wd:Q15070966'?item != 'wd:Q15441916'?item != 'wd:Q15460907'?item != 'wd:Q15974165'?item != 'wd:Q15978553'?item != 'wd:Q15989862'?item != 'wd:Q15996947'?item != 'wd:Q16008101'?item != 'wd:Q16031643'?item != 'wd:Q16066519'?item != 'wd:Q16107501'?item != 'wd:Q16115555'?item != 'wd:Q16196573'?item != 'wd:Q16556667'?item != 'wd:Q16944187'?item != 'wd:Q17217406'?item != 'wd:Q17421365'?item != 'wd:Q18027097'?item != 'wd:Q18608890'?item != 'wd:Q18642000'?item != 'wd:Q18752972'?item != 'wd:Q19826246'?item != 'wd:Q20712225'?item != 'wd:Q21183725'?item != 'wd:Q21605386'?item != 'wd:Q23683405'?item != 'wd:Q24192149'?item != 'wd:Q24540136'?item != 'wd:Q24545965'?item != 'wd:Q24546031'?item != 'wd:Q26267171'?item != 'wd:Q28870200'?item != 'wd:Q29429584'?item != 'wd:Q30083528'?item != 'wd:Q47452757'?item != 'wd:Q47454902'?item != 'wd:Q47455082'?item != 'wd:Q55426206'?item != 'wd:Q56085746'?item != 'wd:Q61721789'?item != 'wd:Q61740974'?item != 'wd:Q81550282'"]] f1 --> v2 v2 --"p:P106"--> a1 a1 --"p:statement/P106"--> a2 a2 --"p:direct/P279"--> c294 v2 --"p:P214"--> a3 a4 --"p:statement/P214"--> v3 a4 --"wikibase:rank"--> v4 v2 --"p:P214"--> a4 bind2[/"concat(substring(str(?rank),'27^^xsd:integer'),': #91;https://viaf.org/viaf/',str(?viaf),'/ ',str(?viaf),'#93;')"/] v4 --o bind2 v3 --o bind2 bind2 --as--o v5 bind3[/"http://www.w3.org/2001/XMLSchema#integer(substring(str(?item),'33^^xsd:integer'))"/] v2 --o bind3 bind3 --as--o v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c299 --"wikibase:language"--> c301 end bind6[/"count(?viaf)"/] v3 --o bind6 bind6 --as--o v6 bind7[/"?raw_viaf"/] v5 --o bind7 bind7 --as--o v7