MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE IF NOT EXISTS `temp` (
  `custid` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '客戶代碼',
  `productid` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '存貨代碼',
  `amount` bigint(12) NOT NULL COMMENT '銷售額'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `temp` (`custid`, `productid`, `amount`) VALUES ('WJ0090', 'EK-15-SSP5', 85860), ('U20032', 'NART-30UUR-IKO', 4800), ('WJ0130', 'Z12', 70), ('X20016', 'SMK-12WUU-E-SK', 45000), ('WJ0131', 'SSR15XW1UU-1120LY', 3000), ('FX0016', 'L-1980ZZ', 720), ('9R0004', 'HSR25AZZ', 301140), ('FT0007', 'SMF-12GUU-SK', 660), ('FT0007', '7204BW', 2430), ('XU0007', 'RB-2508UUCC0', 9280), ('F10002', 'SSLF-1060-EZO', 1472), ('WJ0104', 'LM-30UU', 6450), ('WG0012', 'L-730ZZ-JIB', 160), ('WJ0090', '6001-H-20T1XDDU*MA', 104000), ('WJ0094', 'L-630ZZ', 4230), ('WG0012', 'SS6901ZZ-YCB', 50), ('WJ0009', 'TLA-1210', 372), ('WG0012', 'L-730ZZ', 960), ('FT0007', 'AFF+70G', 29904), ('WJ0091', 'EGH20R260', 660), ('RM0012', 'MBF1602-3.7G0-334LC3', 90000), ('WJ0091', 'FK-20', 6980), ('AF5010', 'DPM-2550', 1770), ('UU0009', '6001ZZ-NSK', 300), ('RJ0006', 'T-1810', 7000), ('WJ0094', 'L-630ZZ', 846), ('WJ0090', '6006-H-20T1XDDU*MA', 38500), ('ZM0006', 'L-1960ZZ', 160), ('5Z0011', 'SB-30', 980), ('WJ0100', 'LM-6', 800), ('WJ0090', '6811LLB', 141000), ('JR0008', 'AFB-LF+70G', 3000), ('FT0007', 'AFF+70G', 29904), ('MT0024', 'MTC-55CRD-22K6-25K8', 1450), ('WJ0091', 'SS6201-2RS', 3360), ('WJ0104', '6304VV-NSK', 400), ('FM0014', 'CF-3MA-JNS', 6900), ('F10001', 'GRS-LGU', 9000), ('XM0007', '6218-NTN', 950), ('WJ0009', 'NTB-1024', 336), ('WJ0009', 'L-1340ZZ', 39), ('BM0002', 'CFN-6RA', 14700), ('WJ0031', 'SRS12WMUU', 2360), ('WG0012', '6815ZZ-FBJ', 1000), ('WJ0090', 'LMF-30MLUU', 23820), ('FT0007', 'SHS45LV2UUFME-3610LTF', 63460), ('WG0012', 'LM-12UU-YCB', 140), ('BM0002', 'BWU25-45', 14000), ('AZ0005', 'HSR25LCSS', 55200), ('VU0021', 'GRS-LGU', 9500), ('CF0022', 'VR3-75H-10Z', 16275), ('WG0012', '1651-211-22-4-1605-201-31-1300L', 33600), ('F10002', 'SVW2120-21Z', 10800), ('U20007', 'SCE200-80X120-2', 1635), ('WJ0090', '2SRS12MUU-120LM', 4630), ('WJ0090', '6002ZZ-NSK', 5200), ('WJ0091', 'VLAST45-06-0100-0-0N', 12300), ('RU0035', 'MTC-65CRD-19-20', 3760), ('U20010', '2-KSH-40L-110-52-HD-HD', 120000), ('NV0002', 'L-1260ZZ', 3600), ('5Z0011', 'Z12', 40), ('FT0007', 'SMSF-30WUU-E', 12080), ('RE0001', '30206-NSK', 1680), ('WG0012', 'L-1360ZZ-JIB', 112), ('FX0011', 'GRS-NS7', 6500), ('FT0006', 'WBK20-11-2', 3500), ('FT0007', '6004-H-20T1XDDU*MA', 222), ('WJ0094', 'L-1650ZZ', 70), ('FT0007', 'LMK-13LUU', 2100), ('U20007', 'SRS15-310LM', 3500), ('RJ0006', 'L-1910ZZ', 4800), ('TR0009', '6804ZZ-NTN', 520), ('WJ0090', '6905-H-20T1XDDU*MA', 30000), ('FT0006', '6914VV', 1350), ('WJ0009', 'L-1350ZZ', 86), ('WJ0090', '1314127', 284000), ('R50025', 'Z18', -17300), ('CR0003', 'SFIR3205-4-635L-DF-C7', 12770), ('FT0007', '1666-113-20', 4485), ('WJ0091', '6003-H-20T1XDDU*MA', 192), ('CF0022', 'NV2045-9Z', 19300), ('WJ0075', 'L-1480ZZ', 360), ('WG0012', 'L-1360ZZ-JIB', 112), ('FG0010', 'LM-8', 680), ('WJ0009', 'L-1560ZZ', 1672), ('MC0007', 'SSR15XVUU', 2700), ('WJ0090', 'AFF+400G', 290000), ('WJ0090', '1314095', -360000), ('WC0009', '7210A5RDULP3', 27600), ('WJ0009', 'L-1040ZZ', 360), ('R20016', 'SR30-3000L', 180900), ('9R0004', 'SHS35R2SS-2040L', 57800), ('5X0011', 'Z12', 40), ('FT0007', 'SS6001ZZ', 2610), ('WJ0090', '1315768', -340000), ('9R0003', 'DK2506S-3RRGT-503LC7', 45820), ('WJ0090', '6904ZZ-NSK', 95), ('U20032', 'SHS30RSSFM', 29200), ('WJ0009', '6902ZZ', 352), ('WJ0091', '0455-203-31-280L', 8415), ('RU0035', 'MFL-32-12-12', 2040), ('JR0008', 'AFB-LF+70G', 3000), ('WJ0221', 'UC215-FYH', 3400), ('WJ0095', 'AFF+70G', 3720), ('WJ0009', 'L-1040ZZ', 90), ('WJ0090', 'AFF+400G', 290000), ('WJ0009', '6900ZZ-EZO', 120), ('VU0004', 'GRS-AS2', 600), ('JA0004', 'GRS-LG2', 14500), ('WJ0091', 'SS6203-2RS', 2628), ('WJ0009', 'VR6-100H-7Z', 4290), ('FT0007', '1-KSH-32WL-60-500', 66000), ('WJ0090', 'AFA+400G', 90000), ('CW0015', 'LWHDG12SL', 8600), ('WG0012', 'LF-740ZZ-JIB', 1152), ('WJ0090', '1651-294-20', 7440), ('FT0006', 'L-1650ZZ', 1200), ('CV0047', 'MTC-40CRD-15-16', 4705), ('SF0002', 'Z18', 6100), ('CW0015', 'GRS-LG2', 16000), ('MA0010', '6810ZZ-NTN', 3900), ('U20007', '2-KSH-40-110-54-HD-HD', 25200), ('JR0008', 'SSA-2216', 1275), ('WG0012', 'CF-6UUA', 870), ('EV0012', 'XGL2-30C-8-14', 2150), ('CF0004', 'GRS-LGU', 22000), ('CM0005', 'SS6804ZZ-FBJ', 5800), ('CM0005', '6205-H-20T1XAZZ*MA', 740), ('UG0028', 'BGXH25FN-N-Z0', 2780), ('WJ0009', 'CRT6-12', 384), ('FM0014', 'HK-1501-A', 49800), ('WJ0091', 'GRS-LG2', 8800), ('WJ0090', '010-T5-0900E-F', 2670), ('WJ0090', 'WGF50100FM-3ZZG3-2900LC7F', 573720), ('VA0003', 'LF-740ZZ-JIB', 200), ('FT0008', 'AFF+70G', 17800), ('WJ0091', '0443-293-01', 2780), ('CF0004', 'RNA-6911UU', 9450), ('CW0015', 'BST17X47-1BP4', 8044), ('BM0002', 'CF-3MA', 19440), ('FT0007', 'LF-850ZZ', 10000), ('WG0012', 'SS6901ZZ-YCB', 300), ('CF0022', 'NV2045-9Z', 11580), ('FT0007', 'AFF+70G', 712), ('WJ0090', '1623-114-20', 49000), ('A-0002', 'GRS-NF2', 2800), ('BM0002', 'AFC+70G', 2870), ('MT0024', 'MHS-35C', 715), ('U20012', 'RB-18025UUC0P5-6', -4750), ('2C0017', 'AFE-CA+70G', 520), ('XU0007', 'RA-5008UUCC0', 76500), ('2X0011', '6702ZZ', 5240), ('FT0007', 'AFF+70G', 29904), ('WJ0065', 'GRS-LG2', 8400), ('MZ0011', 'CHROME-A-1+1/8', 8640), ('XA0008', 'GRS-LR3', 7200), ('VU0021', 'AFE-CA+70G', 5400), ('2C0017', 'AFC+70G', 580), ('UZ0009', 'LM-25MGUU', 3575), ('XU0007', 'RB-2508UUCC0', 62640), ('FT0007', 'AFF+70G', 2136), ('WJ0091', 'SHS20V1SSFE-220LF', 4800), ('GZ0003', 'Z12', 40), ('AG0013', '6214-NTN', 620), ('WJ0091', 'EGH20R1770', 4100), ('WG0012', 'LRT-121516', 45), ('WJ0091', 'SHW14CR2UUM-250LM', 20844), ('VU0021', 'GRS-LGU', 3800), ('9R0004', 'LM-8S', 19950), ('WJ0090', '1315772', -370000), ('VE0018', 'GRS-LG2', 1400), ('WJ0094', 'CFS-3A', 1300), ('WJ0091', 'R20-20A1-FSW-410-520-0.018', 10650), ('5Z0011', 'SSR15XV2UUC1M-160LM', 13200), ('9R0004', 'HSR25BSS', 256500), ('WJ0009', '6204ZZNR', 600), ('WG0012', 'SS6901ZZ-YCB', 400), ('UT0032', 'Z12', 120), ('WJ0090', '1315197', 114590), ('9R0004', 'SHS25C2SS-3440LT', 64236), ('WJ0091', 'Z14', 8600), ('UA0011', '6800ZZ-NSK', 1200), ('XU0007', 'FK-8', 6300), ('JR0008', 'AFC+70G', 520), ('CF0022', 'VR3-50H-7Z', 7455), ('RU0035', 'MTC-55CRD-15-20', 2560), ('EX0016', 'MFC-20-5-10', 450), ('CW0015', 'FA-1210MB-C', 29600), ('XV0020', 'NTB-5070', 1100), ('U20010', 'SS6202ZZ-NSK', 3780), ('FT0008', 'AFF+70G', 18512), ('5Z0011', 'SSL-1450ZZ', 3150), ('BM0002', '6000ZZ-YCB', 200), ('WJ0090', '6004ZZ-NSK', 1260), ('WJ0009', 'TLA-810', 399), ('WJ0104', '6006ZZ-NSK', 720), ('520008', '7000CTYNDBHP4', 1145), ('WX0013', 'CB-2012', 18), ('9R0004', 'SSR35XW3SSFM-3320LHF', 77000), ('WJ0091', '6203DDU-NSK', 330), ('FT0007', '6001-H-20T1XZZ*MA', 4560), ('RC0004', 'SFP25-950L', 3400), ('WJ0090', 'SHS45V4SSHHC0FMS-6870LHFT', 344296), ('U20011', '6212-2RS-KOYO', 3456), ('WJ0090', '1314134', 290000), ('CR0003', 'BGXS20BN-1-L520-N-Z0', 18690), ('EZ0008', 'Z12', 65), ('FT0007', 'AFF+70G', 3580), ('WG0012', '6815ZZ-FBJ', 2000), ('WX0013', 'AW10', 33), ('UR0021', '6901ZZNR', 460), ('WG0012', '1200-IJK', 360), ('FT0006', '6000-H-20T1XZZ*MA', 13900), ('RJ0006', 'T-1810', 7000), ('CA0006', '6802ZZ-NSK', 3650), ('GB0004', 'GRS-PS2', 1480), ('U20032', 'BTK2510V-5.3ZZ-612.5LC7T', 49140), ('RC0052', 'L-1680HH-NMB', 665), ('RE0006', 'CF-6BUU', 3237), ('U20032', 'BWU25-30', 4070), ('CJ0004', 'GRS-PS2', 360), ('MC0023', 'CFH-6UURA', 5200), ('WG0012', '126', 280), ('XC0007', 'AFE-CA+70G', 3300), ('R10009', 'UFL005-ASAHI', 1860), ('VT0004', 'SFP20-250L', 680), ('FT0006', '6910ZZ-NSK', 500), ('WJ0090', '1315767', 348000), ('5C0018', '6904-H-20T1XDDU*MA', 8550), ('WJ0091', '6004-H-20T1XZZ', 18560), ('WC0009', '6204ZZC4-SKF', 3400), ('WJ0009', 'LF-1140ZZ', 510), ('2X0011', '6702ZZ', 7860), ('WJ0090', 'GRS-LG2', 35200), ('U20007', '6804-H-20T1XZZ*MA', 992), ('CW0015', 'LF-740ZZ', 3500), ('WJ0075', 'L-1480ZZ', 360), ('TR0009', 'AFE-CA+70G', 1500), ('FM0014', '6004-H-20T1XDDU*MA', 1180), ('WG0012', '126', 280), ('FU0015', 'GRS-PS2', 1710), ('XQ0004', 'MHC-45C', 935), ('EV0012', 'XGL2-30C-12-14', 2150), ('FT0007', '6908VV-NSK', 522), ('2C0017', 'AFE-CA+70G', 520), ('U20007', 'SR30M1WUU', 94500), ('FG0008', 'GRS-LR3', 1790), ('CW0015', 'LF-630ZZ-JIB', 180), ('FT0007', 'AFF+70G', 35600), ('WJ0091', 'Z13', 13000), ('C20013', 'BGXH15BN-1-L900-N-Z0-30-30', 1900), ('9R0003', '6905-H-20T1XZZ*MA', 26300), ('9R0003', 'BNT1605-2.6ZZ-319LT', 7400), ('WJ0009', 'LF-630ZZ', 600), ('CA0020', 'L-1030ZZ(623)', 1200), ('WJ0090', '1315770', -360000), ('RJ0006', 'L-1910ZZ', 4800), ('WJ0090', '6000ZZ-NSK', 1440), ('JR0008', 'AFC+70G', 2080), ('VU0041', 'SS6004ZZ-KOYO', 960), ('BM0004', 'GRS-NSL', 8000), ('WJ0091', 'Z13', 3510), ('WJ0009', 'ML12C2R350H', 3665), ('EV0012', '6800ZZ-NSK', 6750), ('FT0007', '6207ZZ-NSK', 1380), ('FU0015', 'AFC+70G', 2280), ('CV0023', 'GRS-LG2', 4350), ('WJ0009', 'L-1060', 180), ('FG0007', 'SSR20XW1UU-220L', 4900), ('WJ0009', '6800ZZ-NTN', 162), ('WJ0009', '6900ZZ-EZO', 120), ('WJ0091', '6811LLB', 18800), ('WJ0095', 'AFF+70G', 3720), ('WJ0091', '1315558', 60000), ('FA0007', 'SHS45LCSS', 14800), ('WJ0090', 'BNK1004-2.5RRG2-230LC7Y', 12660), ('WJ0090', 'GRS-LG2', 35200), ('GG0004', 'AFB-LF+70G', 915), ('WX0013', '51210-NACHI', 405), ('WJ0009', 'L-1060', 720), ('FT0006', '7204ATYNDFMP5', 1785), ('WJ0091', 'ST-16B', 740), ('WJ0090', 'SVR45R3SSHHC0FMS-5925LPTF', 2798600), ('WJ0091', 'AFF+400G', 2900), ('WJ0009', 'LF-1480ZZ', 6720), ('RJ0006', '6000ZZ-IBK', 2350), ('9R0004', 'HSR25BSS', 11400), ('WG0012', 'L-1360ZZ-JIB', 224), ('WJ0009', '6201ZZNR', 400), ('VU0041', '6002-KOYO', 516), ('WJ0094', 'L-630ZZ', 846), ('WJ0090', 'BK-25', 7500), ('FG0008', 'MTC-55CRD', 1390), ('520009', 'SSR15XW1UUM-110LYM', 8800), ('WJ0009', 'LF-1480ZZ', 140), ('CJ0004', 'RIF-518ZZ', 850), ('U20007', '6920VV-NTN', 3800), ('WJ0091', '608-H-DDMC3*MA', 2100), ('WJ0091', 'SHW14CR2UUM-200LM', 22000), ('2C0017', 'Z12', 65), ('CM0005', 'SS6303ZZ', 13350), ('FU0015', 'AFA+70G', 8550), ('CV0047', 'MTC-55CRD-12-24', 2590), ('CW0015', 'LCF-16BLUU', 5580), ('VE0020', 'HGP', 3000), ('WJ0094', 'CFS-4VA-JNS', 1480), ('U20007', 'SCE200-80X120-2', 4700), ('RC0004', 'SFP25-950L', 3400), ('WJ0090', 'BLK3636FM-7.2QZZZ-1788LF', 51500), ('RU0035', 'MTC-55CRD-15-15', 8960), ('CA0006', 'SMR106ZZMC3*MAZ', 260), ('WJ0009', 'CRT6-12', 192), ('X20013', 'AFF+70G', 5700), ('CF0032', 'BARRIERTA-IS/V-75G', 4658), ('WJ0009', 'L-940ZZ', 210), ('FT0008', 'AFF+70G', 35600), ('WJ0009', '7004ADB', 2318), ('WJ0091', 'FK-20', 13960), ('WJ0094', 'L-630ZZ', 846), ('WG0012', 'Z1', 4), ('WG0012', '51100-YCB', 210), ('WJ0094', '6800-H-20ZZ*MA', 3160), ('EX0002', 'MG70', 2750), ('FT0007', 'SFC-030DA2-14B-14B', 1360), ('JR0008', 'GRS-LG2', 2800), ('CA0020', 'L-1360ZZ(686)', 960), ('WJ0009', '6801ZZ', 252), ('MT0024', 'SSR15XW1SS-730LY', 10200), ('WJ0009', 'LF-1760ZZ', 280), ('RE0001', '6307ZZ-NSK', 1500), ('2F0006', 'AFC+70G', 1100), ('WJ0090', '6203-H-20T1XDD*MA', 14400), ('9R0004', 'HSR25A6ZZE-2320LTE', 64820), ('WJ0090', 'HSR25R2SSFMS-340LM', 26600), ('WJ0094', 'L-630ZZ', 846), ('250007', '6001ZZ-NSK', 5000), ('250007', '6000ZZ-NSK', 5200), ('XR0020', 'AFA+70G', 810), ('WJ0069', 'BRD35A0', 12400), ('WJ0090', 'AFF+400G', 145000), ('9R0004', 'BLK2020-3.6ZZ-1000L', 10680), ('WJ0069', 'POS-12', 1225), ('U20008', 'SHS30VSS', 2835), ('FT0007', '6816ZZ-NSK', 2580), ('FT0006', 'AFF+70G', 1780), ('U20007', 'NAS20CLNPCZ1AA', 4080), ('UA0011', '6000ZZ-NSK', 6800), ('TR0010', 'AG0524A0', 240), ('WJ0090', '6902-H-20T1XDD1*MA', 42000), ('WJ0090', '6001-H-20T1XDDU*MA', 52000), ('WG0012', 'SHS25C4SSC1-1300LSP-2', 201600), ('WJ0009', '6802ZZ', 82), ('U20007', 'BLK2525F-7.2ZZ-402LTFG-JIK-4', 4725), ('FT0007', 'LM-50UU', 6000), ('WJ0094', 'LM-8UU', 740), ('CF0022', 'LF-1360ZZ', 660), ('CA0006', '6802ZZ-NSK', 7300), ('CR0003', 'BGXS20BS-1-L226-N-Z0', 3400), ('U20007', '33007-NSK', 3720), ('1F0002', '7901CTYNSULP4', 84000), ('WJ0090', '1623-114-20', 58800), ('UZ0009', 'PSS1505N1D0261', 26300), ('FG0008', 'AFF+70G', 5800), ('WJ0009', 'NTB-1226', 336), ('CF0022', 'VR3-50H-7Z', 2485), ('BM0002', 'MG70-P', 585), ('WG0012', '1200-IJK', 360), ('U20007', '33007-NSK', 1240), ('XC0007', 'SKR2602A-0060-P0-00A0', 209880), ('WG0012', 'L-730ZZ', 160), ('WJ0091', 'SS6800-2RS', 14200), ('FU0015', 'AFE-CA+70G', 24360), ('VT0004', 'Z12', 40), ('WJ0091', 'SS6203-2RS', 2190), ('FT0007', '6004-H-20T1XDDU*MA', 11100), ('FT0008', '6004-H-20T1XDDU*MA', 22200), ('WJ0094', 'L-630ZZ', 846), ('WJ0090', '6002-H-20T1XZZ*MA', 1700), ('WG0012', 'MHC-27C-8-8', 1160), ('WJ0090', 'SGL35HTE2-1080/W2LB', 81400), ('ZM0006', 'L-1040ZZ', 960), ('2F0006', 'AFC+400G', 6300), ('WG0012', 'LF-740ZZ', 96), ('CM0005', '6205-H-20T1XAZZ*MA', 2960), ('FT0008', '7204BW', 3645), ('R10009', 'HSR35RSS', 18800), ('WJ0090', '6203ZZ-NTN', 60), ('CV0047', 'MTC-30CRD-06-14', 1176), ('WJ0091', '1347007', 84480), ('CF0022', '6903ZZ', 620), ('WJ0009', 'L-730ZZ', 2352), ('FT0007', 'AFF+70G', 7120), ('JR0008', '6206ZZ-NSK', 280), ('FT0006', '6001-H-20T1XZZ*MA', 2336), ('R20016', 'SHS30LRSS', 13500), ('WJ0090', 'AFA+400G', 108000), ('WG0012', 'CF-6UUA', 580), ('WJ0090', 'SHS30R2UUFME-760LF', 37056), ('9R0003', 'SHS25CSS', 18800), ('XC0007', 'SKR2602A-0060-P0-00A0', 34980), ('WG0012', 'L-1960ZZ', 276), ('WG0012', 'L-1360ZZ-JIB', 336), ('920004', 'Z12', 65), ('WG0012', 'LF-740ZZ-JIB', 864), ('WG0012', '126', 280), ('5C0047', 'R-BRF1208', 4000), ('CV0004', 'AFF+70G', 8400), ('WJ0009', '6800ZZ-NTN', 486), ('WJ0104', '6005ZZ-NSK', 1460), ('FT0007', '6804ZZ-NSK', 9000), ('QD0001', 'C-8', 800), ('WJ0100', 'POM-6000-PA-GS', 1440), ('CW0015', 'LM-12UU', 1630), ('FG0009', 'GRS-LR3', 716), ('WJ0090', '6908ZZ-NTN', 720), ('WJ0009', 'L-1060ZZ', 180), ('U20007', '020-MA5-0723E-FY', 15540), ('U20011', 'RBI-20D-HIJ', 2445), ('FM0014', '2214M-FAG', 3100), ('MT0024', 'MTC-40CRD', 4500), ('9R0003', '6905-H-20T1XZZ*MA', 26300), ('U20010', 'SSR20XWUU', 8100), ('RU0033', '6902ZZ-NTN', 480), ('XU0007', 'L-2280ZZ', 104), ('FT0007', 'WBK06-11', -2730), ('WJ0090', 'AFA+400G', 144000), ('FT0007', 'AFF+70G', 4272), ('U20032', 'BTK2510V-5.3ZZ-679LC7T', 50760), ('WJ0091', 'RNFCL5050A6S-2272LT', 60000), ('U20007', '6804-H-20T1XZZ*MA', 4725), ('CW0015', 'AFE-CA+70G', 3100), ('WJ0091', 'HSR8R1UUM-75LM', 1924), ('MW0015', 'MG80', 800), ('R20016', 'SHS35CSS', 12000), ('WJ0104', '6003ZZ-NSK', 600), ('WG0012', 'L-730ZZ-JIB', 160), ('WJ0009', 'L-840ZZ', 168), ('FT0007', 'AFF+70G', 712), ('WJ0163', 'L-1960ZZ', 400), ('U20007', '1SRS7MUU-55LM', 7500), ('U20007', '6920VV-NTN', 3800), ('T50004', 'Z12', 70), ('CW0012', 'LM-50GA', 6600), ('CF0022', 'LF-1360ZZ', 2640), ('BN0002', 'AFE-CA+70G', 3360), ('CM0005', '6205ZZ-NSK', 172), ('RX0022', 'MR12MNV0N', 1040), ('WG0012', 'L-1960ZZ-JIB', 92), ('UA0011', 'SHS35LVSS', 15456), ('XU0007', 'L-2280ZZ', 1040), ('MV0021', 'L-740ZZ', 2112), ('CA0006', 'AFC+70G', 71250), ('FT0007', 'AFF+70G', 2136), ('CJ0004', 'CF-3A', 1275), ('WJ0009', 'L-1680ZZ', 80), ('WJ0094', '6800-H-20ZZ*MA', 3160), ('FT0007', 'AFF+70G', 10680), ('RE0001', 'AFE-CA+70G', 17100), ('WJ0091', 'R20-20A1-FSW-410-520-0.018', 10650), ('VU0021', 'GRS-LGU', 5700), ('FU0029', 'Z12', 40), ('FT0007', 'AFF+70G', 8900), ('VZ0012', 'Z12', 65), ('VR0023', 'AFB-LF+70G', 2300), ('JR0008', 'LMK-10UU', 4160), ('EV0012', 'SSL-950ZZ', 750), ('CM0005', 'L-2280ZZ', 320), ('RX0013', 'LMC-20UU', 450), ('WG0012', 'SSL-1980ZZ-YCB', 1296), ('WJ0178', 'GRS-LG2', 6000), ('WG0012', 'L-1360ZZ-JIB', 112), ('JR0008', 'CB-0606-12T', 840), ('WJ0091', 'SHS45VSSHHC0FMS', 41600), ('WJ0091', 'ST-16B', 1480), ('WG0012', 'LF-1980ZZ-JIB', 220), ('ZT0001', '2FBW50110XRUU-800L', 11960), ('FT0007', 'RA-12008CUUC0', 29000), ('FT0007', 'MDW-40C-12X17', 3820), ('FT0007', 'AFF+70G', 35600), ('WJ0090', '6202-H-20T1XZZ', 170), ('FT0007', '1666-113-22', 2990), ('WJ0009', 'L-940ZZ-JIB', 168), ('XU0007', 'RA-12008UUC0', 87395), ('FT0007', 'AFF+70G', 71200), ('JR0008', 'NTB-1024', 450), ('AU0005', 'CFT-20M', 9520), ('Z20004', 'SSR20XWSS', -4680), ('MA0010', 'PSS1520N1D1179', 64125), ('WJ0018', '6201ZZ-NSK', 260), ('BM0002', 'AFC+70G', 2050), ('RJ0006', 'T-1810', 7000), ('CR0003', 'BGXH25FN-2-L1186-N-Z0', 17704), ('FT0008', '6802ZZ-NSK', 567), ('FT0006', 'W0800MA-1PY-C3Z1', 27990), ('WG0012', 'L-1360ZZ-JIB', 112), ('XU0007', 'L-2280ZZ', 1950), ('WX0011', 'Z11', 625), ('UR0022', 'Z18', 2100), ('5Z0011', 'Z11', 955), ('WJ0090', '1623-114-20', 49000), ('CA0020', 'L-1470ZZ', 450), ('CR0003', 'SFIR3205-4-819L-DF-C7', 5175), ('WJ0090', 'SHS20CSSFM', 14720), ('CM0005', 'CRM-6902-PT-ZR2P', 11904), ('WJ0091', 'SS6203-2RS', 6570), ('FT0007', 'SHS45LV2UUFME-3610LTF', 190380), ('EX0002', 'AFC+70G', 2800), ('VE0020', 'NIPPLE-A-M6F', 80), ('WJ0009', 'CRT6-12', 384), ('FT0007', 'GSR35T5UUFE-7600LHRTF', 167680), ('FT0007', 'AKS-25W', 21300), ('WG0012', 'AN04', 184), ('FT0007', 'SW-70-I', 19200), ('XM0009', 'NTB-3552', 220), ('ER0006', 'HGP-NZ3', 2100), ('WJ0075', 'MG70-P', 1750), ('WJ0009', 'NTB-1528', 96), ('WJ0091', 'SHW14CR2UUM-250LM', 10422), ('EV0012', 'SS6302ZZ', 1560), ('X20016', 'SMK-10WUU-E-SK', 9000), ('WG0012', 'L-1360ZZ-JIB', 224), ('M10002', 'Z12', 65), ('WJ0090', '6203-H-20T1XDD*MA', 14400), ('WJ0090', 'SHW14CR2UUM-210LM', 53400), ('WG0012', 'LF-740ZZ-JIB', 1152), ('RT0028', 'BGCS20BS-1-L900-N-Z0', 3800), ('FG0009', 'GRS-LR3', 1790), ('WJ0091', 'SGL35TF2-3000-W2LB', 93800), ('CF0004', 'GRS-LGU', 11000), ('RE0001', '6000ZZ-KOYO', 1100), ('WJ0009', '6901ZZ', 120), ('CW0012', 'LM-50GA', 6600), ('WJ0091', 'PSL-G-60', 2900), ('FT0007', 'NV2075-19Z', 18000), ('RJ0006', 'L-1910ZZ', 4800), ('WJ0091', 'RB-4010UUCC0', 45876), ('FT0008', 'AFF+70G', 3560), ('FM0014', 'HK-2001-A', 33600), ('FT0007', 'NKX25T2Z', 2460), ('9R0004', 'SHS30CSS', 22900), ('WG0012', 'LMF-6LUU', 4140), ('WJ0090', '6900-H-20T1XDD1-MA', 1300), ('GU0037', 'MHC-57C-24*25', 4200), ('EV0012', '7304A', 2680), ('5Z0011', 'L-1060ZZ', 336), ('XM0009', 'CF-8MUURA', 3760), ('FG0008', 'GRS-LR3', 1074), ('FT0008', 'AFF+70G', 3916), ('CA0006', '6802ZZ-NSK', 3650), ('WJ0104', 'UCFL205-ASAHI', 8700), ('F10002', 'SRS12MUU', 4320), ('TZ0011', 'HGP', 2590), ('ZM0006', '608ZZ-EZO', 1020), ('WJ0075', '6904-2NSE-NACHI', 2240), ('JR0008', 'F6900VV-YCB', 200), ('CR0003', 'BGXH25FN-2-L1186-N-Z0', 17704), ('WG0012', '51100-YCB', 210), ('FG0008', '6202ZZC3-NTN', 2550), ('WJ0222', 'AFC+70G', 580), ('WJ0091', '6004-H-20T1XZZ', 4640), ('WG0012', 'SS6901ZZ-YCB', 800), ('WJ0090', '6006-H-20T1XDDU*MA', 19250), ('V20015', 'GRS-LGU', 4100), ('FG0008', 'GRS-LR3', 358), ('WJ0018', '6308ZZ-NSK', 700), ('WG0012', 'CF-3UUA', 426), ('WJ0114', 'CF-8UUA', 2880), ('WJ0094', 'L-630ZZ', 1692), ('CA0006', '6802ZZ-NSK', 3650), ('CA0006', 'SMR106ZZMC3*MAZ', 130), ('CT0014', 'SFP10-350L', 4340), ('WJ0090', 'DIK2005F6WWG0-240C5F', 22350), ('U20007', 'GSR25TUU', 48600), ('VG0002', '7001A', 2550), ('FT0006', 'AFB-LF+70G', 300), ('VT0004', 'CB-1615-24T', 180), ('5X0011', 'CF-4BUU', 2300), ('WJ0009', 'TLA-2526', 95), ('CC0020', 'AFE-CA+70G', 5600), ('WJ0090', 'L100-400G', 19500), ('2C0017', 'AFF+70G', 580), ('WJ0090', '7908UCG/GNP4', 105000), ('FT0006', 'AFB-LF+70G', 300), ('WJ0009', 'A-2520', 390), ('U20007', 'NRS45LRX6UUFME-7800LTFE', 276000), ('FT0007', 'FK-30', 14600), ('CA0006', '6802ZZ-NSK', 3650), ('RM0027', 'DPM-2550', 3975), ('MA0010', 'MR7WNSSV0N', 7280), ('BM0002', '6001-2RS-NTN', 2250), ('WJ0009', 'L-310', 2400), ('VU0041', 'PSP2505N3AB0499B', 40820), ('ER0005', 'CF-4A', 1275), ('WG0012', 'SS6801ZZ-YCB', 750), ('WJ0091', 'GRS-LG2', 17600), ('MT0024', 'MTC-30CRD-10K4-10K4', 750), ('MT0024', 'SHS20V2SS-1530L', 31560), ('WJ0090', 'SHS20C2ZZFMJ-460FJII', 42600), ('FT0007', 'AFF+70G', 2848), ('U20032', '62/22DDU', 1530), ('WG0012', 'SFP6-130L', 128), ('JA0004', 'GRS-LGU', 4632), ('FT0006', 'AFB-LF+70G', 900), ('BM0002', 'AFC+70G', 1230), ('U20012', 'RB-18025UUC0P5-6', -4665), ('WJ0090', 'BK-25', 7500), ('VV0010', 'HK-0810', 90), ('UA0011', 'FK-6', 3088), ('CT0007', 'HSR35LCSS', 53000), ('5Z0011', '6911ZZ-KOYO', 1788), ('FT0007', '30TAC62CSUHPN7C', 45432), ('WJ0090', '2R050-50A1-1FSKT-3655-3925-0.018H', -295000), ('CV0047', 'MTC-65CRD-25-35', 1890), ('XC0007', 'SKR2602A-0060-P0-00A0', 34980), ('RE0001', '30205-NSK', 1140), ('XA0008', 'GRS-LR3', 7200), ('WJ0100', 'TLA-810', 900), ('FT0007', 'NH451200BND2KCZ1AL', 92480), ('1F0002', 'NHS-3T', 1040), ('UC0018', 'AFF+70G', 1920), ('XA0008', '6901ZZ-NSK', 3000), ('MT0024', 'SSR20XW2SS-3335LT', 24339), ('WJ0090', 'WGF50100FM-3ZZG3-3300LC7TF', 308228), ('WJ0009', 'LF-1060ZZ', 488), ('FT0007', '6904-H-20T1XDDU*MA', 2128), ('WJ0094', 'L-1350ZZW05', 440), ('TR0009', '6807ZZ-NTN', 2000), ('UW0004', 'HSR12R1UUM-230LM', 5070), ('WJ0091', 'VRT-1025AM', 88000), ('RE0001', '6205VV-NSK', 2000), ('U20032', 'FK-10', 3250), ('BM0002', 'NAH25BNZ', 5660), ('CM0005', '6004-H-20T1XDDU*MA', 5300), ('WJ0100', 'L-1470ZZ', 180), ('WJ0009', 'L-1060', 360), ('MG0018', '6203-2NSE', 1200), ('RX0022', 'MR12MNV0N', 1040), ('FT0007', 'SS6001ZZ', 8700), ('FT0007', 'NS251480ALD2PCZ1AL', 46960), ('FT0006', 'LF-1060ZZ-NMB', 480), ('VU0021', 'GRS-LGU', 3800), ('WJ0100', 'SS6002ZZ', 1140), ('WJ0090', '1623-114-20', 49000), ('WJ0009', 'L-1560ZZ', 76), ('R20016', 'SHS30-840L', 4040), ('A-0002', 'AFE-CA+70G', 10800), ('CJ0004', 'AFC+70G', 10000), ('XU0007', 'RA-7008UUCC0', 3900), ('WJ0090', 'BLK3636-7.2ZZ', 30400), ('RE0001', '6004VV-NSK', 1020), ('X20013', 'LM-8S', 6700), ('WG0012', '6815ZZ-FBJ', 2000), ('5X0011', 'SS6002ZZ-FBJ', 4620), ('CF0022', '7005CTYNDBLP5', 7500), ('FT0007', 'AFF+70G', 8900), ('WG0012', 'L-1960ZZ', 552), ('WJ0091', '6203-H-20T1XZZ*MA', 2450), ('WJ0114', '0455-504-31-75L', 1230), ('U20032', 'PP-STK-CARRIAGE昇降軸包膠導輪組', 16580), ('FT0006', 'AFF+70G', 10740), ('FT0006', 'AFF+70G', 35600), ('WG0012', '5200-IJK', 560), ('CM0005', 'SS6804ZZ-FBJ', 131760), ('WG0012', 'L-1960ZZ', 184), ('WJ0091', 'HSR25R2SSFMS-340LFM', 26600), ('WJ0108', 'BSR1530SL', 2600), ('FT0007', '6828VV', 4950), ('U20007', 'TU65', 2500), ('VE0020', 'GRS-LG2', 3200), ('WJ0009', 'LF-1260ZZ', 300), ('WG0012', 'L-1360ZZ-JIB', 1344), ('WJ0090', 'L-1350ZZ', 230), ('WJ0091', 'SHS25VSS', 9072), ('9R0004', 'SBN3210V-7WWG0-1230LC5-J2K', 48000), ('WG0012', 'LF-740ZZ-JIB', 1536), ('UA0011', '6904ZZ-NSK', 5880), ('2D0002', 'CF-5UURA', 3700), ('WJ0009', 'RBI-6D', 441), ('VE0020', 'NIPPLE-B-MT6X1', 60), ('FT0006', '7204BW', 2430), ('WJ0091', '6207-H-20T1XZZ*MA', 658), ('FT0007', 'RB-7013UUC0', 38000), ('MV0021', 'LF-1790ZZ', 8432), ('2F0006', 'AFC+400G', 6300), ('WJ0104', 'H2308', 332), ('WJ0091', '1532-2-2016-1531-2-2900-92L', 41600), ('WJ0090', 'SSR20XTB2SS-300L', 7924), ('9R0003', 'SSR25XW6QZDDME-1900LYM', 158400), ('CR0003', 'BGXS20BN-1-L466-N-Z0', 1300), ('ZM0006', 'L-1480ZZ', 520), ('U20008', 'SSR35XW2UUFM-4910LTF', 104000), ('CV0023', 'GRS-LG2', 4350), ('FT0007', '6908ZZ-NSK', 1800), ('520008', '608VV-NSK', 30), ('WJ0091', 'HSR8R2UUM-75LM', 3310), ('WJ0100', 'L-1680ZZ', 920), ('WJ0090', 'SHS30V1SSFM-680LF', 20700), ('WJ0090', 'RSR15M1WVUUS-94LS', 27320), ('F10002', 'PSS2040N1D0658', 38000), ('XU0007', 'RB-2508UUCC0', 11600), ('WJ0009', '6206ZZ-NSK', 1380), ('FT0007', '1-KSH-32WL-60-500', 132000), ('FU0005', 'AFB-LF+70G', 4600), ('FT0001', 'Z12', 40), ('UR0022', 'Z18', -3300), ('BM0002', 'CF-4WBUUR', 6240), ('WJ0090', 'GSR30TKK', 11600), ('AR0012', '洗淨機軸承', 40937), ('XM0007', '6304ZZ-NSK', 2700), ('MC0007', 'Z12', 70), ('WJ0130', 'LMC-20LUU', 1560), ('9R0004', 'HSR25M1B', 122600), ('MT0024', 'SSR15XW1SS-450LY', 8180), ('FT0007', 'RA-5008CUUC0', 17200), ('WJ0090', 'BIF1605FM-5RRG0-586LC7F', 23450), ('CA0006', '6802ZZ-NSK', 3650), ('CA0006', '6802ZZ-NSK', 3650), ('FT0006', '6800ZZ-NSK', 1960), ('U20010', 'HSR15RSS', 1835), ('JX0002', '6206ZZ-FBJ', 520), ('CJ0004', 'MG70-U', 520), ('WJ0009', 'L-830ZZ', 100), ('CM0005', '6005-H-20T1XZZ*MA', 992), ('WJ0009', 'L-1050ZZ', 160), ('FT0007', 'AFF+70G', 7120), ('U20007', '6804ZZ-NSK', 3720), ('WG0012', 'RB-35020UUCC0P4', 156000), ('U20007', 'HSR25LR2QZSSM-1060LHM', 88000), ('ER0006', 'GRS-PS2', 2100), ('C50004', 'GRS-LR3', 1680), ('WJ0091', 'AFF+400G', 8700), ('FG0008', '6900VV-NSK', 210), ('FT0007', '1-KSH-32WL-60-500', 66000), ('SY0002', 'ADVU-16-20-P-A', 4900), ('JV0011', 'GRS-PS2', 380), ('WJ0131', 'SHS15V1SS-940L', 8100), ('WJ0094', 'L-1650ZZ', 175), ('WJ0090', 'HSR25R3SSFME-4540LMTF-AP-CF', 180000), ('5C0018', 'MG70', 2300), ('WJ0090', 'BIF1810EFM-3RRG0-1123LC5FM', 198500), ('MT0024', 'MTC-40CRD-10K4-14K5', 1125), ('WJ0009', '6808ZZNR', 850), ('WJ0009', '6900ZZ-NSK', 120), ('WJ0009', 'GS-1528', 152), ('EV0012', 'L-1360ZZ', 1200), ('UW0022', 'GRS-PS2', 340), ('R20016', 'FK-10-OAMG', 78000), ('WG0012', 'LF-1980ZZ', 220), ('EX0002', 'VR1-60H-16Z', 11850), ('FG0010', 'GRS-AS2', -620), ('WJ0094', 'CFS-04FV', 4550), ('EV0012', '6802ZZ', 1500), ('WJ0100', 'NAS15CLZ', 7400), ('XV0020', 'NTB-3047', 850), ('XU0007', 'MDK1002FM-3RRG2+125LC7F', 47600), ('CM0005', '6004-H-20T1XDDU*MA+NR', 4656), ('AG0013', '6218-KOYO', 1580), ('WJ0091', 'LMH-10LUU', 2040), ('WJ0091', 'AFE-CA+400G', 2650), ('XU0007', 'RA-7008UUC0', 2600), ('FG0008', 'GRS-LR3', 716), ('MT0024', 'MHC-40C-15K5X-16K5', 925), ('CW0015', 'LM-8S', 1644), ('WJ0095', 'LF-1980ZZ', 100), ('R10009', 'POS-12', 7350), ('WJ0090', '6802ZZ-NSK', 1800), ('WG0012', 'L-1360ZZ-JIB', 112), ('WJ0009', '6801ZZ', 126), ('CF0022', 'NV2045-9Z', 27020), ('WJ0018', '6204ZZ-NSK', 190), ('CR0003', 'BGXS20BN-1-L466-N-Z0', 3900), ('FT0008', 'AFF+70G', 17800), ('FT0008', '7003AW', 1050), ('R20016', 'CF-20-1B', 3500), ('WJ0090', 'SS6909-2RS', 7760), ('FT0007', '6004-H-20T1XDDU*MA', 6660), ('CF0022', 'VR3-75H-10Z', 35805), ('9R0003', 'SHS30R1SS-1960LP', 19920), ('WG0012', 'MHC-27C-8-8', 1740), ('FA0019', 'LM-10GAUU', 4400), ('5Z0011', 'Z12', 40), ('WJ0104', 'Z18', 2070), ('CM0005', '608-H-20T1XZZMC3ZMA', 750), ('WJ0100', 'NAS15ALZ', 8360), ('VU0021', 'AFC+70G', 11000), ('RA0009', 'LWES25C1S1', 10500), ('TM0006', 'HSR35CSS', 13320), ('WJ0090', '1532-4-2006-1531-4-2900-252L', 19040), ('WJ0009', 'VR4-80H-7Z', 14180), ('R20016', 'FK-08-OAMG', 36300), ('WJ0221', 'UC215-NTN', 2900), ('RE0001', 'R6ZZ-NSK', 1700), ('R20016', 'GSR25-1600L', -79000), ('VU0004', 'GRS-AS2', 600), ('5Z0011', 'BTK1404VFM-3.6ZZ-202LTF-H1K', 15500), ('WJ0090', '2R050-50A1-1FSKT-4930-5200-0.018H', 330000), ('250007', '6000ZZ-NSK', 5200), ('MT0024', 'WTM-05C', 1950), ('WJ0090', 'AFF+400G', 580000), ('U20007', 'HSR20M1A', 29600), ('WG0012', '51100-YCB', 210), ('WJ0114', '6001ZZ-NACHI', 640), ('VA0003', 'L-740ZZ-JIB', 185), ('WJ0091', 'AFF+400G', 8700), ('R20016', 'BTK2005V-2.6ZZ-1000LC7', 14148), ('UC0018', 'AFF+400G', 3350), ('UC0018', 'VR4-80H-7Z', 13520), ('R20016', 'GSR25-1500LR', 106600), ('WJ0090', '1653-294-20', 6000), ('WJ0009', 'NTB-2542', 335), ('WJ0091', 'EGR20R1135C', 5320), ('FT0007', 'SEBS5BYUU1-47/W2', 12300), ('5E0002', 'GSR35TUU', 36000), ('BM0002', 'MFB-20', 1305), ('FG0008', 'GRS-LR3', 358), ('VU0041', '6004-KOYO', 342), ('CU0009', 'GRS-LR3', 5760), ('WJ0100', '6002ZZ-NSK', 2600), ('WJ0091', 'SHS20V1SSFE-220LF', 4800), ('WJ0099', '6202ZZ-KOYO', 530), ('MT0024', 'MTC-40CRD-10K4-14K5', 1125), ('U20008', 'EGH20CAZ0C', 2700), ('MT0024', 'MTC-55CRD-22K6-25K8', 1450), ('WJ0100', '6000ZZ-NSK', 4700), ('WJ0009', 'LF-1560ZZ-JIB', 232), ('WG0012', 'LF-1980ZZ', 220), ('CR0003', 'SFIR3205-4-819L-DF-C7', 10350), ('R20016', 'GSR25TUU', 57480), ('U20032', 'BLK2020F-7.2ZZ-1850LC7F', 27000), ('FG0010', 'LM-5', 1560), ('WJ0108', 'MGN12H1R90Z0PM', 5660), ('ZM0006', 'L-1480ZZ', 520), ('WJ0114', '6801ZZ-NSK', 1170), ('WG0012', 'SSL-1980ZZ-YCB', 486), ('WJ0090', 'SHS20CSSFM', 14720), ('WJ0009', 'CRT-1680', 176), ('2;0001', 'HSR25A2SS-660L', 12900), ('ZM0006', 'L-1260ZZ', 220), ('VC0010', '2SRS15MUU-310LM', 9000), ('VJ0002', '7202BW', 4940), ('WJ0100', '6004-KOYO', 220), ('WJ0090', '6202-H-20T1XDDU*MA', 55500), ('5Z0011', '40J-SER-48-LINK', 870), ('WJ0091', 'AFF+400G', 2900), ('CA0020', 'L-1260ZZ', 500), ('WJ0090', '6815VV-NSK', 4000), ('WJ0009', 'L-1280ZZ', 188), ('RE0001', '6004VV-NSK', 2125), ('AX0013', 'Z12', 65), ('AR0007', 'NAH45ANNPCZ1AA', 27600), ('2F0006', 'AFC+400G', 6300), ('XM0009', 'SFP6-190L', 3700), ('JR0008', 'CB-0606-12T', 840), ('JR0008', '6900ZZ-YCB', 250), ('NV0002', 'LF-1360ZZ', 534), ('A10001', 'Z11', 560), ('WJ0090', '1315655', 280000), ('U20007', '020-MA5-0723E-FY', 5180), ('WG0012', '126', 280), ('5C0018', 'AG1.5-20R1J10', 5985), ('WG0012', 'CF-3UUA', 1278), ('WJ0090', 'BLK3636FM-7.2QZZZ-1662LTF', 452275), ('FT0007', 'AFF+70G', 2492), ('WJ0009', 'NBJ01-8-72-H5', 3600), ('WJ0090', '1314117', 300000), ('XA0008', 'AFC+70G', 2750), ('XR0020', 'AFA+70G', 2700), ('WJ0009', 'LF-1150ZZ', 840), ('GG0004', 'AFA+70G', 2900), ('WJ0009', 'NTB-1024', 336), ('U20007', '1-KSH-24L-42-40', 4000), ('U20010', '6804ZZ-NSK', 4650), ('U20008', 'HR2042UUM', 51300), ('520006', '7007AW', 2765), ('WJ0009', 'LF-1680ZZ', 75), ('WJ0009', 'L-1060ZZ', 540), ('A-0002', 'Z12', 65), ('EV0012', 'XGL2-30C-8-14', 2150), ('CM0005', '6218LLU', 7200), ('FT0007', '6900-H-20T1XDD1-MA', 1250), ('XU0007', 'RA-5008UUCC0', 48960), ('CR0003', 'BGXH25FN-3-L1366-N-Z0-23-23', 11800), ('MT0024', '6006ZZ-YCB', 160), ('DS0003', 'SFP6-500L', 7275), ('WG0012', 'L-1360ZZ-JIB', 672), ('2X0008', 'GRS-PS2', 760), ('CV0032', 'VR2-45H-8Z', 2900), ('JR0008', 'CF-5UUA', 1176), ('WJ0009', 'L-1560ZZ', 152), ('5C0018', 'HGP-NZ3', 1050), ('WJ0104', '6012ZZ-KOYO', 6500), ('WJ0009', 'LF-1910ZZ', 616), ('WG0012', '7202-NACHI', 1600), ('CF0022', 'NV2045-9Z', 30880), ('9R0004', '6901-H-20T1XZZ*MA', 3100), ('RR0001', 'MHC-40C-8*10', 1650), ('FT0007', '6908ZZ-NSK', 1500), ('WJ0090', '6003-H-20T1XDDU*MA', 49200), ('5Z0011', 'BNF2010AFM-1.5RRG1-360LC7F', 12420), ('T50004', 'LM-40UU-HST', 1360), ('A-0002', 'AFE-CA+70G', 15680), ('BM0002', 'AFF+70G', 3920), ('WG0012', 'LM-6LUU', 1640), ('ZU0005', 'CHROME-2.5M/M', 25), ('WG0012', '1200-IJK', 360), ('U20007', '020-MA5-0723E-FY', 5180), ('WJ0091', 'AFF+400G', 2900), ('ER0005', '6904ZZ-NSK', 570), ('WJ0090', '6001-H-20T1XDDU*MA', 52000), ('U20008', 'VRU-2080', 38000), ('WJ0090', 'SSR20XWUU', 4126), ('WJ0009', 'L-1910ZZ', 54), ('FU0029', '6900-H-20T1XDD1-MA', 1600), ('WJ0009', 'L-1960ZZ', 180), ('WJ0009', 'LF-1350ZZ', 240), ('FT0006', 'PM2.5-20', 40200), ('CF0022', 'LF-1360ZZ', 2310), ('CW0015', 'LF-1450ZZ', 60), ('U20007', 'CF-10-1BUU-IKO', 4680), ('WJ0009', 'AS-1024', 120), ('1B0003', 'TLA-1010', 630), ('FT0007', 'AFF+70G', 14320), ('XC0004', 'MFCS-20C-6.35-8', 950), ('WJ0090', '2R050-50A1-1FSKT-4630-4900-0.018H', -310000), ('U20007', 'CF-12-1UUAB', 3950), ('UY0004', 'HCR15A2UU+60/150R-3T', 50350), ('U20008', 'SHS30C2SSC0F-550LF', 116000), ('WJ0100', 'POM-6900-PA-GS', 2850), ('RC0056', 'Z18', -3600), ('WJ0091', '6004-H-20T1XZZ', 3712), ('RE0001', 'Z12', 40), ('CW0015', 'PSS2040N1D0505', 26230), ('ER0006', 'GRS-PS2', 2100), ('RE0001', '6205VV-NSK', 1200), ('CR0003', 'BGXH25FN-2-L886-N-Z0', 6724), ('CR0003', 'BGXS20BS-1-L286-N-Z0-23-23', 1880), ('WJ0104', '6309ZZC3-NSK', 5500), ('U20007', 'TU65', 2500), ('FT0007', 'MG70', 4400), ('U20032', '1-KSH-24WL-42-200', 10245), ('FT0006', 'AFB-LF+70G', 2250), ('5C0018', 'AFF+70G', 4500), ('2D0002', 'CFS-03VA', 13600), ('WJ0009', 'LF-1150ZZ', 1120), ('WJ0091', 'EGH20SAZAH', 2260), ('FM0014', '7002AW', 1040), ('WJ0091', 'SHS20C2SS-3200LF', 80200), ('WG0012', 'L-1360ZZ-JIB', 448), ('WJ0104', '6214P5-NSK', 11200), ('CA0020', 'L-1360ZZ(686)', 900), ('FT0008', 'AFF+70G', 5340), ('FU0029', 'L-1560ZZ', 240), ('FT0007', 'AFF+70G', 10680), ('9D0001', 'GRS-PS2', 7600), ('AT0006', 'GRS-PS2', 1400), ('VE0004', '6000ZZ-NSK', 65), ('WJ0091', '0443-293-01', 1390), ('ZM0006', '6904ZZ-NSK', 440), ('CW0015', 'LM-12UU', 1630), ('BM0002', 'CF-03FBUU', 13000), ('FT0007', '6003ZZ-NSK', 1000), ('WJ0009', 'L-1350ZZ', 688), ('CR0003', 'BGXS20BS-1-L466-N-Z0', 1040), ('UU0009', '6000ZZ-NSK', 570), ('WJ0009', 'NTB-1024', 168), ('WJ0104', 'Z18', -8360), ('MT0024', 'SSR15XW1SS-640LY', 9380), ('DA0002', 'GRS-LR3', 7200), ('WG0012', 'LM-6LUU', 1640), ('WJ0090', 'LRR45MNS6CV0P-8550L-22.5-22.5-II-J-RRB', -314000), ('WG0012', 'L-1360ZZ-JIB', 112), ('VR0023', 'MG70', 5600), ('RC0004', 'SFP25-950L', 3400), ('U20010', 'HSR15M1R', 36000), ('WJ0009', 'L-1910ZZ', 432), ('WJ0100', 'BK-4615A', 945), ('UC0018', 'BARRIERTA-IS/V-75G', 29370), ('U20007', '33007-NSK', 3720), ('FT0007', '6904-H-20T1XDDU*MA', 106400), ('WG0012', 'L-730ZZ-JIB', 160), ('RR0035', 'SRS9WMUU', 2320), ('UC0018', 'LM-20UU-YCB', 500), ('UV0009', 'SSL-850ZZ', 3250), ('WJ0094', 'L-1350ZZW05', 440), ('9R0004', '6204-H-20T1XADDU*MA', 7350), ('WJ0091', 'MUCP205-ASAHI', 30520), ('JR0008', '6204ZZ-NSK', 160), ('WG0012', 'L-1960ZZ-JIB', 92), ('MV0021', 'LF-1060ZZ-NMB', 6300), ('FT0008', '7204BW', 2916), ('FT0007', '6904-H-20T1XDDU*MA', 2650), ('WJ0104', '6205ZZ-NSK', 800), ('WJ0090', 'Z11', 6000), ('U20007', 'BLK2525F-7.2ZZ-402LTFG-JIK-4', 4110), ('WJ0131', 'HSR12R1UUC1M-430LM', 3600), ('BM0002', '2SRS12MUU-142LM', 16332), ('FT0008', 'AFF+70G', 3560), ('VX0013', 'AFB-LF+70G', 1200), ('JR0008', 'SSA-2216', 1275), ('CM0005', 'SS6004ZZ-KSK', 15300);
WITH temp2 AS (
	WITH temp1 AS (
		SELECT
			temp.custid,
			temp.productid,
			SUM( temp.amount ) AS amount 
		FROM
			temp,
			(
			SELECT
				@custids := (
				SELECT
					group_concat( custid ) 
				FROM
					( SELECT temp.custid FROM temp GROUP BY temp.custid ORDER BY ( Sum( temp.amount )) DESC LIMIT 10 ) a 
				)) b,
			(
			SELECT
			@productids := ( SELECT GROUP_CONCAT( DISTINCT temp.productid ) FROM temp WHERE find_in_set( temp.custid, @custids ) )) d 
		WHERE
			FIND_IN_SET( temp.custid, @custids ) 
			AND FIND_IN_SET( temp.productid, @productids ) 
		GROUP BY
			temp.custid,
			temp.productid 
		) SELECT
		custid,
		productid,
		amount,
		(
		DENSE_RANK() OVER ( PARTITION BY custid ORDER BY amount DESC )) AS `Rank` 
	FROM
		temp1 
	) SELECT
	*,
	( SELECT sum( temp3.amount ) FROM temp2 AS temp3 WHERE temp3.custid = temp2.custid ) AS CustTotal 
FROM
	temp2 
WHERE
	`Rank` < 11 
ORDER BY
	5 DESC,
	`Rank`


custid
productid
amount
Rank
CustTotal


WJ0090
1315767
348000
1
756350

WJ0090
2R050-50A1-1FSKT-4930-5200-0.018H
330000
2
756350

WJ0090
1314117
300000
3
756350

WJ0090
1314134
290000
4
756350

WJ0090
1314127
284000
5
756350

WJ0090
1315655
280000
6
756350

WJ0090
6001-H-20T1XDDU*MA
208000
7
756350

WJ0090
1623-114-20
205800
8
756350

WJ0090
6811LLB
141000
9
756350

WJ0090
1315197
114590
10
756350

FT0007
1-KSH-32WL-60-500
264000
1
359609

FT0007
30TAC62CSUHPN7C
45432
2
359609

FT0007
6004-H-20T1XDDU*MA
17982
3
359609

FT0007
6804ZZ-NSK
9000
4
359609

FT0007
6828VV
4950
5
359609

FT0007
6001-H-20T1XZZ*MA
4560
6
359609

FT0007
1666-113-20
4485
7
359609

FT0007
1666-113-22
2990
8
359609

FT0007
6816ZZ-NSK
2580
9
359609

FT0007
6207ZZ-NSK
1380
10
359609

WJ0091
1347007
84480
1
250107

WJ0091
1315558
60000
2
250107

WJ0091
1532-2-2016-1531-2-2900-92L
41600
3
250107

WJ0091
6004-H-20T1XZZ
26912
4
250107

WJ0091
6811LLB
18800
5
250107

WJ0091
0455-203-31-280L
8415
6
250107

WJ0091
0443-293-01
4170
7
250107

WJ0091
6203-H-20T1XZZ*MA
2450
8
250107

WJ0091
608-H-DDMC3*MA
2100
9
250107

WJ0091
6207-H-20T1XZZ*MA
658
10
250107

U20007
020-MA5-0723E-FY
25900
1
80717

U20007
2-KSH-40-110-54-HD-HD
25200
2
80717

U20007
33007-NSK
8680
3
80717

U20007
1SRS7MUU-55LM
7500
4
80717

U20007
6804-H-20T1XZZ*MA
5717
5
80717

U20007
1-KSH-24L-42-40
4000
6
80717

U20007
6804ZZ-NSK
3720
7
80717

WG0012
1651-211-22-4-1605-201-31-1300L
33600
1
41990

WG0012
6815ZZ-FBJ
5000
2
41990

WG0012
126
1120
3
41990

WG0012
1200-IJK
1080
4
41990

WG0012
51100-YCB
630
5
41990

WG0012
5200-IJK
560
6
41990

9R0004
6204-H-20T1XADDU*MA
7350
1
10450

9R0004
6901-H-20T1XZZ*MA
3100
2
10450


WITH cte as (
 SELECT custid,SUM(amount) amount,productid
 FROM temp
 GROUP BY custid,productid
)
SELECT t1.custid,
      t1.productid,
      t1.amount
FROM (
  SELECT *,dense_rank() OVER(PARTITION BY custid ORDER BY amount desc) rn
  FROM cte
) t1
INNER JOIN (
  SELECT custid,
       dense_rank() OVER(ORDER BY total desc) rn
  FROM (
   SELECT custid,SUM(amount) total
   FROM cte
   GROUP BY custid
  ) t2
) t2 ON t1.custid =t2.custid  
WHERE t2.rn <= 10 AND t1.rn <= 10




custid
productid
amount


9R0003
SSR25XW6QZDDME-1900LYM
158400

9R0003
6905-H-20T1XZZ*MA
52600

9R0003
DK2506S-3RRGT-503LC7
45820

9R0003
SHS30R1SS-1960LP
19920

9R0003
SHS25CSS
18800

9R0003
BNT1605-2.6ZZ-319LT
7400

9R0004
HSR25AZZ
301140

9R0004
HSR25BSS
267900

9R0004
HSR25M1B
122600

9R0004
SSR35XW3SSFM-3320LHF
77000

9R0004
HSR25A6ZZE-2320LTE
64820

9R0004
SHS25C2SS-3440LT
64236

9R0004
SHS35R2SS-2040L
57800

9R0004
SBN3210V-7WWG0-1230LC5-J2K
48000

9R0004
SHS30CSS
22900

9R0004
LM-8S
19950

FT0007
AFF+70G
318720

FT0007
1-KSH-32WL-60-500
264000

FT0007
SHS45LV2UUFME-3610LTF
253840

FT0007
GSR35T5UUFE-7600LHRTF
167680

FT0007
6904-H-20T1XDDU*MA
111178

FT0007
NH451200BND2KCZ1AL
92480

FT0007
NS251480ALD2PCZ1AL
46960

FT0007
30TAC62CSUHPN7C
45432

FT0007
RB-7013UUC0
38000

FT0007
RA-12008CUUC0
29000

R20016
SR30-3000L
180900

R20016
GSR25-1500LR
106600

R20016
FK-10-OAMG
78000

R20016
GSR25TUU
57480

R20016
FK-08-OAMG
36300

R20016
BTK2005V-2.6ZZ-1000LC7
14148

R20016
SHS30LRSS
13500

R20016
SHS35CSS
12000

R20016
SHS30-840L
4040

R20016
CF-20-1B
3500

U20007
NRS45LRX6UUFME-7800LTFE
276000

U20007
SR30M1WUU
94500

U20007
HSR25LR2QZSSM-1060LHM
88000

U20007
GSR25TUU
48600

U20007
HSR20M1A
29600

U20007
020-MA5-0723E-FY
25900

U20007
2-KSH-40-110-54-HD-HD
25200

U20007
BLK2525F-7.2ZZ-402LTFG-JIK-4
8835

U20007
33007-NSK
8680

U20007
6920VV-NTN
7600

U20008
SHS30C2SSC0F-550LF
116000

U20008
SSR35XW2UUFM-4910LTF
104000

U20008
HR2042UUM
51300

U20008
VRU-2080
38000

U20008
SHS30VSS
2835

U20008
EGH20CAZ0C
2700

WG0012
SHS25C4SSC1-1300LSP-2
201600

WG0012
RB-35020UUCC0P4
156000

WG0012
1651-211-22-4-1605-201-31-1300L
33600

WG0012
6815ZZ-FBJ
5000

WG0012
LF-740ZZ-JIB
4704

WG0012
LMF-6LUU
4140

WG0012
L-1360ZZ-JIB
3920

WG0012
LM-6LUU
3280

WG0012
MHC-27C-8-8
2900

WG0012
SSL-1980ZZ-YCB
1782

WJ0090
SVR45R3SSHHC0FMS-5925LPTF
2798600

WJ0090
AFF+400G
1305000

WJ0090
WGF50100FM-3ZZG3-2900LC7F
573720

WJ0090
BLK3636FM-7.2QZZZ-1662LTF
452275

WJ0090
1315767
348000

WJ0090
SHS45V4SSHHC0FMS-6870LHFT
344296

WJ0090
AFA+400G
342000

WJ0090
2R050-50A1-1FSKT-4930-5200-0.018H
330000

WJ0090
WGF50100FM-3ZZG3-3300LC7TF
308228

WJ0090
1314117
300000

WJ0091
SGL35TF2-3000-W2LB
93800

WJ0091
VRT-1025AM
88000

WJ0091
1347007
84480

WJ0091
SHS20C2SS-3200LF
80200

WJ0091
1315558
60000

WJ0091
RNFCL5050A6S-2272LT
60000

WJ0091
RB-4010UUCC0
45876

WJ0091
SHS45VSSHHC0FMS
41600

WJ0091
1532-2-2016-1531-2-2900-92L
41600

WJ0091
SHW14CR2UUM-250LM
31266

WJ0091
MUCP205-ASAHI
30520

WJ0091
6004-H-20T1XZZ
26912

XU0007
RA-5008UUCC0
125460

XU0007
RA-12008UUC0
87395

XU0007
RB-2508UUCC0
83520

XU0007
MDK1002FM-3RRG2+125LC7F
47600

XU0007
FK-8
6300

XU0007
RA-7008UUCC0
3900

XU0007
L-2280ZZ
3094

XU0007
RA-7008UUC0
2600
custid	productid	amount	Rank	CustTotal
WJ0090	1315767	348000	1	756350
WJ0090	2R050-50A1-1FSKT-4930-5200-0.018H	330000	2	756350
WJ0090	1314117	300000	3	756350
WJ0090	1314134	290000	4	756350
WJ0090	1314127	284000	5	756350
WJ0090	1315655	280000	6	756350
WJ0090	6001-H-20T1XDDU*MA	208000	7	756350
WJ0090	1623-114-20	205800	8	756350
WJ0090	6811LLB	141000	9	756350
WJ0090	1315197	114590	10	756350
FT0007	1-KSH-32WL-60-500	264000	1	359609
FT0007	30TAC62CSUHPN7C	45432	2	359609
FT0007	6004-H-20T1XDDU*MA	17982	3	359609
FT0007	6804ZZ-NSK	9000	4	359609
FT0007	6828VV	4950	5	359609
FT0007	6001-H-20T1XZZ*MA	4560	6	359609
FT0007	1666-113-20	4485	7	359609
FT0007	1666-113-22	2990	8	359609
FT0007	6816ZZ-NSK	2580	9	359609
FT0007	6207ZZ-NSK	1380	10	359609
WJ0091	1347007	84480	1	250107
WJ0091	1315558	60000	2	250107
WJ0091	1532-2-2016-1531-2-2900-92L	41600	3	250107
WJ0091	6004-H-20T1XZZ	26912	4	250107
WJ0091	6811LLB	18800	5	250107
WJ0091	0455-203-31-280L	8415	6	250107
WJ0091	0443-293-01	4170	7	250107
WJ0091	6203-H-20T1XZZ*MA	2450	8	250107
WJ0091	608-H-DDMC3*MA	2100	9	250107
WJ0091	6207-H-20T1XZZ*MA	658	10	250107
U20007	020-MA5-0723E-FY	25900	1	80717
U20007	2-KSH-40-110-54-HD-HD	25200	2	80717
U20007	33007-NSK	8680	3	80717
U20007	1SRS7MUU-55LM	7500	4	80717
U20007	6804-H-20T1XZZ*MA	5717	5	80717
U20007	1-KSH-24L-42-40	4000	6	80717
U20007	6804ZZ-NSK	3720	7	80717
WG0012	1651-211-22-4-1605-201-31-1300L	33600	1	41990
WG0012	6815ZZ-FBJ	5000	2	41990
WG0012	126	1120	3	41990
WG0012	1200-IJK	1080	4	41990
WG0012	51100-YCB	630	5	41990
WG0012	5200-IJK	560	6	41990
9R0004	6204-H-20T1XADDU*MA	7350	1	10450
9R0004	6901-H-20T1XZZ*MA	3100	2	10450
custid	productid	amount
9R0003	SSR25XW6QZDDME-1900LYM	158400
9R0003	6905-H-20T1XZZ*MA	52600
9R0003	DK2506S-3RRGT-503LC7	45820
9R0003	SHS30R1SS-1960LP	19920
9R0003	SHS25CSS	18800
9R0003	BNT1605-2.6ZZ-319LT	7400
9R0004	HSR25AZZ	301140
9R0004	HSR25BSS	267900
9R0004	HSR25M1B	122600
9R0004	SSR35XW3SSFM-3320LHF	77000
9R0004	HSR25A6ZZE-2320LTE	64820
9R0004	SHS25C2SS-3440LT	64236
9R0004	SHS35R2SS-2040L	57800
9R0004	SBN3210V-7WWG0-1230LC5-J2K	48000
9R0004	SHS30CSS	22900
9R0004	LM-8S	19950
FT0007	AFF+70G	318720
FT0007	1-KSH-32WL-60-500	264000
FT0007	SHS45LV2UUFME-3610LTF	253840
FT0007	GSR35T5UUFE-7600LHRTF	167680
FT0007	6904-H-20T1XDDU*MA	111178
FT0007	NH451200BND2KCZ1AL	92480
FT0007	NS251480ALD2PCZ1AL	46960
FT0007	30TAC62CSUHPN7C	45432
FT0007	RB-7013UUC0	38000
FT0007	RA-12008CUUC0	29000
R20016	SR30-3000L	180900
R20016	GSR25-1500LR	106600
R20016	FK-10-OAMG	78000
R20016	GSR25TUU	57480
R20016	FK-08-OAMG	36300
R20016	BTK2005V-2.6ZZ-1000LC7	14148
R20016	SHS30LRSS	13500
R20016	SHS35CSS	12000
R20016	SHS30-840L	4040
R20016	CF-20-1B	3500
U20007	NRS45LRX6UUFME-7800LTFE	276000
U20007	SR30M1WUU	94500
U20007	HSR25LR2QZSSM-1060LHM	88000
U20007	GSR25TUU	48600
U20007	HSR20M1A	29600
U20007	020-MA5-0723E-FY	25900
U20007	2-KSH-40-110-54-HD-HD	25200
U20007	BLK2525F-7.2ZZ-402LTFG-JIK-4	8835
U20007	33007-NSK	8680
U20007	6920VV-NTN	7600
U20008	SHS30C2SSC0F-550LF	116000
U20008	SSR35XW2UUFM-4910LTF	104000
U20008	HR2042UUM	51300
U20008	VRU-2080	38000
U20008	SHS30VSS	2835
U20008	EGH20CAZ0C	2700
WG0012	SHS25C4SSC1-1300LSP-2	201600
WG0012	RB-35020UUCC0P4	156000
WG0012	1651-211-22-4-1605-201-31-1300L	33600
WG0012	6815ZZ-FBJ	5000
WG0012	LF-740ZZ-JIB	4704
WG0012	LMF-6LUU	4140
WG0012	L-1360ZZ-JIB	3920
WG0012	LM-6LUU	3280
WG0012	MHC-27C-8-8	2900
WG0012	SSL-1980ZZ-YCB	1782
WJ0090	SVR45R3SSHHC0FMS-5925LPTF	2798600
WJ0090	AFF+400G	1305000
WJ0090	WGF50100FM-3ZZG3-2900LC7F	573720
WJ0090	BLK3636FM-7.2QZZZ-1662LTF	452275
WJ0090	1315767	348000
WJ0090	SHS45V4SSHHC0FMS-6870LHFT	344296
WJ0090	AFA+400G	342000
WJ0090	2R050-50A1-1FSKT-4930-5200-0.018H	330000
WJ0090	WGF50100FM-3ZZG3-3300LC7TF	308228
WJ0090	1314117	300000
WJ0091	SGL35TF2-3000-W2LB	93800
WJ0091	VRT-1025AM	88000
WJ0091	1347007	84480
WJ0091	SHS20C2SS-3200LF	80200
WJ0091	1315558	60000
WJ0091	RNFCL5050A6S-2272LT	60000
WJ0091	RB-4010UUCC0	45876
WJ0091	SHS45VSSHHC0FMS	41600
WJ0091	1532-2-2016-1531-2-2900-92L	41600
WJ0091	SHW14CR2UUM-250LM	31266
WJ0091	MUCP205-ASAHI	30520
WJ0091	6004-H-20T1XZZ	26912
XU0007	RA-5008UUCC0	125460
XU0007	RA-12008UUC0	87395
XU0007	RB-2508UUCC0	83520
XU0007	MDK1002FM-3RRG2+125LC7F	47600
XU0007	FK-8	6300
XU0007	RA-7008UUCC0	3900
XU0007	L-2280ZZ	3094
XU0007	RA-7008UUC0	2600