SELECT count(s.sale_id) count FROM sales s INNER JOIN collections cl ON cl.col_id=s.col_id WHERE s.display IN (1) AND s.rub_id IN (42) AND s.brand_id IN (96) AND cl.col_id IN (767)
Смеситель для раковины Emmevi Tiffany (CG 6003, CG6003, 6003CG), купить в Москве в интернет-магазине aquamir.ru
SELECT s.* FROM sales s INNER JOIN collections cl ON cl.col_id=s.col_id LEFT JOIN stock_item si ON s.sale_id=si.sale_id LEFT JOIN stock_load sl ON sl.load_id=si.load_id WHERE s.display IN (1) AND s.brand_id IN (96) AND cl.col_id IN (767) AND s.sale_id NOT IN (27733) GROUP BY s.sale_id ORDER BY s.display DESC , si.in_stock DESC, s.in_stock DESC, s.sale_order, s.price_display LIMIT 0, 1000
