countries-regions-cities
countries-regions-cities copied to clipboard
Problem with Bangladesh, country id 17
I found two problems.
1. SELECT * FROM regions WHERE regions.country_id=17
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'
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.
and for Moldova, Republic of, same problems
If you search for this pattern:
\((\d+\, \'\')\, \'.+'\, .+\)\,
You will find 502 occurrences matching the pattern: