========================2018-02-27 10:25:40======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = F44D30AEBA6F248A73A5 sCDKey = 202384525937 sName = USER-PC ========================2018-02-27 10:25:40======================== 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 = '202384525937' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-27 10:25:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skd77' ========================2018-02-27 10:25:40======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30AEBA6F248A73A5' AND app_code = '039' ========================2018-02-27 10:25:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '217660' ========================2018-02-27 10:25:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '217660' ========================2018-02-27 10:25:40======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'skd77', user_name = '성광기계[김대원]', screen_w = '1600', screen_h = '900', cdkey = '202384525937' WHERE mac_idx = '217660' ========================2018-02-27 10:56:27======================== noteurl_start parm_app_code = 046 parm_pc_name = HANKOOK-1 parm_os_type = 110 parm_screen_w = 1080 parm_screen_h = 1080 parm_user_mac = E0D55E450899C86E327E sCDKey = 453330832068 sName = HANKOOK-1 ========================2018-02-27 10:56:27======================== 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 = '453330832068' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 10:56:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hkem20' ========================2018-02-27 10:56:27======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E450899C86E327E' AND app_code = '046' ========================2018-02-27 10:56:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242998' ========================2018-02-27 10:56:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242998' ========================2018-02-27 10:56:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '242998', 'E0D55E450899C86E327E', '046', 'HANKOOK-1', '110', '1080', '1080', 'hkem20', '한국전기자재[이철형]', '453330832068' ) ========================2018-02-27 13:37:45======================== noteurl_start parm_app_code = 046 parm_pc_name = MAIN parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 5404A67FBD43644CF510 sCDKey = 871342852776 sName = MAIN ========================2018-02-27 13:37: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 13:37:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 13:37:45======================== SELECT idx FROM macs WHERE mac_addr = '5404A67FBD43644CF510' AND app_code = '046' ========================2018-02-27 13:37:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243026' ========================2018-02-27 13:37:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243026' ========================2018-02-27 13:37:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '243026', '5404A67FBD43644CF510', '046', 'MAIN', '90', '1920', '1080', 'whats', '(주)와츠[이용상]', '871342852776' ) ========================2018-02-27 13:37:50======================== noteurl_start parm_app_code = 046 parm_pc_name = MAIN parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 5404A67FBD43644CF510 sCDKey = 871342852776 sName = MAIN ========================2018-02-27 13:37: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 13:37:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 13:37:50======================== SELECT idx FROM macs WHERE mac_addr = '5404A67FBD43644CF510' AND app_code = '046' ========================2018-02-27 13:37:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243026' ========================2018-02-27 13:37:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243026' ========================2018-02-27 13:37:50======================== UPDATE mac_detail SET pc_name = 'MAIN', os_type = '90', user_id = 'whats', user_name = '(주)와츠[이용상]', screen_w = '1920', screen_h = '1080', cdkey = '871342852776' WHERE mac_idx = '243026' ========================2018-02-27 14:28:38======================== noteurl_start parm_app_code = 046 parm_pc_name = 메인노트북 parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E8039AAC985F68EFA82D sCDKey = 871342852776 sName = 메인노트북 ========================2018-02-27 14:28:38======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:28:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:28:38======================== SELECT idx FROM macs WHERE mac_addr = 'E8039AAC985F68EFA82D' AND app_code = '046' ========================2018-02-27 14:28:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243032' ========================2018-02-27 14:28:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243032' ========================2018-02-27 14:28:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '243032', 'E8039AAC985F68EFA82D', '046', '메인노트북', '90', '1600', '900', 'whats', '(주)와츠[이용상]', '871342852776' ) ========================2018-02-27 14:28:57======================== noteurl_start parm_app_code = 046 parm_pc_name = 메인노트북 parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E8039AAC985F68EFA82D sCDKey = 871342852776 sName = 와츠 ========================2018-02-27 14:28: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:28:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:28:57======================== SELECT idx FROM macs WHERE mac_addr = 'E8039AAC985F68EFA82D' AND app_code = '046' ========================2018-02-27 14:28:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243032' ========================2018-02-27 14:28:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243032' ========================2018-02-27 14:28:57======================== UPDATE mac_detail SET pc_name = '와츠', os_type = '90', user_id = 'whats', user_name = '(주)와츠[이용상]', screen_w = '1600', screen_h = '900', cdkey = '871342852776' WHERE mac_idx = '243032' ========================2018-02-27 14:29:07======================== noteurl_start parm_app_code = 046 parm_pc_name = 메인노트북 parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E8039AAC985F68EFA82D sCDKey = 871342852776 sName = 와츠 ========================2018-02-27 14:29:07======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:29:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:29:07======================== SELECT idx FROM macs WHERE mac_addr = 'E8039AAC985F68EFA82D' AND app_code = '046' ========================2018-02-27 14:29:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243032' ========================2018-02-27 14:29:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243032' ========================2018-02-27 14:29:07======================== UPDATE mac_detail SET pc_name = '와츠', os_type = '90', user_id = 'whats', user_name = '(주)와츠[이용상]', screen_w = '1600', screen_h = '900', cdkey = '871342852776' WHERE mac_idx = '243032' ========================2018-02-27 14:34:02======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 14:34: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:34:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:34:02======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:34:02======================== 값이 없을 경우 ========================2018-02-27 14:34:05======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 14:34:05======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:34:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:34:05======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:34:05======================== 값이 없을 경우 ========================2018-02-27 14:34:41======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 14:34: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:34:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:34:41======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:34:41======================== 값이 없을 경우 ========================2018-02-27 14:34:50======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 14:34: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:34:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:34:50======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:34:50======================== 값이 없을 경우 ========================2018-02-27 14:35:05======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 14:35:05======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:35:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:35:05======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:35:05======================== 값이 없을 경우 ========================2018-02-27 14:35:39======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 14:35:39======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:35:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:35:39======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:35:39======================== 값이 없을 경우 ========================2018-02-27 14:35:52======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 14:35:52======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:35:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:35:52======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:35:52======================== 값이 없을 경우 ========================2018-02-27 14:37:02======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 14:37: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:37:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:37:02======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:37:02======================== 값이 없을 경우 ========================2018-02-27 14:37:07======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 14:37:07======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:37:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:37:07======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:37:07======================== 값이 없을 경우 ========================2018-02-27 14:37:15======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = 삼척 ========================2018-02-27 14:37:15======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:37:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:37:15======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:37:15======================== 값이 없을 경우 ========================2018-02-27 14:37:24======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = 삼척 ========================2018-02-27 14:37: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:37:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:37:24======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:37:24======================== 값이 없을 경우 ========================2018-02-27 14:38:06======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = 와츠 ========================2018-02-27 14:38: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:38:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:38:06======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:38:06======================== 값이 없을 경우 ========================2018-02-27 14:38:23======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = 와츠 ========================2018-02-27 14:38:23======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:38:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:38:23======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:38:23======================== 값이 없을 경우 ========================2018-02-27 14:39:13======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 14:39:13======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:39:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:39:13======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:39:13======================== 값이 없을 경우 ========================2018-02-27 14:39:25======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = 와츠 ========================2018-02-27 14:39: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:39:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:39:25======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:39:25======================== 값이 없을 경우 ========================2018-02-27 14:39:39======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = 와츠 ========================2018-02-27 14:39:39======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:39:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:39:39======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:39:39======================== 값이 없을 경우 ========================2018-02-27 14:40:57======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 14:40: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:40:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:40:57======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:40:57======================== 값이 없을 경우 ========================2018-02-27 14:41:09======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 14:41: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:41:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:41:09======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:41:09======================== 값이 없을 경우 ========================2018-02-27 14:48:25======================== noteurl_start parm_app_code = 046 parm_pc_name = 메인노트북3 parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 6067204B7608DE998C25 sCDKey = 871342852776 sName = 와츠 ========================2018-02-27 14:48: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:48:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:48:25======================== SELECT idx FROM macs WHERE mac_addr = '6067204B7608DE998C25' AND app_code = '046' ========================2018-02-27 14:48:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243034' ========================2018-02-27 14:48:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243034' ========================2018-02-27 14:48:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '243034', '6067204B7608DE998C25', '046', '와츠', '90', '1600', '900', 'whats', '(주)와츠[이용상]', '871342852776' ) ========================2018-02-27 14:48:30======================== noteurl_start parm_app_code = 046 parm_pc_name = 메인노트북3 parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 6067204B7608DE998C25 sCDKey = 871342852776 sName = 와츠 ========================2018-02-27 14:48:30======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:49:49======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = 와츠 ========================2018-02-27 14:49: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:55:17======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 14:55:17======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:55:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:55:17======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:55:17======================== 값이 없을 경우 ========================2018-02-27 14:55:35======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = 와츠 ========================2018-02-27 14:55:35======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 14:55:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 14:55:35======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 14:55:35======================== 값이 없을 경우 ========================2018-02-27 15:00:01======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 15:00: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 15:00:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 15:00:01======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 15:00:01======================== 값이 없을 경우 ========================2018-02-27 15:02:48======================== noteurl_start parm_app_code = 039 parm_pc_name = TOPC-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1867B0470F7CC86D5511 sCDKey = 964456302922 sName = TOPC-PC ========================2018-02-27 15:02:48======================== 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 = '964456302922' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-27 15:02:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'egpia68' ========================2018-02-27 15:02:48======================== SELECT idx FROM macs WHERE mac_addr = '1867B0470F7CC86D5511' AND app_code = '039' ========================2018-02-27 15:02:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243037' ========================2018-02-27 15:02:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243037' ========================2018-02-27 15:02:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '243037', '1867B0470F7CC86D5511', '039', 'TOPC-PC', '90', '1920', '1080', 'egpia68', '이오농경[권복순]', '964456302922' ) ========================2018-02-27 15:10:53======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 15:10: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 15:10:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 15:10:53======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 15:10:53======================== 값이 없을 경우 ========================2018-02-27 15:30:39======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = D02788C53D6E468ADAB8 sCDKey = 899878128527 sName = USER-PC ========================2018-02-27 15:30:39======================== 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 = '899878128527' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-27 15:30:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hdlaser11' ========================2018-02-27 15:30:39======================== SELECT idx FROM macs WHERE mac_addr = 'D02788C53D6E468ADAB8' AND app_code = '039' ========================2018-02-27 15:30:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243042' ========================2018-02-27 15:30:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243042' ========================2018-02-27 15:30:39======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '243042', 'D02788C53D6E468ADAB8', '039', 'USER-PC', '90', '1440', '900', 'hdlaser11', '현대레이저(주)[허진영]', '899878128527' ) ========================2018-02-27 15:34:10======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 15:34:10======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 15:34:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 15:34:10======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 15:34:10======================== 값이 없을 경우 ========================2018-02-27 15:34:48======================== noteurl_start parm_app_code = 039 parm_pc_name = PC04-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = ECA86B26F9D63A8B1247 sCDKey = 899878128527 sName = PC04-PC ========================2018-02-27 15:34:48======================== 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 = '899878128527' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-27 15:34:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hdlaser11' ========================2018-02-27 15:34:48======================== SELECT idx FROM macs WHERE mac_addr = 'ECA86B26F9D63A8B1247' AND app_code = '039' ========================2018-02-27 15:34:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '175683' ========================2018-02-27 15:34:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '175683' ========================2018-02-27 15:34:48======================== UPDATE mac_detail SET pc_name = 'PC04-PC', os_type = '90', user_id = 'hdlaser11', user_name = '현대레이저(주)[허진영]', screen_w = '1280', screen_h = '1024', cdkey = '899878128527' WHERE mac_idx = '175683' ========================2018-02-27 15:44:30======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 15:44:30======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 15:44:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 15:44:30======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 15:44:30======================== 값이 없을 경우 ========================2018-02-27 15:44:45======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 15: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 15:44:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 15:44:45======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 15:44:45======================== 값이 없을 경우 ========================2018-02-27 16:24:17======================== noteurl_start parm_app_code = 046 parm_pc_name = PB-IKXZTWBJV0MN parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 54BEF749F505D0305710 sCDKey = 871342852776 sName = 삼척카운터2 ========================2018-02-27 16:24:17======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 16:24:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 16:24:17======================== SELECT idx FROM macs WHERE mac_addr = '54BEF749F505D0305710' AND app_code = '046' ========================2018-02-27 16:24:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243050' ========================2018-02-27 16:24:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243050' ========================2018-02-27 16:24:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '243050', '54BEF749F505D0305710', '046', '삼척카운터2', '64', '1024', '768', 'whats', '(주)와츠[이용상]', '871342852776' ) ========================2018-02-27 16:30:33======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 16:30:33======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 16:30:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 16:30:33======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 16:30:33======================== 값이 없을 경우 ========================2018-02-27 16:32:52======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 16:32:52======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 16:32:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 16:32:52======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 16:32:52======================== 값이 없을 경우 ========================2018-02-27 16:32:55======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 16:32:55======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 16:32:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 16:32:55======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 16:32:55======================== 값이 없을 경우 ========================2018-02-27 16:33:18======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 16:33:18======================== 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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 16:33:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 16:33:18======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 16:33:18======================== 값이 없을 경우 ========================2018-02-27 16:36:22======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 16:36: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 16:36:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 16:36:22======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 16:36:22======================== 값이 없을 경우 ========================2018-02-27 16:50:14======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 16:50: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 16:50:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 16:50:14======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 16:50:14======================== 값이 없을 경우 ========================2018-02-27 17:00:12======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B8D1646F7D14 sCDKey = 871342852776 sName = IPOS ========================2018-02-27 17:00: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 = '871342852776' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-27 17:00:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whats' ========================2018-02-27 17:00:12======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B8D1646F7D14' AND app_code = '046' ========================2018-02-27 17:00:12======================== 값이 없을 경우 ========================2018-02-27 17:34:49======================== noteurl_start parm_app_code = 050 parm_pc_name = MKP134 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 704D7B2E331E0AAA020E sCDKey = 903738087532 sName = MKP134 ========================2018-02-27 17:34: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 = '903738087532' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-27 17:34:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mkp0366' ========================2018-02-27 17:34:49======================== SELECT idx FROM macs WHERE mac_addr = '704D7B2E331E0AAA020E' AND app_code = '050' ========================2018-02-27 17:34:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243060' ========================2018-02-27 17:34:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243060' ========================2018-02-27 17:34:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '243060', '704D7B2E331E0AAA020E', '050', 'MKP134', '90', '1920', '1080', 'mkp0366', '엠케이프리시젼(주)[엠케이프리시젼(주)]', '903738087532' )