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` = 247) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Measure Your Marketing Successes With Recycled Promotional Rulers
Make a statement about your protection of our environment, while at the same type developing a creative and useful promotional gift. Recycled promotional rulers are an outstanding way to do both. Customers, clients and your employees will value the gift, practical as it is and useful for a variety of daily tasks. The fact that this ruler is not only a high-quality measuring tool, but also a tribute to the preservation of our globe, makes it a great idea. You can be assured that by giving printed recycled rulers, you are giving an item that is using recycled plastic and contributing to a greener environment.
Because custom imprinted eco-friendly rulers are such a low cost gift, they are perfect for handing out at conferences or exhibitions at which you want to promote your brand. Promotional rulers can also accommodate more of a logo, messages, or company information than most promo items. Use this for situations in which you want to include a short message, phone numbers, or physical address.