OVATION 225/50 ZR 17 XL 98W VI-388
Art. 1000317520 - Lieferbar - Neu
Reifen - Sommerreifen
Hersteller: Ovation - Modell/Profil: VI-388 Breite: 225 - Querschnitt: 50 - Zoll: 17 Traglast: 98 (750 kg/Rad) Geschwindigkeit: W (270 km/h) XL - TL
CREATE TEMPORARY TABLE bySize17142016604 ( `products_id` mediumint(6) unsigned NOT NULL ) ENGINE=MEMORY SELECT p.products_id FROM ( SELECT f.products_id FROM wheels_first f JOIN wheels_second s ON (s.products_id=f.products_id) WHERE f.width='600' AND f.radius='1700' AND f.holes='5' AND f.pcd='12000' AND s.season='1' UNION SELECT f.products_id FROM wheels_first f JOIN wheels_second s ON (s.products_id=f.products_id) WHERE f.width='650' AND f.radius='1700' AND f.holes='5' AND f.pcd='12000' AND s.season='1' UNION SELECT f.products_id FROM wheels_first f JOIN wheels_second s ON (s.products_id=f.products_id) WHERE f.width='700' AND f.radius='1700' AND f.holes='5' AND f.pcd='12000' AND s.season='1' UNION SELECT f.products_id FROM wheels_first f JOIN wheels_second s ON (s.products_id=f.products_id) WHERE f.width='740' AND f.radius='1700' AND f.holes='5' AND f.pcd='12000' AND s.season='1' UNION SELECT f.products_id FROM wheels_first f JOIN wheels_second s ON (s.products_id=f.products_id) WHERE f.width='750' AND f.radius='1700' AND f.holes='5' AND f.pcd='12000' AND s.season='1' UNION SELECT f.products_id FROM wheels_first f JOIN wheels_second s ON (s.products_id=f.products_id) WHERE f.width='800' AND f.radius='1700' AND f.holes='5' AND f.pcd='12000' AND s.season='1' UNION SELECT f.products_id FROM wheels_first f JOIN wheels_second s ON (s.products_id=f.products_id) WHERE f.width='850' AND f.radius='1700' AND f.holes='5' AND f.pcd='12000' AND s.season='1' ) tmp JOIN products20 p ON (p.products_id=tmp.products_id) WHERE p.status=1 AND p.quantity>3 [TEP STOP] |