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` = 132) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Pen Knives - A Cut Above The Rest
Here is an outstanding way to promote your brand: pen knives. Haven't you ever found yourself in that situation where you just need a knife? Most likely, you can think of a recent situation in which that was the case. Promotional items are particularly strategic when they meet a need, create a convenience, and are something that is used or looked at very often. That describes a pen knife.
Pen knives come in handy all day long. Need to open a package? Need to cut a stray thread? Need to open a letter? Need to trim a box down? Need to slice a piece of tape? The possibilities of using a pen knife are endless. That means power for the promotional potential of a pen knife. Your brand identity should be in as many places as possible. Don't overlook the effectiveness of putting your brand's presence on promotional pen knives, too. It is a strategic place that will get a lot of visibility, stimulate a lot of reminders, and place your company a cut above the rest.