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` = 308) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Desk Tidy Gadgets
Desk Tidy Gadgets - Practical Promotional Gifts, With Desk Top Branding Power
Taking control of the desk real estate available in your client's offices is a tricky business, that's why we've come up with a range that can help your clients make better use of their office space, and help you make better use of one of the most valuable branding areas in a business. Our collection of branded desk tidy gadgets, can help square away cables, hold mobile phones in place, and keep your pens nicely ordered, all with the added value of your logo being visible for those all important hours of 9 to 5.
Why not put together a package for your new starters? Or simply offer your clients an easy way to get organised, if you can't see anything suitable why not give one of sales staff a ring and find out what else we can do for you. If you want to see any of the products in action you could always talk to one of our Camsultants, who are ready to chat to you right now.