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` = 195) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promote Your Brand with Promotional Calendars
The absolute best way to promote and advertise your business is with promotional calendars. These great marketing pieces are printed with your name and logo and are a terrific advertising piece that will give you a return on your investment many times over again. Many give away items just get thrown in a drawer and forgotten, but this is not the case with calendars. They will be hung on the wall and looked at over and over for the next twelve months.
Who doesn't need a calendar, and what office doesn't have one hanging on the wall? Think about it, buy these custom printed calendars once and put your name in front of your clients and prospects for a full year. There are few promotional ideas that give a better value than imprinted promo calendars, so order yours today. These beautiful calendars come custom printed with your company name and logo and for a fraction of other advertising methods will keep your company or business name in front of your customers or potential customers for a full year.