ORA-00936: missing expression

Когда я select делаю в Server я ловлю ошибку в catch ORA-00936: missing expression:

string query = "select tu.ID, ds.id, ds.name_ru, tu.NAME, tu.CREATE_DATE, tu.PHONE, tu.IS_BLACK, tu.SEARCH_LIMIT_PER_DAY, tu.LANG" +
                "(select count(sl.drug_id) from item_search_logs sl where sl.search_date > sysdate-30 and sl.USER_TYPE = 't' and sl.user_id = tu.id) as TotalTelegramSearched, " +
                "(select count(sl.drug_id) from item_search_logs sl where sl.search_date > sysdate-30 and sl.USER_TYPE = 't' and sl.user_id = tu.id and exists (select 1 from item_search_logs_dt where sl.id = log_id)) as SuccessTelegramSearchs from TELEGRAM_USERS tu left join drug_stores ds on ds.telegram_id = tu.id and ds.telegram_id is not null";