SELECT SQL_CALC_FOUND_ROWS * ,LEAST(IF(price1_1 > 0, (price1_1 * (1-(discount/100))),9999), IF(price2_1 > 0, (price2_1 * (1-(discount/100))),9999), IF(price3_1 > 0, (price3_1 * (1-(discount/100))),9999), IF(price4_1 > 0, (price4_1 * (1-(discount/100))),9999), IF(price5_1 > 0, (price5_1 * (1-(discount/100))),9999), IF(price6_1 > 0, (price6_1 * (1-(discount/100))),9999)) AS priceMin FROM `jos_virtuemart_products_en_gb` as l JOIN `jos_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `jos_productPrices` ON p.`virtuemart_product_id` = `jos_productPrices`.`product_id` LEFT JOIN `jos_productDetails` ON p.`virtuemart_product_id` = `jos_productDetails`.`product_id` LEFT JOIN `jos_virtuemart_product_categories` ON p.`virtuemart_product_id` = `jos_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_categories_en_gb` as c ON c.`virtuemart_category_id` = `jos_virtuemart_product_categories`.`virtuemart_category_id` WHERE ( p.`published`="1" AND `jos_virtuemart_product_categories`.`virtuemart_category_id` = 143) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC

Promotional Sewing Kits

Promotional Sewing Kits Make For Practical Low Cost Giveaways

Promotional sewing kits are a brilliant little marketing and sales tool. With several styles available, in a multitude of sizes, there will definitely be a perfect little functional and fun promotional giveaway here for your company. The most popular promotional sewing kits are of course the miniature kits that can be slipped into a pocket, handbag or purse and be on hand for those little emergencies, with these kits available to buy for less than a pound its hard to go wrong! Complete the kit with your company name or logo and you have a handy little promotional token that will really spread the word about your company.?

Most kits are complete with a selection of needles and thread; some even include small sewing scissors, a device to help thread the needle and even a mirror and safety pins. The fact that there are these many products in such a small, compact little kit makes for a great travel item. The kits can be found in hard or soft cases and are an excellent little giveaway for employees that travel a lot. A small token of appreciation for all their hard work whilst also getting your company name recognised further afield.