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` = 249) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Recycled Pencil Cases
Recycled Pencil Cases: Do Your Bit For The Environment
Recyled pencil cases are an excellent way to both promote your business and ensure your company presents an environmentally aware presence. Invest in eco friendly pencil cases for promotiona targeting schools, unversities, office workers, teachers... any one that need to carry pens and pencils around. Make sure that your customers can transport their stationery around in ec friendly style!
Manufactured from recycled tyres, our recylced pencil cases offer a long lasting and effective way to pass on your eco friendly message. Available in a range of trim colours, our range of durable recycled pencil cases is sure to have the perfect product to compliment your brand.