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%') )

[TEP STOP]

Rikardo’s 2014 Ford Focus ST on 18×9.5 Hyper Black Grids

Owner: Rikardo Duran
Car: 2014 Focus ST
Wheels: 18×9.5 Rota Grid - Hyper Black (5×108/e38/73)
Tires: 235/40/18
Suspensions: eibach lowering springs

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
Suspension:
BC Racing BR coilovers
Whiteline 22mm front swaybar
Whiteline 24mm rear swaybar
Kartboy end links
Rear fenders are rolled, no rubbing issues
Mods:
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.