mysql> select c.title_en from countries c left join cities ci ON ci.country = c.id AND ci.geonames_fcode = 3 where ci.title_en is null;
+----------------------------------------------+
| title_en |
+----------------------------------------------+
| Netherlands Antilles |
| Antarctica |
| American Samoa |
| Aland Islands |
| Saint-Barthelemy |
| Bhutan |
| Bouvet Island |
| Cocos Islands |
| Christmas Island |
| Western Sahara |
| Grenada |
| South Georgia and the South Sandwich Islands |
| Guam |
| Heard Island and McDonald Islands |
| Israel |
| British Indian Ocean Territory |
| Saint Lucia |
| Northern Mariana Islands |
| Montserrat |
| Norfolk Island |
| Nauru |
| Pitcairn |
| Puerto Rico |
| Palestinian Territory |
| French Southern Territories |
| Tokelau |
| Tonga |
| United States Minor Outlying Islands |
| Vatican |
| Saint Vincent and the Grenadines |
| U.S. Virgin Islands |
| Wallis and Futuna |
+----------------------------------------------+
32 rows in set (1.30 sec)