Wholesale Balloon Distributors

Catalog - Bubbles

select item.name as iname, item.id as iid, item.pricecode as pricecode, categorymap.id as cmapid, categorymap.catid as catid, categorymap.itemid as itemid, item.imageid as imageid, image.id as imid, image.thumb as thumb, item.avail as itemavail, item.mfg_no FROM (item join categorymap on item.id = categorymap.itemid) left join image on item.mfg_no=image.mfg_no WHERE item.avail='on' AND categorymap.catid=12 GROUP BY item.mfg_no order by imid DESC