User:Lockal/Queries

Strange genderless people from Russia and around

SELECT ?item ?itemLabel WHERE {
  hint:Query hint:optimizer "None" .
  VALUES ?countries {wd:Q159 wd:Q15180 wd:Q34266 wd:Q212 wd:Q2184 wd:Q184}
  ?item wdt:P27 ?countries .
  OPTIONAL { ?item wdt:P21 ?gender } FILTER(!BOUND(?gender)).  
  
  ?item wdt:P31 wd:Q5 .
  ?item rdfs:label ?itemLabel . FILTER(lang(?itemLabel) = "en") .
  
  filter(!regex(?itemLabel, "^(?:Pafnuty|Daniil|Boris|Serge|Roman|Rudolf|Taras|Julij|Mykola|Rustam|Oleksiy|Oleksii|Oleksandr|Vassily|Josif|Yurii|Simon|Dimitrij|Arsenij|Vladyslav|Yurii|Aleksandrs|Abram|Sergiy|Alexander|Fedor|Semen|Evgeni|Jaroslav|Alexei|Aleksander|Stepan|Viktor|Vyacheslav|Viacheslav|Rinat|Maksim|Svjatoslav|Dimitri|Maxim|Rodion|Igor|Sergei|German|Vladimir|Voldemar|Voleslav|Svetozar|Yuliy|Dmitri|Iouri|Artem|Aleksander|Akinf|Adomas|Adalbi|Abdulakh|Nikolaj|Nicolai|Timofej|Vail|Valerij|Vasili|Vasilij|Vasily|Villi|Vitalie|Vitalij|Yuriy|Zurab|Danil|Andrijan|Andrian|Anatolie|Anatoli|Dmitriy|Dmitri|Dmitri|Damir|Marat|Mikhail|Moisei|Jurij|Dmitrij|Efim|Alexej|Maksim|Mark|Nikolay|Igor|Anatoly|Vadim|Mikhail|Nikita|Alexey|Dmitry|Matvey|Sergey|Vladimir|Egor|Ivan|Evgeny|Petr|Juriy|Grigory|Pavel|Stanislav|Valeriy|Yury|Oleg|Andrey|Valery|Nickolay|Ashot|Yuri|Anatolyi|Serguey|Vladislav|Viktor|Gennadiy|Evgenii|Anatoliy|Valeryi|Guennady|Gadzhy|Sergei|Akhmar|Ilja|Farid|Vjacheslav|Vitali|Sergej|Gennadij|Aleksander|Aleksandr|Aleksej|Artur|Gennadij|Gennady|Evgenij|Alexandre|Ilia|Nikolai|Leonid|Vitaly|Asker|Aleksey|Andrej|Anvar|Dmitri|Eduard|Anatolii|Arkady|Arslan|Gavriil|Georgi|Georgij|Nikolaĭ|Abdulmumin|Gleb|Eugene|Magomed|Erdem|Adis|Dmitri|Konstantin|Mukharbi|Ruslan|Timur|Vladimir|Vladlen|Dmitri|Vassyly|Zinovij|Anatolij|Kirill|Lev|Abdulzagir|Bilal|Grigorij|Karl|Kirill|Valentin|Aleksander|Aleksey|Constantine|Arkadij|Arkadiy|Aslan|Murat|Andronik|Feliks|Ildar|Dzmitryj|Evgeniy|Michail|Dzmìtryj|Ilya|Kanstantsin|Michail)[\\s\\u202F\\u00A0]"))
  
  filter(!regex(?itemLabel, "^(?:Alexsandra|Alija|Roza|Lidiya|Lesia|Elizaveta|Katerina|Larysa|Lada|Mariia|Vasilisa|Olena|Ljubow|Iolanta|Elena|Marie|Majja|Lyudmila|Marjana|Jana|Marina|Liubov|Sofya|Sveta|Fatima|Sardana|Ksenija|Vera|Alena|Sofija|Inga|Ekaterina|Evdokija|Darja|Jaroslava|Nonna|Victoria|Natalija|Nelli|Antonina|Alisa|Agrafena|Marija|Nina|Anzhelika|Tatjana|Rimma|Rozalija|Veronika|Janina|Raisa|Anna|Viktorija|Ira|Ekaterina|Viktorija|Zamira|Ljudmila|Ekaterina|Alina|Ada|Valeria|Uljana|Alevtina|Aleksandera|Lilija|Polina|Anastasija|Inna|Antonida|Margarita|Irina|Natalya|Natalja|Maria|Vera|Snezhana|Mariya|Ekaterina|Irena|Yulia|Zhanna|Zilija|Zinaida|Zoya|Zoja|Zukhra|Larisa|Ludmila|Maria|Tatjana|Alla|Julija|Inessa|Nurija|Evgenija|Anastasia|Fagilja|Varvara|Nadezda|Lidija|Ljubov|Tatyana|Ekaterina|Natalia|Galina|Irina|Oksana|Olga|Olesja|Aleksandra|Albina|Oxana|Liudmila|Tatiana|Svetlana|Nadezhda|Nelya|Alesja|Aksana|Sviatlana|Tamara|Taisija|Valentina|Tatʹjana|Natalʹja|Nataliya|Tat'jana|Olʹga)[\\s\\u202F\\u00A0]"))
}
limit 1000

