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 Hieronymus Curio BVEV019076
BVEV036771
8 Regiomontanus BVEV021551
VEAV486511
9 Aldus Manutius BVEV021775
BVEV016960
10 Pietro Maria Marchetti BVEV021897
BVEV041291
11 Giovanni Maria Memmo BVEV023995
BVEV017775
12 Filippo Giunta BVEV036888
BVEV017020
13 Francesco Torresano BVEV047349
BVEV110628
14 Johann Theodor de Bry BVEV054675
BVEV071141
15 Jean de Tournes BVEV055124
BVEV018561
16 Accademia spoletina di Spoleto BVEV056657
CFIV075201
17 Zacharias Calliergi BVEV058110
UBOV112743
18 Pierre Landry BVEV059155
BVEV017091
19 François Estienne BVEV059749
BVEV059790
20 Adriaan Vlacq BVEV069967
PUVV182101
21 Johann Philipp Eysel BVEV070536
BVEV070541
22 Paul Estienne BVEV087701
BVEV025590
23 Mariam Baouardy BVEV235660
CUBV099172
CFIV222077
24 Luigi Franchi CFIV005610
RT1V009521
25 Pierre Louÿs CFIV008172
RMSV105470
26 Girolamo Porro CFIV020522
BVEV020718
27 National Archaeological Museum CFIV066705
CFIV158137
28 Giovan Battista Amico CFIV090310
BVEV021853
29 Ottavio Beltrano CFIV161146
SBLV185825
30 Bankim Chandra Chatterjee CUBV012020
NAPV079423
31 Louis Bard CUBV013609
UFIV071952
32 Heinrich Barth CUBV014221
GEAV013872
33 Fritz Baumgarten CUBV015058
RAVV094010
34 George Miller Beard CUBV015218
PUVV383874
35 Camillo Bernardi CUBV018578
PUVV407616
36 Michele Tramezzino CUBV033580
BVEV016919
37 Paulus Manutius CUBV059174
BVEV017683
38 Edwin Brant Frost CUBV069343
UBOV469635
39 George Ellery Hale CUBV081920
PUVV093533
40 Kazimierz Kelles-Krauz CUBV083069
IEIV072747
41 George Rusby Kaye CUBV085880
VEAV528113
42 Henri Lebesgue CUBV088582
RMSV001203
43 Friedrich Paulsen CUBV106074
RAVV044303
44 Richard Mayr CUBV110055
SBNV030005
45 Giacomo Medici CUBV110603
LO1V132762
46 Christian Moser CUBV117262
VEAV548644
47 Benjamin Wills Newton CUBV119271
RMSV039967
48 Heinrich Proch CUBV129696
LIAV456476
49 Henri Ramière CUBV131241
RAVV101168
50 John Joy Bell CUBV140432
UBOV803242
51 Bansui Doi CUBV156649
MUSV004214
52 Joseph Walter CUBV162789
LO1V166619
53 Charles Weinberger CUBV162949
MUSV068485
54 Miska Hauser CUBV166262
MUSV033244
55 Bona CUBV168568
CFIV062154
56 Cora Pearl CUBV171911
LO1V319948
57 William Temple CUBV172365
RAVV092941
58 Girolamo Scotto DDSV098436
BVEV016879
59 Friedrich Bluhme FERV030531
RAVV056423
60 Antonio Bulifon LO1V090408
MILV167690
61 Giuseppe Regaldi LO1V090513
LIAV456399
62 Henri Grégoire MILV061565
CFIV343822
63 Zinaida Gippius MILV098214
RMSV109981
64 Gregorio Leti MILV102982
BVEV088284
65 Niccolò Tartaglia MILV110199
BVEV026777
66 Nicola Antonio Stigliola MILV173794
BVEV017023
67 Giovanni Battista Romano MILV286823
UTOV550281
68 Giuseppe Natoli PALV049222
PALV082079
69 John Ironside PALV060314
RAVV704008
70 Noré Brunel PALV066148
CFIV322054
71 Accademia Albertina PUVV095525
CFIV168081
72 Andrea Della Vaccheria PUVV327214
BVEV054407
73 Winston Churchill RAVV003813
UM1V009797
74 Vincenzo Coronelli RAVV006106
VEAV055201
75 Enrico Mauceri RAVV021144
SBNV006550
76 Eugenia Codronchi Argeli RAVV036812
PALV070498
77 Francesco Bianchini RAVV052087
BVEV074404
78 André Chénier RAVV059126
MUSV015697
79 Robert F. Kennedy RAVV073423
DDSV211044
80 Domenico Maria Manni RAVV076537
TO0V258911
81 Theodor de Bry RMLV025231
BVEV048844
82 Marco Ginammi RMLV031508
BVEV089063
83 Barezzo Barezzi RMLV031922
BVEV022509
84 Maurice de La Porte SBLV011439
BVEV018277
85 Francesco Cichè SBLV040055
TO0V465465
86 Rainis SBLV125563
CUBV126462
87 Hippolito Salviani SBLV182779
BVEV018550
88 Piero Guicciardini TO0V091706
RT1V033504
89 Louis Gallet TO0V208476
LIAV456802
90 Henry Thomas TO0V369128
TO0V150377
91 Antonio Piazza UBOV135635
MILV313014
92 Tōson Shimazaki UFIV027594
MUSV065038
93 Matthew Fontaine Maury UFIV069077
PAVV049882
94 Franz von Paula Schrank UFIV080537
PAVV031442
95 Hungarian Natural History Museum UFIV095389
UFIV019753
96 Association of Cancer Physicians UFIV112588
UFIV065931
97 Ignazio Lazzari UFIV120987
RMLV031993
98 Clément Cyriaque de Mangin UFIV124990
UFIV124989
99 Abraham Ortelius VEAV011727
BVEV026284
100 Giovanni Battista Albrizzi VEAV033526
MILV173025
End of automatically generated list.