select *, minprice startingprice from product where iscoke <> '1' and productname not like '%discontinued%' and minprice > 0 and productid in ( select productid from category c , productcategory pc where c.categoryid=pc.categoryid and categoryname='glass' )