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` = 199) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Wall Clocks
Promotional Wall Clocks Get Your Brand Noticed
If you are looking for a really brilliant way to get you brand noticed you should seriously consider investing in some promotional wall clocks to hand out to your customers. Not only is this an extremely effective way to make sure you brand is notice (how many times do you look at the clock throughout the day?!) but is its also inexpensive. A brilliant way to make sure your brand is noticed throughout your chosen industry but also a lovely way to say thank you to staff and customers with a useful gift.
When you customers receive their wall clock it is sure to be used for years to come. When a clock is hung, how frequently does it get changed? Not very, and you can be sure people will be checking the time throughout the day and in every instance seeing your brand name. This will create an affinity towards your company and provide you with invaluable promotion.