Try it!

Strange genderless people with ru label

SELECT DISTINCT ?item ?fixedLabel WHERE {
  hint:Query hint:optimizer "None" .
  VALUES ?countries {wd:Q159 wd:Q15180 wd:Q34266 wd:Q212 wd:Q2184 wd:Q184}
  ?item wdt:P27 ?countries .
  
  OPTIONAL { ?item wdt:P21 ?gender } FILTER(!BOUND(?gender)).  
  
  ?item wdt:P31 wd:Q5 .
  ?item rdfs:label ?itemLabel . FILTER(lang(?itemLabel) = "ru") .
    
  BIND(REPLACE(?itemLabel, "^(?:([А-Яа-яЁё]+),(\\s))?(.+)$", "$3$2$1") AS ?fixedLabel)
  
  filter(!regex(?fixedLabel, "^(?:Олег|Леонард|Геннадий|Адиль|Турдымурат|Пауль|Павел|Марат|Макс|Леонид|Пётр|Дмитрий|Вячеслав|Борис|Хосейн|Жалауди|Хасан|Вадим|Ефим|Степан|Лев|Николай|Максим|Георгий|Владимир|Илья|Игорь|Андрей|Александр|Алексей|Валерий|Юрий|Габдулхак|Петр|Антон|Константин|Эмиль|Сергей|Станислав|Виктор|Армен|Анвир|Иван|Альберт|Евгений|Михаил|Анатолий|Артём|Василий|Виталий|Владислав|Кирилл|Никита|Эдуард|Фёдор|Валентин|Герман|Глеб|Роман|Руслан|Святослав)\\s"))
  
  filter(!regex(?fixedLabel, "^(?:Сагдия|Рада|Наталья|Екатерина|Алина|Александра|Фотима|Янина|Надежда|Степанида|Пелагея|Раиса|Лариса|Галина|Анна-Эльвира|Зинаида|Флюза|Тамара|Алёна|Генриетта|Елена|Юлия|Нина|Дарья|Людмила|Ольга|Инесса|Таисия|Татьяна|Виолетта|Флюра|Венера|Антонина|Вера|Анна|Елизавета|Мария|Ирина|Евгения|Наталия|Фаина|Устинья|Валентина|Сабина|Эмилия|Светлана|Виктория)\\s"))
}

Try it!

Items without P31 or P279

select ?item ?itemLabel {
  ?article schema:about ?item ; schema:inLanguage "ru" .
  filter (substr(str(?article), 1, 16) = "https://ru.wikip")
  minus { ?item wdt:P31 [] . }
  minus { ?item wdt:P279 [] . }
  minus { ?item wdt:P361 [] . }
  optional {
    ?item rdfs:label ?itemLabel .
    filter (lang(?itemLabel) = "ru")
  }
} limit 200

Try it!

Most commonly used external ids for genderless japanese people

select ?propertyLabel (count(?propertyLabel) as ?cnt)
  with {
    select ?item { ?item wdt:P31 wd:Q5 ; wdt:P27 wd:Q17 optional {?item wdt:P21 ?gender} filter (!bound(?gender)) }
  } as %items
{
  ?property wikibase:claim ?propertyclaim .
  ?item ?propertyclaim [] .
  ?property wikibase:propertyType wikibase:ExternalId .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }

  INCLUDE %items
}
group by ?propertyLabel
order by desc(?cnt)
limit 20

Try it!

P31 usage

