number of errors=42
number of warnings=0
country=TR
Group=chkGrpPostalCode
select countrycode,zip,placename,geonameid,admincode1,geonamesadmcode from zip_code where countrycode in ('TR') and zip_code.geonameid not in (2775000,4020092) and not exists (select 1 from geoname b where b.countrycode=zip_code.countrycode and b.admincode1=zip_code.geonamesadmcode and b.featurecode='ADM1' and b.countrycode in ('TR')) order by countrycode,zip,placename
countrycode zip placename geonameid admincode1 geonamesadmcode TR 99040 Hamitköy 312739 null null TR 99050 Değirmenlik 317378 null null TR 99250 Türkeli 738614 null null TR 99280 Akincilar 752473 null null TR 99290 Gaziler 747028 null null TR 99390 Akçiçek 7746834 null null TR 99390 Boğazköy 750539 null null TR 99410 Bahçeli 322334 null null TR 99410 Beşparmak 321334 null null TR 99410 Karaağaç 310377 null null TR 99440 Karşiyaka 302799 null null TR 99440 Kayalar 308609 null null TR 99440 Kozan 302712 null null TR 99440 Tepebaşi 7458041 null null TR 99500 Tuzla 738552 null null TR 99520 Akdoğan 747071 null null TR 99620 Sütlüce 296428 null null TR 99640 Tatlisu 738752 null null TR 99650 Paşaköy 302844 null null TR 99655 Güvercinlik 313265 null null TR 99655 İncirli 299142 null null TR 99675 Turunçlu 7639476 null null TR 99690 Akova 7639115 null null TR 99700 Güzelyurt 752721 null null TR 99750 Akçay 8025310 null null TR 99750 Şahinler 740402 null null TR 99750 Yayla 737864 null null TR 99750 Yuvacik 737120 null null TR 99790 Doğanci 748029 null null TR 99790 Ömerli 303529 null null TR 99790 Yeşilyurt 323751 null null TR 99860 Ağillar 325199 null null TR 99860 Altinova 7572288 null null TR 99860 Boğaziçi 297612 null null TR 99860 Boğazköy 750546 null null TR 99860 Turnalar 738589 null null TR 99880 Kaplica 745535 null null TR 99970 Derince 316884 null null TR 99970 Esenköy 747344 null null TR 99970 Sipahi 739596 null null TR 99970 Taşlica 739057 null null TR 99970 Yeşilköy 747662 null null