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` = 139) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Pedometers Help Your Business To Stay One Step Ahead
When promoting your company, it is a good idea to consider what needs your target audience might have. It is also a good time to be innovative, but still practical. It is a safe bet that quite a few of your prospective customers might be trying to improve their health. A great way to do so is through the use of promotional pedometers. Pedometers tell the user approximately how many steps he or she has taken that day. Adding steps to your day adds physical activity and therefore burns off excess calories.
So, why not have your company logo printed on the pedometer. If your customers are health conscious and will use the pedometer, then they will have your company in mind as well. Custom printed pedometers are not something many companies give out, but this only increases the possibility that your pedometer will be used. The pedometers will not only keep your company in peoples' minds, but it will also send the message that you care about your customers!