{"data":"","draw":null,"recordsTotal":"0","recordsFiltered":"0","query":"SELECT\r\n\t\t\t\tT0.ID,\r\n\t\t\t\tT0.NIC,\r\n\t\t\t\tT0.MEMBER_NO,\r\n\t\t\t\tT0.FULL_NAME,\r\n\t\t\t\tCONCAT_WS('-',T1.BRANCH_CODE,T1.BRANCH_NAME) AS BRANCH,\r\n\t\t\t\tT0.BLACKLIST_REASON,\r\n\t\t\t\tDATE(T0.BLACKLIST_DATE) AS DATEONLY\r\n\t\t\tFROM\r\n\t\t\t\tmas_customer AS T0\r\n\t\t\tINNER JOIN mas_branch AS T1 ON T0.BRANCH_ID = T1.ID\r\n\t\t\tWHERE\r\n\t\t\t\tT0.IS_BLACKLIST = '1'   ORDER BY T0.ID DESC \r\n\t    \tLIMIT , "}