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` = 197) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Metal Clocks
Why Use Metal Clocks In Your Promotional Campaign?
There are a vast number of options available for promotional items, making it easy to customize your marketing campaign. When your aim is to both promote your business and to make your customer feel valued and important, then promotional metal clocks is a great solution to your marketing needs. The elegance of metal framed desk clocks is both upscale and timeless, while not being prohibitively expensive.
A promotional metal clock gracing each desk in your office will give your visitors the impression of prosperity and taste. Alternatively, distribute these clocks to your most valued clients to show them your appreciation, while still getting your company name displayed in a tasteful manner. The imprinting on these clocks can be customised to reflect your company's name and logo, and our product line is varied for all your needs. For more information on incorporating promotional metal clocks into your marketing scheme, please browse our site or contact one of our product specialists for more help.