sql union NOT EXISTS not in

#SELECT a.userid FROM es_adminuser a left join es_user_role s on  s.roleid not in(2,3)
#SELECT userid FROM  es_user_role  where roleid not in(2,3)
#SELECT * FROM es_adminuser where  roleid not in(SELECT userid FROM  es_user_role  where roleid  in(2,3))
#SELECT a.userid FROM es_adminuser a left join es_user_role s on  s.userid = a.userid where s.roleid not in(2,3)
#SELECT s.userid FROM es_adminuser a , es_user_role s where s.roleid not in(2,3)
#SELECT a.userid FROM es_adminuser a , es_user_role s where s.roleid<>2 and s.roleid<>3
#SELECT userid FROM  es_user_role  where roleid not in(2,3) union 
#SELECT title FROM titles WHERE NOT EXISTS (SELECT title_id FROM sales WHERE title_id = titles.title_id)
#SELECT userid FROM es_adminuser WHERE NOT EXISTS (SELECT userid FROM es_user_role WHERE userid = es_adminuser.userid)
SELECT userid FROM  es_user_role  where roleid not in(2,3) union SELECT userid FROM es_adminuser WHERE NOT EXISTS (SELECT userid FROM es_user_role WHERE userid = es_adminuser.userid)  order by userid

select * from es_adminuser WHERE userid in(SELECT userid FROM  es_user_role  where roleid not in(2,3) union SELECT userid FROM es_adminuser WHERE NOT EXISTS (SELECT userid FROM es_user_role WHERE userid = es_adminuser.userid) order by userid)