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` = 220) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Paper Clips
Promotional Inexpensive & Cost Effective Advertising
Think about it. Think of something that everybody needs in their office all the time and yet no one seems to have enough of? That's right, paper clips. Buy these great promotional paper clips that come in a custom container printed with your company name, and your clients and potential customers will think of you and thank you every day. And isn't that what advertising is for? Spend a little on these custom printed paper clips and reap the benefit every time your customers need to put some papers together.
If you want an inexpensive and cost effective way to advertise your company, business or organization, there are not many ways that will be better or smarter than these paper clips. Promotional items like these are only effective if they stay in front of your client and looked at or used often. And these boxes of paper clips will stay on the desk of the prospect or client and used all day long. What better value can you get for your marketing dollar than that?