Alfasud Parts and Spares
  Shop »
My Account  |  Cart Contents  |  Checkout  |  Contact Us  
Categories
Body Panels (93)
Exterior Trim (115)
Interior (167)
Wheels and Tyres (4)
Electrical / Lighting (163)
Mechanical (112)
Service Items (40)
Accessories (1)
Specials
Newest Products
Goto...
Languages
English French Spanish
German Italian Portuguese
Korean Japanese Arabic
Join Our Mailing List
Email:
For Email Marketing you can trust
Photo gallery
View some pictures of our customers cars.
Go to the Image Gallery
Add Your Own Image
What's New? more
33 Series 1/ 2 1983-90 Left door mirror
33 Series 1/ 2 1983-90 Left door mirror
£19.99
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Solution Graphics
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Product not found!
Continue
You may be interested in these other Alfa products
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and res.product_id<> group by res.product_id order by count desc, rand() limit 8' at line 1

select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price , count(distinct res.ipaddress) as count, res.product_id from product_audit source join product_audit res on res.IPAddress = source.IPAddress join products p on p.products_id = res.product_id join products_description pd on pd.products_id = p.products_id join specials s on p.products_id = s.products_id where res.source<>'related' and source.product_id = and res.product_id<> group by res.product_id order by count desc, rand() limit 8

[TEP STOP]