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


Ryan’s 2017 Subaru WRX on 18×9.5 Gold Grids

Owner: Ryan
Car: 2017 Subaru WRX
Wheels: 18×9.5 Rota Grid - Gold (5×114.3/e38/73)
Tires: 255/35/18 hankook ventus v12 evo2
Suspension: fortune auto 500 coilovers
Instagram: @WRXnRYAN
YOUTUBE: Ryan’s Random RideZ

Jesse’s 2017 Ford Focus ST on 18×9.5 Rota Grid in Hyper Black

Owner: Jesse
Car: 2017 Ford Focus ST
Wheels: 18×9.5 Rota Grid - Hyper Black (5×108/e38/73)
Tires: Good Year Tires 235/30/18
Suspensions: H&R lowering springs 1.5 in the front and 1.8 in the rear

Alex’s 2015 Focus ST on 18×9.5 Flat Black Grids

Owner: Alex
Car: 2015 Focus ST
Wheels: 18×9.5 Rota Grid - Flat Black (5×108/e38/73)
Tires: 255/35/18
Suspensions: H&R springs
Mods: Stage 3 Injen cold air intake COBB intercooler/Mbrp charge pipes AWE touring non resonated exhaust

Brian’s STi on 18×9.5 e38 Chameleon Grids

Owner: Brian
Car: Subaru STi
Wheels: 18×9.5 Rota Grid - Chameleon (5×114.3/e38/73) with 5mm spacers front
Suspension: Feal 44

Other mods include:
-Cobb sf
-Cobb dp modded to catless
-ARK Grip catback
-Mishimoto inlet
-AEM 320
-Air pump delete
-AC delete
-FP Blue Turbo
-Grimmspeed uppipe
-Turbosmart wastegate
-Turbosmart 50/50 BOV
-Company 23 EBCS
-Radium fuel rails
-Fuelabs fuel pressure regulator
-Cobb flex fuel kit
-Custom AN fuel lines
-One step colder plugs
-Tomioka motor mounts
-Tomioka trans mount
-Cusco front strut tower brace
-Cusco lower control arms
-Cusco rear diff carrier
-Cusco rear diff collars
-Cusco battery Tie-down
-Kartboy Pitchstop mount
-Perrin wing risers
-Rota grids
-ARP 3″ wheel studs
-Muteki open-ended lug nuts
-Mishimoto weighted shift knob
-Sparco steering wheel
-NRG hub and quick disconnect
-Ati triple center gauge pod
-Rebel VLS AFR, Oil Temp, Boost Guage
-Kartboy Short shifter
-Kartboy shifter bushings
-Feal 441 Coilovers
-Painted Headlight housing
-Morimoto Halos Headlights/Fogs
-Morimoto Bluetooth Controller
-Rally Innovations Ultimate Rally Bar
-6″ pod lights
-12″ bar light
-Battle Aero Chassis Mount Wing
-Aeroflow Rear Quad Canards
-Seamless Designs Shift/E-brake boot
-Alpine head unit
-Kicker door speakers
-Alpine type R 10″ Sub
-Kicker 1200.1 amp
-Blue foot well LEDS
-Blue dome and map light LEDs

@sithevo8 2005 Mitsubishi Evolution VIII SSL on 18×9.5 e20 Flat Black Grids

Owner: Instagram @sithevo8
Car: 2005 Mitsubishi EVO 8
Wheels: 18×9.5 Rota Grid - Flat Black (5×114.3/e20/73)
Tires: 245/45/ZR18
Suspension: Megan Racing Track Series Coilovers

Corrina’s 2014 Mitsubishi Evolution X on 18×9.5 e20 Chameleon Grids

Owner: Corrina
Car: 2014 Mitsubishi Lancer Evolution X MR
Wheels: 18×9.5 Rota Grid - Chameleon (5×114.3/e20/73)
Tires: 245/40/18 Toyo Proxes
Suspension: H&R Sport Springs
ETS bolt ons: Intake, FMIC, UICP, Race Test Pipe, V2 Exhaust System
Grimmspeed Boost Controller
H&R Sport Springs
Rexspeed Dual Pillar
AEM Digital Boost & Wideband UEGO Gauges
Solleci UFO Dual Horns
Smoked LED Bumper Reflectors

Fallen Angel’s 2010 EVOX on 18×9.5 e20 Rota Grid in Sports Bronze

Owner: Fallen Angel
Car: 2010 Mitsubishi EVOX
Wheels: 18×9.5 Rota Grid - Sports Bronze (5×114.3/e20/73)
Tires: 245/40/18

Joseph’s 2014 Focus ST on 18×9.5 e38 Hyper Black Grids

Owner: Joseph
Car: 2014 Ford Focus ST
Wheels: 18×9.5 Rota Grid - Hyper Black (5×108/e38/73)
Tires: 235/40/18
Suspensions: stock
Mods: Cobb intake, Borla exhaust, Turbosmart bov and Rally armor mudd flap

Bryan’s 2017 Subaru STi on 18×9.5 +38 Hyper Black Grids

Owner: Bryan
Car: 2017 Subaru WRX STi
Wheels: 18×9.5 Rota Grid - Hyper Black (5×114.3/e38/73)
Tires: 245/40/18 Dunlop Sports Maxx
Suspensions: Stock (for now)
Mods: Rear fenders rolled, invidia q300 catback, invidia catted downpipe, Cobb acxessport, subispeed smoked sequential tail lights

Instagram: @bryty93

Jack’s 2015 Subaru STi on 18×9.5 e38 Gold Grids

Owner: Jack
Car: 2015 Subaru STi
Wheels: 18×9.5 Rota Grid - Gold (5×114.3/e38/73)
Tires: Falken Azenis FK510 255/35/18
Suspension: ISC Coilovers
Mods: Invidia Catless Downpipe
Tomei Ti Catback
Cobb V3 AccessPort
Cobb SF Intake
Front Lip
Rear Roof Vortex