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

Tetra

Tetra have been at the forefront of fish food manufacturing since introducing TetraMin in the 1950s, and are famous for their quality fish food and water treatments.

With a wide range of koi sticks, pellets and wheatgerm food, as well as water treatments for everything from greenwater to dechlorination, you can rely on Tetra!

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(15037, 12619, 15036, 13648, 13633, 13875, 13660, 13645, 13630, 12617, 12596, 13657))

1 - 12 of 50

  2. 1
▪▪▪
  1. 5
Filter By
Help +44 1904 698815, let us help you!

1 - 12 of 50

  2. 1
▪▪▪
  1. 5
Filter By
Help +44 1904 698815, let us help you!
Latest from our Blog View Blog