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

Eco Promotional Gifts

Recycled Environmentally Friendly Promotional Products

Now, your advertising campaigns can also reflect your ecological conscience. Ideasbynet have a large range of high-quality promotional gifts, designed with the environment in mind.

Our eco-friendly products are manufactured from recycled materials and our branding process utilises organic inks. You can still expect the same vibrant colours and durability of our other items while safe in the knowledge you are doing your part for the planet!
Decided on promotional pens, rulers or calendars? Why not check out the eco-friendly options available and add another dimension to you marketing message ? presenting your company as environmentally friendly.

Get more information about how our company can give you the items you need in an environmentally friendly way by emailing or calling our customer service team. We can give you quick quotes on cost and time as well as detailed information on our recycled environmentally friendly products.