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` = 309) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional iPad Folders - Protect and Brand Your Most Valuable TechPopular, innovative and practical, Promotional iPad Folders are a printed gift your clients will love. Protecting your clients later gadgets, and offering a sizeable print area to showcase your brand, our selection of folders and covers can cater to any price range and any taste. Perfect for many business events, you could take your iPad Folder along to conferences, meetings, or simply around the office, and get your logo seen by hundreds every day.
Browse our range and see the variety of iPad Folders we can offer you, whether you are looking for full colour print, folders perfect for demonstrating video or pictures, or simply for a hard backed cover that will ensure your iPad stays safe, we have you covered.