User:Sannita/Constraint violations/P396 single value

From Wikidata
Jump to navigation Jump to search

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images | Recent changes | Query: SELECT DISTINCT ?item ?itemLabel ?count ?sample1 ?sample2 ?exception WHERE { { SELECT ?item (COUNT(?value) AS ?count) (MIN(?value) AS ?sample1) (MAX(?value) AS ?sample2) { ?item wdt:P396 ?val . OPTIONAL { wd:P396 wdt:P1630 ?formatter } . BIND( IF( BOUND( ?formatter ), URI( REPLACE( ?formatter, '\\$1', ?val ) ), ?val ) AS ?value ) . } GROUP BY ?item HAVING ( ?count > 1 ) LIMIT 100 } . OPTIONAL { wd:P396 p:P2302 [ ps:P2302 wd:Q19474404; pq:P2303 ?exc ] . FILTER( ?exc = ?item ) . } . BIND( BOUND( ?exc ) AS ?exception ) . SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } . }
# label SBN author ID
1 Boneto Locatello BVEV017097
BVEV049385
2 Gabriele Giolito de' Ferrari BVEV017412
CUBV076160
3 Sigmund Feyerabend BVEV017571
BVEV048220
4 Vincenzo Busdraghi BVEV017580
CNCV001083
5 Federico Commandino BVEV018085
BVEV023669
6 Giovanni Antonio Bertano BVEV018877
BVEV064782
7 Regiomontanus BVEV021551
VEAV486511
8 Aldus Manutius BVEV021775
BVEV016960
9 Pietro Maria Marchetti BVEV021897
BVEV041291
10 Giovanni Maria Memmo BVEV023995
BVEV017775
11 Filippo Giunta BVEV036888
BVEV017020
12 Francesco Torresano BVEV047349
BVEV110628
13 Jean de Tournes BVEV055124
BVEV018561
14 Zacharias Calliergi BVEV058110
UBOV112743
15 Pierre Landry BVEV059155
BVEV017091
16 François Estienne BVEV059749
BVEV059790
17 Adriaan Vlacq BVEV069967
PUVV182101
18 Johann Philipp Eysel BVEV070536
BVEV070541
19 Paul Estienne BVEV087701
BVEV025590
20 Mariam Baouardy BVEV235660
CUBV099172
CFIV222077
21 Pierre Louÿs CFIV008172
RMSV105470
22 Girolamo Porro CFIV020522
BVEV020718
23 National Archaeological Museum CFIV066705
CFIV158137
24 Giovan Battista Amico CFIV090310
BVEV021853
25 Ottavio Beltrano CFIV161146
SBLV185825
26 Bankim Chandra Chatterjee CUBV012020
NAPV079423
27 Louis Bard CUBV013609
UFIV071952
28 Heinrich Barth CUBV014221
GEAV013872
29 Fritz Baumgarten CUBV015058
RAVV094010
30 George Miller Beard CUBV015218
PUVV383874
31 Camillo Bernardi CUBV018578
PUVV407616
32 Michele Tramezzino CUBV033580
BVEV016919
33 William Harbutt Dawson CUBV052944
UBOV005202
34 Paulus Manutius CUBV059174
BVEV017683
35 Edwin Brant Frost CUBV069343
UBOV469635
36 George Ellery Hale CUBV081920
PUVV093533
37 Kazimierz Kelles-Krauz CUBV083069
IEIV072747
38 George Rusby Kaye CUBV085880
VEAV528113
39 Henri Lebesgue CUBV088582
RMSV001203
40 Friedrich Paulsen CUBV106074
RAVV044303
41 Richard Mayr CUBV110055
SBNV030005
42 Giacomo Medici CUBV110603
LO1V132762
43 Christian Moser CUBV117262
VEAV548644
44 Benjamin Wills Newton CUBV119271
RMSV039967
45 Heinrich Proch CUBV129696
LIAV456476
46 Henri Ramière CUBV131241
RAVV101168
47 John Joy Bell CUBV140432
UBOV803242
48 Bansui Doi CUBV156649
MUSV004214
49 Joseph Walter CUBV162789
LO1V166619
50 Charles Weinberger CUBV162949
MUSV068485
51 Miska Hauser CUBV166262
MUSV033244
52 Bona CUBV168568
CFIV062154
53 Cora Pearl CUBV171911
LO1V319948
54 William Temple CUBV172365
RAVV092941
55 Girolamo Scotto DDSV098436
BVEV016879
56 Friedrich Bluhme FERV030531
RAVV056423
57 Antonio Bulifon LO1V090408
MILV167690
58 Giuseppe Regaldi LO1V090513
LIAV456399
59 Édouard Batiste LO1V316479
MUSV005152
60 Henri Grégoire MILV061565
CFIV343822
61 Zinaida Gippius MILV098214
RMSV109981
62 Gregorio Leti MILV102982
BVEV088284
63 Niccolò Tartaglia MILV110199
BVEV026777
64 Nicola Antonio Stigliola MILV173794
BVEV017023
65 Giovanni Battista Romano MILV286823
UTOV550281
66 Giuseppe Natoli PALV049222
PALV082079
67 John Ironside PALV060314
RAVV704008
68 Noré Brunel PALV066148
CFIV322054
69 Accademia Albertina PUVV095525
CFIV168081
70 Andrea Della Vaccheria PUVV327214
BVEV054407
71 Winston Churchill RAVV003813
UM1V009797
72 Vincenzo Coronelli RAVV006106
VEAV055201
73 Enrico Mauceri RAVV021144
SBNV006550
74 Francesco Bianchini RAVV052087
BVEV074404
75 André Chénier RAVV059126
MUSV015697
76 Robert F. Kennedy RAVV073423
DDSV211044
77 Domenico Maria Manni RAVV076537
TO0V258911
78 Gaetano Barbieri RAVV083455
MUSV047419
79 Marco Ginammi RMLV031508
BVEV089063
80 Barezzo Barezzi RMLV031922
BVEV022509
81 Maurice de La Porte SBLV011439
BVEV018277
82 Francesco Cichè SBLV040055
TO0V465465
83 Rainis SBLV125563
CUBV126462
84 Hippolito Salviani SBLV182779
BVEV018550
85 Jules Rouch SBLV246109
SBLV008031
86 Piero Guicciardini TO0V091706
RT1V033504
87 Louis Gallet TO0V208476
LIAV456802
88 Henry Thomas TO0V369128
TO0V150377
89 Antoine Jacques Claude Joseph, comte Boulay de la Meurthe TO0V507029
SBLV317719
90 Antonio Piazza UBOV135635
MILV313014
91 Tōson Shimazaki UFIV027594
MUSV065038
92 Matthew Fontaine Maury UFIV069077
PAVV049882
93 Franz von Paula Schrank UFIV080537
PAVV031442
94 Hungarian Natural History Museum UFIV095389
UFIV019753
95 Association of Cancer Physicians UFIV112588
UFIV065931
96 Ignazio Lazzari UFIV120987
RMLV031993
97 Clément Cyriaque de Mangin UFIV124990
UFIV124989
98 Scottish Law Commission UFIV126796
UFIV056283
99 Abraham Ortelius VEAV011727
BVEV026284
100 Giovanni Battista Albrizzi VEAV033526
MILV173025
End of automatically generated list.