========================2018-07-28 08:33:58======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 08:33:58======================== 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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 08:36:07======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 08:36: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 08:36:07======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 08:36: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 08:36:08======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 08:36:08======================== 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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 08:36:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 08:36: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 08:41:28======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 08:41: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 08:41:32======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 08:41:32======================== 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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 08:51:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 08:51: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 08:56:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 08:56: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:06:25======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 09:06: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:06:31======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 09:06: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:36:12======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 09:36: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:36:24======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 09:36: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:36:32======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = ========================2018-07-28 09:36:32======================== 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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:36:48======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = 동양철물공구 ========================2018-07-28 09:36: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:36:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = 동양철물 ========================2018-07-28 09:36: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:37:08======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = 동양 ========================2018-07-28 09:37:08======================== 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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:37:12======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = 동양 ========================2018-07-28 09:37: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:37:16======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = 동양 ========================2018-07-28 09:37: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:37:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = 동양 ========================2018-07-28 09:37: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:37:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = 동양 ========================2018-07-28 09:37: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:37:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = 동양 ========================2018-07-28 09:37: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:37:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = 동양 ========================2018-07-28 09:37: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:37:19======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = 동양 ========================2018-07-28 09:37:19======================== 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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:38:15======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = 동양 ========================2018-07-28 09:38: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:52:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 09:52: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 09:52:07======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 09:52: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 10:11:08======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 10:11:08======================== 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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 10:50:55======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 10:50: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 10:52:16======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 10:52: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 10:52:57======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 10:52: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 11:04:33======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 11:04: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 11:16:16======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 11:16: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 12:23:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 12:23:44======================== 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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 12:28:02======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 12:28: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 12:46:38======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-07-28 12:46: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-28 16:20:33======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-585RDJV parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 70C94E9140E93A9F6F59 sCDKey = 169591860148 sName = notebook2018 ========================2018-07-28 16:20: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 = '169591860148' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-28 16:30:56======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-585RDJV parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 70C94E9140E93A9F6F59 sCDKey = 169591860148 sName = 노트북2018 ========================2018-07-28 16:30: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 = '169591860148' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-28 16:30:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjss064' ========================2018-07-28 16:30:56======================== SELECT idx FROM macs WHERE mac_addr = '70C94E9140E93A9F6F59' AND app_code = '046' ========================2018-07-28 16:30:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '255905' ========================2018-07-28 16:30:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '255905' ========================2018-07-28 16:30: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 ( '255905', '70C94E9140E93A9F6F59', '046', '노트북2018', '110', '1536', '864', 'hjss064', '형제상사주식회사[양진규]', '169591860148' ) ========================2018-07-28 17:28:49======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-SOB08AL parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 001D0995145868149764 sCDKey = 916970945314 sName = DESKTOP-SOB08AL ========================2018-07-28 17:28: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 = '916970945314' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-28 17:28:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'danjinail' ========================2018-07-28 17:28:49======================== SELECT idx FROM macs WHERE mac_addr = '001D0995145868149764' AND app_code = '046' ========================2018-07-28 17:28:49======================== 값이 없을 경우 ========================2018-07-28 17:38:26======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-SOB08AL parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 001D0995145868149764 sCDKey = 916970945314 sName = DESKTOP-SOB08AL ========================2018-07-28 17:38: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 = '916970945314' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-28 17:38:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'danjinail' ========================2018-07-28 17:38:26======================== SELECT idx FROM macs WHERE mac_addr = '001D0995145868149764' AND app_code = '046' ========================2018-07-28 17:38:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '255908' ========================2018-07-28 17:38:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '255908' ========================2018-07-28 17:38:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '255908', '001D0995145868149764', '046', 'DESKTOP-SOB08AL', '110', '1280', '1024', 'danjinail', '단지네네일가게[임재완]', '916970945314' )