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


Clint’s 2017 WRX on 18×9.5 Rota Grids in custom Blue finish

Owner: Clint
Car: 2017 Subaru WRX
Wheels: 18×9.5 Rota Grid - (5×114.3/e38/73) in custom Blue finish
Tires: 255/35 federal rsr tires.
Suspensions: Cusco 26 mm front sway bar, Whiteline 22mm rear sway bar, Whiteline heavy duty endlinks
Mods: Levorg front bumper
Torque solutions tgv, egr deletes and pitch stop
Perrin Fmic and sump restrictor
Cobb cold air intake.
Mishimoto oil cooler
Superstik dip stick
Velox front spilter
Hella horns mounted in fog light location
Killer b catless jpipe
Arc grip exhaust with burnt tips
Perrin shift stop, short shift adapter and bushing
Boomba short throw shifter
Anarchy Goliath shift knob
STI interior

protuned by metro performance of so cal
Sponsored by wickedly bossted, superstik, reupdesigns,

instagram is @matatabi_wrx

$15 for a set of wheels!! really!

here is a link to our instagram post:

***HUGE CONTEST** We are doing a contest for all the Wheeldude IG followers! We are raffling off a set of Rota wheels. We will have a 5×100 and a 5×114 and 5×108 rs and st fitment for the winner to pick from. Raffle tickets cost $15 and is limited to two tickets per customer. We have a limited number of tickets set to 75! Payment needs to be sent via PayPal to please put a not with you first and last name along with email and phone number! We have ticket numbers for both you and us! On Sunday 11/13/17 we will be on IG live to pull the winning ticket! Ticket will be in a box and one ticket will be pulled. After the live drawing a picture of the winning ticket will be posted. To enter please send payment as friends and family so no fee is given. Please give us time to send you an email with you ticket and number! If we don’t get the 75 tickets we will extend the raffle for another 2 days. At that point if we don’t sell the 75 needed tickets we will refund all PayPal payments to customers! We have the following wheels .winner can pick from!
Rota Grid 17×9+42 5×100 Gold

Rota KB-R 18×9.5+38 5×108 hyper black

Rota Roku 18×8.5+44 5×100 hyper black

Rota strike 18×9.5+38 5×100 flat black

Dan’s 2011 WRX on 18×9.5 e38 Titanium Chrome Grids

Owner: Dan
Car: 2011 Subaru WRX
Wheels: 18×9.5 Rota Grid - Titanium Chrome (5×100/e38/73)
Tires: SUMITOMO HTR Z III 265/35R18
Suspensions: Whiteline Rear Sway Bar 24mm Adjustable With control arm Links
Whiteline Front Sway Bar 22mm Adjustable
Kartboy Front Endlinks
Kartboy Rear Endlinks
BC Racing BR Series Coilovers with rear Extenders

for more picture click here

Year:​ 2011
Make:​ Subaru
Model:​ Impreza
Sub Model:​ WRX Sedan
Color: ​Obsidian Black Pearl
Engine:​ EJ255 2.5L intercooled turbo, DOHC, 16 valve, H4 cylinder
Power:​ 307WHP / 334FT/LBS TQ Uncorrected
Tuner: ​Cleo (IAG Performance)
New items for May before Boxerfest 2017:
● Perrin Turbo Inlet Hose
● GrimmSpeed Cold Air Intake
● Aeromotive Black A1000-6 FPR Fuel Pressure Regulator
● Fragola 0-100 PSI Fuel Pressure Gauge
● IAG V2 Top Feed Fuel Rails
● IAG Braided Fuel Line & Fitting Kit with Flex Fuel Adapters
● IAG Silver CNC Top Feed TGV Deletes
● Blouch 440XT Turbocharger with HPD Turbine and 10cm^2 Housing
● COBB Tuning Flex Fuel Package with Fuel Pressure Sensor
● AEM 320LPH E85 Ethanol Fuel Pump
● Omni Power 4 Bar Map Sensor
● Delete Secondary Air Pump and install IAG block off plates
● IAG Comp to Street AOS Conversion Kit
● Cobb AP V2 to V3 Upgrade

● SPT Carbon Fiber Trunk Trim
● Rally Armor Red/Black Mud Flaps
● Bayson*R CS Replica Front Lip
● Perrin Shorty Antenna
● 30% Window Tint all around
● Stock Halogen Headlamps
● Stock Fog Lights

● SMY Clustermaker Gauge Pod
● Solid Modifications 52mm Vent Pod
● Prosport Amber White Needle 52mm Boost Gauge
● Prosport Amber White Needle 52mm Oil Pressure Gauge
● AEM UEGO Digital Wideband 52mm Air/Fuel Ratio Gauge
● Proto Tuning Tool Holder
● Cobb Red 5 Speed Subaru Shift Knob
● STI Short Throw Shifter

● Whiteline Rear Sway Bar 24mm Adjustable With control arm Links
● Whiteline Front Sway Bar 22mm Adjustable
● Kartboy Front Endlinks
● Kartboy Rear Endlinks
● BC Racing BR Series Coilovers with rear Extenders
● ROTA Grid 18×9.5” +38 Wheels Titanium Chrome
● SUMITOMO HTR Z III 265/35R18 Tires
● DBA T2 Street Slotted Rotors
● Hawk HPS Ceramic Pads
● Deburred and G2 Painted Calipers Gloss Black

● Nameless Performance Muffler Delete Axleback Double Walled Tips
● Stock Midpipe
● Cobb SS 3” Downpipe
● Cobb AccessPort V2 (Will Be trading in to V3)
● Cobb SF Intake and Airbox
● Cobb Turbo Heat Shield
● IAG SS Uppipe
● Prosport UEL Headers
● TiAL MVS 38mm External Wastegate
● Grimmspeed Top Mount Intercooler with shroud
● Grimmspeed Electronic Boost Control Solenoid
● IAG Air Oil Separator
● Injector Dynamics 1000CC Injectors
● Walbro 255lph Fuel Pump
● Perrin Turbo Inlet for 2.5” Turbo
● Stock Block
● Stock Turbo - VF52

shout out to the photographers for the pictures which include @timothy.yiu, @logan_photography_, EP’s Photos, @crazyKonceptz, @subarusense and @european.whips.

Also I’d like to thank IAG Performance, GrimmSpeed, and F.A.S.T. of West Chester for help with the build.

@chelsiecastetter 2014 Focus ST on 18×9.5 e38 Hyper Black Grids

Owner: @chelsiecastetter
Car: 2014 Ford Focus ST
Wheels: 18×9.5 Rota Grid - Hyper Black (5×108/e38/73)
Tires: 235/40/18 Eagle F1
Suspensions: Eibach lowering springs

Stage 1 Cobb tune with Cobb intake. Has a flowmaster catback. Boomba bov.

No fender mods were necessary to fit this wheel and tire setup.

Matts 2016 WRX on 18×9.5 Chameleon Grids

Owner: Matt
Car: 2016 Subaru WRX
Wheels: 18×9.5 Rota Grid - Chameleon (5×114.3/e38/73)
Tires: 245/40/18
Suspensions: D2 Race Coilovers and Cobb front and rear sway bars

for more pix click here

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!!!