SELECT `prod`.`code`, `prod`.`type`, `prod`.`discount`, `prod`.`caption_ua` as `caption`, `prod`.`content_ua` as `content`, `prod`.`price1`, `prod`.`price2`, `brand`, `prod`.`show`, `prod`.`isnew`, `cnt`.warehouse as `warehouse` FROM `products` as `prod` left join `count` as `cnt` on `cnt`.product_id = `prod`.id WHERE `prod`.id = 2832