Замки навесные

RawSql: SELECT `product`.`id`, `product`.`idgroup`, `product`.`idbrand`, `product`.`idcategory`, `product`.`title`, `product`.`alias`, `product`.`published`, `product`.`sku`, `product`.`flag_liquidation`, `product`.`flag_bestseller`, `product`.`flag_new`, `product`.`flag_optimalchoice`, `product`.`available`, `product`.`idcolor`, `pcp`.`price`, coalesce(ppp.price, pcp.price) AS `ppp_price` FROM `product` LEFT JOIN `product_customergroup_price` `pcp` ON product.id=pcp.idproduct LEFT JOIN `product_promo_price` `ppp` ON ((product.id=ppp.idproduct)and(ppp.idcustomergroup=37)) WHERE (`pcp`.`idcustomergroup` = 37) AND (`product`.`published`=1) AND (`product`.`idcategory`=553)