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


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

David’s 2017 WRX on 18×9.5 Flat Black Grids

Owner: David
Car: 2017 Subaru WRX
Wheels: 18×9.5 Rota Grid - Flat Black (5×114.3/e38/73) with Custom 3D Red Carbon Fiber Vinyl Spokes
Tires: Michelin Pilot Super Sports 255/35/18
Suspension: stock
Mods: ETS Catback
Stage 1 91 Tune

Kenny’s 2015 WRX on 18×9.5 e38 Chameleon Grids

Owner: Kenny
Car: 2015 Subaru WRX
Wheels: 18×9.5 Rota Grid - Chameleon (5×114.3/e38/73)
Tires: 255/40
Suspension: Megan coilovers 10k front and rear, Rolled fenders, Not pulled.
Mods:Cobb V3 access port
Tuned by snail performance @30k
309 hp 346tq
Process west top mount vertacooler w/charge pipe
Grimspeed ebc
Mishimoto cold air intake
CNT catless downpipe
ETS catback exhaust no muff no res
Perrin steering lock out
Perrin solid shifter bushing
CS style front lip
OLM side skirts
OLM window spoiler
Oem rear spats
Rok block mud flaps
HT auto rear defuser
JDM front grill
projector fogs with halo iJdmtoy
Stillen trunk spoiler
JDM rain visor
Premium auto style emblem overlays
Chameleon tint on side emblems
Window tint 20%

Instagram: @Urabus2wrx44

Jerry’s EVOX on 18×9.5 e20 Chameleon Grids

Owner: Jerry
Car: Mitsubishi Lancer Evolution 10
Wheels: 18×9.5 Rota Grid - Chameleon (5×114.3/e20/73)
Tires: 255/35/18 Nitto tires
Suspensions: BC coilovers, Rear adjustable toe & camber arms, Front & rear whiteline swap bar end links
Mods: Ets fmic
Ams exhaust w/test pipe
Ams intake
DW65c fuel pump
1000cc injectors
Cobb 3-port ebcs
Tuned by Evans Tuning on 93 octane
362 hp/364 torque