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

Gift Ideas

Gifts Ideas From Ideasbynet

Feeling stuck? Don't know what to give your customers at you next promotional event? Then you are in the right place! This page is chock full of gift ideas for every type of company and every budget!

When coming up with gift ideas for your next marketing campiagn you can either look at products that are unique and make you stand out from the crowd, such as our promotional yo yos or puzzles and games or  or stick to more traditional items that have the practicality factor and will be used time and again. Why not invest in promotional pens, promotional mouse mats or laptop bags to achieve this end? 

If you need any help with promotional gift ideas for you next event please do not hesitate to contact us; one of our experienced product team will be delighted to help!