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` = 161) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Badges Are One Of The Best Promotional Items Available
Promotional badges are one of the most familiar advertising items available. They have been around for a couple centuries, first used for political statements, and today, some custom printed badges are even collectible. They are popular at events, conventions, and of course for advertising.
There are several types of standard badges you can order, including the standard button badges with a safety pin attachment on the back. Check out our steel badges which carry colour infills and are fitted with a butterfly clutch pin or go for soft enamel photo etched badges which are made on polished metal with up to 4 spot colour infills.
Promotional badges are very affordable in large quantities, and are just right for large meetings, conventions, conferences, school, or government assemblies. You can create a great slogan and sell them at retail for profit, in stores or on the internet.