select astorb_disc2.nr, asteroids_namesrc5.name, SUBSTRING(COALESCE(asteroids_namesrc5.src3, asteroids_namesrc5.src0),1,100) as `NameFource` FROM astorb_disc2, asteroids_namesrc5, astermap, astercat WHERE astermap.id <> 'sittt' and astercat.eng = 'Japanese Mythology'
and astercat.id = astermap.id and astermap.nr = astorb_disc2.nr and astermap.nr = asteroids_namesrc5.nr order by nr
| nr
↓
| name
↓
| NameFource
↓
|
| 1374 | Isora | This name is a combination of the word “Isor” (which is the backward form of the feminine name “Rosi |
| 1532 | Inari | One of the principal lakes of Finland. (M 3929) |
| 3178 | Yoshitsune | Named for one of the most famous and tragic Japanese military commanders, Minamoto Yoshitsune (1159– |
| 5744 | Yorimasa | Named for a Japanese military commander and well-known poet in the late Heian era, Minomoto-no Yorim |
| 10154 | Tanuki | Lake Tanuki is an artificial pond to the east of Mt. Fuji. Amateur astronomers gather at its shores |
| 10227 | Izanami | Izanami-no-mikoto is the mythical goddess who descended to the island Onogoro with the god Izanaki a |
| 10353 | Momotaro | In a Japanese folk tale Momotaro, the Peach Boy, came out of a big peach and fought off ogres with h |
| 10627 | Ookuninushi | The mythical Japanese god Ookuninushi-no-mikoto created the land, together with the god Sukunabikona |
| 10831 | Takamagahara | Takamagahara was the heaven that appears in Japanese ancient myth. The place was ruled by the goddes |
| 44711 | Carp | The Hiroshima Toyo Carp, founded in 1949, is a professional baseball team. Operated with capital fr |
| 162173 | Ryugu | Ryugu is the undersea palace of the Dragon God. In a Japanese legend, a fisherman was rewarded with |
| 163693 | Atira | Atira is the Pawnee goddess of Earth and the evening star. This is the first numbered minor planet |