relevant items

 SELECT typename,invTypes.typeid,categoryname,COALESCE(valueint,valuefloat,0) meta FROM invTypes JOIN invGroups ON (invTypes.groupid=invGroups.groupid) JOIN invCategories ON (invGroups.categoryid=invCategories.categoryid) LEFT JOIN dgmTypeAttributes ON (invTypes.typeid=dgmTypeAttributes.typeid AND attributeid=633) WHERE COALESCE(valueint,valuefloat,0) <7 AND invGroups.categoryid IN (4,5,6,7,8,10,17,18,20,22,30,32,34,35,39) AND invTypes.published!=0 AND marketGroupID IS NOT NULL