Личный кабинет
SELECT `product_version`.`available` AS stock, `product_version`.`id` AS product_version_id, `product`.`id` AS product_id, `product`.`label_ru` AS product_label, `product_version`.`price_ttc`, `product`.`image_id`, `product`.`label_ru` AS product_label, `product`.`category_id` AS category_id, `product_category`.`parent_id` AS parent_category_id, `product_promo`.`id` as promo_id, `product_version_to_promo`.`promo_price` as promo_priceFROM (`product_version`)LEFT JOIN `product` ON `product`.`id` = `product_version`.`product_id`LEFT JOIN `product_version_to_promo` ON `product_version_to_promo`.`product_version_id` = `product_version`.`id`INNER JOIN `product_promo` ON `product_promo`.`id` = `product_version_to_promo`.`promo_id` AND `product_promo`.`status` = "active" AND `product_promo`.`type` = "selected_products" AND ( product_promo.date_start IS NULL || product_promo.date_start <= "2012-05-19" ) AND ( product_promo.date_end IS NULL || product_promo.date_end >= "2012-05-19" ) AND ( product_promo.code = "" || ( product_promo.code = "" ) )LEFT JOIN `product_category` ON `product`.`category_id` = `product_category`.`id`WHERE `product`.`status` = 'active'GROUP BY `product`.`id`ORDER BY `product`.`category_id` ASC
