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 = 19 and hide=0 order by cprice desc
Occasional Tables | Occasional Table | Occasional Table Set
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 = 19 and hide=0 order by cprice desc