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_rota_g-force%' or p.products_model like '%18x9_rota_g-force%' or m.manufacturers_name like '%18x9_rota_g-force%') )

[TEP STOP]

Jesse’s 1998 Mitsubishi Evolution on 18×9 e25 Rota G-Force

Owner: Jesse Morgan
Car: 1998 Mitsubishi Lancer Evolution
Wheels: Rota G-Force 18×9 +25
Tires: 245/40-18 Dunlop Dizzera ZII
Suspension: BC coilovers
Fender liners removed in front, rear arches shaved 3mm

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.

Aaron Barnes’ 2014 Focus ST on 18×9 e35 Rota G-Force in Gunmetal

Owner: Aaron Barnes
Car: 2014 Ford Focus ST
Wheels: 18×9 e35 Rota G-Force in Gunmetal
Tires: 245/40/18 Michelin PSS
Suspension: Bilstein B14 coilovers
JBR Tru Torsion 1.25 RSB w/Billet brackets
Steeda adjustable endlinks
SPC rear camber arms

Performance:
Greddy SP catback
Mountune quick shift arm
Boosted design shifter/transmission bushings
NTC shifter cable bushing
Depo racing “THE BEAST” FMIC
CPE EXHALE TIAL Q
CPE hot side charge pipe
Levels performance catless downpipe
Cobb accessport V3
CFM valve cover breather
Damond motorsports stage 1 OCC
Damond Motorsports stage 2 OCC (to be installed)
Cobb CAI
Deadhook Motorsports 93 octane protune.

Appearance:
Maxton Design splitter in Ford Rally black
Maxton Design side splitters Ford Rally black
Innovative fabworx wing risers
professionally painted tails
Boosted design dead pedal
Diode Dynamics Luxeon LED (to be installed)Projector fog lights

Ryan’s 2013 WRX on 18×9 e35 Rota G-Force

Owner: Ryan Brown
Car: 2013 Subaru WRX
Wheel: Rota G-Force 18×9 (5×100/e35/73) in White
Tires: 245/40/18 Potenza RE760 Sport
Additional Mods: Turbo-Back/Short Shift

Ramsey’s 2015 Ford Focus ST on 18×9 Rota G-Force in Gunmetal

Wheels: 18×9 Rota G-force 5×108 e35 - Gunmetal
Tires: (stock) 235/40/18

some parking lot shots… photoshoot to follow :)

Rest of the photoshoot, click here.

2015/2016 Subaru WRX/STi ROTA Wheel Guide

Here’s some wheels we currently have for the 2015 Subaru WRX/STi, now sharing the 5×114.3 platform for both the WRX and STi. yahoo!!!

17×9 setups

17×9 Rota Grid - Chameleon (5×114.3/e42/73)

17×9 Rota Grid - Flat Black (5×114.3/e42/73)

17×9 Rota Grid - Gold (5×114.3/e42/73)

17×9 Rota Grid - Hyper Black(5×114.3/e42/73)

17×9 Rota Grid - Yamaha Black (5×114.3/e42/73)

17×9 Rota Grid - White (5×114.3/e42/73)

18×8.5 setups

18×8.5 Rota Roku - Flat Black (5×100/114.3/e44/73)

18×8.5 Rota Roku - Hyper Black (5×100/114.3/e44/73)

18×8.5 Rota SS10 - Sports Bronze (5×114.3/e44/73)

18×8.5 Rota SS10 - Hyper Black (5×114.3/e44/73)

18×8.5 Rota SS10 - Slate Blue (5×114.3/e44/73)

18×8.5 Rota SS10 - White (5×114.3/e44/73)

18×8.5 Rota G-Force - Gold (5×114.3/e48/73)

18×8.5 Rota G-Force - Hyper Black (5×114.3/e48/73)

18×9 setups

18×9 Rota Grid - Flat Black (5×114.3/+42/73)

18×9 Rota Grid - Hyper Black (5×114.3/+42/73)

18×9 Rota G-Force - Gold (5×114.3/e30/73)

18×9 Rota G-Force - Gunmetal (5×114.3/e25/73)

18×9 Rota G-Force - Hyper Black (5×114.3/e30/73)

18×9 Rota G-Force - White (5×114.3/e30/73)

18×9 Rota G-Force - Gunmetal(5×114.3/e30/73)

18×9.5 setups

18×9.5 Rota MXR - Hyper Black (5×114.3/e38/73)

18×9.5 Rota MXR - Royal Hyper Black (5×114.3/e38/73)

18×9.5 Rota Grid - Deep Red (5×114.3/e38/73)

18×9.5 Rota Grid - Flat Black (5×114.3/e38/73)

18×9.5 Rota Grid - Hyper Black (5×114.3/e38/73)

18×9.5 Rota Grid - White (5×114.3/e38/73)

18×9.5 Rota HG5 - Hyper Black (5×114.3/e35/73)

18×9.5 Rota HG5 - Gold (5×114.3/e35/73)

18×9.5 Rota Roku - Flat Black (5×108/114.3/e38/73)

18×9.5 Rota Roku - Gunmetal Grey(5×108/114.3/e38/73)

18×9.5 Rota Roku - Flat Black (5×100/114.3/e38/73)

18×9.5 Rota Roku - Hyper Black (5×100/114.3/e38/73)


New Wheel Arrivals for Ford Focus ST, Rota ROKU, Rota Huck Gee

The following wheels are now available for Focus ST and WRX/STi  :


Rota Huck Gee 18×9.5 5×108 e38 Hyper Black

Rota Huck Gee 18×9.5 5×108 e38 Flat Black


ROTA ROKU 18×9.5 5×108/114.3 e38 Flat Black


ROTA ROKU 18×9.5 5×108/114.3 e38 Gunmetal Gray


Rota G-force 18×9 5×108 e35 Gunmetal


Rota G-force 18×9 5×108 e35 White

For more Focus ST wheels: http://store.wheeldude.com/by-cars/ford/focus.html

For more 2015 WRX/STi wheels: http://store.wheeldude.com/by-cars/subaru/wrx-sti-15.html

http://store.wheeldude.com/wp/new-wheel-arrivals-for-ford-focus-st-rota-roku-rota-huck-gee/

Ryan’s WRX on 18×9 +35 Gunmetallic G-Force

Ryan’s world rally blue 2014 Subaru WRX hatch on 18×9 +35 Gun metallic  Rota G-Force with 245/35/18 Bridgestone Potenzas

Justin 2004 WRX on G-Forces 18×9 +35

Owner: Justin (@justinchapmanjc)
Car: 2004 Subaru Impreza WRX
Wheels: 18×9 Rota G-Force - White (5×100/E35/73)
Tires: 255/35/18
Suspension: air suspension

Clean, sexy and simplicity at its best.

Double Feature Rota G-Force

Irene has always been a fan of the White and Teal color combo and just by looking at the pictures of her car, we can see why. Check out her whip @salisepp on Instagram.

Owner: Irene Beeler
Car: 2011 Subaru Impreza STi
Wheels: G-Force 18×9 5×114.3/+35 custom painted teal
Photographer: @bl_pixlab (insta) BL Pixlab (facebook)

Adam sent us some pics of his 08 WRX hatch rockin’ a set of 18×8.5 Rota G-Force in Hyper Black. The fitment is perfect on these wheels!

Owner: Adam (@adamgsimpson3 on Instagram)
Car: 2008 Subaru Impreza WRX
Wheels: G-Force 18×8.5 5×100/+48 Hyper Black
Tires: 225/40/18 Toyo tires
Suspension: stock
Other: Greedy red long lug nuts
Photo cred: (@woyshnis17 on Instagram)