/* Aantal mentions dat een persoon doet */

SELECT
    backend_tweet.twitter_id,
    backend_feed.id,
    backend_feed.actor_id,
    backend_person.actor_ptr_id,
    backend_person.firstname,
    COUNT(backend_person.firstname) AS aantal_gemaakte_mentions
FROM
    backend_tweet,
    backend_feed,
    backend_person
WHERE
    text LIKE '% @% %'
    AND
    backend_tweet.in_reply_to_user_id IS NULL
    AND
    backend_tweet.retweeted_user_id IS NULL
    AND
    backend_tweet.twitter_id = backend_feed.id
    AND
    backend_feed.actor_id = backend_person.actor_ptr_id
GROUP BY
    backend_person.firstname
ORDER BY
    aantal_gemaakte_mentions
    DESC