Search Here

 

My Shopping Cart

Products: 0
Total: £0.00

My Wish Lish (View)

You have no items on your Wishlist

Home » Universal » Universal Lamps and horns » HL-

To check on Internet placed orders 01472 722227 Telephone Orders 01472 722 222 Postal related enquiries 01472 722224

  
My Currency

Social Login
Please choose below:
Please choose below:
Goto...
Gift VouchersAutomatic Scooter PartsLambretta PartsVespa PartsMotorcycle PartsExhausts, Shock Absorbers, TyresBrake Pads, Shoes, Discs, HydrauTools, Manuals, Fasteners, PaintOil, Spark Plug, Battery, FilterCarburettor Kits and PartsAlarms, Covers, SecurityBulbs, Gauges, Counters, WiringClothingMudflapsNumber Plates and L PlatesUniversalUniversal AccessoriesUniversal Bars, Grips, LeversUniversal Footpegs / Side StandsUniversal Lamps and hornsUniversal Licence HoldersUniversal MirrorsUniversal Switches + ElectricalUniversal Valve CapsNoveltySpecial Offers, Clearance PartsPowder Coating Service
Latest Products
1030 - Got error 28 from storage engine

SELECT p.products_id, pd.products_name, pd.products_description, pd.products_short, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' where p.products_status = '1' and p.products_featured = '1' order by rand() DESC limit 2

[TEP STOP]