INFINITY 245/40 R 19 XL 98Y ECOMAX
Art. 1000405562 - Lieferbar - Neu
Reifen - Sommerreifen
Hersteller: Infinity - Modell/Profil: ECOMAX Breite: 245 - Querschnitt: 40 - Zoll: 19 Traglast: 98 (750 kg/Rad) Geschwindigkeit: Y (300 km/h) XL - TL
Infinity ist eine neue Grenze in der Reifentechnologie. Dank langjähriger Erfahrung und ständiger Arbeit an der Verbesserung der Produkte konnte das Ingenieurteam von Infinity ein Höchstmaß an Sicherheit, Haltbarkeit und Reifenkomfort erreichen. Infinity bietet eine vielfältige Auswahl an Reifenmodellen, die sich für jede Straße eignen: PCR, High Performance, Ultra Hign Performance, für 4x4-SUVs, Winterreifen, Transporterreifen, leichte und schwere LKWs. Jeder Infinity-Reifen ist die perfekte Kombination aus Hightech und exzellentem Design.
1213 - Deadlock found when trying to get lock; try restarting transactionCREATE TEMPORARY TABLE bySize171629707838 ( `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='750' AND f.radius='1900' AND f.holes='5' AND f.pcd='10800' 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='1900' AND f.holes='5' AND f.pcd='10800' 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='1900' AND f.holes='5' AND f.pcd='10800' 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='860' AND f.radius='1900' AND f.holes='5' AND f.pcd='10800' 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='1900' AND f.holes='5' AND f.pcd='10800' 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='1900' AND f.holes='5' AND f.pcd='10800' 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='1900' AND f.holes='5' AND f.pcd='10800' 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='1050' AND f.radius='1900' AND f.holes='5' AND f.pcd='10800' 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='1100' AND f.radius='1900' AND f.holes='5' AND f.pcd='10800' 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] |