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` = 125) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC

Promotional First Aid Kits

Promotional Bottles First Aid Kits To Your Marketing Rescue

First aid kits are a unique item to use for marketing purposes. They can be miniature to full size kits, kits for camping, or kits for travel. They include basic needs for first aid treatment, and sterile packaging of items like bandages. Some promotional first aid kits are contained in plastic boxes, and others can be packaged in zip pouches. You will be able to have an imprint on the container, and some, like boxes or pouches, will have a considerable size for your message.

There are basic first aid kits, and specialty kits like sports oriented kits, or camping and survival kits. Some action sport kits will have things like ear protectors, ponchos, and sun block in them also. There are many sizes of custom printed first aid kits, large to mini. There are kits that are attached to a lanyard for wearing around the neck, good for hikers or bikers. Some are encapsulated in waterproof containers, for boating use. Some are small enough to be part of a keychain, while others are full size kits. Whatever your requirements we are sure to be able to cater to meet them.