number of errors=164
number of warnings=0
country=IT
select source.countrycode,provider,datasourceid,source.name,geoname.geonameid,source.population,geoname.population from source,geoname,geoname_datasource where source.countrycode in ('IT') and datasourceid=nameorid and source.userid=geoname_datasource.userid and geoname_datasource.geonameid=geoname.geonameid and source.population>0 and abs(source.population - geoname.population)>1
countrycode provider datasourceid name geonameid population population IT istat 06300210001 Afragola 3183455 62775 64470 IT istat 00310610002 Novara 3172189 93295 101916 IT istat 08101210002 Mazara del Vallo 2524205 45953 51534 IT istat 08102110002 Trapani 2522876 58681 67531 IT istat 08006310015 Reggio di Calabria 2523630 169140 182455 IT istat 08800610005 Modica 2524119 41126 54456 IT istat 07204410002 Toritto 3165513 8060 8475 IT istat 01201110001 Besano 3182116 2594 2350 IT istat 01309010001 Dongo 3177526 3489 3407 IT istat 01402610001 Delebio 3177630 3022 3252 IT istat 01505110001 Carugate 3180389 13421 15368 IT istat 01507710001 Cinisello Balsamo 3178671 71109 75943 IT istat 01508610001 Cormano 3178087 19452 20031 IT istat 01518110001 Rescaldina 3169481 13911 14211 IT istat 01520910001 Sesto San Giovanni 3166598 76509 81822 IT istat 01524210003 Vimodrone 3164080 16183 17072 IT istat 01607910001 Cologno al Serio 3178285 10089 11145 IT istat 08500710001 Gela 2524653 73854 75001 IT istat 04601810004 Massarosa 3173754 10881 22435 IT istat 03700610002 Bologna 3181928 366133 394843 IT istat 03800810020 Ferrara 3177090 92802 132009 IT istat 01903610004 Cremona 3177838 59561 71223 IT istat 03504010012 Scandiano 3166989 11010 25896 IT istat 01714910003 Pontevico 3170208 5714 6931 IT istat 01717010003 Salò 3168633 8165 10576 IT istat 01902210001 Casalmorano 3180175 1466 1610 IT istat 01602410001 Bergamo 3182164 114162 121200 IT istat 01909910003 Sospiro 3166343 2378 3094 IT istat 01213310006 Varese 3164699 76851 80588 IT istat 07302710004 Taranto 3165926 181082 198585 IT istat 04001210007 Forlì 3176746 93638 116696 IT istat 05807210001 Nettuno 3172287 44756 49873 IT istat 05401810008 Foligno 3176854 47747 56918 IT istat 03900410001 Brisighella 3181521 2702 7598 IT istat 03900710003 Cervia 3178998 20487 28700 IT istat 01514610006 Milano 3173435 1236837 1371498 IT istat 01202610001 Busto Arsizio 3181355 79519 83405 IT istat 07701410003 Matera 3173721 54891 60403 IT istat 00121910002 Rivoli 3169231 46031 48629 IT istat 00107810001 Chieri 3178818 32169 36749 IT istat 03602310008 Modena 3173331 158886 184732 IT istat 04000710005 Cesena 3178957 79398 97137 IT istat 05811810001 Ciampino 3178738 35174 38277 IT istat 08702410001 Mascalucia 2524236 29910 32179 IT istat 10802410002 Giussano 3176041 24357 25916 IT istat 02309110021 Verona 3164527 219103 258031 IT istat 00116410001 Nichelino 3172269 47605 47760 IT istat 05203210006 Siena 3166548 42867 53901 IT istat 00803110004 Imperia 3175532 38675 42328 IT istat 02411610005 Vicenza 3164419 107129 111980 IT istat 00126510006 Settimo Torinese 3166576 44122 47485 IT istat 02100810001 Bolzano 3181913 99049 107436 IT istat 00420310002 Saluzzo 3168609 13111 16537 IT istat 10401710005 Olbia 3172087 42930 60345 IT istat 08701110001 Caltagirone 2525450 35371 38391 IT istat 03012910003 Udine 3165072 97761 100170 IT istat 03200610009 Trieste 3165185 187056 204338 IT istat 00112010002 Grugliasco 3175755 33100 36700 IT istat 00806510011 Ventimiglia 3164582 18442 24120 IT istat 05503210016 Terni 3165771 97050 111189 IT istat 00905610005 Savona 3167022 58283 61345 IT istat 08200610001 Bagheria 2525628 52952 53149 IT istat 05100210002 Arezzo 3182884 76346 100734 IT istat 00115610004 Moncalieri 3173180 49153 56134 IT istat 04101310004 Fano 3177219 38999 60978 IT istat 00600310001 Alessandria 3183299 64178 92104 IT istat 02105110001 Merano 3173577 33453 41051 IT istat 02805510003 Monselice 3173124 12623 18682 IT istat 08404110001 Sciacca 2523194 36897 40569 IT istat 08009610002 Villa San Giovanni 2522730 12960 13747 IT istat 06200810001 Benevento 3182179 48931 58418 IT istat 06704110022 Teramo 3165803 36099 54338 IT istat 00215810004 Vercelli 3164565 45593 45875 IT istat 06304910001 Napoli 3172394 959470 909048 IT istat 06904610002 Lanciano 3175173 30705 34791 IT istat 03402710015 Parma 3171457 146299 198292 IT istat 02803710002 Este 3177337 14629 16963 IT istat 05002610002 Pisa 3170647 77007 109960 IT istat 08701510001 Catania 2525068 290927 311584 IT istat 05809110020 Lido di Ostia 3174741 79400 85301 IT istat 02215310003 Riva del Garda 3169272 14727 17331 IT istat 06308410001 Torre del Greco 3165456 85897 85332 IT istat 05805710001 Marino 3173914 38013 44142 IT istat 06507810001 Nocera Inferiore 3172244 45086 45608 IT istat 06513710001 Scafati 3167010 49264 48702 IT istat 04900910004 Livorno 3174659 153773 157017 IT istat 09901410005 Rimini 3169361 118673 148688 IT istat 10101010001 Crotone 2524881 48704 64603 IT istat 04603310002 Viareggio 3164433 49099 62169 IT istat 03601510004 Formigine 3176733 26324 34328 IT istat 01307510003 Como 3178229 81975 84808 IT istat 01304110002 Cantù 3180758 37273 39917 IT istat 06306010005 Pozzuoli 3169984 45575 81231 IT istat 07000610001 Campobasso 3180991 39723 49230 IT istat 04801710002 Firenze 3176959 349296 367150 IT istat 07400110001 Brindisi 3181528 78548 87141 IT istat 10803310001 Monza 3172629 119618 124398 IT istat 02703310010 San Donà di Piave 3168429 32819 41856 IT istat 01818210004 Voghera 3163995 36054 38464 IT istat 11000310001 Bisceglie 3182007 53648 55385 IT istat 02006610011 Viadana 3164440 14654 20013 IT istat 01403310001 Grosio 3175788 4179 4431 IT istat 07200610001 Bari 3182351 277387 316491 IT istat 07102910001 Manfredonia 3174092 52911 56932 IT istat 01702910001 Brescia 3181554 184826 200423 IT istat 08500410001 Caltanissetta 2525448 56715 62797 IT istat 05900710001 Fondi 3176843 26634 39762 IT istat 05900110001 Aprilia 3182957 41094 74977 IT istat 02220510018 Trento 3165243 80425 120709 IT istat 07200410001 Altamura 3183178 67821 70539 IT istat 01500210001 Abbiategrasso 3183573 30659 32784 IT istat 02904110008 Rovigo 3168843 39347 50279 IT istat 06302310002 Casoria 3179806 58456 73918 IT istat 07104610001 San Giovanni Rotondo 3168234 26179 27124 IT istat 07105110001 San Severo 3167731 54880 51919 IT istat 02101010001 Brennero 3181570 247 2085 IT istat 07916010008 Nicastro-Sambiase 2524013 55687 40000 IT istat 07900410001 Amato 6535314 644 807 IT istat 08100610001 Castelvetrano 2525083 28072 31680 IT istat 00127210001 Torino 3165524 870456 847287 IT istat 08601310001 Nissoria 2524004 2382 2969 IT istat 09103310001 Irgoli 3175474 2221 2307 IT istat 08901710011 Siracusa 2523083 97472 121605 IT istat 09002310001 Castelsardo 3179470 3747 5994 IT istat 09002510001 Chiaramonti 3178858 1602 1639 IT istat 09002910001 Florinas 3176903 1341 1514 IT istat 06305910001 Portici 3170116 55765 53801 IT istat 01101510005 La Spezia 3175081 88491 93288 IT istat 09501710001 Busachi 3181384 1378 1282 IT istat 09503810004 Oristano 2523964 24641 31671 IT istat 04901210002 Piombino 3170674 30103 34041 IT istat 09706910001 Premana 3169863 2288 2205 IT istat 03703210006 Imola 3175537 52981 69953 IT istat 10802310001 Desio 3177608 40337 41960 IT istat 06503710001 Cava Dè Tirreni 3179337 48127 53130 IT istat 11000110001 Andria 3183072 98342 99784 IT istat 06502410001 Cannalonga 3180827 1002 973 IT istat 06105210001 Mondragone 3173160 26076 28683 IT istat 01002510006 Genova 3176219 580223 580097 IT istat 03100710001 Gorizia 3175986 34646 34428 IT istat 06802810001 Pescara 3171168 116596 119554 IT istat 03503310017 Reggio nell'Emilia 3169522 133296 171944 IT istat 08700910001 Bronte 2525498 18397 19074 IT istat 11000410001 Canosa di Puglia 3180792 30046 29847 IT istat 03600510002 Carpi Centro 3180445 53024 71148 IT istat 06100510001 Aversa 3182640 52830 52974 IT istat 00700310001 Aosta 3182997 32295 35261 IT istat 02608610006 Treviso 3165201 77604 85760 IT istat 04301310003 Portocivitanova 8948702 31064 0 IT istat 06300110001 Acerra 3183541 53578 59910 IT istat 08800910004 Ragusa 2523650 61380 74251 IT istat 00112510001 Ivrea 3175384 23278 23599 IT istat 10000510004 Prato 3169921 181820 195089 IT istat 06302410001 Castellammare di Stabia 3179661 65730 66164 IT istat 08101410005 Pantelleria 2523890 3455 6044 IT istat 03303210007 Piacenza 3171058 93228 103607 IT istat 00407810002 Cuneo 3177700 46416 55980 IT istat 06909910005 Vasto 3164672 30367 41409 IT istat 00603910004 Casale Monferrato 3180208 31275 33213 IT istat 00306810001 Galliate 3176379 14649 15699 IT istat 00402920003 Falchetto 8956192 101 104 IT istat 01605320008 Santuario di Caravaggio 9033631 52 0 IT istat 05811110002 Velletri 3164630 48443 52911 IT istat 00500510001 Asti 3182714 61254 74348