========================2019-05-27 09:12:48======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-KGBACEE parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C691322C84904D8579 sCDKey = 428662420564 sName = DESKTOP-KGBACEE ========================2019-05-27 09:12: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 = '428662420564' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 09:12:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ys9270' ========================2019-05-27 09:12:48======================== SELECT idx FROM macs WHERE mac_addr = '94C691322C84904D8579' AND app_code = '039' ========================2019-05-27 09:12:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '286852' ========================2019-05-27 09:12:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '286852' ========================2019-05-27 09:12: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 ( '286852', '94C691322C84904D8579', '039', 'DESKTOP-KGBACEE', '110', '1920', '1080', 'ys9270', '¿µ»óÄɹÌÄ®[±è¿µ»ó]', '428662420564' ) ========================2019-05-27 09:37:10======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL1 parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = D02788078402984E2974 sCDKey = 240742859361 sName = MSDN-SPECIAL1 ========================2019-05-27 09:37: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 = '240742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 09:37:26======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL1 parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = D02788078402984E2974 sCDKey = 210742859361 sName = MSDN-SPECIAL1 ========================2019-05-27 09:37: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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 09:37:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'julee37' ========================2019-05-27 09:37:26======================== SELECT idx FROM macs WHERE mac_addr = 'D02788078402984E2974' AND app_code = '039' ========================2019-05-27 09:37:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '198515' ========================2019-05-27 09:37:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '198515' ========================2019-05-27 09:37:26======================== UPDATE mac_detail SET pc_name = 'MSDN-SPECIAL1', os_type = '90', user_id = 'julee37', user_name = '°³¼ºÀÚ¹Ù¶ó, ½ºÅÙ³ª¶ó[À̼ø³à]', screen_w = '1680', screen_h = '1050', cdkey = '210742859361' WHERE mac_idx = '198515' ========================2019-05-27 09:39:31======================== noteurl_start parm_app_code = 039 parm_pc_name = SJ0506E-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 04D4C4235B9FA86EE33E sCDKey = 796377480568 sName = SJ0506E-PC ========================2019-05-27 09:39:31======================== 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 = '796377480568' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 09:39:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'treebelle' ========================2019-05-27 09:39:31======================== SELECT idx FROM macs WHERE mac_addr = '04D4C4235B9FA86EE33E' AND app_code = '039' ========================2019-05-27 09:39:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '286787' ========================2019-05-27 09:39:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '286787' ========================2019-05-27 09:39:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '286787', '04D4C4235B9FA86EE33E', '039', 'SJ0506E-PC', '90', '1920', '1080', 'treebelle', 'ÁÖ½Äȸ»ç ¼¼Á¾¾îÆÐ·²[¹Ú¿ë¼®]', '796377480568' ) ========================2019-05-27 10:09:25======================== noteurl_start parm_app_code = 039 parm_pc_name = USERX360 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = E0D55EA578F7B004FC0C sCDKey = 454717149262 sName = USERX360 ========================2019-05-27 10:09: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 = '454717149262' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 10:09:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ja4692' ========================2019-05-27 10:09:25======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EA578F7B004FC0C' AND app_code = '039' ========================2019-05-27 10:09:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '286864' ========================2019-05-27 10:09:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '286864' ========================2019-05-27 10:09: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 ( '286864', 'E0D55EA578F7B004FC0C', '039', 'USERX360', '110', '1280', '1024', 'ja4692', '´ë¼º°ø±¸¹éÈ­Á¡[ÀÌÀçÈÄ]', '454717149262' ) ========================2019-05-27 11:07:17======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E89A8FDB0FCE143BB83D sCDKey = 952469659701 sName = MSDN-SPECIAL ========================2019-05-27 11:07: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 = '952469659701' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 11:16:37======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E89A8FDB0FCE143BB83D sCDKey = 952469659701 sName = MSDN-SPECIAL ========================2019-05-27 11:16:37======================== 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 = '952469659701' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 11:20:07======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E89A8FDB0FCE143BB83D sCDKey = 952469659701 sName = MSDN-SPECIAL ========================2019-05-27 11:20: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 = '952469659701' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 11:20:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs466' ========================2019-05-27 11:20:07======================== SELECT idx FROM macs WHERE mac_addr = 'E89A8FDB0FCE143BB83D' AND app_code = '039' ========================2019-05-27 11:20:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '185379' ========================2019-05-27 11:20:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '185379' ========================2019-05-27 11:20:07======================== UPDATE mac_detail SET pc_name = 'MSDN-SPECIAL', os_type = '90', user_id = 'bs466', user_name = '¸íÁø»ê¾÷[ºÎ»êÁö»ç]', screen_w = '1920', screen_h = '1080', cdkey = '952469659701' WHERE mac_idx = '185379' ========================2019-05-27 11:41:18======================== noteurl_start parm_app_code = 039 parm_pc_name = KIM-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = B8AEEDA7413C8EF04540 sCDKey = 399626261722 sName = KIM-PC ========================2019-05-27 11:41: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 = '399626261722' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 11:41:42======================== noteurl_start parm_app_code = 039 parm_pc_name = KIM-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = B8AEEDA7413C8EF04540 sCDKey = 399626261722 sName = KIM-PC ========================2019-05-27 11:41:42======================== 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 = '399626261722' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 11:42:38======================== noteurl_start parm_app_code = 039 parm_pc_name = KIM-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = B8AEEDA7413C8EF04540 sCDKey = 399626261722 sName = KIM-PC ========================2019-05-27 11:42: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 = '399626261722' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 11:42:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rlarlfyd' ========================2019-05-27 11:42:38======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDA7413C8EF04540' AND app_code = '039' ========================2019-05-27 11:42:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '286794' ========================2019-05-27 11:42:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '286794' ========================2019-05-27 11:42: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 ( '286794', 'B8AEEDA7413C8EF04540', '039', 'KIM-PC', '90', '1280', '1024', 'rlarlfyd', 'µ¿¿ì»ó»ç[±è±â·æ]', '399626261722' ) ========================2019-05-27 11:44:24======================== noteurl_start parm_app_code = 047 parm_pc_name = USERSHOP-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C03FD5BEDFAB42FF512D sCDKey = 000149395113 sName = USERSHOP-PC ========================2019-05-27 11:44: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 = '000149395113' AND r.app_code = '047' AND r.app_block = 0 ========================2019-05-27 11:45:26======================== noteurl_start parm_app_code = 047 parm_pc_name = USERSHOP-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C03FD5BEDFAB42FF512D sCDKey = 000149395113 sName = USERSHOP-PC ========================2019-05-27 11:45: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 = '000149395113' AND r.app_code = '047' AND r.app_block = 0 ========================2019-05-27 11:46:07======================== noteurl_start parm_app_code = 039 parm_pc_name = KIM-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = B8AEEDA7413C25E7633 sCDKey = 399626261722 sName = KIM-PC ========================2019-05-27 11:46: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 = '399626261722' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 11:46:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rlarlfyd' ========================2019-05-27 11:46:07======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDA7413C25E7633' AND app_code = '039' ========================2019-05-27 11:46:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '286797' ========================2019-05-27 11:46:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '286797' ========================2019-05-27 11:46:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '286797', 'B8AEEDA7413C25E7633', '039', 'KIM-PC', '90', '1280', '1024', 'rlarlfyd', 'µ¿¿ì»ó»ç[±è±â·æ]', '399626261722' ) ========================2019-05-27 11:46:11======================== noteurl_start parm_app_code = 047 parm_pc_name = USERSHOP-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C03FD5BEDFAB42FF512D sCDKey = 586451149110 sName = USERSHOP-PC ========================2019-05-27 11:46:11======================== 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 = '586451149110' AND r.app_code = '047' AND r.app_block = 0 ========================2019-05-27 11:46:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kkoddl' ========================2019-05-27 11:46:11======================== SELECT idx FROM macs WHERE mac_addr = 'C03FD5BEDFAB42FF512D' AND app_code = '047' ========================2019-05-27 11:46:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '286872' ========================2019-05-27 11:46:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '286872' ========================2019-05-27 11:46:11======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '286872', 'C03FD5BEDFAB42FF512D', '047', 'USERSHOP-PC', '�쐢�룄�슦 7', '0', '0', 'kkoddl', 'ÇöÁø¿ø¿¹[ÀÌ¸í¼·]', '586451149110' ) ========================2019-05-27 11:47:41======================== noteurl_start parm_app_code = 039 parm_pc_name = KIM-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = B8AEEDA7413C8EF04540 sCDKey = 399626261722 sName = KIM-PC ========================2019-05-27 11:47: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 = '399626261722' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 11:47:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rlarlfyd' ========================2019-05-27 11:47:41======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDA7413C8EF04540' AND app_code = '039' ========================2019-05-27 11:47:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '286794' ========================2019-05-27 11:47:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '286794' ========================2019-05-27 11:47:41======================== UPDATE mac_detail SET pc_name = 'KIM-PC', os_type = '90', user_id = 'rlarlfyd', user_name = 'µ¿¿ì»ó»ç[±è±â·æ]', screen_w = '1280', screen_h = '1024', cdkey = '399626261722' WHERE mac_idx = '286794' ========================2019-05-27 13:57:25======================== noteurl_start parm_app_code = 045 parm_pc_name = °û¿µÇÐ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E470B8FB7AB1DAB017AA sCDKey = 805832056590 sName = °û¿µÇÐ ========================2019-05-27 13:57: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 = '805832056590' AND r.app_code = '045' AND r.app_block = 0 ========================2019-05-27 13:57:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ltweenn' ========================2019-05-27 13:57:25======================== SELECT idx FROM macs WHERE mac_addr = 'E470B8FB7AB1DAB017AA' AND app_code = '045' ========================2019-05-27 13:57:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '285380' ========================2019-05-27 13:57:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '285380' ========================2019-05-27 13:57: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 ( '285380', 'E470B8FB7AB1DAB017AA', '045', '°û¿µÇÐ', '110', '1920', '1080', 'ltweenn', '(ÁÖ)º§ºª[(ÁÖ)º§ºª]', '805832056590' ) ========================2019-05-27 14:16:56======================== noteurl_start parm_app_code = 039 parm_pc_name = BEST1-PC parm_os_type = 90 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 002185FC7A213849398B sCDKey = 618702022642 sName = Àüº´Àç ========================2019-05-27 14:16: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 = '618702022642' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 14:16:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jbj8000' ========================2019-05-27 14:16:56======================== SELECT idx FROM macs WHERE mac_addr = '002185FC7A213849398B' AND app_code = '039' ========================2019-05-27 14:16:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '286890' ========================2019-05-27 14:16:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '286890' ========================2019-05-27 14:16: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 ( '286890', '002185FC7A213849398B', '039', 'Àüº´Àç', '90', '1360', '768', 'jbj8000', '´ë»êÁ¾ÇÕ°ø±¸[Àüº´Àç]', '618702022642' ) ========================2019-05-27 14:17:01======================== noteurl_start parm_app_code = 039 parm_pc_name = BEST1-PC parm_os_type = 90 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 002185FC7A213849398B sCDKey = 618702022642 sName = Àüº´Àç ========================2019-05-27 14:17: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 = '618702022642' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 14:30:27======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-T7QCQA5 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8C89A5535B433E4FBE02 sCDKey = 277886843570 sName = DESKTOP-T7QCQA5 ========================2019-05-27 14:30: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 = '277886843570' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 14:30:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cs8419' ========================2019-05-27 14:30:27======================== SELECT idx FROM macs WHERE mac_addr = '8C89A5535B433E4FBE02' AND app_code = '039' ========================2019-05-27 14:30:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '286896' ========================2019-05-27 14:30:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '286896' ========================2019-05-27 14:30: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 ( '286896', '8C89A5535B433E4FBE02', '039', 'DESKTOP-T7QCQA5', '110', '1920', '1080', 'cs8419', '⼺Á¤À°À¯Åë[Á¤Çà½É]', '277886843570' ) ========================2019-05-27 16:40:45======================== noteurl_start parm_app_code = 039 parm_pc_name = BOSS-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 7085C22561B4DE7047 sCDKey = 036174096362 sName = BOSS-PC ========================2019-05-27 16:40: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 = '036174096362' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-27 16:40:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hongik97' ========================2019-05-27 16:40:45======================== SELECT idx FROM macs WHERE mac_addr = '7085C22561B4DE7047' AND app_code = '039' ========================2019-05-27 16:40:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '286916' ========================2019-05-27 16:40:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '286916' ========================2019-05-27 16:40: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 ( '286916', '7085C22561B4DE7047', '039', 'BOSS-PC', '90', '1440', '900', 'hongik97', 'Áø¿ìÅ×Å©[¾ö¿ì¼·]', '036174096362' )