+44 1904 698815
My basket €0.000 item(s)

Ecopond

Previously named 'Aqua Hydrotech,' 'Ecopond' are a brand well known for their range of more natural and Eco Friendly water treatment products. This means you can trust Ecopond to be kind and safe for your fish in any environment; whether you have a small wildlife pond or a large swimming pond, and whether it's made from stone, wood, plastic or steel - Ecopoond will be kind to any pond or water feature.

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '2' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2' WHERE (`e`.`entity_id` IN(11708, 14599, 14601, 14600))

0 - 4 of 4

Filter By
Help +44 1904 698815, let us help you!

0 - 4 of 4

Filter By
Help +44 1904 698815, let us help you!
Latest from our Blog View Blog