Products meeting the search criteria

1054 - Unknown column 'p.products_id' in 'on clause'

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%18x9.5_rundfahren_rm200%' or p.products_model like '%18x9.5_rundfahren_rm200%' or m.manufacturers_name like '%18x9.5_rundfahren_rm200%') )

[TEP STOP]

Be Different - The Wheeldude FR-S on Machined RM200’s

Owner: Wheeldude
Car: 2013 Scion FR-S
Wheels: 18×9.5 Rundfahren RM200 - Machined(5×100/e38/73)
Tires: 235/40/18
Suspension: KW V3 coilovers
Performance Parts: Stivo Exhaust
Accessories: Stivo Chin Spoiler , Stivo Ducktail Spoiler, Stivo Roof Spoiler

Just in case you haven’t heard about it yet, we just added the latest brand to our wheel line up - the Rundfahren. We took our shop FR-S to our secret spot for a shoot with the RM200 which is the latest release under the Rundfahren brand.

Incoming Wheels - February 2014

These wheels are coming in this February 2014. We are now accepting pre-orders for these wheels. You can give us a call at the shop at 510.252.1111 Monday to Friday 10am-5pm PST or you may place the order on our website.

ROTA WHEELS

17×8 Rota DPT - Flat Black (5×100/114.3/e48/73)

17×8 Rota DPT - Hyper Black (5×100/114.3/e48/73)

17×9 Rota DPT - Hyper Black (5×100/114.3/e35/73)

17×9 Rota DPT - Flat Black (5×100/114.3/e42/73)

17×9 Rota DPT - Hyper Black (5×100/114.3/e42/73)

18×9.5 Rota DPT - Flat Black (5×100x114.3/e22/73)

18×9.5 Rota DPT - Flat Black (5×100x114.3/e35/73)

18×9.5 Rota DPT - Gold (5×100x114.3/e44/73)

18×8.5 Rota Grid - Flat Black (5×100/e44/73)

18×8.5 Rota Grid - Hyper Black (5×100/e44/73)

18×8.5 Rota Grid - Speed Bronze (5×100/e44/73)

18×8.5 Rota Grid - White (5×100/e44/73)

18×8.5 Rota Grid - Flat Black (5×114.3/e44/73)

18×8.5 Rota Grid - Hyper Black (5×114.3/e44/73)

18×8.5 Rota Grid - Speed Bronze (5×114.3/e44/73)

18×8.5 Rota Grid - White (5×114.3/e44/73)

18×9.5 Rota Grid - Deep Red (5×100/e38/73)

18×9.5 Rota Grid - Flat Black (5×100/e38/73)

18×9.5 Rota Grid - Full Royal Silver (5×100/e38/73)

18×9.5 Rota Grid - Hyper Black (5×100/e38/73)

18×9.5 Rota Grid - Speed Bronze (5×100/e38/73)

18×9.5 Rota Grid - Titanium Chrome (5×100/e38/73)

18×9.5 Rota Grid - White (5×100/e38/73)

18×9.5 Rota Grid - Speed Bronze (5×114.3/e38/73)

18×9.5 Rota Grid - White (5×114.3/e38/73)

18×9.5 Rota Grid - Flat Black (5×114.3/e20/73)

18×9.5 Rota Grid - Hyper Black (5×114.3/e20/73)

18×9.5 Rota Grid - Speed Bronze (5×114.3/e20/73)

18×9.5 Rota RT5 - Flat Black (5×100/e38/73)

18×9.5 Rota RT5 - Hyper Black (5×100/e38/73)

18×10 Rota RT5 - Flat Black (5×100/e30/73)

18×10 Rota RT5 - Hyper Blue (5×100/e30/73)

18×10 Rota RT5 - Titanium Chrome (5×100/e30/73)

18×10 Rota RT5 - White (5×100/e30/73)

18×10 Rota RT5 - Hyper Black (5×114.3/e30/73)

18×10 Rota RT5 - Titanium Chrome (5×114.3/e30/73)

LINEA CORSE WHEELS

19×8.5/10 Linea Corse Dyna - Polished (5×114.3/e30F,e38R/73)

19×8.5/10 Linea Corse Dyna - Polished (5×120/e30F,e37R)

17×7.5/9 Linea Corse Fox - Satin Black w/Satin Silver Lip (5×130/e35/e16)

17×7.5/9 Linea Corse Fox - Gloss Black w/ Pol Lip (5×130/e35/e16)

19×8.5/10 Linea Corse LC818 - Hyper Silver (5×114 +30+38)

19×8.5/10 Linea Corse LC818 - Hyper Silver (5×120 +30+37/72.6)

19×8.5/10 Linea Corse LC818 - Satin Black (5×120 +30+37)

19×9.5/11 Linea Corse LC818 - Satin Black (5×120 +25+25 72.6)

18×9.5 Linea Corse Lemans - Silver w/ Polished Li (5×100/e30/73)

18×9.5 Linea Corse Lemans - Hyper Silver w/ Pol (5×114.3/e17/73)

19×8.5/9.5 Linea Corse Veneto - Hyper Silver (6×115/+40F+47R)

RUNDFAHREN WHEELS

18×9 Rundfahren RM110 - Machined(5×112/e40/73)

18×9.5 Rundfahren RM110 - Machined(5×100/e38/73)

18×9 Rundfahren RM200 - Machined(5×112/e40/73)

18×9.5 Rundfahren RM200 - Machined(5×112/e35/73)

18×9.5 Rundfahren RM200 - Machined(5×100/e38/73)