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 = 80 and hide=0 order by cprice desc
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 = 80 and hide=0 order by cprice desc