These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Getting number of asteroid belts in a system
Author
Previous Topic Next Topic
Kw1jybo
Sunny Weather Mercenaries
The Initiative.
#1 - 2013-01-04 18:26:12 UTC
Anyone got the sql querry for this?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2013-01-04 19:13:29 UTC
select count(*) from mapDenormalize where typeID=15 and solarSystemID=30001364;

solarSystemID comes from mapSolarSystems if you need to look it up from the name


Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Louis Vitton
Viziam
Amarr Empire
#3 - 2013-01-06 08:07:59 UTC
check here out also help u with further querys
http://wiki.eve-id.net/SQL_Methods_on_the_dump