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` = 114) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Beach Accessories
Promotional Beach Accessories Fun Advertising Giveaways
If you've hit a slump as far as thinking about ways to promote your company, but you live near a beach, consider giving out promotional beach accessories with your company's name and logo on them. From towels to beach hats, and from umbrellas to water-bottles, you can hand out a wide array of accessories to get people's attention.
Here's how to go about executing your plan: Come into work any day of the week and pull a few trusted employees into your office. Have all the imprinted beach accessories sitting in front of you and announce that they will all be going to the beach for the day. Then tell them that they should be handing out the accessories to beach goers, thereby creating buzz about your company. It's just that easy! You will be amazed at how many new customers you'll get in the following weeks. If you want to promote your company, promotional giveaways are the perfect idea. Not only are they economical, but they always work wonders to generating a buzz about your company.