gas giant record?
- Thread starter seeyouen
- Start date
Deleted member 38366
D
Hard to say...
Scaule YA-D d13-108 for example has 17 Gas Giants.
Scaule YA-D d13-108 for example has 17 Gas Giants.
Looks like the record is 25 gas giants, in "Phleedgoea MY-R e4-365".
Code:
mysql> select systems.name,count(*) from systems,planets where systemId=edsm_id and subType like '%giant%' and planets.deletionState=0 group by systemId having count(*)>10 order by count(*) desc limit 20;
+--------------------------+----------+
| name | count(*) |
+--------------------------+----------+
| Phleedgoea MY-R e4-365 | 25 |
| Eol Prou LX-U e2-1077 | 24 |
| Phleedgoea PD-S e4-121 | 24 |
| Preae Ain CG-X e1-14 | 24 |
| Bleia Dryiae ND-S d4-16 | 23 |
| Phrooe Pre VP-O e6-19 | 23 |
| Phoi Auscs BB-W e2-385 | 23 |
| Bleae Thua FR-N e6-13 | 23 |
| Phrooe Greau MD-S d4-245 | 23 |
| Nuekuae MS-A b17-19 | 22 |
| Phleedgoea LI-S e4-86 | 22 |
| Eord Flyuae SD-B e4335 | 22 |
| Blaa Phoe JX-T e3-26 | 22 |
| TYC 3319-306-1 | 21 |
| Phroi Phreia TZ-X d1-0 | 21 |
| Granau PN-T e3-301 | 21 |
| Pha Aob VO-R e4-1433 | 21 |
| Eol Prou OC-V e2-4184 | 21 |
| Skaude YJ-A f248 | 21 |
| Pyramoe ZA-M d8-38 | 21 |
+--------------------------+----------+
20 rows in set (8 min 29.85 sec)It also looks like we only know of 33 systems with 20+ gas giants. If you can find one with anything in the 20s, it's well into the "less than one in a million" category.
In fact, it also looks like only 223 systems have 17+ gas giants. That's 223 out of 49,241,850 systems in the data, so 0.00045%... which is like 4.5% of one percent of one percent. So pretty darn rare!
Here are the ones with 20+:
In fact, it also looks like only 223 systems have 17+ gas giants. That's 223 out of 49,241,850 systems in the data, so 0.00045%... which is like 4.5% of one percent of one percent. So pretty darn rare!
Here are the ones with 20+:
Code:
mysql> select systems.name,count(*) from systems,planets where systemId=edsm_id and subType like '%giant%' and planets.deletionState=0 group by systemId having count(*)>=20 order by count(*) desc;
+--------------------------+----------+
| name | count(*) |
+--------------------------+----------+
| Phleedgoea MY-R e4-365 | 25 |
| Eol Prou LX-U e2-1077 | 24 |
| Phleedgoea PD-S e4-121 | 24 |
| Preae Ain CG-X e1-14 | 24 |
| Phrooe Pre VP-O e6-19 | 23 |
| Bleia Dryiae ND-S d4-16 | 23 |
| Bleae Thua FR-N e6-13 | 23 |
| Phrooe Greau MD-S d4-245 | 23 |
| Phoi Auscs BB-W e2-385 | 23 |
| Eord Flyuae SD-B e4335 | 22 |
| Phleedgoea LI-S e4-86 | 22 |
| Blaa Phoe JX-T e3-26 | 22 |
| Nuekuae MS-A b17-19 | 22 |
| Skaude YJ-A f248 | 21 |
| Eol Prou OC-V e2-4184 | 21 |
| Phroi Phreia TZ-X d1-0 | 21 |
| Granau PN-T e3-301 | 21 |
| Eol Prou HC-K d9-500 | 21 |
| Pha Aob VO-R e4-1433 | 21 |
| Pyramoe ZA-M d8-38 | 21 |
| TYC 3319-306-1 | 21 |
| Drojuae NK-D d13-6 | 20 |
| Eephaills CL-Y f484 | 20 |
| Wisanye | 20 |
| Eembaids YE-A f3139 | 20 |
| Blu Aescs DQ-N d7-15 | 20 |
| Pyraea Eur RI-T e3-0 | 20 |
| Leamae AL-O e6-800 | 20 |
| Hypuae Scrua BA-Z e474 | 20 |
| Smojue NI-T c3-8 | 20 |
| Aucoks KT-F d12-34 | 20 |
| Greae Flyi MI-S e4-1 | 20 |
| Boesky HG-W d2-856 | 20 |
+--------------------------+----------+
33 rows in set (8 min 30.65 sec)
How many with 16 gas giants?
Looks like another 150, so 373 total with 16+.