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` = 116) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Frisbees and Boomerangs Keep Your Customers Coming Back
Promotional frisbees are a fun toy to use for all size events and gatherings. Add your imprinted logo or message, and send your advertisement flying all over the place! Fun, small, lightweight, convenient and desirable, promotional boomerangs and frisbee fill the bill for utility and popularity. They come in different sizes, mini, small or large, and in a variety of colours, and different shapes.
You can have round, three prong or pop out foldable flyers, as well as the more traditional shapes.The boomerang perfectly represents the goal of your marketing, getting the customer to come back to you! There is plenty of room on every item for your message, company name or logo. Phoenix frisbee flyers feature a high gloss finish to highlight your print. The lightweight nylon frisbees are good for a mailing campaign, and fun to use. They also come with individual pouches for storage and mailing convenience.