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` = 157) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Time To Look At Promotional Watches For Your Next Promotion
Are you planning a promotion based on a prize giveaway or high end promotional gift? A prize giveaway is always a brilliant way of drawing attention to your brand, but if you do plan on going down this route you need to make sure the prize will be desirable; promotional watches fit this criteria perfectly.
Everybody wants a watch and so for a promotional prize there cannot be a better choice. Giving one of these away, will be a brilliant way to draw people into the company as they desire one of our range of brilliant high-end watches. Offer these custom printed watches and you can be sure your customers will be excited to attend your events and excited about the generosity of your company. IdeasByNet have a range of watches in various styles and colours available in low quantities and are fabulous for increasing your brand awareness.