mysql select title_en from countries left join cities ci ON ci country

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
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)