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 = 68 and hide=0 order by cprice desc
Executive Desks | Executive Office Desks | Modern Executive Desks
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 = 68 and hide=0 order by cprice desc