005 Crankshaft, Pistons, Conrods & Flywheel

Click on the image for a larger picture

Item Name	Price (Ex.VAT)
001 Piston Assy	€272,79
002 Lower Shim Ring, "cl. A" SOLD OUT	€14,62
002 Upper Piston Ring	€38,98
003 Lower Piston Ring	€96,81
003 Upper Shim Ring, "cl. A" SOLD OUT	€14,72
004 Dowel	€8,84
004 Oil Scraper With Spring	€102,38
005 Bearing	€16,36
005 Retaining Ring	€2,96
006 Piston Ring	Unavailable (at the moment)
006 Retaining Ring	€0,32
007 Dowel	€2,31
008 Flywheel Assy 6 Securing Holes	€246,69
008 Upper Shim Ring, Cl. B (0.025) SOLD OUT	€31,18
008 Upper Shim Ring, Cl. C (0.030)	€13,34
009 Crankshaft	Unavailable (at the moment)
009 Crankshaft	Unavailable (at the moment)
010 Connecting Rod, Assy	€66,43
018 Bolt	Unavailable (at the moment)
019 Lower Shim Ring, Cl. B (0.025)	€31,18
019 Lower Shim Ring, Cl. C (0.030) SOLD OUT	€13,34
019 Standard Big End Bearing	€48,00
020 Standard Main Bearing	€61,00
021 Crankshaft Oil Plug	Unavailable (at the moment)
022 Dowel	Unavailable (at the moment)
023 Toothed Pulley	€51,31
027 Disc	€129,89
027 Screw	Unavailable (at the moment)
028 Flange	€347,82
030 Plate	€2,12
031 Crown Gear 8 Securing Holes	€308,79
031 Dowel	€4,43

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 'groups where status = 'active'' at line 2
in:
[select group_id AS id, group_name_nl AS text from groups where status = 'active']