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

Conference Folders

Conference Folders - An Innovative Way for Business Promotion

Custom printed promotional conference folders are one of the most popular and innovative products businesses and organisations turn to when seeking out a marketing aid. When attending a conference, exhibition or seminar, conference folders are one of the first items an attendee is given on their arrival. Usually these folders which are printed or embossed with corporate details and contain all the relevant material that is likely to be required during the event, and are often updated by the recipient on an ongoing basis. A quality conference folder will be used on a regular basis and will increase the visibility and perception of the brand in a stylish and professional manner.

There are many conference folder options to choose from including popular choices such as PU or leather, many come with additional items such as ringbinders, calculators and zipped outers for added utility. Whatever your requirements are, at Ideasbynet you will find a wide range from low cost budget through to executive leather folders for the discerning client.