Startseite » Reifen » Sommerreifen » ORIUM 225/40 R 18 XL 92Y ULTRA HIGH PERFORMANCE

ORIUM 225/40 R 18 XL 92Y ULTRA HIGH PERFORMANCE

ORIUM 225/40 R 18 XL 92Y ULTRA HIGH PERFORMANCE
Der Reifen wird ohne Felge geliefert. Je nach Reifenbreite kann das Profilbild von der Abbildung abweichen.
61,99 €
Preis pro Stück inkl. MwSt.
Kostenloser Versand
ab 2 Stück ***
4 Stück = 247,96 €
Art. 1000421891 - Lieferbar - Neu
Frage zum Produkt Favorisieren - Hinweis
Reifen - Sommerreifen 
Hersteller: Orium - Modell/Profil: Ultra High Performance
Breite: 225 - Querschnitt: 40 - Zoll: 18 
Traglast: 92 (630 kg/Rad)
Geschwindigkeit: Y (300 km/h)
XL  - TL 
Reifenlabel
CCKlasse B
72 dB
1213 - Deadlock found when trying to get lock; try restarting transaction

CREATE TEMPORARY TABLE bySize171688244128 ( `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='500' AND f.radius='1800' AND f.holes='5' AND f.pcd='11200' 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='600' AND f.radius='1800' AND f.holes='5' AND f.pcd='11200' 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='1800' AND f.holes='5' AND f.pcd='11200' 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='1800' AND f.holes='5' AND f.pcd='11200' 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='1800' AND f.holes='5' AND f.pcd='11200' 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='780' AND f.radius='1800' AND f.holes='5' AND f.pcd='11200' 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='1800' AND f.holes='5' AND f.pcd='11200' 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='825' AND f.radius='1800' AND f.holes='5' AND f.pcd='11200' 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='830' AND f.radius='1800' AND f.holes='5' AND f.pcd='11200' 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='840' AND f.radius='1800' AND f.holes='5' AND f.pcd='11200' 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='1800' AND f.holes='5' AND f.pcd='11200' 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='900' AND f.radius='1800' AND f.holes='5' AND f.pcd='11200' 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='950' AND f.radius='1800' AND f.holes='5' AND f.pcd='11200' 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='1000' AND f.radius='1800' AND f.holes='5' AND f.pcd='11200' 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='8800' AND f.radius='1800' AND f.holes='5' AND f.pcd='11200' 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]