Comment 5 for bug 1150109

Turns out our database does know about all of these locations, but our SQL query is buggy.
It was incorrectly joining and discarding locations which have administrative district set to NULL or '00', thus ignoring many locations which happen to be district by themself e.g. Hong Kong, Bangladesh, Mexico etc. Most of them are simply countries, e.g. "Ireland". Overall we were ignoring about 5% of location, but some of them are high profile in terms of population or by virtue of being a capital.