SELECT `sh_product`.*, `pval`.`id` AS `sh_product_property_value_id`, `pval`.`web_id`, `pval`.`sh_product_category_id`, `pval`.`sh_property_option_id`, `pval`.`sh_property_id`, `pval`.`sh_product_id`, `pval`.`sh_property_option_value` FROM `sh_product` LEFT JOIN `sh_product_property_value` AS `pval` ON pval.sh_product_id=sh_product.id WHERE …
Цааш унших