========================2025-04-30 09:38:16======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 001745E4455D764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 09:38: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 09:38:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modpam' ========================2025-04-30 09:38:16======================== SELECT idx FROM macs WHERE mac_addr = '001745E4455D764182DD' AND app_code = '047' ========================2025-04-30 09:38:16======================== °ªÀÌ ¾øÀ» °æ¿ì ========================2025-04-30 09:40:39======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 001745E4455D764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 09:40: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 09:40:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modpam' ========================2025-04-30 09:40:39======================== SELECT idx FROM macs WHERE mac_addr = '001745E4455D764182DD' AND app_code = '047' ========================2025-04-30 09:40:39======================== °ªÀÌ ¾øÀ» °æ¿ì ========================2025-04-30 09:52:43======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 001745E4455D764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 09:52:43======================== 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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 09:52:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modpam' ========================2025-04-30 09:52:43======================== SELECT idx FROM macs WHERE mac_addr = '001745E4455D764182DD' AND app_code = '047' ========================2025-04-30 09:52:43======================== °ªÀÌ ¾øÀ» °æ¿ì ========================2025-04-30 09:53:40======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 001745E4455D764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 09:53: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 09:53:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modpam' ========================2025-04-30 09:53:40======================== SELECT idx FROM macs WHERE mac_addr = '001745E4455D764182DD' AND app_code = '047' ========================2025-04-30 09:53:40======================== °ªÀÌ ¾øÀ» °æ¿ì ========================2025-04-30 09:55:46======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 001745E4455D764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 09:55: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 09:55:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modpam' ========================2025-04-30 09:55:46======================== SELECT idx FROM macs WHERE mac_addr = '001745E4455D764182DD' AND app_code = '047' ========================2025-04-30 09:55:47======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 001745E4455D764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 09:55: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 09:55:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modpam' ========================2025-04-30 09:55:47======================== SELECT idx FROM macs WHERE mac_addr = '001745E4455D764182DD' AND app_code = '047' ========================2025-04-30 09:55:49======================== °ªÀÌ ¾øÀ» °æ¿ì ========================2025-04-30 09:55:49======================== °ªÀÌ ¾øÀ» °æ¿ì ========================2025-04-30 09:55:56======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 001745E4455D764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 09:55: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 09:55:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modpam' ========================2025-04-30 09:55:56======================== SELECT idx FROM macs WHERE mac_addr = '001745E4455D764182DD' AND app_code = '047' ========================2025-04-30 09:55:56======================== °ªÀÌ ¾øÀ» °æ¿ì ========================2025-04-30 09:56:38======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 001745E4455D764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 09:56: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 09:56:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modpam' ========================2025-04-30 09:56:38======================== SELECT idx FROM macs WHERE mac_addr = '001745E4455D764182DD' AND app_code = '047' ========================2025-04-30 09:56:38======================== °ªÀÌ ¾øÀ» °æ¿ì ========================2025-04-30 09:57:35======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 001745E4455D764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 09:57: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 09:57:35======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 001745E4455D764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 09:57: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 09:57:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modpam' ========================2025-04-30 09:57:35======================== SELECT idx FROM macs WHERE mac_addr = '001745E4455D764182DD' AND app_code = '047' ========================2025-04-30 09:57:35======================== °ªÀÌ ¾øÀ» °æ¿ì ========================2025-04-30 09:57:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modpam' ========================2025-04-30 09:57:35======================== SELECT idx FROM macs WHERE mac_addr = '001745E4455D764182DD' AND app_code = '047' ========================2025-04-30 09:57:35======================== °ªÀÌ ¾øÀ» °æ¿ì ========================2025-04-30 10:07:56======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 001745E4455D764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 10:07: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 10:07:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modpam' ========================2025-04-30 10:07:56======================== SELECT idx FROM macs WHERE mac_addr = '001745E4455D764182DD' AND app_code = '047' ========================2025-04-30 10:07:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '420707' ========================2025-04-30 10:07:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '420707' ========================2025-04-30 10:07: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 ( '420707', '001745E4455D764182DD', '047', 'DESKTOP-0DUDFAS', '�쐢�룄�슦 10', '0', '0', 'modpam', '(ÁÖ)´õÆíÇѼ¼»ó[ÀÌ·¡¿Ï]', '905487135700' ) ========================2025-04-30 11:01:02======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-3EQ7HEU parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA146C363F98B60A56 sCDKey = 967550604120 sName = DESKTOP-3EQ7HEU ========================2025-04-30 11:01: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 = '967550604120' AND r.app_code = '039' AND r.app_block = 0 ========================2025-04-30 11:01:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kisa2133' ========================2025-04-30 11:01:02======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA146C363F98B60A56' AND app_code = '039' ========================2025-04-30 11:01:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '420548' ========================2025-04-30 11:01:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '420548' ========================2025-04-30 11:01:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '420548', 'FCAA146C363F98B60A56', '039', 'DESKTOP-3EQ7HEU', '110', '1920', '1080', 'kisa2133', 'ÀÌ·¹Å×Å©[ÀÌÁ¤µÎ]', '967550604120' ) ========================2025-04-30 17:11:26======================== noteurl_start parm_app_code = 046 parm_pc_name = KIMNOTEBOOK parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 3C7C3F5B85B6284F0DEA sCDKey = 475467945095 sName = KIMNOTEBOOK ========================2025-04-30 17:11: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 = '475467945095' AND r.app_code = '046' AND r.app_block = 0 ========================2025-04-30 17:11:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bookpang' ========================2025-04-30 17:11:26======================== SELECT idx FROM macs WHERE mac_addr = '3C7C3F5B85B6284F0DEA' AND app_code = '046' ========================2025-04-30 17:11:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '368798' ========================2025-04-30 17:11:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '368798' ========================2025-04-30 17:11:26======================== UPDATE mac_detail SET pc_name = 'KIMNOTEBOOK', os_type = '110', user_id = 'bookpang', user_name = 'ºÏÆÎ[±èºÎÇö]', screen_w = '1536', screen_h = '864', cdkey = '475467945095' WHERE mac_idx = '368798' ========================2025-04-30 17:11:32======================== noteurl_start parm_app_code = 046 parm_pc_name = KIMNOTEBOOK parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 3C7C3F5B85B6284F0DEA sCDKey = 475467945095 sName = KIMNOTEBOOK ========================2025-04-30 17:11: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 = '475467945095' AND r.app_code = '046' AND r.app_block = 0 ========================2025-04-30 17:11:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bookpang' ========================2025-04-30 17:11:32======================== SELECT idx FROM macs WHERE mac_addr = '3C7C3F5B85B6284F0DEA' AND app_code = '046' ========================2025-04-30 17:11:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '368798' ========================2025-04-30 17:11:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '368798' ========================2025-04-30 17:11:32======================== UPDATE mac_detail SET pc_name = 'KIMNOTEBOOK', os_type = '110', user_id = 'bookpang', user_name = 'ºÏÆÎ[±èºÎÇö]', screen_w = '1536', screen_h = '864', cdkey = '475467945095' WHERE mac_idx = '368798' ========================2025-04-30 23:30:48======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C23113E0764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 23:30: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 23:30:53======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C23113E0764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 23:30: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 23:31:04======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C23113E0764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 23:31: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 23:31:12======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C23113E0764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 23:31: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 23:31:18======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C23113E0764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 23:31: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 23:31:20======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C23113E0764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 23:31: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 23:31:23======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C23113E0764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 23:31: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 23:31:32======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C23113E0764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 23:31: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 23:31:39======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C23113E0764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 23:31: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 23:34:09======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C23113E0764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 23:34: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 23:34:11======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C23113E0764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 23:34: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2025-04-30 23:36:43======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0DUDFAS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C23113E0764182DD sCDKey = 905487135700 sName = DESKTOP-0DUDFAS ========================2025-04-30 23:36:43======================== 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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0