Duplicate values in DB awb_localities with the same Name and CountyID
Table awb_localities has 249 duplicate values for the same CountyID. This generate issues when importing AWBs where the recipient's locality could not be matched and fails to display the shipping method if cost != costfix The list with duplicate values: SQL query: SELECT Name, CountyID, COUNT(*) FROM `awb_localities` GROUP BY Name, CountyID HAVING COUNT(*) > 1; Rows: 249 Name CountyID COUNT(*) Almasu Mic 24 2 Apateu 7 2 Aranghel 41 2 Arcesti 32 2 Armasenii Noi 23 2 Aurel Vlaicu 30 2 Aurora 16 2 BACESTI 5 2 Balaia 6 2 Balanesti 43 2 Balesti 42 2 Banesti 41 2 Barlogu 41 2 Barna 6 2 Barza 30 2 Begu 12 2 Benesti 36 2 Bercu 24 2 Beta 23 2 Blidari 41 2 Bobaia 24 2 Bogdanesti 33 2 Borzesti 15 2 Bradeanca 12 2 Buda 41 2 Name CountyID COUNT(*) Budesti 6 2 Budesti 42 2 Bughea de Sus 33 2 Capalnas 4 2 Capu Dealului 41 2 Carpitus 23 2 Caslita 40 2 Cergau 3 2 Cernesti 33 2 Cetatuia 6 2 CHILII 5 2 Chitcani 43 2 Ciobanis 23 2 Ciocanari 18 2 Ciuresti 20 2 Closca 40 2 Colibasi 22 2 Colonia Brazi 33 2 Comanca 41 2 Corbu 41 2 Cornesti 6 2 Corni 31 2 Costei 6 2 Cozia 24 2 Craciunesti 18 2 Name CountyID COUNT(*) Crangeni 20 2 Crangurile 33 2 Criseni 3 2 Curmatura 33 2 Curpenii Silvasului 24 2 Dabaca 24 2 Damburile 15 2 Danulesti 24 2 Dealu 21 2 Dealu Bisericii 5 2 Dealu Goiesti 3 2 Deleni 12 2 Deleni 31 2 Desirati 10 2 Dobreni 31 2 Dornesti 31 2 Dragesti (Damienesti) 6 2 Dudesti 24 2 Dumbrava 24 2 Dumbravesti 41 2 Dumbravita 24 2 Dumesti 24 2 Dumitra 3 2 Dumitresti 25 2 Dusesti 31 2 Name CountyID COUNT(*) Facai 41 2 Fata Lapusului 3 2 Floresti 19 2 Frasinet 33 2 Fratesti 5 2 Fratesti 22 2 Fulga 12 2 Fundatura 41 2 Gavanesti 41 2 Gazarie 6 2 Gherman 31 2 Ghiurche 23 2 Gialacuta 24 2 Glodurile 12 2 Godinesti 24 2 Gottlob 39 2 Grabicina de Sus 12 2 Gresia 12 2 Grosani 33 2 Grozavesti 20 2 Hartop 31 2 Hotarele 41 2 Iacobeni 23 2 IAZ 6 2 Ighiu 23 2 Name CountyID COUNT(*) Izvoru 32 2 Jieni 19 2 Laceni 5 2 Livada 9 2 Livadia 41 2 Livezi 24 2 Lucacesti 37 2 Luncsoara 24 2 Macesti 14 2 Magherus 23 2 Magureni 41 2 Maia 15 2 Malaiesti 24 2 Mesteacan 31 2 Mesteacan (Brad) 24 2 Misihanesti 6 2 Moglanesti 23 2 Mogosesti 41 2 Moldoveni 38 2 Moreni 42 2 Mosna 19 2 Namoloasa-Sat 20 2 Neagra 30 2 Nedelcu 10 2 Negreni 6 2 Name CountyID COUNT(*) Nicolae Balcescu 10 2 Obreja 22 2 Ocoale 3 2 Oncestii Vechi 6 2 Padureni 21 2 Padureni 31 2 Padureni 36 2 Pantesti 3 2 Parau 22 2 Pausa 41 2 Pestera 15 2 Pietrisu 41 2 Pleasa 41 2 Plopi 15 2 Plopis 23 2 Plugari 31 2 Podeni 42 2 Podisor 21 2 Podoleni 20 2 Poenari 41 2 Poiana 32 2 Popeni (Braesti) 9 2 Prisaca 43 2 Prodanesti 41 2 Radulesti 38 2 Name CountyID COUNT(*) ...... Valea Seaca 13 2 Valea Seaca 42 2 Valea Stanei 12 2 Valea Stefanului 12 2 Valea Uriesului 30 2 Valea Viei 41 2 Valisoara 3 2 Varghis 17 2 Versesti 6 2 Viforata 12 2 Viforeni 9 2 Vladesti 3 2 Vladiceni 31 2 Vultureni 9 2 Zaplazi 12 2 Zapodea 23 2 Zapodia 12 2 Zavoi 24 2 Zimbru 20 2
You're not signed in. Please sign-in to report an issue or post a comment.