select catid, catname
from MM_CATS
order by catname
select v.variationname, v.inventorycount, v.variationname, p.title, p.shortdescription
from MM_PRODUCTVARIATIONS v, MM_PRODUCTS p
where (v.productid = p.prodid) and p.active = 1 and p.deleted = 0 and p.catid = #getcats.catid#
order by p.title