lorien lorien web tripster ru code rating myt select title_en name geo

 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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
lorien@lorien /web/tripster.ru/code/rating $ myt 'select c.title_en, a.name, c.geoname_id, a.lang, a2.name, a2.lang from cities c left join alternames a on a.geoname_id = c.geoname_id and a.lang = "ru" left join alternames a2 on a2.geoname_id = c.geoname_id having a.name is null limit 50'
+-----------------+------+------------+------+--------------------+------+
| title_en | name | geoname_id | lang | name | lang |
+-----------------+------+------------+------+--------------------+------+
| l'Aldosa | NULL | 3040140 | NULL | NULL | NULL |
| l'Aldosa | NULL | 3040141 | NULL | NULL | NULL |
| Umm al Qaywayn | NULL | 290594 | NULL | Um al Quweim | |
| Umm al Qaywayn | NULL | 290594 | NULL | Umm al Qaiwain | |
| Umm al Qaywayn | NULL | 290594 | NULL | Umm al Qawain | |
| Umm al Qaywayn | NULL | 290594 | NULL | Yumul al Quwain | |
| Ra's al Khaymah | NULL | 291074 | NULL | Julfa | |
| Ra's al Khaymah | NULL | 291074 | NULL | Khaimah | |
| Ra's al Khaymah | NULL | 291074 | NULL | Rās al Khaima | |
| Ra's al Khaymah | NULL | 291074 | NULL | Ras al Khaimah | |
| Khawr Fakkan | NULL | 291696 | NULL | Fakkān | |
| Khawr Fakkan | NULL | 291696 | NULL | Khawr al Fakkān | |
| Khawr Fakkan | NULL | 291696 | NULL | Khor al Fākhān | |
| Khawr Fakkan | NULL | 291696 | NULL | Khor al Fakkan | |
| Khawr Fakkan | NULL | 291696 | NULL | Khorfakan | |
| Khawr Fakkan | NULL | 291696 | NULL | Khor Fakhan | |
| Khawr Fakkan | NULL | 291696 | NULL | Khor Fakkān | |
| Khawr Fakkan | NULL | 291696 | NULL | Port Khor Fakkan | |
| `Ajman | NULL | 292932 | NULL | Al Ajman | |
| `Ajman | NULL | 292932 | NULL | `Ujmān | |
| Kuhestan | NULL | 1120483 | NULL | Kōhistān | |
| Kuhestan | NULL | 1120483 | NULL | Kohsān | |
| Kuhestan | NULL | 1120483 | NULL | Kuhsan | |
| Kuhestan | NULL | 1120483 | NULL | Kūhestān | |
| Tokzar | NULL | 1120487 | NULL | Kala Sangchārak | |
| Tokzar | NULL | 1120487 | NULL | Qala Sangcharak | |
| Tokzar | NULL | 1120487 | NULL | Qal`eh Sangchārek | |
| Tokzar | NULL | 1120487 | NULL | Sangcārak | |
| Tokzar | NULL | 1120487 | NULL | Sangcharak | |
| Tokzar | NULL | 1120487 | NULL | Tākzār | |
| Tokzar | NULL | 1120487 | NULL | Tuksar | |
| Tokzar | NULL | 1120487 | NULL | Tukzār | |
| Zendeh Jan | NULL | 1120711 | NULL | Fus̄anj | |
| Zendeh Jan | NULL | 1120711 | NULL | Fūshanj | |
| Zendeh Jan | NULL | 1120711 | NULL | Zenḏajān | |
| Zendeh Jan | NULL | 1120711 | NULL | Zindajān | |
| Zendeh Jan | NULL | 1120711 | NULL | Zendeh Jān | |
| Zarghun Shahr | NULL | 1120863 | NULL | Katāwāz | |
| Zarghun Shahr | NULL | 1120863 | NULL | Khayṟ Kot | |
| Zarghun Shahr | NULL | 1120863 | NULL | Khayr Kūṯ | |
| Zarghun Shahr | NULL | 1120863 | NULL | Zaraghūn S̄ahr | |
| Zarghun Shahr | NULL | 1120863 | NULL | Zaṟgūns̄ahr | |
| Zarghun Shahr | NULL | 1120863 | NULL | Zargun Shahr | |
| Zarghun Shahr | NULL | 1120863 | NULL | Zaṟghun Sahr | |
| Zareh Sharan | NULL | 1120879 | NULL | Sharan | |
| Zareh Sharan | NULL | 1120879 | NULL | Sharnah | |
| Zareh Sharan | NULL | 1120879 | NULL | Sherana | |
| Zareh Sharan | NULL | 1120879 | NULL | Sheranna | |
| Zareh Sharan | NULL | 1120879 | NULL | Zara Šaran | |
| Zareh Sharan | NULL | 1120879 | NULL | Zara-Sharan | |
+-----------------+------+------------+------+--------------------+------+