#defaultView:LineChart
SELECT ?day ?count WITH { SELECT (".+\\|31=(\\d+).+" as ?r) ("|31=" as ?p)
  (IF(CONTAINS(?r1, ?p), xsd:integer(REPLACE(?r1, ?r, "$1")), -1) AS ?c1) (xsd:dateTime(?t1) AS ?d1)
  (IF(CONTAINS(?r2, ?p), xsd:integer(REPLACE(?r2, ?r, "$1")), -1) AS ?c2) (xsd:dateTime(?t2) AS ?d2)
  (IF(CONTAINS(?r3, ?p), xsd:integer(REPLACE(?r3, ?r, "$1")), -1) AS ?c3) (xsd:dateTime(?t3) AS ?d3)
  (IF(CONTAINS(?r4, ?p), xsd:integer(REPLACE(?r4, ?r, "$1")), -1) AS ?c4) (xsd:dateTime(?t4) AS ?d4)
  (IF(CONTAINS(?r5, ?p), xsd:integer(REPLACE(?r5, ?r, "$1")), -1) AS ?c5) (xsd:dateTime(?t5) AS ?d5)
  (IF(CONTAINS(?r6, ?p), xsd:integer(REPLACE(?r6, ?r, "$1")), -1) AS ?c6) (xsd:dateTime(?t6) AS ?d6)
  (IF(CONTAINS(?r7, ?p), xsd:integer(REPLACE(?r7, ?r, "$1")), -1) AS ?c7) (xsd:dateTime(?t7) AS ?d7)
  (IF(CONTAINS(?r8, ?p), xsd:integer(REPLACE(?r8, ?r, "$1")), -1) AS ?c8) (xsd:dateTime(?t8) AS ?d8)
  (IF(CONTAINS(?r9, ?p), xsd:integer(REPLACE(?r9, ?r, "$1")), -1) AS ?c9) (xsd:dateTime(?t9) AS ?d9)
  (IF(CONTAINS(?r10, ?p), xsd:integer(REPLACE(?r10, ?r, "$1")), -1) AS ?c10) (xsd:dateTime(?t10) AS ?d10)
  (IF(CONTAINS(?r11, ?p), xsd:integer(REPLACE(?r11, ?r, "$1")), -1) AS ?c11) (xsd:dateTime(?t11) AS ?d11)
  (IF(CONTAINS(?r12, ?p), xsd:integer(REPLACE(?r12, ?r, "$1")), -1) AS ?c12) (xsd:dateTime(?t12) AS ?d12)
  (IF(CONTAINS(?r13, ?p), xsd:integer(REPLACE(?r13, ?r, "$1")), -1) AS ?c13) (xsd:dateTime(?t13) AS ?d13)
  (IF(CONTAINS(?r14, ?p), xsd:integer(REPLACE(?r14, ?r, "$1")), -1) AS ?c14) (xsd:dateTime(?t14) AS ?d14)
  (IF(CONTAINS(?r15, ?p), xsd:integer(REPLACE(?r15, ?r, "$1")), -1) AS ?c15) (xsd:dateTime(?t15) AS ?d15)
  (IF(CONTAINS(?r16, ?p), xsd:integer(REPLACE(?r16, ?r, "$1")), -1) AS ?c16) (xsd:dateTime(?t16) AS ?d16)
  (IF(CONTAINS(?r17, ?p), xsd:integer(REPLACE(?r17, ?r, "$1")), -1) AS ?c17) (xsd:dateTime(?t17) AS ?d17)
  (IF(CONTAINS(?r18, ?p), xsd:integer(REPLACE(?r18, ?r, "$1")), -1) AS ?c18) (xsd:dateTime(?t18) AS ?d18)
  (IF(CONTAINS(?r19, ?p), xsd:integer(REPLACE(?r19, ?r, "$1")), -1) AS ?c19) (xsd:dateTime(?t19) AS ?d19)
  (IF(CONTAINS(?r20, ?p), xsd:integer(REPLACE(?r20, ?r, "$1")), -1) AS ?c20) (xsd:dateTime(?t20) AS ?d20)
  (IF(CONTAINS(?r21, ?p), xsd:integer(REPLACE(?r21, ?r, "$1")), -1) AS ?c21) (xsd:dateTime(?t21) AS ?d21)
  (IF(CONTAINS(?r22, ?p), xsd:integer(REPLACE(?r22, ?r, "$1")), -1) AS ?c22) (xsd:dateTime(?t22) AS ?d22)
  (IF(CONTAINS(?r23, ?p), xsd:integer(REPLACE(?r23, ?r, "$1")), -1) AS ?c23) (xsd:dateTime(?t23) AS ?d23)
  (IF(CONTAINS(?r24, ?p), xsd:integer(REPLACE(?r24, ?r, "$1")), -1) AS ?c24) (xsd:dateTime(?t24) AS ?d24)
  (IF(CONTAINS(?r25, ?p), xsd:integer(REPLACE(?r25, ?r, "$1")), -1) AS ?c25) (xsd:dateTime(?t25) AS ?d25)
  (IF(CONTAINS(?r26, ?p), xsd:integer(REPLACE(?r26, ?r, "$1")), -1) AS ?c26) (xsd:dateTime(?t26) AS ?d26)
  (IF(CONTAINS(?r27, ?p), xsd:integer(REPLACE(?r27, ?r, "$1")), -1) AS ?c27) (xsd:dateTime(?t27) AS ?d27)
  (IF(CONTAINS(?r28, ?p), xsd:integer(REPLACE(?r28, ?r, "$1")), -1) AS ?c28) (xsd:dateTime(?t28) AS ?d28)
  (IF(CONTAINS(?r29, ?p), xsd:integer(REPLACE(?r29, ?r, "$1")), -1) AS ?c29) (xsd:dateTime(?t29) AS ?d29)
  (IF(CONTAINS(?r30, ?p), xsd:integer(REPLACE(?r30, ?r, "$1")), -1) AS ?c30) (xsd:dateTime(?t30) AS ?d30)
  (IF(CONTAINS(?r31, ?p), xsd:integer(REPLACE(?r31, ?r, "$1")), -1) AS ?c31) (xsd:dateTime(?t31) AS ?d31)
  (IF(CONTAINS(?r32, ?p), xsd:integer(REPLACE(?r32, ?r, "$1")), -1) AS ?c32) (xsd:dateTime(?t32) AS ?d32)
  (IF(CONTAINS(?r33, ?p), xsd:integer(REPLACE(?r33, ?r, "$1")), -1) AS ?c33) (xsd:dateTime(?t33) AS ?d33)
  (IF(CONTAINS(?r34, ?p), xsd:integer(REPLACE(?r34, ?r, "$1")), -1) AS ?c34) (xsd:dateTime(?t34) AS ?d34)
  (IF(CONTAINS(?r35, ?p), xsd:integer(REPLACE(?r35, ?r, "$1")), -1) AS ?c35) (xsd:dateTime(?t35) AS ?d35)
  (IF(CONTAINS(?r36, ?p), xsd:integer(REPLACE(?r36, ?r, "$1")), -1) AS ?c36) (xsd:dateTime(?t36) AS ?d36)
  (IF(CONTAINS(?r37, ?p), xsd:integer(REPLACE(?r37, ?r, "$1")), -1) AS ?c37) (xsd:dateTime(?t37) AS ?d37)
  (IF(CONTAINS(?r38, ?p), xsd:integer(REPLACE(?r38, ?r, "$1")), -1) AS ?c38) (xsd:dateTime(?t38) AS ?d38)
  (IF(CONTAINS(?r39, ?p), xsd:integer(REPLACE(?r39, ?r, "$1")), -1) AS ?c39) (xsd:dateTime(?t39) AS ?d39)
  (IF(CONTAINS(?r40, ?p), xsd:integer(REPLACE(?r40, ?r, "$1")), -1) AS ?c40) (xsd:dateTime(?t40) AS ?d40)
  (IF(CONTAINS(?r41, ?p), xsd:integer(REPLACE(?r41, ?r, "$1")), -1) AS ?c41) (xsd:dateTime(?t41) AS ?d41)
  (IF(CONTAINS(?r42, ?p), xsd:integer(REPLACE(?r42, ?r, "$1")), -1) AS ?c42) (xsd:dateTime(?t42) AS ?d42)
  (IF(CONTAINS(?r43, ?p), xsd:integer(REPLACE(?r43, ?r, "$1")), -1) AS ?c43) (xsd:dateTime(?t43) AS ?d43)
  (IF(CONTAINS(?r44, ?p), xsd:integer(REPLACE(?r44, ?r, "$1")), -1) AS ?c44) (xsd:dateTime(?t44) AS ?d44)
  (IF(CONTAINS(?r45, ?p), xsd:integer(REPLACE(?r45, ?r, "$1")), -1) AS ?c45) (xsd:dateTime(?t45) AS ?d45)
  (IF(CONTAINS(?r46, ?p), xsd:integer(REPLACE(?r46, ?r, "$1")), -1) AS ?c46) (xsd:dateTime(?t46) AS ?d46)
  (IF(CONTAINS(?r47, ?p), xsd:integer(REPLACE(?r47, ?r, "$1")), -1) AS ?c47) (xsd:dateTime(?t47) AS ?d47)
  (IF(CONTAINS(?r48, ?p), xsd:integer(REPLACE(?r48, ?r, "$1")), -1) AS ?c48) (xsd:dateTime(?t48) AS ?d48)
  (IF(CONTAINS(?r49, ?p), xsd:integer(REPLACE(?r49, ?r, "$1")), -1) AS ?c49) (xsd:dateTime(?t49) AS ?d49)
  (IF(CONTAINS(?r50, ?p), xsd:integer(REPLACE(?r50, ?r, "$1")), -1) AS ?c50) (xsd:dateTime(?t50) AS ?d50)
  { SERVICE wikibase:mwapi {
      bd:serviceParam wikibase:api "Generator" ; wikibase:endpoint "www.wikidata.org" ; mwapi:generator "allpages" ;
                      mwapi:gapfrom "Property_uses" ; mwapi:gaplimit "1" ; mwapi:gapnamespace "10" ; mwapi:prop "revisions" ;
                      mwapi:rvprop "content|timestamp" ; mwapi:rvlimit "50" ; mwapi:rvuser "PLbot" .
      ?t1 wikibase:apiOutput "revisions/rev[1]/@timestamp" . ?r1 wikibase:apiOutput "revisions/rev[1]/text()" .
      ?t2 wikibase:apiOutput "revisions/rev[2]/@timestamp" . ?r2 wikibase:apiOutput "revisions/rev[2]/text()" .
      ?t3 wikibase:apiOutput "revisions/rev[3]/@timestamp" . ?r3 wikibase:apiOutput "revisions/rev[3]/text()" .
      ?t4 wikibase:apiOutput "revisions/rev[4]/@timestamp" . ?r4 wikibase:apiOutput "revisions/rev[4]/text()" .
      ?t5 wikibase:apiOutput "revisions/rev[5]/@timestamp" . ?r5 wikibase:apiOutput "revisions/rev[5]/text()" .
      ?t6 wikibase:apiOutput "revisions/rev[6]/@timestamp" . ?r6 wikibase:apiOutput "revisions/rev[6]/text()" .
      ?t7 wikibase:apiOutput "revisions/rev[7]/@timestamp" . ?r7 wikibase:apiOutput "revisions/rev[7]/text()" .
      ?t8 wikibase:apiOutput "revisions/rev[8]/@timestamp" . ?r8 wikibase:apiOutput "revisions/rev[8]/text()" .
      ?t9 wikibase:apiOutput "revisions/rev[9]/@timestamp" . ?r9 wikibase:apiOutput "revisions/rev[9]/text()" .
      ?t10 wikibase:apiOutput "revisions/rev[10]/@timestamp" . ?r10 wikibase:apiOutput "revisions/rev[10]/text()" .
      ?t11 wikibase:apiOutput "revisions/rev[11]/@timestamp" . ?r11 wikibase:apiOutput "revisions/rev[11]/text()" .
      ?t12 wikibase:apiOutput "revisions/rev[12]/@timestamp" . ?r12 wikibase:apiOutput "revisions/rev[12]/text()" .
      ?t13 wikibase:apiOutput "revisions/rev[13]/@timestamp" . ?r13 wikibase:apiOutput "revisions/rev[13]/text()" .
      ?t14 wikibase:apiOutput "revisions/rev[14]/@timestamp" . ?r14 wikibase:apiOutput "revisions/rev[14]/text()" .
      ?t15 wikibase:apiOutput "revisions/rev[15]/@timestamp" . ?r15 wikibase:apiOutput "revisions/rev[15]/text()" .
      ?t16 wikibase:apiOutput "revisions/rev[16]/@timestamp" . ?r16 wikibase:apiOutput "revisions/rev[16]/text()" .
      ?t17 wikibase:apiOutput "revisions/rev[17]/@timestamp" . ?r17 wikibase:apiOutput "revisions/rev[17]/text()" .
      ?t18 wikibase:apiOutput "revisions/rev[18]/@timestamp" . ?r18 wikibase:apiOutput "revisions/rev[18]/text()" .
      ?t19 wikibase:apiOutput "revisions/rev[19]/@timestamp" . ?r19 wikibase:apiOutput "revisions/rev[19]/text()" .
      ?t20 wikibase:apiOutput "revisions/rev[20]/@timestamp" . ?r20 wikibase:apiOutput "revisions/rev[20]/text()" .
      ?t21 wikibase:apiOutput "revisions/rev[21]/@timestamp" . ?r21 wikibase:apiOutput "revisions/rev[21]/text()" .
      ?t22 wikibase:apiOutput "revisions/rev[22]/@timestamp" . ?r22 wikibase:apiOutput "revisions/rev[22]/text()" .
      ?t23 wikibase:apiOutput "revisions/rev[23]/@timestamp" . ?r23 wikibase:apiOutput "revisions/rev[23]/text()" .
      ?t24 wikibase:apiOutput "revisions/rev[24]/@timestamp" . ?r24 wikibase:apiOutput "revisions/rev[24]/text()" .
      ?t25 wikibase:apiOutput "revisions/rev[25]/@timestamp" . ?r25 wikibase:apiOutput "revisions/rev[25]/text()" .
      ?t26 wikibase:apiOutput "revisions/rev[26]/@timestamp" . ?r26 wikibase:apiOutput "revisions/rev[26]/text()" .
      ?t27 wikibase:apiOutput "revisions/rev[27]/@timestamp" . ?r27 wikibase:apiOutput "revisions/rev[27]/text()" .
      ?t28 wikibase:apiOutput "revisions/rev[28]/@timestamp" . ?r28 wikibase:apiOutput "revisions/rev[28]/text()" .
      ?t29 wikibase:apiOutput "revisions/rev[29]/@timestamp" . ?r29 wikibase:apiOutput "revisions/rev[29]/text()" .
      ?t30 wikibase:apiOutput "revisions/rev[30]/@timestamp" . ?r30 wikibase:apiOutput "revisions/rev[30]/text()" .
      ?t31 wikibase:apiOutput "revisions/rev[31]/@timestamp" . ?r31 wikibase:apiOutput "revisions/rev[31]/text()" .
      ?t32 wikibase:apiOutput "revisions/rev[32]/@timestamp" . ?r32 wikibase:apiOutput "revisions/rev[32]/text()" .
      ?t33 wikibase:apiOutput "revisions/rev[33]/@timestamp" . ?r33 wikibase:apiOutput "revisions/rev[33]/text()" .
      ?t34 wikibase:apiOutput "revisions/rev[34]/@timestamp" . ?r34 wikibase:apiOutput "revisions/rev[34]/text()" .
      ?t35 wikibase:apiOutput "revisions/rev[35]/@timestamp" . ?r35 wikibase:apiOutput "revisions/rev[35]/text()" .
      ?t36 wikibase:apiOutput "revisions/rev[36]/@timestamp" . ?r36 wikibase:apiOutput "revisions/rev[36]/text()" .
      ?t37 wikibase:apiOutput "revisions/rev[37]/@timestamp" . ?r37 wikibase:apiOutput "revisions/rev[37]/text()" .
      ?t38 wikibase:apiOutput "revisions/rev[38]/@timestamp" . ?r38 wikibase:apiOutput "revisions/rev[38]/text()" .
      ?t39 wikibase:apiOutput "revisions/rev[39]/@timestamp" . ?r39 wikibase:apiOutput "revisions/rev[39]/text()" .
      ?t40 wikibase:apiOutput "revisions/rev[40]/@timestamp" . ?r40 wikibase:apiOutput "revisions/rev[40]/text()" .
      ?t41 wikibase:apiOutput "revisions/rev[41]/@timestamp" . ?r41 wikibase:apiOutput "revisions/rev[41]/text()" .
      ?t42 wikibase:apiOutput "revisions/rev[42]/@timestamp" . ?r42 wikibase:apiOutput "revisions/rev[42]/text()" .
      ?t43 wikibase:apiOutput "revisions/rev[43]/@timestamp" . ?r43 wikibase:apiOutput "revisions/rev[43]/text()" .
      ?t44 wikibase:apiOutput "revisions/rev[44]/@timestamp" . ?r44 wikibase:apiOutput "revisions/rev[44]/text()" .
      ?t45 wikibase:apiOutput "revisions/rev[45]/@timestamp" . ?r45 wikibase:apiOutput "revisions/rev[45]/text()" .
      ?t46 wikibase:apiOutput "revisions/rev[46]/@timestamp" . ?r46 wikibase:apiOutput "revisions/rev[46]/text()" .
      ?t47 wikibase:apiOutput "revisions/rev[47]/@timestamp" . ?r47 wikibase:apiOutput "revisions/rev[47]/text()" .
      ?t48 wikibase:apiOutput "revisions/rev[48]/@timestamp" . ?r48 wikibase:apiOutput "revisions/rev[48]/text()" .
      ?t49 wikibase:apiOutput "revisions/rev[49]/@timestamp" . ?r49 wikibase:apiOutput "revisions/rev[49]/text()" .
      ?t50 wikibase:apiOutput "revisions/rev[50]/@timestamp" . ?r50 wikibase:apiOutput "revisions/rev[50]/text()" .
    }
  }
} as %revs {
  {BIND(?c1 AS ?count) BIND(?d1 AS ?day) INCLUDE %revs} UNION
  {BIND(?c2 AS ?count) BIND(?d2 AS ?day) INCLUDE %revs} UNION
  {BIND(?c3 AS ?count) BIND(?d3 AS ?day) INCLUDE %revs} UNION
  {BIND(?c4 AS ?count) BIND(?d4 AS ?day) INCLUDE %revs} UNION
  {BIND(?c5 AS ?count) BIND(?d5 AS ?day) INCLUDE %revs} UNION
  {BIND(?c6 AS ?count) BIND(?d6 AS ?day) INCLUDE %revs} UNION
  {BIND(?c7 AS ?count) BIND(?d7 AS ?day) INCLUDE %revs} UNION
  {BIND(?c8 AS ?count) BIND(?d8 AS ?day) INCLUDE %revs} UNION
  {BIND(?c9 AS ?count) BIND(?d9 AS ?day) INCLUDE %revs} UNION
  {BIND(?c10 AS ?count) BIND(?d10 AS ?day) INCLUDE %revs} UNION
  {BIND(?c11 AS ?count) BIND(?d11 AS ?day) INCLUDE %revs} UNION
  {BIND(?c12 AS ?count) BIND(?d12 AS ?day) INCLUDE %revs} UNION
  {BIND(?c13 AS ?count) BIND(?d13 AS ?day) INCLUDE %revs} UNION
  {BIND(?c14 AS ?count) BIND(?d14 AS ?day) INCLUDE %revs} UNION
  {BIND(?c15 AS ?count) BIND(?d15 AS ?day) INCLUDE %revs} UNION
  {BIND(?c16 AS ?count) BIND(?d16 AS ?day) INCLUDE %revs} UNION
  {BIND(?c17 AS ?count) BIND(?d17 AS ?day) INCLUDE %revs} UNION
  {BIND(?c18 AS ?count) BIND(?d18 AS ?day) INCLUDE %revs} UNION
  {BIND(?c19 AS ?count) BIND(?d19 AS ?day) INCLUDE %revs} UNION
  {BIND(?c20 AS ?count) BIND(?d20 AS ?day) INCLUDE %revs} UNION
  {BIND(?c21 AS ?count) BIND(?d21 AS ?day) INCLUDE %revs} UNION
  {BIND(?c22 AS ?count) BIND(?d22 AS ?day) INCLUDE %revs} UNION
  {BIND(?c23 AS ?count) BIND(?d23 AS ?day) INCLUDE %revs} UNION
  {BIND(?c24 AS ?count) BIND(?d24 AS ?day) INCLUDE %revs} UNION
  {BIND(?c25 AS ?count) BIND(?d25 AS ?day) INCLUDE %revs} UNION
  {BIND(?c26 AS ?count) BIND(?d26 AS ?day) INCLUDE %revs} UNION
  {BIND(?c27 AS ?count) BIND(?d27 AS ?day) INCLUDE %revs} UNION
  {BIND(?c28 AS ?count) BIND(?d28 AS ?day) INCLUDE %revs} UNION
  {BIND(?c29 AS ?count) BIND(?d29 AS ?day) INCLUDE %revs} UNION
  {BIND(?c30 AS ?count) BIND(?d30 AS ?day) INCLUDE %revs} UNION
  {BIND(?c31 AS ?count) BIND(?d31 AS ?day) INCLUDE %revs} UNION
  {BIND(?c32 AS ?count) BIND(?d32 AS ?day) INCLUDE %revs} UNION
  {BIND(?c33 AS ?count) BIND(?d33 AS ?day) INCLUDE %revs} UNION
  {BIND(?c34 AS ?count) BIND(?d34 AS ?day) INCLUDE %revs} UNION
  {BIND(?c35 AS ?count) BIND(?d35 AS ?day) INCLUDE %revs} UNION
  {BIND(?c36 AS ?count) BIND(?d36 AS ?day) INCLUDE %revs} UNION
  {BIND(?c37 AS ?count) BIND(?d37 AS ?day) INCLUDE %revs} UNION
  {BIND(?c38 AS ?count) BIND(?d38 AS ?day) INCLUDE %revs} UNION
  {BIND(?c39 AS ?count) BIND(?d39 AS ?day) INCLUDE %revs} UNION
  {BIND(?c40 AS ?count) BIND(?d40 AS ?day) INCLUDE %revs} UNION
  {BIND(?c41 AS ?count) BIND(?d41 AS ?day) INCLUDE %revs} UNION
  {BIND(?c42 AS ?count) BIND(?d42 AS ?day) INCLUDE %revs} UNION
  {BIND(?c43 AS ?count) BIND(?d43 AS ?day) INCLUDE %revs} UNION
  {BIND(?c44 AS ?count) BIND(?d44 AS ?day) INCLUDE %revs} UNION
  {BIND(?c45 AS ?count) BIND(?d45 AS ?day) INCLUDE %revs} UNION
  {BIND(?c46 AS ?count) BIND(?d46 AS ?day) INCLUDE %revs} UNION
  {BIND(?c47 AS ?count) BIND(?d47 AS ?day) INCLUDE %revs} UNION
  {BIND(?c48 AS ?count) BIND(?d48 AS ?day) INCLUDE %revs} UNION
  {BIND(?c49 AS ?count) BIND(?d49 AS ?day) INCLUDE %revs} UNION
  {BIND(?c50 AS ?count) BIND(?d50 AS ?day) INCLUDE %revs}
  FILTER(?count != -1)
}

