number of errors=47
number of warnings=0
country=GR
select countrycode,name,geonameid,admincode1,admincode2,featureclass,featurecode,relevance from geoname where countrycode in ('GR') and not featureCode in ('ADM1H','ADM2H','ADM3H','ADM4H','ADM5H','ADMD') and not featurecode in ('STM') and admincode1 is not null and admincode1<>'00' and admincode2 is not null and not exists (select 1 from geoname b where b.countrycode=geoname.countrycode and b.admincode1=geoname.admincode1 and b.admincode2=geoname.admincode2 and b.featurecode='ADM2' and b.countrycode in ('GR')) order by relevance desc,admincode1,admincode2
countrycode name geonameid admincode1 admincode2 featureclass featurecode relevance GR Límni Sachtoúri 254152 ESYE25 35 H LK 8 GR Límni Thermisías 252948 ESYE25 35 H LK 8 GR Spalathronísi 253406 ESYE31 36 T ISL 8 GR Ákra Thermísi 252947 ESYE25 35 T CAPE 7 GR Nisída Koronída 259257 ESYE25 35 T ISL 7 GR Nísoi Diapórioi 263136 ESYE31 36 T ISLS 7 GR Nisída Ledoú 258530 ESYE31 36 T ISL 7 GR Dáfni 736482 736572 15 P PPL 6 GR Kallithéa 6779079 ESYE12 48 L AREA 6 GR Nisídes Falarídes 262523 ESYE23 27 T ISLS 6 GR Nisída Kápari 261131 ESYE25 35 T ISL 6 GR Ákra Mouzáki 256666 ESYE25 35 T CAPE 6 GR Tragonísi 252746 ESYE31 36 T ISL 6 GR Nisída Ágios Ioánnis 263888 ESYE31 36 T ISL 6 GR Nisída Ypsilí 261759 ESYE31 36 T ISL 6 GR Nisída Ágios Thomás 263711 ESYE31 36 T ISL 6 GR Nisída Moládi 256832 ESYE31 36 T ISL 6 GR Ákra Boúda 263421 ESYE41 34 T PT 6 GR Díavlos Dílou 263089 ESYE42 00 H STRT 6 GR Kerkyra Road 2463677 ESYE22 00 H ANCH 5 GR Chounovína 259880 ESYE23 27 T HLLS 5 GR Limáni Petalá 255479 ESYE23 27 H HBR 5 GR Chersónisos Dióni 263067 ESYE23 27 T PEN 5 GR Limáni Nafplíou 443797 ESYE25 00 H HBR 5 GR Ráchi Baroutospiliás 263492 ESYE25 35 T RDGE 5 GR Athinióti 264369 ESYE25 35 T RDGE 5 GR Ráchi Panagopoúlou 255953 ESYE25 35 T RDGE 5 GR Órmos Achladítsas 263343 ESYE25 35 H BAY 5 GR Longarákia 258592 ESYE25 35 T RDGE 5 GR Órmos Kápari 261130 ESYE25 35 H BAY 5 GR Fournovoúni 262279 ESYE25 35 T RDGE 5 GR Vezyrórrachi 251998 ESYE25 35 T RDGE 5 GR Ráchi Malavriás 257874 ESYE25 35 T RDGE 5 GR Nisída Xéra 251582 ESYE31 36 T ISL 5 GR Ákra Tháskoloi 252975 ESYE41 34 T CAPE 5 GR Órmos Léfkes 258435 ESYE42 00 H BAY 5 GR Ákra Koúmaros 259082 ESYE23 27 T CAPE 4 GR Ákra Trellí 7348328 ESYE25 35 T CAPE 4 GR Ákra Stenó 253201 ESYE25 35 T CAPE 4 GR Mavronísi 257527 ESYE25 35 T HDLD 4 GR Ákra Kastrí 260772 ESYE25 35 T CAPE 4 GR Órmos Kouvérta 258903 ESYE25 35 H BAY 4 GR Órmos Dióni 263066 ESYE23 27 H BAY 3 GR Rákhi Grávas 261872 ESYE25 35 T RDGE 3 GR Ýfalos Trypití 7324092 ESYE42 35 H RF 2 GR Élos Lesíni 258474 ESYE23 27 H MRSH 1 GR Límni Koumbourlá 259071 ESYE25 35 H LGN 1