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


Cameron’s FRS on 17×9 Rota Grid-V in Hyper Black

Owner: Cameron
Car: Scion FR-S
Wheels: 17×9 Rota Grid-V - Hyper Black (5×100/e42/73)
Tires: 245/40/17 Federal 595 rsrr tires
Suspension: BC BR coilovers

Zak’s WRX on 17×9 Flat Black Grids

Owner: Zak
Car: Subaru WRX
Wheels: 17×9 Rota Grid - Flat Black (5×100/e42/73)
Tire: 245/40/17
Suspension: Stock

Sven’s Bugeye on 17×9 Sports Bronze Grids

Owner: Sven
Car: Subaru WRX
Wheels: 17×9 Rota Grid - Sports Bronze(5×100/e42/73)
Tire: 245/40-17

Noah’s STi on 17×9 Gold Grids

Owner: Noah
Car: Subaru STi
Wheels: 17×9 Rota Grid - Gold (5×114.3/e42/73)
Suspensions: Megan Racing Coilovers
Tire: Michelin pilot sport 3 245/45/17

Spencer’s 2013 Scion FR-S on 17×9 +42 in Flat Black Grids

Owner: Spencer
Car: 2013 Scion FR-S
Wheels: 17×9 Rota Grid - Flat Black (5×100/e42/73)
Tires: Michelin Pilot Super Sport tires in 245/40/17
Suspension: Stance Super Sport coilovers (lowered about 2in)
SPC rear lower control arms
Mods: Jackson Racing C30 CARB legal supercharger
Delicious Tuning flex fuel kit
Verus front splitter with race upgrade

Brad’s 2014 BRZ on 17×9 e40 Chameleon Grids

Owner: Brad
Car: 2014 Subaru BRZ limited
Wheels: 17×9 Rota Grid - Chameleon (5×100/e40/73)
Tires: 245/40-17 Firestone Firehawk Indy’s
Suspension: KW v1 coilovers

$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

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