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` = 222) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Paperweights High Quality Ambassadors For Your Brand
Paperweights are the perfect giveaway to promote your business or organisation. Cost effective and useful to prospective clients, promotional paperweights can be distributed easily to current customers, event attendees and can even be given away as a thank you for the hard work of your employees.
The great thing about imprinted paperweights is the fact that they are durable and will therefore remain in the view of prospective clients for a long time. In addition, paperweights are used to hold down important papers on a desk which means that your message will remain within eyesight of your audience at all times.
Paperweights are cost effective to purchase in bulk, are easy to have printed with your company logo, and will be well received by clients and prospective customers alike. Order your paperweights today and watch your message spread.