select DISTINCT p.catalogid,cprice from products p, prodcategories cc, categories c where cc.intcatalogid=p.catalogid and cc.intcategoryid=c.categoryid and cc.intcategoryid = 72 and hide=0 order by cprice desc Office Chairs | Leather Office Chairs | Executive Office Chairs
select DISTINCT p.catalogid,cprice from products p, prodcategories cc, categories c where cc.intcatalogid=p.catalogid and cc.intcategoryid=c.categoryid and cc.intcategoryid = 72 and hide=0 order by cprice desc
