========================2020-02-28 09:17:04======================== noteurl_start parm_app_code = 047 parm_pc_name = POS2 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 382C4A64255C0CDE1A67 sCDKey = 204297080946 sName = ³ëÃâÆ÷½º ========================2020-02-28 09:17: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 = '204297080946' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-28 09:17:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ulsanwood' ========================2020-02-28 09:17:04======================== SELECT idx FROM macs WHERE mac_addr = '382C4A64255C0CDE1A67' AND app_code = '047' ========================2020-02-28 09:17:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292811' ========================2020-02-28 09:17:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292811' ========================2020-02-28 09:17:04======================== UPDATE mac_detail SET pc_name = '³ëÃâÆ÷½º', os_type = '�쐢�룄�슦 7', user_id = 'ulsanwood', user_name = '¿¬¾Ïö¹°°ø±¸Á¾ÇÕ»ó»ç[¹Úµ¿Áø]', screen_w = '0', screen_h = '0', cdkey = '204297080946' WHERE mac_idx = '292811' ========================2020-02-28 09:18:02======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-45SOOM2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 88366CFB5226C042FFAB sCDKey = 204297080946 sName = ö¹°Á¡TV ========================2020-02-28 09:18: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 = '204297080946' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-28 09:18:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ulsanwood' ========================2020-02-28 09:18:02======================== SELECT idx FROM macs WHERE mac_addr = '88366CFB5226C042FFAB' AND app_code = '047' ========================2020-02-28 09:18:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304213' ========================2020-02-28 09:18:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304213' ========================2020-02-28 09:18:02======================== UPDATE mac_detail SET pc_name = 'ö¹°Á¡TV', os_type = '�쐢�룄�슦 10', user_id = 'ulsanwood', user_name = '¿¬¾Ïö¹°°ø±¸Á¾ÇÕ»ó»ç[¹Úµ¿Áø]', screen_w = '0', screen_h = '0', cdkey = '204297080946' WHERE mac_idx = '304213' ========================2020-02-28 09:18:51======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-EI0SL2T parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 04D9F564A5D00EC19E50 sCDKey = 204297080946 sName = ¹Úµ¿Áø ========================2020-02-28 09:18:51======================== 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 = '204297080946' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-28 09:18:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ulsanwood' ========================2020-02-28 09:18:51======================== SELECT idx FROM macs WHERE mac_addr = '04D9F564A5D00EC19E50' AND app_code = '047' ========================2020-02-28 09:18:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304356' ========================2020-02-28 09:18:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304356' ========================2020-02-28 09:18:51======================== UPDATE mac_detail SET pc_name = '¹Úµ¿Áø', os_type = '�쐢�룄�슦 10', user_id = 'ulsanwood', user_name = '¿¬¾Ïö¹°°ø±¸Á¾ÇÕ»ó»ç[¹Úµ¿Áø]', screen_w = '0', screen_h = '0', cdkey = '204297080946' WHERE mac_idx = '304356' ========================2020-02-28 09:19:51======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-QGR0CRO parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 88366CFB55A0623E7FD7 sCDKey = 204297080946 sName = Ä«¿îÅÍ µÞÀÚ¸® ========================2020-02-28 09:19:51======================== 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 = '204297080946' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-28 09:19:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ulsanwood' ========================2020-02-28 09:19:51======================== SELECT idx FROM macs WHERE mac_addr = '88366CFB55A0623E7FD7' AND app_code = '047' ========================2020-02-28 09:19:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304357' ========================2020-02-28 09:19:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304357' ========================2020-02-28 09:19:51======================== UPDATE mac_detail SET pc_name = 'Ä«¿îÅÍ µÞÀÚ¸®', os_type = '�쐢�룄�슦 10', user_id = 'ulsanwood', user_name = '¿¬¾Ïö¹°°ø±¸Á¾ÇÕ»ó»ç[¹Úµ¿Áø]', screen_w = '0', screen_h = '0', cdkey = '204297080946' WHERE mac_idx = '304357' ========================2020-02-28 09:21:15======================== noteurl_start parm_app_code = 047 parm_pc_name = SDFVCV-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 107B449105A07A611CA1 sCDKey = 204297080946 sName = ¸ÞÀÎÆ÷½º ========================2020-02-28 09:21: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 = '204297080946' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-28 09:21:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ulsanwood' ========================2020-02-28 09:21:15======================== SELECT idx FROM macs WHERE mac_addr = '107B449105A07A611CA1' AND app_code = '047' ========================2020-02-28 09:21:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '307428' ========================2020-02-28 09:21:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '307428' ========================2020-02-28 09:21:15======================== UPDATE mac_detail SET pc_name = '¸ÞÀÎÆ÷½º', os_type = '�쐢�룄�슦 7', user_id = 'ulsanwood', user_name = '¿¬¾Ïö¹°°ø±¸Á¾ÇÕ»ó»ç[¹Úµ¿Áø]', screen_w = '0', screen_h = '0', cdkey = '204297080946' WHERE mac_idx = '307428' ========================2020-02-28 09:49:20======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-79PIOS0 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55E1752908E04A769 sCDKey = 658489921113 sName = sgja01 ========================2020-02-28 09:49:20======================== 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 = '658489921113' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-28 09:54:05======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-79PIOS0 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55E1752908E04A769 sCDKey = 658489921113 sName = ÀåÁÖ¿ø ========================2020-02-28 09:54: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 = '658489921113' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-28 09:54:28======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-79PIOS0 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55E1752908E04A769 sCDKey = 658489921113 sName = ÀåÁÖ¿ø ========================2020-02-28 09:54:28======================== 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 = '658489921113' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-28 09:54:49======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-79PIOS0 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55E1752908E04A769 sCDKey = 658489921113 sName = ÀåÁÖ¿ø ========================2020-02-28 09:54: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 = '658489921113' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-28 09:55:02======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-79PIOS0 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55E1752908E04A769 sCDKey = 658489921113 sName = ÀåÁÖ¿ø ========================2020-02-28 09:55: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 = '658489921113' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-28 10:05:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-SJA1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C6913D1BC49A82F853 sCDKey = 089176965729 sName = DESKTOP-SJA1 ========================2020-02-28 10:05:29======================== 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 = '089176965729' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-28 10:05:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dguk9188' ========================2020-02-28 10:05:29======================== SELECT idx FROM macs WHERE mac_addr = '94C6913D1BC49A82F853' AND app_code = '039' ========================2020-02-28 10:05:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310444' ========================2020-02-28 10:05:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310444' ========================2020-02-28 10:05:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '310444', '94C6913D1BC49A82F853', '039', 'DESKTOP-SJA1', '110', '1920', '1080', 'dguk9188', 'µ¿±¹ÀÇ·á±â[¹ÚÁ¾¿¬]', '089176965729' ) ========================2020-02-28 11:18:41======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EI7KM6C parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A159104DD722362759 sCDKey = 553963775460 sName = DESKTOP-EI7KM6C ========================2020-02-28 11:18: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 = '553963775460' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-28 11:18:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dnsexper0401' ========================2020-02-28 11:18:41======================== SELECT idx FROM macs WHERE mac_addr = 'A8A159104DD722362759' AND app_code = '039' ========================2020-02-28 11:18:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311775' ========================2020-02-28 11:18:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311775' ========================2020-02-28 11:18:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '311775', 'A8A159104DD722362759', '039', 'DESKTOP-EI7KM6C', '110', '1920', '1080', 'dnsexper0401', 'µð¾Ø¿¡½º¿¢½ºÆÛ[À¯Á¤Çö]', '553963775460' ) ========================2020-02-28 13:05:03======================== noteurl_start parm_app_code = 039 parm_pc_name = ADMIN-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 2CD05AD0E24F62A9266C sCDKey = 453015259105 sName = ADMIN-PC ========================2020-02-28 13:05:03======================== 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 = '453015259105' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-28 13:05:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'w787654' ========================2020-02-28 13:05:04======================== SELECT idx FROM macs WHERE mac_addr = '2CD05AD0E24F62A9266C' AND app_code = '039' ========================2020-02-28 13:05:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248527' ========================2020-02-28 13:05:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248527' ========================2020-02-28 13:05:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '248527', '2CD05AD0E24F62A9266C', '039', 'ADMIN-PC', '90', '1366', '768', 'w787654', 'W±â°ø¼Ò[ÀÓ»ó¿í]', '453015259105' ) ========================2020-02-28 13:05:17======================== noteurl_start parm_app_code = 039 parm_pc_name = ADMIN-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 2CD05AD0E24F62A9266C sCDKey = 453015259105 sName = ADMIN-PC ========================2020-02-28 13:05: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 = '453015259105' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-28 13:05:57======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-HBPNO7H parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00D86114B78F900E6067 sCDKey = 773623978231 sName = DESKTOP-HBPNO7H ========================2020-02-28 13:05: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 = '773623978231' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-28 13:05:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'xrzx4756' ========================2020-02-28 13:05:57======================== SELECT idx FROM macs WHERE mac_addr = '00D86114B78F900E6067' AND app_code = '039' ========================2020-02-28 13:05:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311779' ========================2020-02-28 13:05:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311779' ========================2020-02-28 13:05: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 ( '311779', '00D86114B78F900E6067', '039', 'DESKTOP-HBPNO7H', '110', '1920', '1080', 'xrzx4756', 'ÁÖ½Äȸ»ç ű¤½Ã½ºÅÛ[¹ÚÁ¤Èñ]', '773623978231' ) ========================2020-02-28 14:05:13======================== noteurl_start parm_app_code = 039 parm_pc_name = JUNE parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCAEC570E29690C8F1DA sCDKey = 702871287149 sName = JUNE ========================2020-02-28 14:05: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 = '702871287149' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-28 14:05:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ksd1557' ========================2020-02-28 14:05:13======================== SELECT idx FROM macs WHERE mac_addr = 'BCAEC570E29690C8F1DA' AND app_code = '039' ========================2020-02-28 14:05:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '279691' ========================2020-02-28 14:05:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '279691' ========================2020-02-28 14:05:13======================== UPDATE mac_detail SET pc_name = 'JUNE', os_type = '90', user_id = 'ksd1557', user_name = 'À¯ÇÑȸ»ç µ¿ÁøÁ¾ÇÕ»ó»ç[±èÀιü]', screen_w = '1920', screen_h = '1080', cdkey = '702871287149' WHERE mac_idx = '279691' ========================2020-02-28 14:25:09======================== noteurl_start parm_app_code = 047 parm_pc_name = MSDN-SPECIAL parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B8975A97BB83289BE526 sCDKey = 807375456416 sName = MSDN-SPECIAL ========================2020-02-28 14:25: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 = '807375456416' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-28 14:25:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gana4807' ========================2020-02-28 14:25:10======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A97BB83289BE526' AND app_code = '047' ========================2020-02-28 14:25:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311788' ========================2020-02-28 14:25:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311788' ========================2020-02-28 14:25:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '311788', 'B8975A97BB83289BE526', '047', 'MSDN-SPECIAL', '�쐢�룄�슦 7', '0', '0', 'gana4807', '(ÁÖ)°¡³ª24½Ãµ¿¹°º´¿ø[±èâ±Ô]', '807375456416' ) ========================2020-02-28 14:49:23======================== noteurl_start parm_app_code = 039 parm_pc_name = »çÀå´Ô parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5CEC7F88C0DC40E0 sCDKey = 910889212815 sName = »çÀå´Ô ========================2020-02-28 14:49: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 = '910889212815' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-28 14:51:01======================== noteurl_start parm_app_code = 039 parm_pc_name = »çÀå´Ô parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5CEC7F88C0DC40E0 sCDKey = 910889212815 sName = »çÀå´Ô ========================2020-02-28 14:51: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 = '910889212815' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-28 14:52:09======================== noteurl_start parm_app_code = 039 parm_pc_name = »çÀå´Ô parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5CEC7F88C0DC40E0 sCDKey = 910889212815 sName = »çÀå´Ô ========================2020-02-28 14:52: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 = '910889212815' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-28 14:54:46======================== noteurl_start parm_app_code = 039 parm_pc_name = »çÀå´Ô parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5CEC7F88C0DC40E0 sCDKey = 910889212815 sName = »çÀå´Ô ========================2020-02-28 14:54:46======================== 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 = '910889212815' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-28 14:55:00======================== noteurl_start parm_app_code = 039 parm_pc_name = »çÀå´Ô parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5CEC7F88C0DC40E0 sCDKey = 910889212815 sName = »çÀå´Ô ========================2020-02-28 14:55:00======================== 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 = '910889212815' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-28 14:55:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'insan' ========================2020-02-28 14:55:00======================== SELECT idx FROM macs WHERE mac_addr = '408D5CEC7F88C0DC40E0' AND app_code = '039' ========================2020-02-28 14:55:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311790' ========================2020-02-28 14:55:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311790' ========================2020-02-28 14:55:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '311790', '408D5CEC7F88C0DC40E0', '039', '»çÀå´Ô', '110', '1920', '1080', 'insan', 'ÀÎ»ê°ø¾÷[±è¿ëÁ¦]', '910889212815' )