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 = 'Middle-east Mythology'
and astercat.id = astermap.id and astermap.nr = astorb_disc2.nr and astermap.nr = asteroids_namesrc5.nr order by nr
| nr
↓
| name
↓
| NameFource
↓
|
| 65 | Cybele | Named for the Phrygian goddess often identified with Rhea {see planet (577)}. (H 10) The planet was |
| 209 | Dido | Dido (also named Elissa) was the daughter of Belus, king of Tyre. Her husband Sichaeus was secretly |
| 214 | Aschera | Named for a goddess of the Sidonians, identified by the Phoenicians with Astarte {see planet (672)} |
| 246 | Asporina | Named for the mother of the gods worshiped at the Asporenus mountain in Asia Minor. (H 30) |
| 672 | Astarte | Named for the Phoenician goddess of love and fertility. (H 69) |
| 1181 | Lilith | Named by the discoverer in honor of the French composer Mme. Marie Juliette Olga ‘Lili’ Boulanger (1 |
| 1812 | Gilgamesh | Named after the hero of an old-Babylonian saga. (M 4547) |
| 2101 | Adonis | This Apollo-type minor planet was named previously for the lover of Aphrodite {see planet (1388)}. |
| 2174 | Asmodeus | Named for the Babylonian god of lust. |
| 4947 | Ninkasi | Named for the Sumerian goddess of wine and beer. She aided the god Lugalbanda in rescuing the tablet |
| 5869 | Tanith | Seen as a heavenly goddess by the conquering Romans who called her Caelestis, Tanith was worshipped |
| 7088 | Ishtar | Named for the chief goddess of the Mesopotamian pantheon and a principal goddess of the Assyrians an |
| 7092 | Cadmus | Named for the son of the Phoenician king Agenor {see planet (1873)}, and the brother of Europa {see |