^ DbQuery {#2656
  #query: array:9 [
    "type" => "SELECT"
    "select" => array:3 [
      0 => "pc.*, IF(pc.`id_customer`, CONCAT(c.`firstname`, ' ', c.`lastname`), pc.customer_name) `customer_name`, pcc.`display_name`, pcc.`avatar`"
      1 => """
        (\r\n
                SELECT COALESCE(NULLIF(pcl.content, ""), pol.content) \r\n
                FROM `pbas_ets_rv_product_comment_lang` pcl \r\n
                LEFT JOIN `pbas_ets_rv_product_comment_origin_lang` pol ON pol.id_ets_rv_product_comment = pcl.id_ets_rv_product_comment\r\n
                WHERE pcl.id_ets_rv_product_comment = pc.id_ets_rv_product_comment \r\n
                AND pcl.id_lang = 3\r\n
                LIMIT 1\r\n
            ) AS content
        """
      2 => """
        (\r\n
                SELECT COALESCE(NULLIF(pcl.title, ""), pol.title) \r\n
                FROM `pbas_ets_rv_product_comment_lang` pcl \r\n
                LEFT JOIN `pbas_ets_rv_product_comment_origin_lang` pol ON pol.id_ets_rv_product_comment = pcl.id_ets_rv_product_comment\r\n
                WHERE pcl.id_ets_rv_product_comment = pc.id_ets_rv_product_comment \r\n
                AND pcl.id_lang = 3\r\n
                LIMIT 1\r\n
            ) AS title
        """
    ]
    "from" => array:1 [
      0 => "`pbas_ets_rv_product_comment` pc"
    ]
    "join" => array:2 [
      0 => "LEFT JOIN `pbas_customer` `c` ON c.`id_customer`=pc.`id_customer`"
      1 => "LEFT JOIN `pbas_ets_rv_product_comment_customer` `pcc` ON c.`id_customer`=pcc.`id_customer`"
    ]
    "where" => array:4 [
      0 => "pc.`question`=0"
      1 => "pc.`deleted`=0"
      2 => "pc.`validate`=1"
      3 => """
        (\r\n
                pc.publish_all_language = 1 \r\n
                OR 1 > 0 \r\n
                OR EXISTS (\r\n
                    SELECT 1 FROM `pbas_ets_rv_product_comment_publish_lang` ppl \r\n
                    WHERE ppl.`id_ets_rv_product_comment` = pc.`id_ets_rv_product_comment` \r\n
                    AND ppl.`id_lang` = 3\r\n
                )\r\n
            )
        """
    ]
    "group" => array:1 [
      0 => "pc.id_ets_rv_product_comment"
    ]
    "having" => []
    "order" => array:1 [
      0 => "pc.`id_ets_rv_product_comment` DESC"
    ]
    "limit" => array:2 [
      "offset" => 0
      "limit" => 8
    ]
  ]
}
Home
Brands
Best Sellers
Joint de compartiment pour Filtre Joint tête pour Filtre SERA Fil Bioactive 250 au 400+UV et UVC-Xtreme 800/1200

Reference: SE-30612

Brand: SERA

Filter media compartment seal - SERA Fil Bioactive 250 filter at 400+UV and UVC-Xtreme 800 or 1200

Compartment seal (basket) for the sera Fil Bioactive 250, 250+UV, 400+UV and UVC-Xtreme 800/1200 external filter.
€4.50
More Filter media compartment seal - SERA Fil Bioactive 250 filter at 400+UV and UVC-Xtreme 800 or 1200
All best sellers

Customer reviews

5.0 rating of 1 review
J
Jean-Christophe R.
5 days ago
Very satisfied
I use these collars on my French Bulldogs and so far I am very happy with them!
BIOVETOL Insect Repellent Dog Collar
View all customer reviews

  • Banner

Filtration aquarium
Aquarium Filtration: Internal Filter or External Filter

Filtration aquarium

The role of the aquarium filter is to mechanically clean the water of its suspended particles, through different filter masses and especially to host purifying bacteria which, as part of the nitrogen cycle, will transform harmful substances (fish droppings, food scraps, pieces of plants) into substances tolerable for the fish.
A filter guarantees clear, crystal-clear water and good oxygenation for your fish and allows you to delay water changes but does not eliminate them in any way.

HOW TO CHOOSE YOUR FILTER?

The main characteristics of a filter are the flow rate and the total volume of filtration media . This information can be found in the characteristics of each product on the site.
Manufacturers also offer a wide variety of filter media available for each filter. These generally include wadding (perlon) for mechanical water filtration, synthetic foams, and ceramic noodles in which purifying bacteria will settle. Chemical filter media such as activated carbon can also be found to eliminate unpleasant odors and is highly recommended after treatment in the aquarium (fish diseases, anti-algae).

THE DIFFERENT TYPES OF FILTER:

In order to meet all aquarist needs, there are a large number of filtration systems: exhaust filter , internal filter , external filter , suspended filter , ultraviolet filter , etc.

Internal and external filters are the most commonly used devices in aquariums:

- The foam filter , also called an exhauster , is useful for small capacity aquariums (under 40 liters) or aquariums intended for breeding. It is not connected to an electrical outlet but positioned on the air pump. It filters by mixing the water.

- The internal filter , also called "interior filter", is placed inside the aquarium. It is very easy to install and particularly suitable for small aquariums. However, it is criticized for the space it takes up in the aquarium and its low filtration volume. For aquariums larger than 100 or 120 liters, prefer the external filter.

- The external filter , also called "external filter", is placed outside the aquarium, in the cabinet or next to the cabinet. The advantages of the external filter are multiple: large filtration volumes, preservation of the fish's living space, easy cleaning operation.

- The hanging filter is a hybrid variant between external and internal filtration used for small tanks or tanks requiring low filtration such as for shrimp maintenance or a hospital tank.

- The settling tank is becoming more and more widespread, especially for aquariums of a certain standing and a volume generally greater than 300 liters. It is a block, placed in a corner of the aquarium or outside the aquarium (requires drilling of the tank) and in which we find a good part of the equipment, such as the pump , the filtration masses and the heater .

Active filters
Back to top

Follow us on Facebook

Facebook