countries-regions-cities icon indicating copy to clipboard operation
countries-regions-cities copied to clipboard

Problem with Bangladesh, country id 17

Open abedeenpro opened this issue 7 years ago • 2 comments

I found two problems. 1. SELECT * FROM regions WHERE regions.country_id=17 image Bangladesh has 7 Division, though soon it may be 8. But U seen first row Name is empty.

2. SELECT *FROM cities INNER JOIN regions ON cities.region_id = regions.id WHERE cities.name = 'Dumuria' image City Dumuria has repeated 3 times. Though there is only one Dumuria, it is in Khulna. And same problem, One region name missed. Tough Dumuria is not city but it can be considered.

I have not checked any other.

abedeenpro avatar Jan 07 '18 15:01 abedeenpro

and for Moldova, Republic of, same problems

vodnicearv avatar Apr 04 '18 16:04 vodnicearv

If you search for this pattern: \((\d+\, \'\')\, \'.+'\, .+\)\, You will find 502 occurrences matching the pattern: image

Warafux avatar Nov 07 '18 11:11 Warafux