select soa.id,
       account,
       soa.password,
       soa.email_recovery,
       soa.phone,
       soa.security_question,
       sAp.ip,
       sAp.port
from socialsAccounts_account soa
         inner join socialsAccounts_proxy sAp on soa.proxy_id = sAp.id
where soa.id IN (:accountIds);