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` = 231) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Telephone Accessories
Promotional Telephone Accessories Useful Giveaways
When you spend your precious marketing budget on a product for a promotion or a giveaway, you want it to be something that will be useful and used by your client or potential customer. And these days, absolutely everyone has a mobile phone and everyone likes to get new gadgets for them. That's what great about these promotional telephone accessories, everybody will want one. SIM cards, chargers, batteries, mobile phone kits and pouches, they are all here!. And every one with your company or organisations name printed on them.
When you buy promotional items for a giveaway or promotional event, don't waste your money on junk that no one wants or will use. Spend it on these quality promotional telephone accessories and you will attract the crowds and business you want. And that's what your marketing money is for, right? These terrific products come in a great variety of types and styles and are practical for everyone. So don't delay, order these unique custom printed telephone accessories today.