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` = 217) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Money Boxes
Promote Customer Savings With Promotional Money Boxes And Piggy Banks
In the midst of the current economic crisis, what's the one message you would like to give to customers? That you are going to help them make savings and our promotional money boxes do just that! Money boxes and piggy banks send the message that you are aware of the current sqeeze to everyone budgets and want to do what you can to help. Especially great for banks and investment companies, promotional money boxes are a fun and practical giveaway for adults and children alike.
People are weary and are very distrustful of big business right now and are trying that little bit harder to save their pennies. This is the prime time for big businesses to reconnect and try and regain some trust from the public. Handing out custom printed money boxes or piggy banks is a wonderful conversation starter and people will be genuinely surprised and delighted with their gift. This is a splendid chance for you to elevate your company above the rest.