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` = 156) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Wallets Allow Your Brand To Travel
Promotional wallets are a gift item that is multi-purpose marketing tool. You can use it as a traffic builder, customer or employee gift, or contest prize. They are available in many styles, materials, and colours. Typical wallets that might be used in a radio station giveaway or contest are the single fold nylon wallets that are a simple bill holder. They may have a Velcro closure, or zip pouch for coins. Other promotional wallets may be fancier, bi-fold or tri-fold styles, and in other materials such as leatherette or leather. Leather products can also be imprinted with embossing.
There is ample room on the travel wallets for your logo, company or product name, an image, or a message imprint. Production is fast, and the custom printed wallets are very affordable in quantities. They draw attention to your sale, and are an interesting addition to your stock of promotional gift items. These make a nice new customer gift for a store or business that features financial products, sports or travel items.