Wholesale Balloon Distributors

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 , MATCH (item.name,item.description,item.keywords) AGAINST ('' in boolean mode) as score FROM (item join categorymap on item.id = categorymap.itemid) left join image on item.mfg_no=image.mfg_no WHERE item.avail='on' AND (MATCH (item.name,item.description,item.keywords) AGAINST ('' in boolean mode)) OR (item.mfg_no = '') GROUP BY item.mfg_no order by score DESC