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` = 62) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Counter Mats
Promotional Counter Mats Offer Exceptional Branding Opportunities
If you are in search of a cost effective way to promote your brand, and one that offers exceptional print areas to get as much information across as possible, then look no further than custom printed counter mats. These super sized promotional giveaways offer an exceptional print area to the surface, and can be custom designed to produce a stunning giveaway which is sure to draw attention to your advertising message.
Manufactured in A3 or A2 sized traditional hard top format, soft mat and now wipe clean armadillo welded counter mats there is an option to suit all requirements. The new tough mark resistant counter mats are perfect for those environments where spillages or dirt and grime can be a problem and as such their longevity is enhanced.
At Ideasbynet we have a team of designers with an abundance of flair, so why not work with them to create a visually stunning set of graphics for your custom imprinted counter mats
and give your next promotion an abundance of inspiration.