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` = 84) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Leather Conference Folders
Leather Conference Folders The Classy Promotional Gift
The promotional leather conference folder is an ideal corporate gift for any company giveaway. These beautiful folders are classy and elegant and any recipients are sure to feel an affinity to a company that supplied them with such a quality gift. Leather folders are a highly durable product when compared to other category options such as PU, microfibre or vinyl and retain their original feel and look for a far greater period of time. These custom printed or embossed conference folders are far more durable and able to carry a greater load documents without losing their shape. The value of them is simply in their added durability, appeal and long life span which means your initial cost outlay is well rewarded in the long term.
At IdeasByNet we have a wide range of promotional folders to meet all budgets, but it is our leather product range which meets the high demands of discerning customers requiring that extra touch of quality for their marketing campaigns.