Try it!

Strange items from DACS

SELECT ?item ?enLabel ?nlLabel ?frLabel ?caLabel WHERE {
  hint:Query hint:optimizer "None" .
  ?item wdt:P4663 [] .
  ?item wikibase:sitelinks 0 .
  
  OPTIONAL { ?item rdfs:label ?enLabel . FILTER(lang(?enLabel) = "en") }
  OPTIONAL { ?item rdfs:label ?nlLabel . FILTER(lang(?nlLabel) = "nl") }
  OPTIONAL { ?item rdfs:label ?frLabel . FILTER(lang(?frLabel) = "fr") }
  OPTIONAL { ?item rdfs:label ?caLabel . FILTER(lang(?caLabel) = "ca") }
  
  FILTER(REGEX(COALESCE(?enLabel, ""), "^[A-Z][a-z]*[A-Z]") ||
         REGEX(COALESCE(?nlLabel, ""), "^[A-Z][a-z]*[A-Z]") ||
         REGEX(COALESCE(?frLabel, ""), "^[A-Z][a-z]*[A-Z]") ||
         REGEX(COALESCE(?caLabel, ""), "^[A-Z][a-z]*[A-Z]"))
}

Try it!

DACS items with non-breaking spaces

SELECT ?item ?itemLabel WHERE {
  hint:Query hint:optimizer "None" .
  ?item wdt:P4663 [] .
  ?item rdfs:label ?itemLabel . FILTER(lang(?itemLabel) = "en") .
  filter(regex(?itemLabel, "[\\u202F\\u00A0]"))
}

