Eve SQL of note: Difference between revisions

From Federal Burro of Information
Jump to navigationJump to search
(New page: show Power Grid and Cpu requirements for station bits: <pre> SELECT t.typeName, a30.valueInt AS PG, a50.valueInt AS CPU FROM invTypes t LEFT JOIN dgmTypeAttributes a30 ON t.typeID = a30.t...)
 
No edit summary
Line 15: Line 15:
</pre>
</pre>
taken / adjusted from http://wiki.eve-id.net/Category:Database_Example_Queries
taken / adjusted from http://wiki.eve-id.net/Category:Database_Example_Queries
show what you get if you refine an aferburner:
<pre>
select
      t.typeName as 'Refine',
      components.quantity,
      components.requiredTypeID,
      r.typeName as 'Get'
from
      invTypes t
      left join TL2MaterialsForTypeWithActivity components on
t.typeID=components.typeID
      inner join invTypes r on r.typeID=components.requiredTypeID
where
      t.typeID=439
      and t.published=1
      and r.published=1
order by components.requiredTypeID
</pre>

Revision as of 23:35, 11 January 2009

show Power Grid and Cpu requirements for station bits:

SELECT t.typeName, a30.valueInt AS PG, a50.valueInt AS CPU
FROM invTypes t
LEFT JOIN dgmTypeAttributes a30 ON t.typeID = a30.typeID
LEFT JOIN dgmTypeAttributes a50 ON t.typeID = a50.typeID
INNER JOIN invGroups g ON t.groupID = g.groupID
WHERE g.categoryID =23
AND a30.attributeID =30
AND a50.attributeID =50
AND t.published =1
ORDER BY a30.valueInt DESC 
LIMIT 0 , 30

taken / adjusted from http://wiki.eve-id.net/Category:Database_Example_Queries

show what you get if you refine an aferburner:

select
       t.typeName as 'Refine',
       components.quantity,
       components.requiredTypeID,
       r.typeName as 'Get'
from
       invTypes t
       left join TL2MaterialsForTypeWithActivity components on
t.typeID=components.typeID
       inner join invTypes r on r.typeID=components.requiredTypeID
where
       t.typeID=439
       and t.published=1
       and r.published=1
order by components.requiredTypeID