Select (im_screen_name) as user_screen from jb_screens where user_id = :user_id and service = 'jabber' Select im_screen_name , screen_id from jb_screens where user_id = :add_user_id and service = 'jabber' Select * from jb_friends where user_id = :user_id and friend_screen_id = :screen_id insert into jb_friends (user_id , friend_screen_id) values (:user_id , :screen_id) update jb_screens SET refcount = refcount + 1 where user_id = :add_user_id and service = 'jabber'