Шкаф угловой Сенди ШК-01 сонома купить в интернет гипермаркете «Мебельный VEKТОР» по доступной цене в Челябинске

SELECT p.id, p.url, p.brand_id, p.name, p.annotation, p.novinka, p.novinka_date, p.body, p.with_sku, COALESCE( (SELECT value FROM s_options WHERE feature_id=155 AND product_id=p.id LIMIT 1), 0 ) as height, COALESCE( (SELECT value FROM s_options WHERE feature_id=154 AND product_id=p.id LIMIT 1), 0 ) as width, COALESCE( (SELECT value FROM s_options WHERE feature_id=156 AND product_id=p.id LIMIT 1), 0 ) as depth, COALESCE( (SELECT value FROM s_options WHERE feature_id=204 AND product_id=p.id LIMIT 1), 0 ) as length, p.name_1c, p.position, p.created as created, p.visible, p.featured, p.meta_title, p.meta_keywords, p.meta_description, p.available, p.old_data, p.credit, p.recommend, p.low_price, p.add_label, b.name as brand, b.url as brand_url, COALESCE(( SELECT pc.category_id FROM s_products_categories pc WHERE pc.product_id=p.id ORDER BY pc.position ASC LIMIT 1 ), 0) as category_id, COALESCE(( SELECT c.name FROM s_categories c INNER JOIN s_products_categories pc ON c.id = pc.category_id WHERE pc.product_id=p.id ORDER BY pc.position ASC LIMIT 1 ), '') as category_name FROM s_products p LEFT JOIN s_brands b ON p.brand_id = b.id WHERE 1 AND p.id in('37582','37587','37586','37589','37590','37601','37592','37597','37598','37585','37600','37599','37595','37594','37588','37583','37584') AND p.visible=1 ORDER BY p.position DESC LIMIT 0, 100 Шкаф угловой Сенди ШК-01 сонома купить в интернет гипермаркете «Мебельный VEKТОР» по доступной цене в Челябинске