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

Promotional Sports Bottles

Promotional Sports Bottles Always Hit The Mark

Choosing promotional sports bottles for inclusion in your marketing giveaway campaign is always a great choice. They're available in a wide range of colours, sizes and styles and provide a certain visibility other marketing promotions might not deliver. They're break resistant, affordable and they're always a favourite as a giveaway item. Logo placement is easy as they have a great print area and, because they're durable, they're easy to store until that next job fair or sales convention.

Promotional sports bottles are available in a multitude of colours, which bodes well with those wishing to coordinate their marketing gifts with their company colours and logos, web addresses and phone numbers. It's all about visibility. And as always, quality is first and your satisfaction is guaranteed. Your company's message is sure to hit the mark time and again with any of the sports and drink bottles from our range. And don't forget about our great team of customer service representatives- they're here to ensure you're pleased with every order placed through Ideasbynet.