========================2021-05-13 08:38:33======================== noteurl_start parm_app_code = 048 parm_pc_name = 4¹øPC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 988389DD940A00B06E21 sCDKey = 425257462075 sName = 4¹øPC ========================2021-05-13 08:38: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 = '425257462075' AND r.app_code = '048' AND r.app_block = 0 ========================2021-05-13 08:38:44======================== noteurl_start parm_app_code = 048 parm_pc_name = 4¹øPC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 988389DD940A00B06E21 sCDKey = 434133617414 sName = 4¹øPC ========================2021-05-13 08:38: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 = '434133617414' AND r.app_code = '048' AND r.app_block = 0 ========================2021-05-13 08:42:29======================== noteurl_start parm_app_code = 048 parm_pc_name = 4¹øPC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 988389DD940A00B06E21 sCDKey = 454133617514 sName = 4¹øPC ========================2021-05-13 08:42: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 = '454133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2021-05-13 08:42:42======================== noteurl_start parm_app_code = 048 parm_pc_name = 4¹øPC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 988389DD940A00B06E21 sCDKey = 434133617514 sName = 4¹øPC ========================2021-05-13 08:42: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2021-05-13 08:42:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2021-05-13 08:42:42======================== SELECT idx FROM macs WHERE mac_addr = '988389DD940A00B06E21' AND app_code = '048' ========================2021-05-13 08:42:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '285233' ========================2021-05-13 08:42:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '285233' ========================2021-05-13 08:42:42======================== UPDATE mac_detail SET pc_name = '4¹øPC', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '´ë¼ºÈ°¾î[°­Á¤¹Ì]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '285233' ========================2021-05-13 10:25:55======================== noteurl_start parm_app_code = 048 parm_pc_name = ½ÃÀåÄÄ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 8CB0E914BA0E02F63433 sCDKey = 4341-3361-75 sName = ½ÃÀåÄÄ ========================2021-05-13 10:25: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 = '4341336175' AND r.app_code = '048' AND r.app_block = 0 ========================2021-05-13 10:26:29======================== noteurl_start parm_app_code = 048 parm_pc_name = ½ÃÀåÄÄ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 8CB0E914BA0E02F63433 sCDKey = 434133617514 sName = ½ÃÀåÄÄ ========================2021-05-13 10:26: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2021-05-13 10:26:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2021-05-13 10:26:29======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E914BA0E02F63433' AND app_code = '048' ========================2021-05-13 10:26:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322140' ========================2021-05-13 10:26:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322140' ========================2021-05-13 10:26:29======================== UPDATE mac_detail SET pc_name = '½ÃÀåÄÄ', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '´ë¼ºÈ°¾î[°­Á¤¹Ì]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '322140' ========================2021-05-13 10:35:46======================== noteurl_start parm_app_code = 047 parm_pc_name = JJY parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C24F9015E005C8CF sCDKey = 773774126760 sName = JJY ========================2021-05-13 10:35: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 = '773774126760' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 10:35:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kumho0371' ========================2021-05-13 10:35:46======================== SELECT idx FROM macs WHERE mac_addr = '7085C24F9015E005C8CF' AND app_code = '047' ========================2021-05-13 10:35:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '343246' ========================2021-05-13 10:35:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '343246' ========================2021-05-13 10:35:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '343246', '7085C24F9015E005C8CF', '047', 'JJY', '�쐢�룄�슦 10', '0', '0', 'kumho0371', '±ÝÈ£±â¾÷»ç[¹ÚÀ̶û]', '773774126760' ) ========================2021-05-13 15:20:26======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-HR6KUMA parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E99416E38828DEC9B sCDKey = 678114550550 sName = DESKTOP-HR6KUMA ========================2021-05-13 15:20: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 = '678114550550' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 15:20:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ksb7925' ========================2021-05-13 15:20:26======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99416E38828DEC9B' AND app_code = '047' ========================2021-05-13 15:20:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '342110' ========================2021-05-13 15:20:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '342110' ========================2021-05-13 15:20:26======================== UPDATE mac_detail SET pc_name = 'DESKTOP-HR6KUMA', os_type = '�쐢�룄�슦 10', user_id = 'ksb7925', user_name = '(ÁÖ)µð¾ØÀ¯[°í¼º¹è]', screen_w = '0', screen_h = '0', cdkey = '678114550550' WHERE mac_idx = '342110' ========================2021-05-13 16:07:52======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-KKKI51P parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CD05AAF924D36F978B4 sCDKey = 720431735714 sName = DESKTOP-KKKI51P ========================2021-05-13 16:07:52======================== 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 = '720431735714' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 16:07:59======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-KKKI51P parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CD05AAF924D36F978B4 sCDKey = 720431735714 sName = DESKTOP-KKKI51P ========================2021-05-13 16:07: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 = '720431735714' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 16:08:02======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-KKKI51P parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CD05AAF924D36F978B4 sCDKey = 720431735714 sName = DESKTOP-KKKI51P ========================2021-05-13 16:08: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 = '720431735714' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 16:08:30======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-KKKI51P parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CD05AAF924D36F978B4 sCDKey = 720431735714 sName = DESKTOP-KKKI51P ========================2021-05-13 16:08:30======================== 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 = '720431735714' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 16:12:26======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-KKKI51P parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CD05AAF924D36F978B4 sCDKey = 720431735714 sName = DESKTOP-KKKI51P ========================2021-05-13 16:12: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 = '720431735714' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 16:12:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tyw2323' ========================2021-05-13 16:12:26======================== SELECT idx FROM macs WHERE mac_addr = '2CD05AAF924D36F978B4' AND app_code = '047' ========================2021-05-13 16:12:26======================== °ªÀÌ ¾øÀ» °æ¿ì ========================2021-05-13 16:12:31======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-KKKI51P parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CD05AAF924D36F978B4 sCDKey = 720431735714 sName = DESKTOP-KKKI51P ========================2021-05-13 16:12: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 = '720431735714' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 16:12:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tyw2323' ========================2021-05-13 16:12:31======================== SELECT idx FROM macs WHERE mac_addr = '2CD05AAF924D36F978B4' AND app_code = '047' ========================2021-05-13 16:12:31======================== °ªÀÌ ¾øÀ» °æ¿ì ========================2021-05-13 16:13:37======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-KKKI51P parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CD05AAF924D36F978B4 sCDKey = 720431735714 sName = DESKTOP-KKKI51P ========================2021-05-13 16:13: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 = '720431735714' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 16:13:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tyw2323' ========================2021-05-13 16:13:37======================== SELECT idx FROM macs WHERE mac_addr = '2CD05AAF924D36F978B4' AND app_code = '047' ========================2021-05-13 16:13:38======================== °ªÀÌ ¾øÀ» °æ¿ì ========================2021-05-13 16:15:08======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-KKKI51P parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CD05AAF924D36F978B4 sCDKey = 720431735714 sName = DESKTOP-KKKI51P ========================2021-05-13 16:15: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 = '720431735714' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 16:15:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tyw2323' ========================2021-05-13 16:15:08======================== SELECT idx FROM macs WHERE mac_addr = '2CD05AAF924D36F978B4' AND app_code = '047' ========================2021-05-13 16:15:08======================== °ªÀÌ ¾øÀ» °æ¿ì ========================2021-05-13 16:20:11======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-KKKI51P parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CD05AAF924D36F978B4 sCDKey = 720431735714 sName = DESKTOP-KKKI51P ========================2021-05-13 16:20: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 = '720431735714' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 16:20:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tyw2323' ========================2021-05-13 16:20:12======================== SELECT idx FROM macs WHERE mac_addr = '2CD05AAF924D36F978B4' AND app_code = '047' ========================2021-05-13 16:20:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '343302' ========================2021-05-13 16:20:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '343302' ========================2021-05-13 16:20:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '343302', '2CD05AAF924D36F978B4', '047', 'DESKTOP-KKKI51P', '�쐢�룄�슦 10', '0', '0', 'tyw2323', 'Åõ¿À[¿À¹æ¿ë]', '720431735714' ) ========================2021-05-13 20:16:21======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CVF9BS8 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7431EFDAC23D10FD sCDKey = 978890224543 sName = ±èÇöö ========================2021-05-13 20:16: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 = '978890224543' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 20:16:25======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CVF9BS8 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7431EFDAC23D10FD sCDKey = 978890224543 sName = ±èÇöö ========================2021-05-13 20:16: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 = '978890224543' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 20:16:40======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CVF9BS8 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7431EFDAC23D10FD sCDKey = 532043188650 sName = ±èÇöö ========================2021-05-13 20:16: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 = '532043188650' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 20:23:14======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CVF9BS8 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7431EFDAC23D10FD sCDKey = 978890224543 sName = DESKTOP-CVF9BS8 ========================2021-05-13 20:23: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 = '978890224543' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 20:23:35======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CVF9BS8 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7431EFDAC23D10FD sCDKey = 978890224543 sName = ±èÇöö ========================2021-05-13 20:23: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 = '978890224543' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 20:23:41======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CVF9BS8 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7431EFDAC23D10FD sCDKey = 978890224543 sName = ========================2021-05-13 20:23: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 = '978890224543' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 20:23:50======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CVF9BS8 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7431EFDAC23D10FD sCDKey = 978890224543 sName = Èú¸µ°¡µçÈÞ ========================2021-05-13 20:23: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 = '978890224543' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 20:24:09======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CVF9BS8 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7431EFDAC23D10FD sCDKey = 532043188650 sName = Èú¸µ°¡µçÈÞ ========================2021-05-13 20:24: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 = '532043188650' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 20:25:06======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CVF9BS8 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7431EFDAC23D10FD sCDKey = 978890224543 sName = DESKTOP-CVF9BS8 ========================2021-05-13 20:25:06======================== 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 = '978890224543' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 20:26:36======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CVF9BS8 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7431EFDAC23D10FD sCDKey = 978890224543 sName = DESKTOP-CVF9BS8 ========================2021-05-13 20:26:36======================== 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 = '978890224543' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-13 20:27:30======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CVF9BS8 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7431EFDAC23D10FD sCDKey = 978890224543 sName = DESKTOP-CVF9BS8 ========================2021-05-13 20:27:30======================== 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 = '978890224543' AND r.app_code = '047' AND r.app_block = 0