|
GRENLANDER 255/55 R 19 XL 111V L ZEAL 56
Der Reifen wird ohne Felge geliefert. Je nach Reifenbreite kann das Profilbild von der Abbildung abweichen.
Art. 1000618252 - Lieferbar - Neu
Reifen - Sommerreifen
Hersteller: Grenlander - Modell/Profil: L ZEAL 56 Breite: 255 - Querschnitt: 55 - Zoll: 19 Traglast: 111 (1090 kg/Rad) Geschwindigkeit: V (240 km/h) XL - TL CREATE TEMPORARY TABLE bySize17165743011 ( `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='700' AND f.radius='1900' 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='1900' 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='1900' 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='1900' 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='860' AND f.radius='1900' 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='1900' 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='1900' 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='1900' 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] | ||||||||
