Toggle Nav
Language
This website or third-party tools used by this site use cookies that are necessary for its functioning and are useful for the purposes illustrated in the cookie policy.
If you want to learn more or opt out of all or some cookies, see the cookie policy.
By closing this banner you consent to the use of cookies.
Details
Shop By
Now Shopping by
Shopping Options
- Brand SAP TECNICA Remove This Item
- Category
- External dimension A (mm)
-
- 100.00 1 item
- 106.00 1 item
- 109.00 1 item
- 111.00 1 item
- 115.00 3item
- 124.00 1 item
- 124.50 1 item
- 127.00 2item
- 129.00 1 item
- 129.50 1 item
- 130.00 1 item
- 133.10 2item
- 134.00 2item
- 135.80 1 item
- 136.00 1 item
- 138.00 4item
- 140.00 5item
- 141.00 1 item
- 142.00 3item
- 143.00 2item
- 143.10 1 item
- 145.00 2item
- 146.00 1 item
- 151.50 4item
- 152.00 1 item
- 153.00 1 item
- 153.90 1 item
- 154.00 4item
- 154.35 1 item
- 154.60 1 item
- 158.00 1 item
- 158.70 1 item
- 158.80 1 item
- 162.10 1 item
- 165.00 5item
- 168.00 6item
- 168.10 1 item
- 169.00 5item
- 172.00 2item
- 173.00 2item
- 175.00 1 item
- 175.30 3item
- 176.00 2item
- 178.00 7item
- 180.00 3item
- 181.00 1 item
- 184.00 3item
- 185.00 1 item
- 186.00 1 item
- 188.00 1 item
- 190.00 1 item
- 192.00 1 item
- 195.00 1 item
- 195.10 2item
- 196.00 1 item
- 199.00 3item
- 199.70 2item
- 200.00 2item
- 201.00 6item
- 204.00 1 item
- 205.00 1 item
- 208.00 1 item
- 209.00 2item
- 209.20 1 item
- 213.00 2item
- 214.00 1 item
- 215.00 3item
- 216.90 2item
- 220.00 3item
- 223.00 4item
- 223.50 1 item
- 223.60 1 item
- 223.75 2item
- 224.00 9item
- 228.00 6item
- 228.50 1 item
- 229.00 2item
- 229.25 3item
- 231.00 1 item
- 233.00 2item
- 239.00 3item
- 240.00 1 item
- 242.50 1 item
- 242.60 2item
- 249.00 1 item
- 250.00 1 item
- 253.00 4item
- 254.00 1 item
- 259.10 1 item
- 259.80 1 item
- 260.00 4item
- 261.00 2item
- 262.70 1 item
- 264.00 2item
- 264.90 1 item
- 265.20 1 item
- 268.00 3item
- 272.00 2item
- 280.00 1 item
- 281.70 1 item
- 282.00 3item
- 283.30 1 item
- 284.00 3item
- 286.00 2item
- 288.00 2item
- 289.00 2item
- 290.10 1 item
- 297.50 1 item
- 298.00 2item
- 303.80 2item
- 304.00 2item
- 304.80 2item
- 306.00 1 item
- 311.20 1 item
- 316.00 1 item
- 319.00 1 item
- 325.00 1 item
- 327.00 3item
- 328.00 1 item
- 331.50 1 item
- 334.00 2item
- 340.00 2item
- 342.00 1 item
- 345.00 1 item
- 352.00 1 item
- 355.50 1 item
- 355.60 1 item
- 360.00 1 item
- 365.00 1 item
- 368.00 1 item
- 368.30 1 item
- 370.00 2item
- 371.30 1 item
- 374.00 1 item
- 381.00 1 item
- 384.00 1 item
- 384.60 1 item
- 384.80 2item
- 393.00 1 item
- 393.70 2item
- 408.90 1 item
- 412.20 1 item
- 419.00 1 item
- 420.00 1 item
- 420.90 1 item
- 429.80 1 item
- 431.80 2item
- 433.30 1 item
- 435.00 1 item
- 445.00 1 item
- 460.00 1 item
- 465.80 1 item
- 467.00 1 item
- 482.60 1 item
- 495.30 1 item
- 530.40 1 item
- 533.40 3item
- 550.00 1 item
- 570.00 1 item
- 650.00 1 item
- 677.70 2item
- 715.30 1 item
- 81.50 2item
- 88.00 1 item
- 9 x PAPER 1 item
- 94.00 1 item
- 97.00 1 item
- 98.00 2item
- KIT 19item
- PAD 2item
- External dimension B (mm)
-
- 100.00 4item
- 101.00 1 item
- 101.50 4item
- 102.80 1 item
- 104.90 1 item
- 105.50 1 item
- 105.60 2item
- 106.00 2item
- 106.70 3item
- 107.00 1 item
- 107.20 1 item
- 110.00 1 item
- 111.90 1 item
- 113.54 1 item
- 114.00 5item
- 115.00 1 item
- 116.00 1 item
- 116.20 1 item
- 118.10 1 item
- 119.00 4item
- 119.10 1 item
- 119.80 1 item
- 120.00 1 item
- 120.90 1 item
- 122.00 2item
- 124.00 2item
- 125.00 1 item
- 128.00 1 item
- 130.00 5item
- 132.10 1 item
- 136.00 1 item
- 138.00 3item
- 139.00 1 item
- 140.00 5item
- 141.50 1 item
- 144.00 2item
- 145.00 3item
- 145.20 1 item
- 145.50 2item
- 147.00 1 item
- 148.00 2item
- 150.00 4item
- 155.00 1 item
- 156.00 2item
- 160.00 2item
- 168.40 1 item
- 171.15 3item
- 173.00 1 item
- 175.00 1 item
- 176.00 2item
- 180.00 2item
- 180.10 1 item
- 190.00 1 item
- 192.90 1 item
- 194.00 1 item
- 195.10 1 item
- 200.00 1 item
- 200.20 1 item
- 201.80 1 item
- 204.00 1 item
- 206.00 3item
- 212.90 1 item
- 215.00 1 item
- 217.50 1 item
- 220.00 1 item
- 221.00 1 item
- 222.30 1 item
- 225.00 2item
- 240.00 1 item
- 244.90 1 item
- 252.00 1 item
- 252.10 1 item
- 258.00 1 item
- 259.10 1 item
- 266.00 1 item
- 273.10 1 item
- 273.30 1 item
- 273.80 1 item
- 280.00 2item
- 281.00 1 item
- 284.40 1 item
- 291.30 2item
- 292.10 1 item
- 292.60 2item
- 300.00 1 item
- 302.00 1 item
- 303.00 1 item
- 308.10 1 item
- 320.70 1 item
- 323.90 1 item
- 328.00 1 item
- 337.80 2item
- 34.00 4item
- 36.00 1 item
- 36.50 2item
- 371.10 1 item
- 388.60 1 item
- 391.00 1 item
- 40.00 1 item
- 40.50 5item
- 41.00 7item
- 416.00 1 item
- 42.00 1 item
- 43.00 2item
- 434.10 1 item
- 435.10 2item
- 44.00 7item
- 445.80 1 item
- 45.00 2item
- 45.10 2item
- 45.70 1 item
- 46.05 1 item
- 46.06 1 item
- 46.50 2item
- 460.00 1 item
- 48.00 1 item
- 492.60 2item
- 50.00 2item
- 50.50 1 item
- 51.00 2item
- 51.10 1 item
- 51.30 1 item
- 511.30 1 item
- 52.00 1 item
- 53.00 3item
- 53.40 1 item
- 55.00 4item
- 55.03 1 item
- 55.10 1 item
- 56.00 1 item
- 56.10 2item
- 57.00 1 item
- 58.00 1 item
- 59.00 4item
- 59.50 1 item
- 60.00 3item
- 62.00 2item
- 64.00 5item
- 66.10 4item
- 69.00 2item
- 70.00 1 item
- 70.10 1 item
- 71.00 2item
- 71.10 2item
- 71.50 5item
- 72.00 1 item
- 78.00 2item
- 79.00 1 item
- 8 x STEEL 1 item
- 80.00 1 item
- 81.00 2item
- 82.00 3item
- 83.80 1 item
- 84.30 1 item
- 84.50 1 item
- 88.00 5item
- 90.00 5item
- 91.00 5item
- 92.00 2item
- 92.70 2item
- 94.00 2item
- 97.00 1 item
- 97.30 1 item
- 97.34 1 item
- 98.00 1 item
- 99.00 5item
- 99.30 1 item
- PAPER 2item
- Internal diameter A (mm)
-
- 10.00 2item
- 100.00 5item
- 105.00 1 item
- 106.00 1 item
- 110.00 6item
- 12.00 3item
- 120.00 8item
- 130.00 7item
- 135.00 1 item
- 14.00 1 item
- 140.00 3item
- 145.00 1 item
- 15.00 4item
- 150.00 4item
- 16.00 4item
- 160.00 2item
- 17.00 2item
- 170.00 4item
- 180.00 1 item
- 19.00 1 item
- 190.00 1 item
- 192.00 1 item
- 195.40 1 item
- 20.00 13item
- 20.64 1 item
- 200.00 3item
- 21.99 1 item
- 22.00 10item
- 220.00 3item
- 231.78 1 item
- 240.00 2item
- 25.00 21item
- 25.40 2item
- 26.00 1 item
- 260.00 1 item
- 28.00 2item
- 280.00 3item
- 30.00 19item
- 30.16 1 item
- 315.00 1 item
- 32.00 2item
- 34.93 1 item
- 35.00 26item
- 36.51 1 item
- 38.00 1 item
- 38.10 1 item
- 40.00 30item
- 41.28 3item
- 42.00 3item
- 44.00 1 item
- 45.00 28item
- 48.00 1 item
- 49.00 1 item
- 50.00 31item
- 52.00 1 item
- 55.00 23item
- 58.00 2item
- 60.00 13item
- 63.00 1 item
- 65.00 18item
- 70.00 11item
- 72.00 1 item
- 75.00 13item
- 8.00 1 item
- 80.00 6item
- 85.00 4item
- 90.00 12item
- 95.00 4item
- 96.84 1 item
- 44.45 1 item
- 57.15 1 item
- 61.91 1 item
- 107.95 1 item
- 109.54 3item
- 158.75 1 item
- External diameter B (mm)
-
- 100.00 21item
- 105.00 2item
- 110.00 23item
- 115.00 5item
- 12.00 1 item
- 120.00 14item
- 125.00 6item
- 130.00 8item
- 135.00 1 item
- 14.00 3item
- 140.00 8item
- 146.00 1 item
- 147.00 1 item
- 150.00 7item
- 16.00 2item
- 160.00 13item
- 165.00 1 item
- 170.00 6item
- 18.00 1 item
- 180.00 7item
- 185.00 2item
- 190.00 2item
- 195.00 2item
- 200.00 5item
- 205.58 1 item
- 21.00 1 item
- 210.00 1 item
- 215.00 2item
- 22.00 4item
- 23.00 1 item
- 230.00 5item
- 24.00 4item
- 240.00 2item
- 250.00 1 item
- 26.00 4item
- 260.00 1 item
- 270.00 3item
- 28.00 4item
- 280.00 1 item
- 29.00 3item
- 290.00 1 item
- 3.00 1 item
- 30.00 6item
- 300.00 1 item
- 310.00 1 item
- 317.50 1 item
- 32.00 4item
- 320.00 1 item
- 340.00 1 item
- 345.00 1 item
- 35.00 7item
- 360.00 2item
- 37.00 2item
- 38.00 2item
- 380.00 2item
- 4.00 1 item
- 40.00 7item
- 400.00 2item
- 42.00 5item
- 420.00 1 item
- 43.00 1 item
- 44.00 1 item
- 45.00 7item
- 45.24 1 item
- 46.00 1 item
- 47.00 6item
- 48.00 2item
- 49.23 1 item
- 50.00 3item
- 52.00 15item
- 53.00 2item
- 54.00 1 item
- 55.00 5item
- 56.90 1 item
- 58.00 4item
- 60.00 2item
- 62.00 18item
- 63.00 1 item
- 64.29 1 item
- 65.00 1 item
- 68.00 4item
- 7.00 1 item
- 70.00 1 item
- 72.00 11item
- 72.23 1 item
- 74.00 1 item
- 75.00 1 item
- 78.00 1 item
- 79.20 1 item
- 79.38 1 item
- 80.00 22item
- 84.00 1 item
- 85.00 9item
- 88.90 2item
- 90.00 20item
- 95.00 5item
- 96.70 1 item
- 96.84 1 item
- 38.75 1 item
- 55.52 1 item
- 57.15 1 item
- 61.74 1 item
- 69.67 1 item
- 73.43 1 item
- 92.25 1 item
- 148.43 1 item
- 158.75 4item
- Size C (mm)
-
- 10.00 2item
- 108.00 1 item
- 11.00 1 item
- 12.00 2item
- 127.00 1 item
- 13.00 5item
- 130.00 1 item
- 14.00 1 item
- 140.00 1 item
- 15.00 5item
- 15.60 1 item
- 16.00 10item
- 16.64 1 item
- 17.00 10item
- 18.00 9item
- 19.00 7item
- 19.43 1 item
- 19.56 1 item
- 19.85 1 item
- 2.00 3item
- 2.80 1 item
- 20.00 30item
- 208.00 1 item
- 21.00 10item
- 21.21 1 item
- 21.43 1 item
- 22.00 7item
- 22.50 1 item
- 23.00 18item
- 23.70 1 item
- 24.00 1 item
- 25.00 20item
- 25.40 1 item
- 26.00 7item
- 27.00 10item
- 28.00 7item
- 28.58 1 item
- 29.00 11item
- 29.37 1 item
- 3.20 1 item
- 30.00 9item
- 30.16 1 item
- 30.63 1 item
- 30.70 1 item
- 30.96 1 item
- 31.00 6item
- 31.50 1 item
- 32.00 9item
- 32.50 1 item
- 33.00 2item
- 33.30 1 item
- 33.50 1 item
- 34.00 4item
- 34.50 1 item
- 35.50 1 item
- 36.00 4item
- 36.70 1 item
- 37.00 4item
- 38.00 7item
- 39.00 2item
- 4.00 1 item
- 40.00 3item
- 41.00 2item
- 43.50 1 item
- 45.00 3item
- 45.50 1 item
- 46.00 3item
- 47.00 1 item
- 47.63 1 item
- 48.00 1 item
- 48.50 1 item
- 49.00 1 item
- 50.00 1 item
- 51.00 2item
- 52.00 1 item
- 52.40 2item
- 53.00 1 item
- 54.00 1 item
- 55.00 1 item
- 56.00 1 item
- 57.00 1 item
- 58.00 1 item
- 6.00 1 item
- 60.00 2item
- 61.50 1 item
- 63.50 1 item
- 64.00 1 item
- 67.00 2item
- 7.00 13item
- 7.94 1 item
- 75.00 1 item
- 76.00 1 item
- 77.00 1 item
- 8.00 3item
- 8.50 1 item
- 80.00 2item
- 84.00 1 item
- 87.00 1 item
- 91.00 1 item
- 10.32 1 item
- 13.25 1 item
- 16.25 2item
- 17.25 2item
- 18.25 6item
- 19.05 1 item
- 19.25 2item
- 19.75 2item
- 20.75 2item
- 21.25 1 item
- 21.75 2item
- 22.25 1 item
- 22.75 4item
- 23.02 4item
- 24.25 1 item
- 24.75 5item
- 25.25 4item
- 26.25 1 item
- 26.75 1 item
- 27.25 6item
- 28.25 1 item
- 29.25 3item
- 29.75 1 item
- 32.75 2item
- 35.25 2item
- 41.27 1 item
- 42.25 2item
- 43.75 1 item
- 58.29 1 item
- 67.75 1 item
- Size B (mm)
-
- 100.00 5item
- 101.50 2item
- 102.00 3item
- 103.30 2item
- 105.00 1 item
- 107.00 1 item
- 110.00 4item
- 113.80 2item
- 114.00 1 item
- 115.00 1 item
- 120.00 11item
- 122.90 2item
- 123.00 1 item
- 126.00 1 item
- 129.30 1 item
- 130.00 1 item
- 134.00 3item
- 134.70 1 item
- 136.00 1 item
- 139.00 1 item
- 140.00 6item
- 143.50 1 item
- 145.00 1 item
- 145.30 1 item
- 149.00 1 item
- 150.00 9item
- 151.30 1 item
- 155.00 1 item
- 156.00 2item
- 160.00 1 item
- 195.00 2item
- 200.00 1 item
- 25.50 1 item
- 40.00 1 item
- 50.00 1 item
- 50.40 1 item
- 60.00 1 item
- 62.00 2item
- 65.00 1 item
- 70.00 3item
- 75.00 3item
- 78.00 1 item
- 78.50 2item
- 78.60 1 item
- 82.00 1 item
- 84.00 1 item
- 85.00 5item
- 99.00 1 item
- Size R (mm)
- Size Hole
- Thickness C (mm)
-
- 0.80 3item
- 1.00 2item
- 1.20 1 item
- 1.40 2item
- 1.50 12item
- 1.60 2item
- 1.70 2item
- 1.80 5item
- 1.90 8item
- 10.00 17item
- 2.00 14item
- 2.10 1 item
- 2.20 3item
- 2.30 5item
- 2.40 6item
- 2.50 7item
- 2.60 4item
- 2.70 15item
- 2.80 4item
- 2.90 4item
- 3.00 10item
- 3.15 1 item
- 3.20 5item
- 3.40 1 item
- 3.50 12item
- 3.60 1 item
- 3.70 2item
- 3.80 4item
- 3.90 2item
- 4.00 9item
- 4.10 1 item
- 4.20 1 item
- 4.30 4item
- 4.50 6item
- 4.60 3item
- 4.70 7item
- 4.80 26item
- 4.90 15item
- 5.00 13item
- 5.10 4item
- 5.20 3item
- 5.30 3item
- 5.50 4item
- 5.60 8item
- 5.70 1 item
- 6.00 1 item
- 6.10 4item
- 6.50 2item
- 6.70 3item
- 6.90 1 item
- 7.00 6item
- 7.10 1 item
- 7.40 1 item
- 7.60 1 item
- 8.90 1 item
- 9.50 4item
- 9.60 2item
- 9.70 3item
- WAFFLE 2item
- Number of teeth Z
-
- 1.000000 9item
- 10.000000 1 item
- 100.000000 1 item
- 102.000000 1 item
- 104.000000 1 item
- 108.000000 2item
- 12.000000 8item
- 120.000000 4item
- 122.000000 2item
- 124.000000 1 item
- 128.000000 2item
- 13.000000 4item
- 132.000000 2item
- 134.000000 1 item
- 138.000000 2item
- 14.000000 8item
- 142.000000 1 item
- 15.000000 10item
- 16.000000 6item
- 17.000000 1 item
- 18.000000 1 item
- 19.000000 5item
- 2.000000 7item
- 20.000000 4item
- 21.000000 4item
- 22.000000 11item
- 23.000000 2item
- 24.000000 5item
- 25.000000 1 item
- 26.000000 3item
- 27.000000 11item
- 28.000000 6item
- 29.000000 3item
- 3.000000 16item
- 32.000000 8item
- 34.000000 2item
- 35.000000 4item
- 36.000000 13item
- 38.000000 3item
- 4.000000 4item
- 40.000000 4item
- 42.000000 1 item
- 43.000000 1 item
- 44.000000 2item
- 45.000000 8item
- 46.000000 1 item
- 48.000000 3item
- 49.000000 1 item
- 5.000000 1 item
- 50.000000 1 item
- 52.000000 6item
- 53.000000 1 item
- 54.000000 7item
- 56.000000 1 item
- 58.000000 3item
- 6.000000 16item
- 60.000000 7item
- 61.000000 1 item
- 62.000000 4item
- 63.000000 1 item
- 64.000000 3item
- 65.000000 2item
- 66.000000 5item
- 67.000000 1 item
- 68.000000 1 item
- 72.000000 3item
- 74.000000 1 item
- 76.000000 1 item
- 78.000000 1 item
- 79.000000 1 item
- 8.000000 4item
- 81.000000 1 item
- 87.000000 3item
- 88.000000 1 item
- 89.000000 1 item
- 90.000000 1 item
- 92.000000 1 item
- 93.000000 1 item
- 95.000000 1 item
- 96.000000 2item
- 97.000000 1 item
- ANELLO+ASOLE+FORI 2item
- STEEL 5item
SAP TECNICA
SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`url_key`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`codicesaptecnica`, `e`.`costruttoredrop`, `e`.`costruttoredrop_value`, `e`.`codiceoriginale`, `e`.`isooforigin`, `e`.`specweightnetmass`, `e`.`diametro_interno`, `e`.`diametro_interno_value`, `e`.`diametro_esterno`, `e`.`diametro_esterno_value`, `e`.`spessore`, `e`.`spessore_value`, `e`.`codice_internazionale`, `e`.`dimensione_a`, `e`.`dimensione_a_value`, `e`.`dimensione_b`, `e`.`dimensione_b_value`, `e`.`dimensione_r`, `e`.`dimensione_r_value`, `e`.`dimensione_foro`, `e`.`dimensione_foro_value`, `e`.`sconto_articolo`, `e`.`dimensione_esterna`, `e`.`dimensione_esterna_value`, `e`.`dimensione_interna`, `e`.`dimensione_interna_value`, `e`.`dettaglio_1`, `e`.`dettaglio_1_value`, `e`.`dettaglio_2`, `e`.`dettaglio_2_value`, `e`.`dettaglio_3`, `e`.`dettaglio_3_value`, `e`.`materiale`, `e`.`materiale_value`, `e`.`numero_denti`, `e`.`numero_denti_value`, `e`.`dimensione_esterna_freno`, `e`.`dimensione_esterna_freno_value`, `e`.`dimensione_interna_freno`, `e`.`dimensione_interna_freno_value`, `e`.`spessore_freno`, `e`.`spessore_freno_value`, `e`.`numero_denti_freno`, `e`.`numero_denti_freno_value`, `e`.`tipo`, `e`.`tipo_value`, `e`.`dimensione_c`, `e`.`dimensione_c_value`, `e`.`codice_iso_cuscinetti`, `e`.`codice_iso_cuscinetti_value`, `e`.`data_consegna`, `e`.`articoli_sostitutivi`, `e`.`diametro_esterno_2`, `e`.`diametro_esterno_2_value`, `e`.`altezza`, `e`.`altezza_value`, `e`.`altezza_2`, `e`.`altezza_2_value`, `e`.`famiglia_prodotto`, `e`.`famiglia_prodotto_value`, `e`.`descrizione_estesa`, `e`.`mescola`, `e`.`mescola_value`, `e`.`availability`, `e`.`availability_value`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_flat_2` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 2 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (e.entity_id IN (1747375, 1743279, 1739183, 1730087, 1725990)) ORDER BY FIELD(e.entity_id,1747375,1743279,1739183,1730087,1725990)
Available
Incoming goods
Not on stock
Insufficient quantity in stock
Information request
Replaced item
Attention
Register or LOGIN to view all data