select t2,t2name,
time,
mcost/tcost as mper,
icost/tcost as iper,
sellmin,
tcost/portionSize as cost,
portionSize,
sellmin-tcost/portionSize as profit,
(sellmin-tcost/portionSize)*portionSize*3600*24/time as profitADay,
me,pe,sellvol
from t2cost11,sellmin,invtypes,sellvol
where sellmin.typeid = t2cost11.t2
and t2cost11.t2 = invtypes.typeID
and t2cost11.t2 = sellvol.typeid
);
这回源码应该没问题了。
(sellmin-tcost/portionSize)*portionSize*3600*24/time as profitADay,
