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

Aquarium accessories

We have selected a set of inexpensive aquarium accessories.
You will find accessories ( glass glue , nets , cleaning kit , thermometer , pipes ) from major brands such as Eheim , JBL , Sera , Soudal ) and products for beginner aquarists or for those looking for low-cost products.