========================2018-07-05 09:04:26======================== noteurl_start parm_app_code = 047 parm_pc_name = 정호노트북 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 60F677ADA90D2C15FFBF sCDKey = 174615471489 sName = 정호노트북 ========================2018-07-05 09:04:26======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '174615471489' AND r.app_code = '047' AND r.app_block = 0 ========================2018-07-05 11:41:06======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 40F02FCDF95D9ACFEAAE sCDKey = 850808088684 sName = USER-PC ========================2018-07-05 11:41:06======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '850808088684' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 11:41:41======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 40F02FCDF95D9ACFEAAE sCDKey = 850808088684 sName = USER-PC ========================2018-07-05 11:41:41======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '850808088684' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 11:41:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wnrmadh' ========================2018-07-05 11:41:42======================== SELECT idx FROM macs WHERE mac_addr = '40F02FCDF95D9ACFEAAE' AND app_code = '046' ========================2018-07-05 11:41:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '237313' ========================2018-07-05 11:41:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '237313' ========================2018-07-05 11:41:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '237313', '40F02FCDF95D9ACFEAAE', '046', 'USER-PC', '90', '1366', '768', 'wnrmadh', '(주)금오식품[장혜숙]', '850808088684' ) ========================2018-07-05 11:43:12======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 40F02FCDF95D9ACFEAAE sCDKey = 850808088684 sName = USER-PC ========================2018-07-05 11:43:12======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '850808088684' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 11:43:49======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 40F02FCDF95D9ACFEAAE sCDKey = 850808088648 sName = USER-PC ========================2018-07-05 11:43:49======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '850808088648' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 11:44:06======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 40F02FCDF95D9ACFEAAE sCDKey = 850808088684 sName = USER-PC ========================2018-07-05 11:44:06======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '850808088684' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 11:44:45======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 40F02FCDF95D9ACFEAAE sCDKey = 850808088684 sName = USER-PC ========================2018-07-05 11:44:45======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '850808088684' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 11:45:09======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 40F02FCDF95D9ACFEAAE sCDKey = 850808088684 sName = USER-PC ========================2018-07-05 11:45:09======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '850808088684' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 11:45:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wnrmadh' ========================2018-07-05 11:45:09======================== SELECT idx FROM macs WHERE mac_addr = '40F02FCDF95D9ACFEAAE' AND app_code = '046' ========================2018-07-05 11:45:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '237313' ========================2018-07-05 11:45:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '237313' ========================2018-07-05 11:45:09======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'wnrmadh', user_name = '(주)금오식품[장혜숙]', screen_w = '1366', screen_h = '768', cdkey = '850808088684' WHERE mac_idx = '237313' ========================2018-07-05 11:48:04======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 40F02FCDF95D9ACFEAAE sCDKey = 850808088684 sName = USER-PC ========================2018-07-05 11:48:04======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '850808088684' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 11:48:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wnrmadh' ========================2018-07-05 11:48:04======================== SELECT idx FROM macs WHERE mac_addr = '40F02FCDF95D9ACFEAAE' AND app_code = '046' ========================2018-07-05 11:48:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '237313' ========================2018-07-05 11:48:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '237313' ========================2018-07-05 11:48:04======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'wnrmadh', user_name = '(주)금오식품[장혜숙]', screen_w = '1366', screen_h = '768', cdkey = '850808088684' WHERE mac_idx = '237313' ========================2018-07-05 11:59:16======================== noteurl_start parm_app_code = 046 parm_pc_name = COUNTER-PC parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 1C1B0D5624C98BB640 sCDKey = 850808088684 sName = COUNTER-PC ========================2018-07-05 11:59:16======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '850808088684' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 11:59:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wnrmadh' ========================2018-07-05 11:59:16======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D5624C98BB640' AND app_code = '046' ========================2018-07-05 11:59:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '225386' ========================2018-07-05 11:59:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '225386' ========================2018-07-05 11:59:16======================== UPDATE mac_detail SET pc_name = 'COUNTER-PC', os_type = '110', user_id = 'wnrmadh', user_name = '(주)금오식품[장혜숙]', screen_w = '1280', screen_h = '1024', cdkey = '850808088684' WHERE mac_idx = '225386' ========================2018-07-05 12:01:06======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4899505646F7D14 sCDKey = 588530981286 sName = IPOS-HDXP ========================2018-07-05 12:01:06======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '588530981286' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 12:01:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbongga33' ========================2018-07-05 12:01:06======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4899505646F7D14' AND app_code = '046' ========================2018-07-05 12:01:06======================== 값이 없을 경우 ========================2018-07-05 12:01:12======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4899505646F7D14 sCDKey = 588530981286 sName = IPOS-HDXP ========================2018-07-05 12:01:12======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '588530981286' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 12:01:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbongga33' ========================2018-07-05 12:01:12======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4899505646F7D14' AND app_code = '046' ========================2018-07-05 12:01:12======================== 값이 없을 경우 ========================2018-07-05 12:01:14======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4899505646F7D14 sCDKey = 588530981286 sName = IPOS-HDXP ========================2018-07-05 12:01:14======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '588530981286' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 12:04:25======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4899505646F7D14 sCDKey = 588530981286 sName = IPOS-HDXP ========================2018-07-05 12:04:25======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '588530981286' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 12:04:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbongga33' ========================2018-07-05 12:04:25======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4899505646F7D14' AND app_code = '046' ========================2018-07-05 12:04:25======================== 값이 없을 경우 ========================2018-07-05 13:17:43======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4899505646F7D14 sCDKey = 588530981286 sName = IPOS-HDXP ========================2018-07-05 13:17:43======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '588530981286' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 13:17:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbongga33' ========================2018-07-05 13:17:43======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4899505646F7D14' AND app_code = '046' ========================2018-07-05 13:17:43======================== 값이 없을 경우 ========================2018-07-05 13:19:50======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4899505646F7D14 sCDKey = 983017299189 sName = IPOS-HDXP ========================2018-07-05 13:19:50======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '983017299189' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 13:19:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbongga33' ========================2018-07-05 13:19:50======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4899505646F7D14' AND app_code = '046' ========================2018-07-05 13:19:50======================== 값이 없을 경우 ========================2018-07-05 13:19:59======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4899505646F7D14 sCDKey = 983017299189 sName = IPOS-HDXP ========================2018-07-05 13:19:59======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '983017299189' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 13:19:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbongga33' ========================2018-07-05 13:19:59======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4899505646F7D14' AND app_code = '046' ========================2018-07-05 13:19:59======================== 값이 없을 경우 ========================2018-07-05 13:20:01======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4899505646F7D14 sCDKey = 983017299189 sName = IPOS-HDXP ========================2018-07-05 13:20:01======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '983017299189' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 13:20:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbongga33' ========================2018-07-05 13:20:01======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4899505646F7D14' AND app_code = '046' ========================2018-07-05 13:20:01======================== 값이 없을 경우 ========================2018-07-05 13:20:53======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4899504646F7D14 sCDKey = 983017299189 sName = IPOS-HDXP ========================2018-07-05 13:20:53======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '983017299189' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 13:20:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbongga33' ========================2018-07-05 13:20:53======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4899504646F7D14' AND app_code = '046' ========================2018-07-05 13:20:53======================== 값이 없을 경우 ========================2018-07-05 14:04:34======================== noteurl_start parm_app_code = 046 parm_pc_name = IMHG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AF0E96D60F97 sCDKey = 473363962434 sName = IMHG ========================2018-07-05 14:04:34======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '473363962434' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 14:04:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lhg88' ========================2018-07-05 14:04:34======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E96D60F97' AND app_code = '046' ========================2018-07-05 14:04:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250690' ========================2018-07-05 14:04:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250690' ========================2018-07-05 14:04:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '250690', 'F44D30B9AF0E96D60F97', '046', 'IMHG', '110', '1920', '1080', 'lhg88', '엠제이소프트[임현규]', '473363962434' ) ========================2018-07-05 14:59:56======================== noteurl_start parm_app_code = 039 parm_pc_name = NEXT-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = D850E6DCD86456641286 sCDKey = 305486504008 sName = NEXT-PC ========================2018-07-05 14:59:56======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '305486504008' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-05 14:59:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'buribd88' ========================2018-07-05 14:59:56======================== SELECT idx FROM macs WHERE mac_addr = 'D850E6DCD86456641286' AND app_code = '039' ========================2018-07-05 14:59:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '253818' ========================2018-07-05 14:59:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '253818' ========================2018-07-05 14:59:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '253818', 'D850E6DCD86456641286', '039', 'NEXT-PC', '90', '1920', '1200', 'buribd88', '부리빌딩[길숙경]', '305486504008' ) ========================2018-07-05 15:27:24======================== noteurl_start parm_app_code = 046 parm_pc_name = FISHWIZ-POS parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = E8039A65E3747683C901 sCDKey = 185317015328 sName = FISHWIZ-POS ========================2018-07-05 15:27:24======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '185317015328' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 15:27:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lkj608' ========================2018-07-05 15:27:25======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A65E3747683C901' AND app_code = '046' ========================2018-07-05 15:27:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '196148' ========================2018-07-05 15:27:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '196148' ========================2018-07-05 15:27:25======================== UPDATE mac_detail SET pc_name = 'FISHWIZ-POS', os_type = '90', user_id = 'lkj608', user_name = '레버스인터네셔널[이건재]', screen_w = '1024', screen_h = '768', cdkey = '185317015328' WHERE mac_idx = '196148' ========================2018-07-05 16:43:57======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE52688A4E2B1FC sCDKey = 565903742676 sName = USER-PC ========================2018-07-05 16:43:57======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '565903742676' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-05 16:43:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'insoo2994' ========================2018-07-05 16:43:57======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAE52688A4E2B1FC' AND app_code = '039' ========================2018-07-05 16:43:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '253831' ========================2018-07-05 16:43:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '253831' ========================2018-07-05 16:43:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '253831', '24F5AAE52688A4E2B1FC', '039', 'USER-PC', '90', '1920', '1080', 'insoo2994', '삼화전기(주)[황인수]', '565903742676' ) ========================2018-07-05 16:44:02======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE52688A4E2B1FC sCDKey = 565903742676 sName = USER-PC ========================2018-07-05 16:44:02======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '565903742676' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-05 17:47:22======================== noteurl_start parm_app_code = 046 parm_pc_name = SERVER1 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A30BE876DCB93B sCDKey = 278917670892 sName = SERVER1 ========================2018-07-05 17:47:22======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '278917670892' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-05 17:47:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'guseoj' ========================2018-07-05 17:47:22======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A30BE876DCB93B' AND app_code = '046' ========================2018-07-05 17:47:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '121047' ========================2018-07-05 17:47:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '121047' ========================2018-07-05 17:47:22======================== UPDATE mac_detail SET pc_name = 'SERVER1', os_type = '90', user_id = 'guseoj', user_name = '현대종합공구[곽기주]', screen_w = '1920', screen_h = '1080', cdkey = '278917670892' WHERE mac_idx = '121047'