Wholesale Balloon Distributors

Catalog - Weights

We're just starting to get the items in this category online. Please call if you can't find what you're looking for.

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=9 GROUP BY item.mfg_no order by imid DESC