MySQL Pligg Check for Active Members

Select * FROM pligg_users
WHERE pligg_users.user_lastlogin NOT LIKE '0000-00-00 00:00:00' /* Make sure that the user has logged in once */
AND pligg_users.user_level != 'Spammer' /* Make sure that the user isn't a known spammer */
AND (
    /* Here we check if the user has submitted a story, comment, or vote */
    pligg_users.user_id
    IN (
        SELECT link_author
        FROM pligg_links
    )
    OR pligg_users.user_id
    IN (
        SELECT comment_user_id
        FROM pligg_comments
    )
    OR pligg_users.user_id
    IN (
        SELECT vote_user_id
        FROM pligg_votes
    )
)
ORDER BY pligg_users.user_id