SELECT `call_date` , `trunk_grp_in` , `trunk_grp_out`
FROM cdr join
WHERE `Acct-Session-Id` IN (
SELECT `Acct-Session-Id` AS aid
FROM cdr
WHERE `Called-Station-Id` = '5551234567'
)