^ DbQuery {#2671
  #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
    ]
  ]
}

Filter By

FILTER TYPE

FILTER TYPE

Filters EHEIM Professional 5e

Filters EHEIM Professional 5e

Filters EHEIM Professional 4+

Filters EHEIM Professional 4+

Filters EHEIM Professional 3e

Filters EHEIM Professional 3e

Filters EHEIM Professional 3

Filters EHEIM Professional 3

Filters EHEIM Professional 2

Filters EHEIM Professional 2

Filters EHEIM Professional

Filters EHEIM Professional

Filtre EHEIM eXperience

Filtre EHEIM eXperience

Filter Here

Filter Here

Filtre EHEIM Classic

Filtre EHEIM Classic

For internal filter

For internal filter

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!
  • Banner

Active filters
Brosse 2en1 pour chien

Reference: GRO-2BRUSH-M

Brand: PET NOVA

2-in-1 dog brush

Dog grooming accessory for maintaining its coat with interchangeable double-sided head.
€8.40
More 2-in-1 dog brush

Follow us on Facebook