help in writing sql select statement

[LKBrwn_DBA]

Maybe you have to re-think the statement because
(SELECT COUNT (user_name)
FROM saved_searches
WHERE sss.user_name = 'TESTADM' AND ROWNUM = 1)
will allways produce either 0 or 1!!!