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` = 201) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC

Promotional Computer Gift Sets

Promotional Computer & IT Gift Sets Get Your Message Noticed Around The Office

If you are looking for a promotional item that will be valued and remembered for a long time, you need to buy some of these promotional computer gift sets. These gift sets are priced so they won't break your marketing budget but contain quality equipment and come in a high quality presentation case. These great quality custom printed computer gift sets will be a great giveaway for the techie on your contact list or as prizes at your next show or presentation.

These super IT related giveaways can be custom imprinted with the name of your company or organization, so the recipient will think of your business every time they use the handy tools and accessories packed into these quality cases. These great gift sets come packed with all the gear an IT guy needs to get the job done and can be bought in quantities as few as 10. Spend your marketing money wisely and buy quality giveaways. To find out more about these fantastic promotional products simply browse our website or contact one of our product specialists.