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 '%19x8.5/10_linea_corse_l22%' or p.products_model like '%19x8.5/10_linea_corse_l22%' or m.manufacturers_name like '%19x8.5/10_linea_corse_l22%') )


BMW e90/e91/e92/e93 Featured Wheels

If flash above is not working, click here for BMW e90 gallery.

19×8.5/10 Linea Corse Dyna - Hyper Black (5×120/e30F,e37R)

19×8.5/10 Linea Corse Dyna - Polished (5×120/e30F,e37R)

* BMW E9X Wheel & Tire Package 19″ Linea Corse L22 - Hyper Black

* BMW E9X Wheel & Tire Pkg 19″ Linea Corse L22 - Hyp Sil PLip

19×8.5/10 Linea Corse L22 - Satin Black (5×120, +30+37)

19×8.5/10 Linea Corse Lemans - Hyper Black(5×120/e30F,e37R)

19×8.5/10 Linea Corse Lemans - Gold(5×120/e30F,e37R)

More wheels for BMW E9X’s after the cut!

Read more…

Jeff’s BMW e92 on Linea Corse L22 wheels

last minute shoot in the middle of the day… was only able to find a tree for shade. This black e90 has been featured before w/ Lemans but something different always works.

owner: jeff
wheels: 19×8.5/10 Linea Corse L22 - Hyper Silver Pol Lip (5×120 +30+37)
tires: NITTO INVOs
235/35/19 front
265/30/19 rear Gallery Gallery Gallery

Wheel Details

Higher res. pix

Just Added! - 19×8.5/10 Linea Corse L22 Wheels - Now in SATIN BLACK!

New color for BMW 2006-current 3-series! Satin black for that “murdered-out” look!

Linea Corse L22 19x8.5/10 Satin Black

Click Here For Details

BMW e92 on 19″ Staggered Linea Corse L22 Wheels

Zoeb’s e92
wheels: 19×8.5/10 Linea Corse L22 - Hyper Silver Pol Lip (5×120 +30+37)
tires: 235/35/19 front, 265/35/19 rear NITTO Invo Gallery Gallery Gallery

Wheel Details

Forum Link