Try it!

SELECT ?item ?itemLabel WHERE {
  hint:Query hint:optimizer "None" .
  ?item wdt:P4663 [] .
  ?item rdfs:label ?itemLabel . FILTER(lang(?itemLabel) = "nl") .
  filter(regex(?itemLabel, "[\\u202F\\u00A0]"))
}

Try it!

Venn of properties by usage scope

SELECT ?type ?cnt WHERE {
  {
    BIND("main" AS ?type)
    {
      SELECT (COUNT(DISTINCT ?prop) as ?cnt) WHERE {
        ?prop wdt:P2302 wd:Q53869507 .
        ?prop p:P2302 [ps:P2302 wd:Q53869507 ; pq:P5314 wd:Q54828448] .
      }
    }
  } UNION {
    BIND("qual" AS ?type)
    {
      SELECT (COUNT(DISTINCT ?prop) as ?cnt) WHERE {
        ?prop wdt:P2302 wd:Q53869507 .
        ?prop p:P2302 [ps:P2302 wd:Q53869507 ; pq:P5314 wd:Q54828449] .
      }
    }
  } UNION {
    BIND("ref" AS ?type)
    {
      SELECT (COUNT(DISTINCT ?prop) as ?cnt) WHERE {
        ?prop wdt:P2302 wd:Q53869507 .
        ?prop p:P2302 [ps:P2302 wd:Q53869507 ; pq:P5314 wd:Q54828450] .
      }
    }
  } UNION {
    BIND("main qual" AS ?type)
    {
      SELECT (COUNT(DISTINCT ?prop) as ?cnt) WHERE {
        ?prop wdt:P2302 wd:Q53869507 .
        ?prop p:P2302 [ps:P2302 wd:Q53869507 ; pq:P5314 wd:Q54828448 ; pq:P5314 wd:Q54828449] .
      }
    }
  } UNION {
    BIND("main ref" AS ?type)
    {
      SELECT (COUNT(DISTINCT ?prop) as ?cnt) WHERE {
        ?prop wdt:P2302 wd:Q53869507 .
        ?prop p:P2302 [ps:P2302 wd:Q53869507 ; pq:P5314 wd:Q54828448 ; pq:P5314 wd:Q54828450] .
      }
    }
  } UNION {
    BIND("qual ref" AS ?type)
    {
      SELECT (COUNT(DISTINCT ?prop) as ?cnt) WHERE {
        ?prop wdt:P2302 wd:Q53869507 .
        ?prop p:P2302 [ps:P2302 wd:Q53869507 ; pq:P5314 wd:Q54828449 ; pq:P5314 wd:Q54828450] .
      }
    }
  } UNION {
    BIND("main qual ref" AS ?type)
    {
      SELECT (COUNT(DISTINCT ?prop) as ?cnt) WHERE {
        ?prop wdt:P2302 wd:Q53869507 .
        ?prop p:P2302 [ps:P2302 wd:Q53869507 ; pq:P5314 wd:Q54828448 ; pq:P5314 wd:Q54828449 ; pq:P5314 wd:Q54828450] .
      }
    }
  } UNION {
    BIND("none" AS ?type)
    {
      SELECT (COUNT(DISTINCT ?prop) as ?cnt) WHERE {
        ?prop wdt:P2302 wd:Q53869507 .
        FILTER NOT EXISTS {VALUES ?types {wd:Q54828448 wd:Q54828449 wd:Q54828450} ?prop p:P2302 [ps:P2302 wd:Q53869507 ; pq:P5314 ?types] } .
      }
    }
  } UNION {
    BIND("garbage" AS ?type)
    {
      SELECT (COUNT(DISTINCT ?prop) as ?cnt) WHERE {
        ?prop wdt:P2302 wd:Q53869507 .
        FILTER EXISTS {?prop p:P2302 [ps:P2302 wd:Q53869507 ; pq:P5314 ?x] FILTER(?x != wd:Q54828448 && ?x != wd:Q54828449 && ?x != wd:Q54828450) } .
      }
    }
  } UNION {
    BIND("not set" AS ?type)
    {
      SELECT (COUNT(DISTINCT ?prop) as ?cnt) WHERE {
        ?prop a wikibase:Property .
        FILTER NOT EXISTS {?prop wdt:P2302 wd:Q53869507} .
      }
    }
  }
}

