SELECT
    count(*) as hoeveelheid_berichten,
    firstname,
    name
FROM
    backend_organization O,
    backend_person P,
    backend_person_organizations PO,
    backend_tweet T,
    backend_feed F
WHERE
    T.twitter_id = F.id
    AND
    F.actor_id = P.actor_ptr_id
    aND
    P.actor_ptr_id = PO.person_id
    AND
    O.actor_ptr_id = PO.organization_id
    AND
    (name LIKE 'Jonge Socialisten'
     OR name LIKE 'jongerenpartij'
     OR name LIKE 'JOVD'
     OR name LIKE 'CDJA')
     AND
    in_reply_to_user_id IS NULL
    AND
    retweeted_user_id IS NULL
GROUP BY
     firstname
ORDER BY
     hoeveelheid_berichten
     DESC