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` = 87) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Get Quote fixed at Live Price
Thank You for your enquiry!We will be in touch soon
Product: Fuel nowPower Banks
Live price deal
Min. 1000 per order
For info or to order call0844 8117 566or email: email@example.com
Standing head and shoulders above other promotional products, the Fuel nowPower Bank offers a battery saving service for your smart phone. A powerful 2200mAh charge means you can power a smartphone battery as if it were fully charged, and brand the Fuel with a 2 colour print, or engraving to one position.(For best results, users are advised to use the charging cables supplied with their model of phone or device) With a new emphasis on devices being powered-on at Airport Security, these Power Banks could make all the difference if you want to take your phone on holiday! Individually card boxed with instructions and charging cable. NB. Powerbanks may require initial charging before use.
1-2 Colour Print or Engraved
There is a screen setup cost of £26.75 per position/ imprint type.
94 X 22 X 21 mm
65 x 1 5 mm
Black / Silver / Red / Green / Blue / Gold / Purple /Pink