EVE Technology Lab

Hi,

I am trying to get a list of all materials with quantity needed to produce a Tech2 item.

I already found out that the correct amount of materials needed seems not to be directly accessible through eve static datadump and has to be calculated by substracting the Tech1 Materials.

So i came out with something like this:

SELECT B.typeName, GREATEST( 0, T2iTM.quantity - COALESCE(T1iTM.quantity, 0)) AS quantity
FROM invTypeMaterials T2iTM
LEFT JOIN invTypes A ON A.typeID = T2iTM.typeID
LEFT JOIN invTypes B ON B.typeID = T2iTM.materialTypeID
LEFT JOIN invMetaTypes iMT ON iMT.typeID = T2iTM.typeID
LEFT JOIN invTypeMaterials T1iTM ON T1iTM.typeID = iMT.parentTypeID AND T1iTM.materialTypeID = T2iTM.materialTypeID
WHERE A.typeName like "heavy missile launcher ii"

resulting in:

typeName | quantity

---

Tritanium | 396
Pyerite | 636
Mexallon | 19
Morphite | 4

By checking the values with these ingame there are 2 Nocxium missing. It also wont appear on Extra Materials.

Am i missing something ore is there a better way to obtain a correct material list?

Thanks in advance!

Right.
Wasted hours asking search engines researching this problem and the problem was I am an idiot and can not read.

Thanks alot for letting me know.

Indeed i linked the Assault missile launcher ingame and always clicked on this link to check.
Above query seems to work fine.