Try it!

Kana with spaces from jpsearch

PREFIX type: <https://jpsearch.go.jp/term/type/>

SELECT ?p ?kana ?wdkana
{
  SERVICE <https://jpsearch.go.jp/rdf/sparql/> {
    {
      SELECT ?wd ?kana {
        ?wd rdfs:isDefinedBy <http://www.wikidata.org/> .
        ?wd owl:sameAs ?item .

        ?item rdf:type type:Person .
        ?item schema:name ?kana .
        FILTER(LANG(?kana) = "ja-kana")
      } LIMIT 10000 OFFSET 0 
    }
  }
  
  OPTIONAL { ?wd p:P1814 ?p . ?p ps:P1814 ?wdkana . }
  FILTER( ?wdkana != STR(?kana) )
  FILTER( ?wdkana = REPLACE(STR(?kana), "[\\s・]", "") )
  FILTER( !REGEX(?wdkana, "[\\s・]") )
}

Try it!

Missing jpsearch statements

PREFIX type: <https://jpsearch.go.jp/term/type/>

SELECT ?qid ?jpid
{
  {
    SERVICE <https://jpsearch.go.jp/rdf/sparql/> {
      {
        SELECT (SUBSTR(STR(?item), 38) AS ?jpid) ?qid {
          ?item rdfs:isDefinedBy <https://jpsearch.go.jp/entity/chname/> .
          ?item owl:sameAs ?qid .
          ?qid rdfs:isDefinedBy <http://www.wikidata.org/> .
        } LIMIT 10000 OFFSET 0
      }
    }
  } UNION {
    SERVICE <https://jpsearch.go.jp/rdf/sparql/> {
      {
        SELECT (SUBSTR(STR(?item), 38) AS ?jpid) ?qid {
          ?item rdfs:isDefinedBy <https://jpsearch.go.jp/entity/chname/> .
          ?item owl:sameAs ?qid .
          ?qid rdfs:isDefinedBy <http://www.wikidata.org/> .
        } LIMIT 10000 OFFSET 10000
      }
    }
  } UNION {
    SERVICE <https://jpsearch.go.jp/rdf/sparql/> {
      {
        SELECT (SUBSTR(STR(?item), 38) AS ?jpid) ?qid {
          ?item rdfs:isDefinedBy <https://jpsearch.go.jp/entity/chname/> .
          ?item owl:sameAs ?qid .
          ?qid rdfs:isDefinedBy <http://www.wikidata.org/> .
        } LIMIT 10000 OFFSET 20000
      }
    }
  }

  FILTER NOT EXISTS { ?qid wdt:P6698 ?jpid }
}

Try it!