========================2019-09-18 10:12:50======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 04D4C422316E78BA3DA8 sCDKey = 108094690671 sName = 거상빌딩1 ========================2019-09-18 10:12: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 = '108094690671' AND r.app_code = '046' AND r.app_block = 0 ========================2019-09-18 10:13:33======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 04D4C422316E78BA3DA8 sCDKey = 108094650671 sName = 거상빌딩1 ========================2019-09-18 10:13: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 = '108094650671' AND r.app_code = '046' AND r.app_block = 0 ========================2019-09-18 10:13:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'a09sang' ========================2019-09-18 10:13:33======================== SELECT idx FROM macs WHERE mac_addr = '04D4C422316E78BA3DA8' AND app_code = '046' ========================2019-09-18 10:13:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '296738' ========================2019-09-18 10:13:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '296738' ========================2019-09-18 10:13:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '296738', '04D4C422316E78BA3DA8', '046', '거상빌딩1', '90', '1920', '1080', 'a09sang', '(주)거상[장동익]', '108094650671' ) ========================2019-09-18 10:13:38======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 04D4C422316E78BA3DA8 sCDKey = 108094650671 sName = 거상빌딩1 ========================2019-09-18 10:13: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 = '108094650671' AND r.app_code = '046' AND r.app_block = 0 ========================2019-09-18 10:33:42======================== noteurl_start parm_app_code = 045 parm_pc_name = WIN-0PGEI61G95T parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002354A3B206705DE530 sCDKey = 244076831899 sName = WIN-0PGEI61G95T ========================2019-09-18 10:33: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 = '244076831899' AND r.app_code = '045' AND r.app_block = 0 ========================2019-09-18 10:33:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hohoinja' ========================2019-09-18 10:33:42======================== SELECT idx FROM macs WHERE mac_addr = '002354A3B206705DE530' AND app_code = '045' ========================2019-09-18 10:33:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292850' ========================2019-09-18 10:33:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292850' ========================2019-09-18 10:33:42======================== UPDATE mac_detail SET pc_name = 'WIN-0PGEI61G95T', os_type = '90', user_id = 'hohoinja', user_name = '세명컴퓨터[김동현]', screen_w = '1920', screen_h = '1080', cdkey = '244076831899' WHERE mac_idx = '292850' ========================2019-09-18 14:28:45======================== noteurl_start parm_app_code = 045 parm_pc_name = WIN-HVRH6D5HA2B parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = E81132397156705DE530 sCDKey = 244076831899 sName = WIN-HVRH6D5HA2B ========================2019-09-18 14:28: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 = '244076831899' AND r.app_code = '045' AND r.app_block = 0 ========================2019-09-18 14:28:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hohoinja' ========================2019-09-18 14:28:45======================== SELECT idx FROM macs WHERE mac_addr = 'E81132397156705DE530' AND app_code = '045' ========================2019-09-18 14:28:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '296793' ========================2019-09-18 14:28:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '296793' ========================2019-09-18 14:28: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 ( '296793', 'E81132397156705DE530', '045', 'WIN-HVRH6D5HA2B', '90', '1024', '768', 'hohoinja', '세명컴퓨터[김동현]', '244076831899' ) ========================2019-09-18 14:32:13======================== noteurl_start parm_app_code = 045 parm_pc_name = SC-201705161422 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002354A3B20686FE11CC sCDKey = 244076831899 sName = SC-201705161422 ========================2019-09-18 14:32: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 = '244076831899' AND r.app_code = '045' AND r.app_block = 0 ========================2019-09-18 14:32:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hohoinja' ========================2019-09-18 14:32:13======================== SELECT idx FROM macs WHERE mac_addr = '002354A3B20686FE11CC' AND app_code = '045' ========================2019-09-18 14:32:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '296799' ========================2019-09-18 14:32:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '296799' ========================2019-09-18 14:32:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '296799', '002354A3B20686FE11CC', '045', 'SC-201705161422', '90', '1920', '1080', 'hohoinja', '세명컴퓨터[김동현]', '244076831899' ) ========================2019-09-18 16:10:39======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JJSGJ2I parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 8A8E20524153207D371B sCDKey = 794400838519 sName = DESKTOP-JJSGJ2I ========================2019-09-18 16:10: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 = '794400838519' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 16:10:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sejong01' ========================2019-09-18 16:10:39======================== SELECT idx FROM macs WHERE mac_addr = '8A8E20524153207D371B' AND app_code = '039' ========================2019-09-18 16:10:39======================== 값이 없을 경우 ========================2019-09-18 16:10:51======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JJSGJ2I parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 8A8E20524153207D371B sCDKey = 794400838519 sName = DESKTOP-JJSGJ2I ========================2019-09-18 16:10: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 = '794400838519' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 16:10:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sejong01' ========================2019-09-18 16:10:51======================== SELECT idx FROM macs WHERE mac_addr = '8A8E20524153207D371B' AND app_code = '039' ========================2019-09-18 16:10:51======================== 값이 없을 경우 ========================2019-09-18 16:11:15======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JJSGJ2I parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 8A8E20524153207D371B sCDKey = 794400838519 sName = DESKTOP-JJSGJ2I ========================2019-09-18 16:11: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 = '794400838519' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 16:11:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sejong01' ========================2019-09-18 16:11:15======================== SELECT idx FROM macs WHERE mac_addr = '8A8E20524153207D371B' AND app_code = '039' ========================2019-09-18 16:11:15======================== 값이 없을 경우 ========================2019-09-18 16:11:21======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JJSGJ2I parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 8A8E20524153207D371B sCDKey = 794400838519 sName = DESKTOP-JJSGJ2I ========================2019-09-18 16:11:21======================== 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 = '794400838519' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 16:11:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sejong01' ========================2019-09-18 16:11:21======================== SELECT idx FROM macs WHERE mac_addr = '8A8E20524153207D371B' AND app_code = '039' ========================2019-09-18 16:11:21======================== 값이 없을 경우 ========================2019-09-18 16:13:58======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JJSGJ2I parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 8A8E20524153207D371B sCDKey = 794400838519 sName = DESKTOP-JJSGJ2I ========================2019-09-18 16:13: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 = '794400838519' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 16:13:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sejong01' ========================2019-09-18 16:13:58======================== SELECT idx FROM macs WHERE mac_addr = '8A8E20524153207D371B' AND app_code = '039' ========================2019-09-18 16:13:58======================== 값이 없을 경우 ========================2019-09-18 16:14:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JJSGJ2I parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 8A8E20524153207D371B sCDKey = 794400838519 sName = DESKTOP-JJSGJ2I ========================2019-09-18 16:14: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 = '794400838519' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 16:14:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sejong01' ========================2019-09-18 16:14:00======================== SELECT idx FROM macs WHERE mac_addr = '8A8E20524153207D371B' AND app_code = '039' ========================2019-09-18 16:14:00======================== 값이 없을 경우 ========================2019-09-18 17:10:29======================== noteurl_start parm_app_code = 039 parm_pc_name = HP4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 86FDD1F21D5990882BC1 sCDKey = 708322585128 sName = HP4 ========================2019-09-18 17:10: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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 17:10:51======================== noteurl_start parm_app_code = 039 parm_pc_name = HP4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 86FDD1F21D5990882BC1 sCDKey = 708322585128 sName = HP4 ========================2019-09-18 17:10: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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 17:10:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2019-09-18 17:10:51======================== SELECT idx FROM macs WHERE mac_addr = '86FDD1F21D5990882BC1' AND app_code = '039' ========================2019-09-18 17:10:51======================== 값이 없을 경우 ========================2019-09-18 17:10:59======================== noteurl_start parm_app_code = 039 parm_pc_name = HP4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 86FDD1F21D5990882BC1 sCDKey = 708322585128 sName = HP4 ========================2019-09-18 17:10:59======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 17:10:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2019-09-18 17:10:59======================== SELECT idx FROM macs WHERE mac_addr = '86FDD1F21D5990882BC1' AND app_code = '039' ========================2019-09-18 17:10:59======================== 값이 없을 경우 ========================2019-09-18 17:11:05======================== noteurl_start parm_app_code = 039 parm_pc_name = HP4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 86FDD1F21D5990882BC1 sCDKey = 708322585128 sName = HP4 ========================2019-09-18 17:11: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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 17:11:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2019-09-18 17:11:05======================== SELECT idx FROM macs WHERE mac_addr = '86FDD1F21D5990882BC1' AND app_code = '039' ========================2019-09-18 17:11:05======================== 값이 없을 경우 ========================2019-09-18 17:12:47======================== noteurl_start parm_app_code = 039 parm_pc_name = HP4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 86FDD1F21D5990882BC1 sCDKey = 708322585128 sName = HP4 ========================2019-09-18 17:12:47======================== 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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 17:12:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2019-09-18 17:12:47======================== SELECT idx FROM macs WHERE mac_addr = '86FDD1F21D5990882BC1' AND app_code = '039' ========================2019-09-18 17:12:47======================== 값이 없을 경우 ========================2019-09-18 17:12:58======================== noteurl_start parm_app_code = 039 parm_pc_name = HP4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 86FDD1F21D5990882BC1 sCDKey = 708322585128 sName = HP4 ========================2019-09-18 17:12: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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 17:12:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2019-09-18 17:12:58======================== SELECT idx FROM macs WHERE mac_addr = '86FDD1F21D5990882BC1' AND app_code = '039' ========================2019-09-18 17:12:58======================== 값이 없을 경우 ========================2019-09-18 17:13:00======================== noteurl_start parm_app_code = 039 parm_pc_name = HP4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 86FDD1F21D5990882BC1 sCDKey = 708322585128 sName = HP4 ========================2019-09-18 17:13: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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 17:13:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2019-09-18 17:13:00======================== SELECT idx FROM macs WHERE mac_addr = '86FDD1F21D5990882BC1' AND app_code = '039' ========================2019-09-18 17:13:00======================== 값이 없을 경우 ========================2019-09-18 17:13:16======================== noteurl_start parm_app_code = 039 parm_pc_name = HP4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 86FDD1F21D5990882BC1 sCDKey = 708322585128 sName = HP4 ========================2019-09-18 17:13: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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 17:13:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2019-09-18 17:13:16======================== SELECT idx FROM macs WHERE mac_addr = '86FDD1F21D5990882BC1' AND app_code = '039' ========================2019-09-18 17:13:16======================== 값이 없을 경우 ========================2019-09-18 17:13:22======================== noteurl_start parm_app_code = 039 parm_pc_name = HP4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 86FDD1F21D5990882BC1 sCDKey = 708322585128 sName = HP4 ========================2019-09-18 17:13: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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 17:13:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2019-09-18 17:13:22======================== SELECT idx FROM macs WHERE mac_addr = '86FDD1F21D5990882BC1' AND app_code = '039' ========================2019-09-18 17:13:22======================== 값이 없을 경우 ========================2019-09-18 17:14:17======================== noteurl_start parm_app_code = 039 parm_pc_name = HP4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 86FDD1F21D5990882BC1 sCDKey = 708322585128 sName = HP4 ========================2019-09-18 17:14: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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 17:14:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2019-09-18 17:14:17======================== SELECT idx FROM macs WHERE mac_addr = '86FDD1F21D5990882BC1' AND app_code = '039' ========================2019-09-18 17:14:17======================== 값이 없을 경우 ========================2019-09-18 17:14:18======================== noteurl_start parm_app_code = 039 parm_pc_name = HP4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 86FDD1F21D5990882BC1 sCDKey = 708322585128 sName = HP4 ========================2019-09-18 17:14: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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 17:14:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2019-09-18 17:14:18======================== SELECT idx FROM macs WHERE mac_addr = '86FDD1F21D5990882BC1' AND app_code = '039' ========================2019-09-18 17:14:18======================== 값이 없을 경우 ========================2019-09-18 17:14:20======================== noteurl_start parm_app_code = 039 parm_pc_name = HP4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 86FDD1F21D5990882BC1 sCDKey = 708322585128 sName = HP4 ========================2019-09-18 17:14: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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 17:14:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2019-09-18 17:14:20======================== SELECT idx FROM macs WHERE mac_addr = '86FDD1F21D5990882BC1' AND app_code = '039' ========================2019-09-18 17:14:20======================== 값이 없을 경우 ========================2019-09-18 17:14:23======================== noteurl_start parm_app_code = 039 parm_pc_name = HP4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 86FDD1F21D5990882BC1 sCDKey = 708322585128 sName = HP4 ========================2019-09-18 17:14: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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-18 17:14:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2019-09-18 17:14:23======================== SELECT idx FROM macs WHERE mac_addr = '86FDD1F21D5990882BC1' AND app_code = '039' ========================2019-09-18 17:14:23======================== 값이 없을 경우