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` = 182) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Recycled Sticky Notes
Gain A Big Environmental Green Star With Recycled Promotional Sticky Notes
Recycled promotional sticky notes hit your customers with a double whammy! Not only are sticky notes one of the most popular office supplies of all time, but they'll be all over your potential customer's monitor, desk, and papers. They'll ride reports into other offices, and adorn the frames of dry erase boards in collaborative business meetings. They'll tag leftover lunches in the office refrigerator, and transfer to cross town offices on express courier packages. Essentially, you'll be tagging offices with your company name throughout a building and across a city with one tiny pad of stickies. It doesn't get much more efficient than that!
Plus, they're recycled, so your company name is instantly and forever linked with a big, fat environmental green star. That also lends the user a brief moment of the feel-good fuzziness associated with acts of environmental awareness. You're great, they're great, and a splinter of tree breathes a sigh of relief as he is yet again spared from the paper mill.