Есть это:

SELECT wallMessage.message, wallMessage.author, COUNT(DISTINCT wallComments.id) as sumComments, wallMessage.id, user.name, SUM(DISTINCT `likeWall`.`likeStats`) as likes, user.surname, wallMessage.author, wallMessage.`date`, wallMessage.pulse FROM wallMessage JOIN myFriends ON wallMessage.author = (IF(myFriends.idInput <> 1, myFriends.idOutgoing, myFriends.idInput and myFriends.status = 1))
left JOIN user on user.id = wallMessage.author
left JOIN likeWall on likeWall.postID = wallMessage.id
left JOIN wallComments on wallComments.postID = wallMessage.id
WHERE wallMessage.author <> 1 group by `message` Order by `wallMessage`.`date` DESC

Нужно заменить это:

IF(myFriends.idInput <> 1, myFriends.idOutgoing, myFriends.idInput and myFriends.status = 1)

На это:

SELECT idOutgoing AS idFriendFROM `myFriends` WHERE idInput=1 AND STATUS = 1 UNION SELECT idInput AS idFriend FROM `myFriends` WHERE idOutgoing=1 AND STATUS = 1


Как правильно "склеить"?