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 '%17x9_rota_grid%' or p.products_model like '%17x9_rota_grid%' or m.manufacturers_name like '%17x9_rota_grid%') )

[TEP STOP]

$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 sales@wheeldude.com 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

Matthew’s 2007 Subaru STi on 17×9 e42 Rota Grid in Flat Black

Owner: Matthew
Car: 2007 Subaru STi
Wheels: 17×9 Rota Grid - Flat Black (5×114.3/e42/73)
Tires: 245/40/17 Hankook Ventus V12 Evo2
Suspensions: Stock STI shocks/struts on RCE Black springs

Setup fits perfect, no rubbing (yet lol). Car looks way meaner, love this look. Really brings out the gold brembos!

Michael’s FR-S on 17×9 +42 Hyper Black Grids-V

Owner: Michael Allman
Car: Scion FR-S
Wheels:17×9 Rota Grid-V - Hyper Black (5×100/e42/73)
Tires: 245/40/17 Hankook Ventus RS3
Suspension: Fortune auto 500

Dustin’s 2016 Subaru BRZ on 17×9 e42 Sports Bronze Grids

Owner: Dustin Schoultz
Car: 2016 Subaru BRZ
Wheel Info: 17×9 Rota Grid - Sports Bronze (5×100/e42/73)
Tires: Hankook Ventus evo2 tires 245/40R17
Suspension: Tein FlexA coilovers approx. 1.5” drop
SPC lower control arms -2* camber front, -1.5* camber rear.

Wheels sit pretty much flush with fender. Looks awesome!!

Dillon’s 2014 Scion FRS on 17×9 Rota Grid-V in Speed Bronze

Owner: Dillon Shelburn
Car: 2014 Scion FRS
Wheels: 17×9 Rota Grid-V - Speed Bronze (5×100/e42/73)
Tires: Hankook Ventus V12 Evo2 245/40/17
Suspension: ST Coilovers, SPL LCAs, Velox Top Hats.

Sam’s BRZ on Rotra Grid-V 17×9 +42 in Speed Bronze

Owner: Sam Le
Car: Subaru BRZ
Wheels: 17×9 Rota Grid-V - Speed Bronze (5×100/e42/73)
Tires: 245/40/17
Suspension: ISR Coilovers

17×9 Rota Grid on 245/40/17 Falken Azenis FK453

Wheels: 17×9 Rota Grid - Gloss Black

Tires: 245/40/18 Falken Azenis FK453

18×9 Rota Grid on Kaden’s 2012 GTi

Car: 2012 Vw GTi

Wheels: 18×9 Rota Grid 5×112 e42 - Hyper Black

Tires: 235/40/18 Bridgestone Potenza re760

Kaden downsized from the 18×9.5 Rota Grid to the 18×9. He will surely enjoy this setups as he mobs back and forth to TX <<>> CA. Safe travels Kaden!

For higher rez pix, 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)


Rota Grids

The Rota Grid is one of our best sellers and one of our favorite wheels. It comes with a variations of color and different sizes and fitments. Comparing the wideness of the deep aggressive concavity 10 and 9.5 inch to the slightly curved spoke of the 8.5 inch width Grids. They came in high offset to clear big brake calipers to the low offset for other fitments.

Sizes

Bolt Pattern

  • 6×139.7
  • 5×120
  • 5×114.3
  • 5×112
  • 5×108
  • 5×100
  • 4×114.3

Color

  • Chameleon
  • Deep Red
  • Flat Black
  • Full Royal Silver
  • Gold
  • Gun Metal
  • Hyper Black
  • Hyper Blue
  • Hyper Silver
  • Speed Bronze
  • Sports Bronze
  • Titanium Chrome
  • White

18×10 Rota Grid - Flat Black (5×120/e25/72.6)

18×9.5 Rota Grid - Chameleon (5×100/e38/73)

18×9.5 Rota Grid - Chameleon (5×114.3/e20/73)

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

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

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

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

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

18×9.5 Rota Grid - Flat Black (5×100/e44/73)

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

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

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

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

18×9.5 Rota Grid - Full Royal Silver (5×100/e38/73)

18×9.5 Rota Grid - Full Royal Silver (5×112/e38/73)

18×9.5 Rota Grid - Full Royal Silver (5×114.3/e20/73)

18×9.5 Rota Grid - Full Royal Silver (5×114.3/e38/73)

18×9.5 Rota Grid - Gold (5×100/e38/73)

18×9.5 Rota Grid - Gold (5×114.3/e20/73)

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

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

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

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

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

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

18×9.5 Rota Grid - Hyper Blue (5×100/e38/73)

18×9.5 Rota Grid - Hyper Blue (5×114.3/e20/73)

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

18×9.5 Rota Grid - Speed Bronze (5×100/e38/73)

18×9.5 Rota Grid - Speed Bronze (5×114.3/e20/73)

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

18×9.5 Rota Grid - Titanium Chrome (5×100/e38/73)

18×9.5 Rota Grid - Titanium Chrome (5×114.3/e20/73)

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

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

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

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

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

18×8.5/9.5 Rota Grid - Flat Black (5×100/e44F/e38R/73)

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

18×8.5 Rota Grid - Flat Black (5×108/e42/73)

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

18×8.5 Rota Grid - Gold (5×100/e44/73)

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

18×8.5 Rota Grid - Hyper Black (5×108/e42/73)

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

18×8.5 Rota Grid - Speed Bronze (5×100/e44/73)

18×8.5 Rota Grid - Speed Bronze (5×114.3/e44/73)

18×8.5 Rota Grid - White (5×100/e44/73)

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

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

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

17×9 Rota Grid - Hyper Black (5×100/e35/73)

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

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

17×9 Rota Grid - Hyper Black(4×100/e20/51.7)

17×9 Rota Grid - Hyper Black(4×114.3/e12/73)

17×9 Rota Grid - Hyper Black(5×100/e30/73)

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

17×9 Rota Grid - Sports Bronze(4×114.3/e12/73)

17×9 Rota Grid - Sports Bronze(4×114.3/e25/73)

17×9 Rota Grid - Sports Bronze(5×100/e35/73)

17×9 Rota Grid - Sports Bronze(5×100/e42/73)

17×9 Rota Grid - Sports Bronze(5×114.3/e25/73)

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

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

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

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

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

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

17×9 Rota Grid-V - Speed Bronze (5×100/e42/73)

17×8 Rota Grid - Flat Black (4×108/e40/73)

16×8 Rota Grid Offroad - Flat Black(6×139.7/e0/110)

16×8 Rota Grid Offroad - Gunmetal(6×139.7/e0/110)