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` = 142) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Create Some Noise About Your Brand With Promotional Rattles
Make some noise at your next sales event with promotional rattles and clappers. These colourful and noisy items will put your message or logo in everyone's hands as they rouse up the crowd and cheer on their team in style.
Made from durable materials, promo rattles are great for sales or team spirit rallies, sports events, or conventions and they come in wide choice of colours to compliment your branding. Print your company or product name, or logo on these promotional rattles and hand clappers and send a message to all that your business means business. Give them out at large meetings or events and add some excitement to the gathering. Planning a big corporate party? Promotional clappers and rattles are the right accessory to hand out when people arrive at the door. Be sure to consider adding these fantastic and fun products to your marketing gift list for the year. There is always a party going on somewhere and your message should be a part of the fun!