46
The Dog & Duck / Flu
« on: April 14, 2009, 10:57:35 PM »
Gonna be in/out for the next couple of days - will be around for a few hours at a time as the drugs kick in - drop me a line if there's anything urgent.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
select
typeName, quantity as "ZydQuantity"
from
typeActivityMaterials
join
invTypes
on invTypes.typeID = typeActivityMaterials.typeID
where
requiredTypeID = 39
and quantity > 10
and activityID=6
and published = 1
and volume <= 51
and (
(typeName not like '%II%')
and (typeName not like '%Sanshas%')
and (typeName not like '%Blood%')
and (typeName not like '%Modified%')
and (typeName not like '%Dread%')
and (typeName not like '%Gist%')
and (typeName not like '%Pith%')
and (typeName not like '%Coreli%')
and (typeName not like '%-Type%')
and (typeName not like '%Domination%')
and (typeName not like '%Navy%')
and (typeName not like '%Fleet%')
and (typeName not like '%Ore%') )
order by
quantity desc