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_rota_dpt%' or p.products_model like '%18x9.5_rota_dpt%' or m.manufacturers_name like '%18x9.5_rota_dpt%') )

[TEP STOP]

Jose’s 2015 Subaru STi Limited on 18×9.5 Rota DPT

Owner: Jose
Car: 2015 Subaru wrx sti limited
Wheels: 18×9.5 Rota DPT - (5×100x114.3/e30/73) Gold
Tires: 245 40 18 Toyo Proxies
Suspension: Teins Flex’s z

Instagram: @hood_15sti



Jordan’s 2017 WRX on 18×9.5 e35 Rota DPT in Hyper Black

Owner: Jordan
Car: 2017 WRX
Wheels: 18×9.5 Rota DPT - Hyper Black (5×100x114.3/e35/73)
Tires: 245/40 tires
Suspensions: stock
Nameless muffler deletes
Subispeed f1 fog light
Olm foglights
Olm led headlights
C light upgrade
Perrin shift stop
Kartboy short shift kit
Diode dynamics led interior lighting
Shiftsolutions co shift knob
Protune

instagram is @1_slowrx

Mike’s 2017 Ford Focus RS /RS2 on 18×9.5 Rota DPT in Hyper Black

Owner: Mike
Car: 2017 Ford Focus RS /RS2.
Wheels: 18×9.5 Rota DPT - Hyper Black (5×108x114.3/e38/73)
Tires: 255/35/18 Continental ExtremeContact DWS06.
Suspensions: n/a
No Mods.. Yet

They Cleared the Brembo Calipers by about 1/16″ No spacers needed

Instagram: @FOCit.RS

Josh’s 2013 STi on Rota DPT 18×9.5 e44

Owner: Josh
Car: 2013 Subaru STi
Wheels: 18×9.5 Rota DPT - Flat Black (5×100x114.3/e44/73)
Tires: 265/35/18 Sumitomo htr ziii
Suspensions: Stock

Cobb sf intake invidia catted downpipe. Nameless performance catback muffler delete. Pro tuned by Corbin Johnson

@thestig719 2004 Subaru WRX on 18×9.5 e35 Rota DPT

Owner: @thestig719
Car: 2004 Subaru WRX
Wheels: 18×9.5 Rota DPT - (5×100x114.3/e35/73) custom finish
Tires: 235/40/18
Suspension: BC Coilovers

Armando’s 04 STi on 18×9.5 e35 Rota DPT

Owner: Armando
Car: 2004 Subaru Impreza STi
Wheels: 18×9.5 Rota DPT - (5×100x114.3/e35/73) custom Red finish
Tires: 235/40/18

@anthony_trboxr 2014 WRX on 18×9.5 e35 Rota DPT

Owner: Anthony @anthony_trboxr
Car: 2014 Subaru WRX
Wheel: Rota DPT 18×9.5 5×100/114.3 e35 Hyper Black
Tires: 265/35/18

Incoming Wheels - Febuary

These wheels are coming in this Febuary 2015. 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.

Subaru WRX Wheels

18×8.5 Rota HG5 - Hyper Black (5X100/+44)

18×8.5 Rota HG5 - Gold (5X100/+44)

18×9.5 Rota HG5 - Gold (5X100/+38)

18×9.5 Rota HG5 - Hyper Black (5X100/+38)

18×8.5 Rota DPT - Hyper Black (5×100/114.3/+ 44)

18×8.5 Rota Grid -Flat Black (5×100/+ 44)

18×8.5 Rota Grid - Hyper Black (5×100/+ 44)

18×9.5 Rota Grid - Chameleon (5×100/+ 38)

18×9.5 Rota Grid - Deep Red (5×100/+ 38)

18×9.5 Rota Grid -Flat Black (5×100/+ 38)

18×9.5 Rota Grid - Hyper Black (5×100/+ 38)

18×9.5 Rota Grid - White (5×100/+ 38)

Ford Focus ST Wheels

18×9.5 Rota Grid - Hyper Black (5×108/+ 38)

18×9.5 Rota Grid - Chameleon (5×108/+ 38)

Mitsubishi EVOX, 350Z Wheels

18×9.5 Rota Grid - Deep Red (5×114.3/+ 20)

18×9.5 Rota Grid -Flat Black (5×114.3/+ 20)

18×9.5 Rota Grid - Gold (5×114.3/+ 20)

18×9.5 Rota Grid - Hyper Black (5×114.3/+ 20)

18×9.5 Rota Grid - White (5×114.3/+ 20)

Subaru STi

18×8.5 Rota DPT - Hyper Black (5×100/114.3/+ 44)

18×8.5 Rota Grid - Speed Bronze (5×114.3/+ 44)

18×9 Rota Grid - Flat Black (5×114.3/+42)

18×9 Rota Grid - Hyper Black (5×114.3/+42)

18×9.5 Rota Grid - Deep Red (5×114.3/+ 38)

18×9.5 Rota Grid -Flat Black (5×114.3/+ 38)

18×9.5 Rota Grid - Hyper Black (5×114.3/+ 38)

18×9.5 Rota Grid - White (5×114.3/+ 38)

FR-S, FT-86 and BRZ Wheels

18×8.5/9.5 Rota HG5 - Hyper Black (5X100/+44F/+38R)

18×8.5/9.5 Rota HG5 - Gold (5X100/+44F/+38R)

18×8.5/9.5 Rota Grid -Flat Black (5X100/+44F/+38R)

18×8.5/9.5 Rota Grid - Hyper Black (5X100/+44F/+38R)

Subaru WRX STi 2015, Mitsubishi EVO 8-9 Wheels

18×9.5 Rota HG5 - Hyper Black (5X114.3/+35)

18×9.5 Rota HG5 - Gold (5X114.3/+35)

Audi , Volkswagen Wheels

18×9 Rota Grid - Hyper Black (5×112/+40)

19×8.5 Linea Corse Dyna - Slate Blue (5×112/e40/73hb)

19×8.5 Linea Corse Dyna - Polished (5×112/e35/57.1hb)

Porsche Wheels

17×7.5/9 Linea Corse Fox - RSR Style High Polish(5×130/e35F/e16R/7 1.6)

17×7.5/9 Linea Corse Fox - Gloss Black w/ Pol Lip (5×130/e35F/e16R/71.6)

BMW Wheels

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

Incoming Wheels - March 2014

These wheels are coming in this March 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×9 Rota DPT - Flat Black (5×100/114.3/e42/73)

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

17×9 Rota DPT - Sports Bronze (5×100/114.3/e42/73)

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

18×9.5 Rota DPT - Speed Bronze (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/e35/73)

18×9.5 Rota DPT - Speed Bronze (5×100x114.3/e35/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×9.5 Rota Grid - Chameleon (5×100/e38/73)

18×9.5 Rota Grid - Gold (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 - 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 Grid - White (5×114.3/e20/73)

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

LINEA CORSE WHEELS

18×9.5 Linea Corse Lemans - Hyper Silver with Polished Lip (5×100/e30/73)

RUNDFAHREN WHEELS

19×8.5/10 Rundfahren RM101 - Machined (5×114 +30+38)

19×8.5/10 Rundfahren RM101 - Machined (5×120 +30+37)

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)