INSERT INTO `Table` (`DN`, `outside diameter D , in mm`, `diameter of bolt circle K , in mm`, `diameter of bolt hole L , in mm`, `number of bolts`, `bolts size`, `outside diameter of neck A , in mm`, `bore diameters B_1 , in mm`, `bore diameters B_2 , in mm`, `flange thickness C_1 , in mm`, `flange thickness C_2 , in mm`, `flange thickness C_3 , in mm`, `flange thickness C_4 , in mm`, `chamfer E , in mm`, `collar thickness F_1 , in mm`, `collar thickness F_2 , in mm`, `collar thickness F_3 , in mm`, `collar thickness F_4 , in mm`, `centre portion G_max , in mm`, `length H_1 , in mm`, `length H_2 , in mm`, `length H_3 , in mm`, `length H_4 , in mm`, `length H_5 , in mm`, `length H_6 , in mm`, `neck diameters N_1 , in mm`, `neck diameters N_2 , in mm`, `neck diameters N_3 , in mm`, `corner radius R_1 , in mm`) VALUES (10, 75, 50, 11, 4, 'M10', 17.2, 18, 21, 12, 12, 12, 12, 3, 10, 5, 2, 2.5, '-', 20, 28, 6, 28, 7, 35, 26, 25, 20, 4), (15, 80, 55, 11, 4, 'M10', 21.3, 22, 25, 12, 12, 12, 12, 3, 10, 5, 2, 2.5, '-', 20, 30, 6, 30, 7, 38, 30, 30, 26, 4), (20, 90, 65, 11, 4, 'M10', 26.9, 27.5, 31, 14, 14, 14, 14, 4, 10, 6, 2.5, 3, '-', 24, 32, 6, 32, 8, 40, 38, 40, 34, 4), (25, 100, 75, 11, 4, 'M10', 33.7, 34.5, 38, 14, 14, 14, 14, 4, 10, 7, 2.5, 3, '-', 24, 35, 6, 35, 10, 40, 42, 50, 44, 4), (32, 120, 90, 14, 4, 'M12', 42.4, 43.5, 46, 16, 14, 14, 14, 5, 10, 8, 3, 3, '-', 26, 35, 6, 35, 12, 42, 55, 60, 54, 6), (40, 130, 100, 14, 4, 'M12', 48.3, 49.5, 53, 16, 14, 14, 14, 5, 10, 8, 3, 3, '-', 26, 38, 7, 38, 15, 45, 62, 70, 64, 6), (50, 140, 110, 14, 4, 'M12', 60.3, 61.5, 65, 16, 14, 14, 14, 5, 12, 8, 3, 3, '-', 28, 38, 8, 38, 20, 45, 74, 80, 74, 6), (65, 160, 130, 14, 4, 'M12', 76.1, 77.5, 81, 16, 14, 14, 14, 6, 12, 8, 3, 3, 55, 32, 38, 9, 38, 20, 45, 88, 100, 94, 6), (80, 190, 150, 18, 4, 'M16', 88.9, 90.5, 94, 18, 16, 16, 16, 6, 12, 10, 3, 4, 70, 34, 42, 10, 42, 25, 50, 102, 110, 110, 8), (100, 210, 170, 18, 4, 'M16', 114.3, 116, 120, 18, 16, 16, 16, 6, 14, 10, 4, 4, 90, 40, 45, 10, 45, 25, 52, 130, 130, 130, 8), (125, 240, 200, 18, 8, 'M16', 139.7, 141.5, 145, 20, 18, 18, 18, 6, 14, 10, 4, 4, 115, 44, 48, 10, 48, 25, 55, 155, 160, 160, 8), (150, 265, 225, 18, 8, 'M16', 168.3, 170.5, 174, 20, 18, 18, 18, 6, 14, 10, 5, 4, 140, 44, 48, 12, 48, 25, 55, 184, 185, 182, 10), (200, 320, 280, 18, 8, 'M16', 219.1, 221.5, 226, 22, 20, 20, 20, 6, 16, 11, 5, 5, 190, 44, 55, 15, 55, 30, 62, 236, 240, 238, 10), (250, 375, 335, 18, 12, 'M16', 273, 276.5, 281, 24, 22, 22, 22, 8, 18, 12, 8, '-', 235, 44, 60, 15, 60, '-', 68, 290, 295, 284, 12), (300, 440, 395, 22, 12, 'M20', 323.9, 327.5, 333, 24, 22, 22, 22, 8, 18, 12, 8, '-', 285, 44, 62, 15, 62, '-', 68, 342, 355, 342, 12), (350, 490, 445, 22, 12, 'M20', 355.6, 359.5, 365, 26, 22, 22, 22, 8, 18, 13, 8, '-', 330, '-', 62, 15, 62, '-', 68, 385, '-', 392, 12), (400, 540, 495, 22, 16, 'M20', 406.4, 411, 416, 28, 22, 22, 22, 8, 20, 14, 8, '-', 380, '-', 65, 15, 65, '-', 72, 438, '-', 442, 12), (450, 595, 550, 22, 16, 'M20', 457, 462, 467, 30, 22, 22, 24, 8, 20, 15, 8, '-', 425, '-', 65, 15, 72, '-', 72, 492, '-', 494, 12), (500, 645, 600, 22, 20, 'M20', 508, 513.5, 519, 30, 24, 24, 24, 8, 22, 16, 8, '-', 475, '-', 68, 15, 75, '-', 75, 538, '-', 544, 12), (600, 755, 705, 26, 20, 'M24', 610, 616.5, 622, 32, 30, 30, 30, 8, 22, 16, '-', '-', 575, '-', 70, 16, 70, '-', '-', 640, '-', 642, 12), (700, 860, 810, 26, 24, 'M24', 711, '-', 721, 40, 30, 30, 40, 4, '-', 16, '-', '-', 670, '-', 76, 16, 70, '-', '-', 740, '-', 746, 12), (800, 975, 920, 30, 24, 'M27', 813, '-', 824, 44, 30, 30, 44, 4, '-', 16, '-', '-', 770, '-', 76, 16, 70, '-', '-', 842, '-', 850, 12), (900, 1075, 1020, 30, 24, 'M27', 914, '-', 926, 48, 34, 34, 48, 4, '-', 16, '-', '-', 860, '-', 78, 16, 70, '-', '-', 942, '-', 950, 12), (1000, 1175, 1120, 30, 28, 'M27', 1016, '-', 1028, 52, 38, 38, 52, 4, '-', 18, '-', '-', 960, '-', 82, 16, 70, '-', '-', 1045, '-', 1050, 16), (1200, 1405, 1340, 33, 32, 'M30', 1219, '-', 1234, 60, 42, 42, 60, 5, '-', 20, '-', '-', 1160, '-', 104, 20, 90, '-', '-', 1248, '-', 1264, 16), (1400, 1630, 1560, 36, 36, 'M33', 1422, '-', '-', 72, 56, 56, 68, '-', '-', '-', '-', '-', 1346, '-', 114, 20, '-', '-', '-', 1452, '-', 1480, 16), (1600, 1830, 1760, 36, 40, 'M33', 1626, '-', '-', 80, 63, 63, 76, '-', '-', '-', '-', '-', 1546, '-', 119, 20, '-', '-', '-', 1655, '-', 1680, 16), (1800, 2045, 1970, 39, 44, 'M36', 1829, '-', '-', 88, 69, 69, 84, '-', '-', '-', '-', '-', 1746, '-', 133, 20, '-', '-', '-', 1855, '-', 1878, 16), (2000, 2265, 2180, 42, 48, 'M39', 2032, '-', '-', 96, 74, 74, 92, '-', '-', '-', '-', '-', 1950, '-', 146, 25, '-', '-', '-', 2058, '-', 2082, 16), (2200, 2475, 2390, 42, 52, 'M39', 2235, '-', '-', '-', 81, 81, '-', '-', '-', '-', '-', '-', '-', '-', 154, 25, '-', '-', '-', 2260, '-', '-', 18), (2400, 2685, 2600, 42, 56, 'M39', 2438, '-', '-', '-', 87, 87, '-', '-', '-', '-', '-', '-', '-', '-', 168, 25, '-', '-', '-', 2462, '-', '-', 18), (2600, 2905, 2810, 48, 60, 'M45', 2620, '-', '-', '-', 91, 91, '-', '-', '-', '-', '-', '-', '-', '-', 175, 25, '-', '-', '-', 2665, '-', '-', 18), (2800, 3115, 3020, 48, 64, 'M45', 2820, '-', '-', '-', 101, 101, '-', '-', '-', '-', '-', '-', '-', '-', 188, 30, '-', '-', '-', 2865, '-', '-', 18), (3000, 3315, 3220, 48, 68, 'M45', 3020, '-', '-', '-', 102, 102, '-', '-', '-', '-', '-', '-', '-', '-', 192, 30, '-', '-', '-', 3068, '-', '-', 18), (3200, 3525, 3430, 48, 72, 'M45', 3220, '-', '-', '-', 106, 106, '-', '-', '-', '-', '-', '-', '-', '-', 202, 30, '-', '-', '-', 3272, '-', '-', 20), (3400, 3735, 3640, 48, 76, 'M45', 3420, '-', '-', '-', 110, 110, '-', '-', '-', '-', '-', '-', '-', '-', 214, 35, '-', '-', '-', 3475, '-', '-', 20), (3600, 3970, 3860, 56, 80, 'M52', 3620, '-', '-', '-', 124, 124, '-', '-', '-', '-', '-', '-', '-', '-', 229, 35, '-', '-', '-', 3678, '-', '-', 20)