mysql> select systemId,stars.id as edsm_id,stars.name,rings.name as ringname from stars,rings where isStar=1 and planet_id=stars.id and subType in ('A (Blue-White) Star','A (Blue-White super giant) Star') order by stars.name;
+----------+-----------+--------------------------------+---------------------------------------+
| systemId | edsm_id | name | ringname |
+----------+-----------+--------------------------------+---------------------------------------+
| 3451975 | 120866985 | Fine Ring Sector AF-A d12 | Fine Ring Sector AF-A d12 A Belt |
| 411081 | 37997214 | Fine Ring Sector AF-A d77 | Fine Ring Sector AF-A d77 A Belt |
| 475930 | 65424612 | Fine Ring Sector BQ-Y d1 | Fine Ring Sector BQ-Y d1 A Belt |
| 21191047 | 38093021 | Fine Ring Sector CQ-Y d13 | Fine Ring Sector CQ-Y d13 A Belt |
| 468144 | 37682060 | Fine Ring Sector CQ-Y d9 | Fine Ring Sector CQ-Y d9 A Belt |
| 23715074 | 16694101 | Fine Ring Sector CQ-Y d93 | Fine Ring Sector CQ-Y d93 A Belt |
| 7650351 | 37832845 | Fine Ring Sector DL-Y d133 | Fine Ring Sector DL-Y d133 A Belt |
| 14257206 | 56356650 | Fine Ring Sector DL-Y d53 | Fine Ring Sector DL-Y d53 A Belt |
| 567108 | 37593639 | Fine Ring Sector DL-Y d89 | Fine Ring Sector DL-Y d89 A Belt |
| 364279 | 37334032 | Fine Ring Sector DL-Y e19 B | Fine Ring Sector DL-Y e19 B A Belt |
| 13276174 | 5220856 | Fine Ring Sector DQ-Y d9 | Fine Ring Sector DQ-Y d9 A Belt |
| 9929900 | 2310597 | Fine Ring Sector EL-Y d126 | Fine Ring Sector EL-Y d126 A Belt |
| 33102424 | 45533116 | Fine Ring Sector EL-Y d132 A | Fine Ring Sector EL-Y d132 A A Belt |
| 14279682 | 37578762 | Fine Ring Sector EL-Y d139 | Fine Ring Sector EL-Y d139 A Belt |
| 19726576 | 36248390 | Fine Ring Sector EL-Y d48 A | Fine Ring Sector EL-Y d48 A A Belt |
| 10818503 | 2995864 | Fine Ring Sector EL-Y d54 A | Fine Ring Sector EL-Y d54 A A Belt |
| 22260776 | 14523763 | Fine Ring Sector EL-Y d6 | Fine Ring Sector EL-Y d6 A Belt |
| 30611028 | 26579014 | Fine Ring Sector EL-Y d64 | Fine Ring Sector EL-Y d64 A Belt |
| 32092518 | 37493710 | Fine Ring Sector EL-Y d92 | Fine Ring Sector EL-Y d92 A Belt |
| 32203106 | 55554124 | Fine Ring Sector GG-Y d50 A | Fine Ring Sector GG-Y d50 A A Belt |
| 32246989 | 38657125 | Fine Ring Sector GW-W d1-2 | Fine Ring Sector GW-W d1-2 A Belt |
| 10171028 | 130384482 | Fine Ring Sector GW-W d1-22 | Fine Ring Sector GW-W d1-22 A Belt |
| 32094280 | 37511982 | Fine Ring Sector GW-W d1-26 | Fine Ring Sector GW-W d1-26 A Belt |
| 30482644 | 26407359 | Fine Ring Sector GW-W d1-39 A | Fine Ring Sector GW-W d1-39 A A Belt |
| 11708054 | 3822071 | Fine Ring Sector GW-W d1-55 A | Fine Ring Sector GW-W d1-55 A A Belt |
| 35635973 | 69023363 | Fine Ring Sector GW-W d1-78 | Fine Ring Sector GW-W d1-78 A Belt |
| 23054330 | 19937610 | Fine Ring Sector GW-W d1-88 | Fine Ring Sector GW-W d1-88 A Belt |
| 3018464 | 69023360 | Fine Ring Sector GW-W d1-90 A | Fine Ring Sector GW-W d1-90 A A Belt |
| 27811370 | 40613112 | Fine Ring Sector HR-W d1-107 | Fine Ring Sector HR-W d1-107 A Belt |
| 9059957 | 1689092 | Fine Ring Sector HR-W d1-109 A | Fine Ring Sector HR-W d1-109 A A Belt |
| 7502076 | 678764 | Fine Ring Sector HR-W d1-18 A | Fine Ring Sector HR-W d1-18 A A Belt |
| 44097557 | 140417831 | Fine Ring Sector HR-W d1-28 | Fine Ring Sector HR-W d1-28 A Belt |
| 80347 | 37594849 | Fine Ring Sector HR-W d1-31 | Fine Ring Sector HR-W d1-31 A Belt |
| 872813 | 68654829 | Fine Ring Sector HR-W d1-48 | Fine Ring Sector HR-W d1-48 A Belt |
| 367607 | 5338295 | Fine Ring Sector HR-W d1-53 | Fine Ring Sector HR-W d1-53 A Belt |
| 537197 | 37471562 | Fine Ring Sector HR-W d1-54 | Fine Ring Sector HR-W d1-54 A Belt |
| 13344794 | 5284720 | Fine Ring Sector HR-W d1-82 | Fine Ring Sector HR-W d1-82 A Belt |
| 706575 | 92556316 | Fine Ring Sector HR-W d1-9 A | Fine Ring Sector HR-W d1-9 A A Belt |
| 484610 | 37499417 | Fine Ring Sector IR-W d1-12 A | Fine Ring Sector IR-W d1-12 A A Belt |
| 103184 | 4329017 | Fine Ring Sector IR-W d1-142 | Fine Ring Sector IR-W d1-142 A Belt |
| 27972619 | 33056431 | Fine Ring Sector IR-W d1-28 | Fine Ring Sector IR-W d1-28 A Belt |
| 467981 | 32574495 | Fine Ring Sector IR-W d1-39 | Fine Ring Sector IR-W d1-39 A Belt |
| 14401868 | 10358582 | Fine Ring Sector IR-W d1-48 | Fine Ring Sector IR-W d1-48 A Belt |
| 476765 | 37573079 | Fine Ring Sector IR-W d1-58 A | Fine Ring Sector IR-W d1-58 A A Belt |
| 467381 | 935966 | Fine Ring Sector IR-W d1-85 | Fine Ring Sector IR-W d1-85 A Belt |
| 12801543 | 4771594 | Fine Ring Sector JM-W d1-31 A | Fine Ring Sector JM-W d1-31 A A Belt |
| 21097739 | 13180298 | Fine Ring Sector KM-W d1-102 | Fine Ring Sector KM-W d1-102 A Belt |
| 1680066 | 45267488 | Fine Ring Sector MX-U d2-21 | Fine Ring Sector MX-U d2-21 A Belt |
| 497804 | 37280510 | Fine Ring Sector ZE-A d138 | Fine Ring Sector ZE-A d138 A Belt |
| 14718257 | 17488680 | Ring Sector CQ-Y d2 | Ring Sector CQ-Y d2 A Belt |
| 9132707 | 62098617 | Ring Sector EL-Y d12 A | Ring Sector EL-Y d12 A A Belt |
| 13220027 | 5164064 | Ring Sector YJ-A d17 A | Ring Sector YJ-A d17 A A Belt |
+----------+-----------+--------------------------------+---------------------------------------+
52 rows in set (1.59 sec)