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` = 181) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Recycled Note Pads
Promotional Recycled Note Pads
Why not look in to having promotional recycled eco note pads at your next conference or event? In our current climate, we are all increasingly aware that we should be doing our bit for the environment, so why not include this ethos in your promotional giveaways? Our?eco-friendly promotional gifts?are a fabulous way of not only promoting your company but also showing your company is aware of environmental issues and doing your bit.?
Our note pads are available in many styles, including the self post styles. They can be glued, stitched or stapled for bindings, or put into notebooks by having pre-drilled holes punched. Recycled environmentally friendly note pads let your colleagues and clients know that you care. Our notepads come in a array of sizes and thicknesses and can include tab inserts and covers, all designed to match your company message and ethos.