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` = 86) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Ringbinder Conference Folders
Ringbinder Conference Folders The Ultimate Executive Conference Gift
For any occasions in which your executives will be representing your firm, a classic promotional ringbinder conference folder will be a perfect item to send them off with to ensure they represent your company in the best possible way. Custom printed and complete with your corporate branding, your staff will feel a sense of pride in your company and go on the represent you as a classy and efficient firm.
Our ring bound promotional conference folders have an integrated ring binder mechanism and can include pen loops and additional pockets depending on your specifications. At IdeasByNet, we have multiple folders for you to choose from, both high-end and budget busting alternatives which ensure your company will meet the most exacting of standards and really stand out as a leader in your field.