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` = 224) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Pencil Cases
Promotional Pencil Cases Not Just For School Promotions
Children, historically, have used pencil cases for school. These carryalls are ideally suited for companies who want to access the youth market. Every time a school item is removed or returned, your business is advertised. Promotional pencil cases hold more than just pencils, though. Imagine people carrying them around a trade show emblazoned with your company's logo. They are ideal for stowing a myriad of small items. Everyone fills these cases with rubber bands, paper clips, business cards...and, sometimes, even pencils! There is always a use for a pencil case and your clients will love them.
Highly popular nylon pencil cases are highly resilient, and withstand mould and mildew. The eye-catching colours include blue, navy, yellow and red and are perfect for school related promotions. PVC cases shine in blue, black, yellow, red, white and clear. If you are tired of the same old message, imprinted recycled pencil cases will provide an eco-friendly spin to any advertising or marketing campaign.