number of errors=101
number of warnings=0
select a.geonameid as pplid,a.ansiname as pplname,a.countrycode as pplcountry,a.admincode1 as ppladm1,b.geonameid pplxid,b.ansiname pplxname,b.countrycode pplxcountry,b.admincode1 as pplxadm1 from geoname a,geoname b,geoname_hierarchy where a.geonameid=parentid and b.geonameid=childid and a.featureClass='P' and b.featurecode='PPLX' and a.countrycode=b.countrycode and a.admincode1<>coalesce(b.admincode1,'') and a.countrycode in ('AT','CH','DE','DK','ES','FI','FR','GB','IT','NL','NO','SE','US','CA','AU','NZ','JP') order by a.countrycode,a.geonameid
pplid pplname pplcountry ppladm1 pplxid pplxname pplxcountry pplxadm1 2761369 Vienna AT 09 2774982 Kahlenbergerdorf AT 03 2767001 Rudersdorf AT 01 2771097 Muehlbreiten AT 06 2768022 Ramingdorf AT 03 2771034 Muenichholz AT 04 2768171 Raasdorf AT 03 3333508 Schopfleithnersiedlung AT 09 2772620 Leopoldsdorf AT 03 2762833 Unterlaa AT 09 3333531 Oberlisse AT 03 3333530 Nordrandsiedlung AT 09 3333555 Falkenberg AT 09 3333558 Wolfsbergen-Siedlung AT 03 2147798 Sutton AU 02 9973384 Throsby AU 01 2152286 Queanbeyan AU 02 9973385 Beard AU 01 2152286 Queanbeyan AU 02 8349378 Oaks Estate AU 01 2154727 Numinbah AU 02 8628361 Natural Bridge AU 04 2163910 Harman AU 01 11704289 Queanbeyan West AU 02 2164064 Hall AU 01 8349230 Wallaroo AU 02 2172710 Caloundra AU 04 10104162 Coochin Creek AU null 2176780 Barooga AU 02 8347996 Cobram East AU 07 8219829 Silverwater AU 02 8348728 Point Wolstoncroft AU null 11747053 Glengarrie AU 02 8348801 Currumbin Valley AU 04 11776271 Murray Downs AU 02 8348049 Pental Island AU 07 5934671 Dalhousie Mills CA 08 5934663 Dalhousie CA 10 6058024 Lloydminster CA 01 12225495 East Lloydminster CA 11 2658577 Sins CH AG 11817094 Unterchamau CH ZG 2658577 Sins CH AG 11817135 Oberchamau CH ZG 2658834 Sangernboden CH BE 11845037 Mittleren Chrutboden CH FR 2658904 Saanen CH BE 11466515 Sassalas d'en Haut CH VD 2658904 Saanen CH BE 11466516 Sassalas d'en Bas CH VD 2659526 Mussen CH OW 11835688 Obersattelschlucht CH LU 2661165 Ciernes-Picat CH VD 11437931 Les Morteys-Dessous CH FR 2661202 Chatel-Saint-Denis CH FR 11466509 Saumont Derriere CH VD 6295522 Daenikon CH ZH 6291518 Rain CH LU 6950968 Dallikon CH ZH 6291510 Rain CH LU 7115579 Schneisingen CH AG 6291593 Niederweningen / Rebhalde CH ZH 7115579 Schneisingen CH AG 6291597 Niederweningen / Huesliweg CH ZH 7670117 Chlyrot CH BE 11817117 Unterberghof CH LU 7670117 Chlyrot CH BE 11817136 Oberberghof CH LU 11489072 Bruch CH FR 11465355 Underi Bire CH BE 11489072 Bruch CH FR 11465376 Undere Ruedersberg CH BE 11489072 Bruch CH FR 11465379 Obere Ruedersberg CH BE 11489072 Bruch CH FR 11465331 Oberi Bire CH BE 2805823 Wulsdorf DE 06 2922109 Geestemuende DE 03 2834354 Schwemsal DE 14 8659164 Hammermuehle DE 13 2843395 Ruedesheim am Rhein DE 05 2891620 Kempten DE 08 2874225 Mainz DE 08 2913460 Gustavsburg DE 05 2874225 Mainz DE 08 2892488 Kastel DE 05 2874225 Mainz DE 08 2885273 Mainz Kostheim DE 05 2881276 Langen DE 06 2879549 Leherheide DE 03 2911298 Hamburg DE 04 2832551 Schenefeld DE 10 2915650 Grossfedderwarden DE 06 2813477 Weddewarden DE 03 2934703 Duhnen DE 06 11669490 Neuwerk DE 04 2943565 Bruchmuehlen DE 07 3206609 Siedlung Steinbrink DE 06 2950159 Berlin DE 16 6691071 Waldesruh DE 11 3107919 Tormantos ES 27 6697220 Quintanilla de las Duenas ES 55 3129650 Areso ES 32 6325334 Zozune ES 59 3129650 Areso ES 32 6324792 Aintzerga ES 59 632563 Valsas FI 15 649848 Kuusisto FI 14 649439 Lahistenlahko FI 05 7626645 Lahinen FI 06 657361 Horonkylae FI 14 7283629 OEstera FI 15 657361 Horonkylae FI 14 644116 Nyby FI 15 3175938 Grand'Albergo IT 17 9881919 Passo Stelvio IT 09 1848439 Yawata JP 22 11790754 Kitayama JP 32 1848439 Yawata JP 22 11818419 Machikuzuha JP 32 1848439 Yawata JP 22 11820223 Koyamichi JP 32 1848439 Yawata JP 22 11790811 Minamikuzuha JP 32 1848522 Yao JP 32 11791582 Sekiyakita JP 28 1853174 Sakaiminato JP 41 1863238 Hanamachi JP 36 1853909 Osaka JP 32 1852433 Shimaya JP 13 1853909 Osaka JP 32 1854357 Okijima-minaminocho JP 13 1853909 Osaka JP 32 1864382 Dempocho-minami JP 13 1857403 Menuma JP 34 11791652 Sengoku JP 10 1857910 Kyoto JP 22 11791339 Oginosatohigashi JP 35 1857910 Kyoto JP 22 11791525 Ogoto JP 35 1859093 Koga JP 14 11776907 Nogi JP 38 1859675 Kawanishi JP 13 11807897 Koda JP 32 1859675 Kawanishi JP 13 11818638 Momozono JP 32 1861795 Ikeda JP 32 11819826 Hagihara JP 13 1863769 Futagawa JP 01 11838048 Ekiminami JP 37 1863769 Futagawa JP 01 11836095 Shinjohara JP 37 1864572 Chikushino-shi JP 07 10257656 Mukaizano JP 21 8611044 Hayatocho-kareigawa JP 25 1865014 Ashitaniharu JP 18 8625036 Osuge JP 41 8625684 Hinagawa JP 36 9277747 Furuecho JP 32 11808993 Tsutsumigataki JP 13 11010398 Nodera JP 34 11808018 Kitamachi JP 40 2744582 Weverwijk NL 09 2759369 Bazeldijk NL 11 2754073 Hillegom NL 11 2759266 Beinsdorp NL 07 2760144 Aalburg NL 06 2750478 Nederhemert-Zuid NL 03 3143244 Oslo NO 12 9304401 Voll NO 01 3143244 Oslo NO 12 11745967 Haslum NO 01 3143244 Oslo NO 12 6944040 Fossum Terrasse, Eiksmarka NO 01 9537568 Russeskaret NO 05 8030470 Garnjarga NO null 2711537 Goeteborg SE 28 2696576 Lerberg SE 06 2711537 Goeteborg SE 28 2708132 Hammeroe SE 06 4062703 Forest US AL 4432649 Labelle Estates US MS 4062703 Forest US AL 4432660 Lacy Subdivision US MS 4062703 Forest US AL 4425286 Eastwood Hills US MS 4062703 Forest US AL 4441387 Pinecrest US MS 4142226 Delmar US DE 4355516 Foxwood US MD 4183981 Boyd Highlands US GA 4627951 Harris Hills US TN 4313047 West Point US KY 11838967 Shawnee Mission US KS 4494473 Tapoco US NC 7627502 Deals Gap US TN 4562457 Zebleys Corner US PA 4145284 Westerloo US DE 4809537 Huntington US WV 4509605 Crescent Lake US OH 4809537 Huntington US WV 4526019 Symmes Park US OH