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` = 141) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Radios - Stay In Tune With Your Customers & Employees
Promotional radios are an excellent way to market your company identity and to stay in tune in the wide world of promotional gift ideas. Radios are small, portable, and something that just about everyone wants to have. With your company logo printed on the radio, your identity is sure to be seen with the frequent use of the radio.
Custom printed radios are stylish and compact, and there are a variety of options to choose from. Although most promo radios are compact and portable, there are several other size options available. Desk radios are one great option. Give your customers or employees a gift that they'll not only want to use once a day, but something they will want to use all day!
These well-loved gifts can be used to thank your customers or can be used as incentives for hard-working employees. Whatever your need, your company is sure to be noticed and appreciated when you use promotional radios.