Select wall.`id` as `idPost`,wall.`author`, wall.`recipient`, wall.`id`, wall.`message`, wall.`attachment`, wall.`pulse`, wall.`date`, `user`.`name`, `user`.`surname`, SUM(likesData.likeStats) as likes FROM `wallMessage` as wall
            left join likeWall as likesData on  likesData.postID=wall.`id`
            Left join `user` on user.id = wall.`author`
            LEFT JOIN likeWall ON likeWall.postID=wall.`id` 
            Left join  `myFriends` on wall.`author`= (user.id = IF(idInput <> 1, idInput, idOutgoing)) and (status = 1) and (wall.author = user.id) and (wall.author <> 1)
            WHERE wall.`author` <> 1
            group by  `idPost` ORDER BY `date` DESC LIMIT 0, 50