^ DbQuery {#2628
  #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

Best Sellers

Reference: PR2757

Brand: PRODIBIO

PRODIBIO BioDigest - 6/12/30 Ampoules

Available in 6/12/30 ampoules, for seeding a seawater or freshwater aquarium with bacteria.

€21.90

Reference: EA-ALG0250

Brand: EASY LIFE

EASY-LIFE Algexit - Anti-algues Pour Aquarium

To combat the vast majority of algae species in freshwater aquariums.

€6.96

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

Reference: JU-88037

Brand: JUWEL

JUWEL BioCarb - Activated Carbon Foam

JUWEL bioCarb is a foamed activated carbon specially adapted for JUWEL Bioflow settling filters.

€3.96

All best sellers

Customer reviews

5.0 rating of 1 review

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

Aquariophily

The Animal Shop - Your Aquarium Specialist

Aquariophily

Welcome to the aquatic pet store section where we have selected a whole range of products to meet the specific needs of each aquarium.
Whether you're a beginner or an experienced aquarist, we offer thousands of items for the health of your aquatic animals.
Thousands of references for aquariums among a wide choice of aquariums, heating, decoration, food for your freshwater or marine fish
Come and discover our regular promotions on products for aquariums and aquarium fish.
Big brands at low prices, Eheim, Jbl, Aqua Nova, Sera, Discusfood, etc.