select count0 from select hdddrug_code as dataValue hdddrug_id as id hdddrug_name as dataText hdddrug_name_all as showText hddpy_code hddwb_code as ctlCode 0 as score 0 as serial hddfont_color as f

SELECT COUNT(0) FROM ( SELECT hdd.drug_code AS "dataValue", hdd.drug_id AS "id", hdd.drug_name AS "dataText", hdd.drug_name_all AS "showText", hdd.py_code || ',' || hdd.wb_code AS "ctlCode", '0' AS "score", '0' AS "serial", hdd.font_color AS "fontColor", dd.SECRET_CODE AS "secretCode", dd.secret_name AS "secretName", (CASE WHEN (dd.SECRET_NAME LIKE '%中选%' AND dd.SECRET_NAME NOT LIKE '%非中选%') AND dd.secret_code LIKE '%23%' AND (dd.secret_code LIKE '%,9%' OR dd.secret_code LIKE '9%' OR dd.secret_code LIKE '%20%' OR dd.secret_code LIKE '%21%' OR dd.secret_code LIKE '%22%') THEN '1' WHEN (dd.SECRET_NAME LIKE '%中选%' AND dd.SECRET_NAME NOT LIKE '%非中选%') AND dd.secret_code LIKE '%23%' THEN '2' WHEN (dd.SECRET_NAME LIKE '%中选%' AND dd.SECRET_NAME NOT LIKE '%非中选%') AND (dd.secret_code LIKE '%,9%' OR dd.secret_code LIKE '9%' OR dd.secret_code LIKE '%20%' OR dd.secret_code LIKE '%21%' OR dd.secret_code LIKE '%22%') THEN '3' WHEN dd.SECRET_NAME LIKE '%中选%' AND dd.SECRET_NAME NOT LIKE '%非中选%' THEN '4' WHEN dd.secret_code LIKE '%23%' AND (dd.secret_code LIKE '%,9%' OR dd.secret_code LIKE '9%' OR dd.secret_code LIKE '%20%' OR dd.secret_code LIKE '%21%' OR dd.secret_code LIKE '%22%') THEN '5' WHEN dd.secret_code LIKE '%23%' THEN '6' WHEN dd.secret_code LIKE '%,9%' OR dd.secret_code LIKE '9%' OR dd.secret_code LIKE '%20%' OR dd.secret_code LIKE '%21%' OR dd.secret_code LIKE '%22%' THEN '7' ELSE '99' END) AS "sort", rownum AS rn FROM SYSMN.SYS_DATA_ELEMENT a, sysmn.sys_his_drug_dict hdd LEFT JOIN sysmn.sys_drug_dict dd ON hdd.drug_code = dd.drug_code WHERE (('A3EEC8AADC1847A1E053ED5B14AC3934', hdd.drug_id) IN ( SELECT f.LEFT_DICT_ID, f.LEFT_VALUE_ID FROM SYSMN.SYS_DICT_FILTER f WHERE (f.RIGHT_DICT_ID, f.RIGHT_VALUE_ID) IN ( ((SELECT ELEMENT_PD_ID FROM SYSMN.SYS_DATA_ELEMENT WHERE ELEMENT_ID = ?), ?) ) INTERSECT SELECT f.LEFT_DICT_ID, f.LEFT_VALUE_ID FROM SYSMN.SYS_DICT_FILTER f WHERE (f.RIGHT_DICT_ID, f.RIGHT_VALUE_ID) IN ( ((SELECT ELEMENT_PD_ID FROM SYSMN.SYS_DATA_ELEMENT WHERE ELEMENT_ID = ?), ?) ) ) OR ('A3EEC8AADC1847A1E053ED5B14AC3934', hdd.drug_id) IN ( SELECT f.RIGHT_DICT_ID, f.RIGHT_VALUE_ID FROM SYSMN.SYS_DICT_FILTER f WHERE (f.LEFT_DICT_ID, f.LEFT_VALUE_ID) IN ( ((SELECT ELEMENT_PD_ID FROM SYSMN.SYS_DATA_ELEMENT WHERE ELEMENT_ID = ?), ?) ) INTERSECT SELECT f.RIGHT_DICT_ID, f.RIGHT_VALUE_ID FROM SYSMN.SYS_DICT_FILTER f WHERE (f.LEFT_DICT_ID, f.LEFT_VALUE_ID) IN ( ((SELECT ELEMENT_PD_ID FROM SYSMN.SYS_DATA_ELEMENT WHERE ELEMENT_ID = ?), ?) ) ) ) AND hdd.stop_flag = '0' AND dd.stop_flag = '0' AND a.ELEMENT_ID = ? AND a.DEL_FLAG = '0' AND a.ELEMENT_PD_ID = 'A3EEC8AADC1847A1E053ED5B14AC3934' AND (hdd.drug_name_all LIKE '%' || ? || '%' ESCAPE '/') ORDER BY "sort" ) tmp_coun