Reference: PR2757
Brand: PRODIBIO
^ 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
Reference: PR2757
Brand: PRODIBIO
Reference: EA-ALG0250
Brand: EASY LIFE
Reference: SE-30612
Brand: SERA
Reference: JU-88037
Brand: JUWEL
Banner
There are 1532 products.
Reference: AV042209
Brand: AQUAVIE
Reference: AD-024
Brand: La Boutique Des Animaux
Reference: AV042205
Brand: AQUAVIE
Reference: TUB-12/16
Brand: La Boutique Des Animaux
Reference: GRO-2BRUSH-M
Brand: PET NOVA
Reference: GRO-SPAREHEAD-2BRUSH-M
Brand: PET NOVA
Reference: AT-005
Brand: BOYU
Reference: AT-006
Brand: BOYU
Reference: AD-021
Brand: La Boutique Des Animaux
Reference: SE-30610
Brand: SERA
Reference: SE-30611
Brand: SERA
Reference: AV042206
Brand: AQUAVIE
check_circle
check_circle