sql query

    public function getAllChirpsByFollowedUsers($currentUserId)
    {
        $query = $this
            ->getEntityManager()
            ->createQuery(
                'SELECT c.* FROM ChirperBundle:User u
                INNER JOIN followers f ON f.follower_id = u.id
                INNER JOIN ChirperBundle:User u2 ON u2.id = f.followed_id
                INNER JOIN ChirperBundle:Chirp c ON c.authorId = u2.id
                    WHERE u.id = ?1
                ORDER BY c.dateAdded DESC'
            );

        $query->setParameter(1, $currentUserId);
        return $query->getResult();
    }



SELECT c.*
FROM
 users AS u
 INNER JOIN followers AS f ON f.follower_id = u.id
 INNER JOIN users as u2 ON u2.id = f.followed_id
 INNER JOIN chirps AS c ON c.authorId = u2.id
WHERE
 u.id = 1
ORDER BY c.dateAdded DESC