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


Aaron’s 2016 WRX on 18×9.5 e38 Flat Black Grids

Owner: Aaron
Car: 2016 Subaru WRX
Wheels: 18×9.5 Rota Grid - Flat Black (5×114.3/e38/73)
Tires: 240/45/18
Suspensions: stock

Bob’s 2013 Focus ST on 18×9.5 e38 Hyper Black Grids

Owner: Bob
Car: 2013 Focus ST
Wheels: 18×9.5 Rota Grid - Hyper Black (5×108/e38/73)
Tires: 235/40/18
Suspensions: Airlift Performance 3H

Pat’s 2015 WRX on 18×9.5 e38 Rota Grid in Gold

Owner: Pat Schwass
Car: 2015 Subaru WRX
Wheels: 18×9.5 Rota Grid - Gold (5×114.3/e38/73)
Tires: Michelin Pilots AS3 245/40/18
Suspension: ISC N1 coilovers, Rear wheel wells have to be rolled
Mods: Mishimoto J pipe
Invidia N1 catback
Cobb SF intake with air box
Second pill delete
EGR & TGV delete
Perrin shifter bushing
Perrin shifter stop
Cobb accessport tune by Bren tuning
Front lip

Gabe’s 2015 EvoX GSR on 18×9.5 e20 Deep Red Grids

Owner: Gabe
Car: 2015 EvoX GSR
Wheels: 18×9.5 Rota Grid - Deep Red (5×114.3/e20/73)
Tires: Yokohama Advans 245/40/18
Suspension: Tein Superstreet coilovers

Instagram: @gabrielgrison

click here for more pix!!!

Ronnie’s 2006 Mitsubishi Evolution RS on 18×9.5 e20 Hyper Black Grids

Owner: Ronnie
Car: 2006 Mitsubishi Evolution RS
Wheels: 18×9.5 Rota Grid - Hyper Black (5×114.3/20/73)
Tires: Nexen 255/35R18
Suspension: D2 Racing Coilovers

Larry’s Focus ST on 18×9.5 Hyper Black Grids

Owner: Larry Hernandez
Car: 2015 Ford Focus ST
Wheel Info: Rota Grid 18×9.5 e38 Hyper Black
Tires: 235/40/18 (stock)
Suspension: Steeda Springs Stage 3

Dustin’s WRX on 18×9.5 e38 Hyper Black Grids

Owner: Dustin
Car: Subaru Impreza WRX
Wheels: 18×9.5 Rota Grid - Hyper Black (5×100/e38/73)
Tires: 265/35/18Goodyear eagle f1 asymmetrical all season tires
BC Racing BR coilovers
Whiteline 22mm front swaybar
Whiteline 24mm rear swaybar
Kartboy end links
Rear fenders are rolled, no rubbing issues
Cobb sf intake
Grimmspeed crosspipe
Invidia catless downpipe
Invidia Q300 catback exhaust
Stage 2 custom tune

Rob’s 2017 Subaru Forester XT on 18×9.5 Hyper Black Grids

Rob got the car two days ago and the Grids are already on!!

Owner: Rob Silverman
Car: 2017 Subaru Forester XT Premium
Wheels: 18×9.5 Rota Grid - Hyper Black (5×100/e38/73)
Tires: 255/45/18 Bf Goodrich G-Force Comp-2 a/s
Suspension: currently on stock, Feal Coil wil be on shortly.

Randy Kesterson’s 2002 Jaguar X-Type on 18×9.5 e38 Rota Grid

Owner: Randy Kesterson
Car: 2002 Jaguar X-Type
Wheels: 18×9.5 Rota Grid 5×108 e38
Tires: 265/35/18 Federal SS595
Suspension: H&R springs, Bilstein struts and shocks. Godspeed adjustable upper arms, massive speed system adjustable rear toe arms. New factory lower arms with polyurethane bushings everywhere. Custom 1st in the world larger 2 way adjustable sway bars with Massive Speed System adjustable front end links and Whiteline adjustable rear end links. Cut, rolled, and pulled fenders.

Sean’s 2015 WRX on 18×9.5 e38 Hyper Black Grids

Owner: Sean
Car: Subaru WRX 2015
Wheel: 18×9.5 Rota Grid - Hyper Black (5×114.3/e38/73)
Tire Size: 265/35 BFG Sport Comp2.
Suspension: Stock