========================2018-11-18 18:59:41======================== noteurl_start parm_app_code = 046 parm_pc_name = LAPTOP-GCDN2R3I parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 2C6E852DD566D608D384 sCDKey = 984684865924 sName = LAPTOP-GCDN2R3I ========================2018-11-18 18:59: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 = '984684865924' AND r.app_code = '046' AND r.app_block = 0