Разноширокие шины 245/45 R18 и 275/40 R18 для BMW 5-series 2017-2023 G30 Sedan M550i xDrive

SELECT DISTINCT C.`id`, C.`pagetitle`, P.`price_krd` as price, P.`price` as price_nomrc, P.`price_retail`, P.`quantity`, P.`supplier_region`, P.`supplier`, P.`delivery`, P.`regional_extra`, P.`image`, P.`vendor`, R.`value` as runflat, S.`value` as season, ST.`value` as stud, C.`parent` as parent, C2.`id` as id2, C2.`pagetitle` as pagetitle2, P2.`price_krd` as price2, P2.`price` as price_nomrc2, P2.`price_retail` as price_retail2, P2.`quantity` as quantity2, P2.`supplier_region` as sp2, P2.`supplier` as sup2, P2.`delivery` as d2, P2.`regional_extra` as re2, P.`price_krd`*2 + P2.`price_krd`*2 as sum FROM `sh_site_content` C INNER JOIN `sh_ms2_products` P on C.`id` = P.`id` AND P.`quantity` > 1 INNER JOIN `sh_ms2_product_options` W ON W.`product_id` = C.`id` AND W.`key`='width' AND W.`value` = '245' INNER JOIN `sh_ms2_product_options` H ON H.`product_id` = C.`id` AND H.`key`='height' AND H.`value` = '45' INNER JOIN `sh_ms2_product_options` D ON D.`product_id` = C.`id` AND D.`key`='diameter' AND D.`value` = '18' LEFT JOIN `sh_ms2_product_options` R ON R.`product_id` = C.`id` AND R.`key`='rf' LEFT JOIN `sh_ms2_product_options` S ON S.`product_id` = C.`id` AND S.`key`='season' LEFT JOIN `sh_ms2_product_options` ST ON ST.`product_id` = C.`id` AND ST.`key`='stud'1 INNER JOIN `sh_site_content` C2 on C2.`parent` = C.`parent` AND C2.`id` <> C.`id` INNER JOIN `sh_ms2_products` P2 on C2.`id` = P2.`id` AND P2.`quantity` > 1 INNER JOIN `sh_ms2_product_options` W2 ON W2.`product_id` = C2.`id` AND W2.`key`='width' AND W2.`value` = '275' INNER JOIN `sh_ms2_product_options` H2 ON H2.`product_id` = C2.`id` AND H2.`key`='height' AND H2.`value` = '40' INNER JOIN `sh_ms2_product_options` D2 ON D2.`product_id` = C2.`id` AND D2.`key`='diameter' AND D2.`value` = '18' LEFT JOIN `sh_ms2_product_options` R2 ON R2.`product_id` = C2.`id` AND R2.`key`='rf' WHERE C.`published` = 1 AND C2.`published` = 1 AND C.`class_key` = 'msProduct' AND C.`template` = 3 AND ( R.`value` = R2.`value` OR (R.`value` IS NULL and R2.`value` IS NULL)) ORDER BY sum ASC LIMIT 0,16

Нет подходящих комплектов