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` = 83) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Laptop Bags
Distributing Promotional Laptop Bags To Increase Brand Visibilty
If you are attending a conference or exhibition, providing your customers and staff with promotional laptop bags can be a brilliant way of promoting your brand and ensuring your company name is firmly etched in your potential customer's head. Laptop bags are great for anybody who owns a laptop to transport their prized possession around; they prevent breakages and scratches to your computer when it is in transit. Presenting your clientele with customised laptop bags will be sure to earn their loyalty; a promotional laptop bag will convey generosity, a reputation that will extend to your brand. Compared to other promotional options printed laptop computer bags offer a durable advertising medium which will go on promoting your brand for many months if not years to come. In addition, laptop computer bags offer an excellent imprint or embroidery area for your logo and brand message providing you with plenty of design flexibility.