Duplicate Prevent Spamming in the Profile Posts Widget?

[Jaxel]

With the default XenForo profile posts widget, if someone posts 5 status updates a row, they will spam the entire widget. This widget should be restricted to only one profile post per user at a time. Currently the query is as follows:

return $this->fetchAllKeyed($this->limitQueryResults(
    '
        SELECT profile_post.*
            ' . $sqlClauses['selectFields'] . '
        FROM xf_profile_post AS profile_post
        ' . $sqlClauses['joinTables'] . '
        WHERE ' . $whereClause . '
        ORDER BY profile_post.post_date DESC
    ', $limitOptions['limit'], $limitOptions['offset']
), 'profile_post_id');

This issue could be easily fixed by simply adding to the query:

GROUP BY profile_post.profile_user_id

 

[Paul B]

Dupe: https://xenforo.com/community/threads/only-one-post-per-user-in-the-new-profile-posts-sidebar.80137/

 

[clove28]

With the default XenForo profile posts widget, if someone posts 5 status updates a row, they will spam the entire widget. This widget should be restricted to only one profile post per user at a time. Currently the query is as follows:

return $this->fetchAllKeyed($this->limitQueryResults(
    '
        SELECT profile_post.*
            ' . $sqlClauses['selectFields'] . '
        FROM xf_profile_post AS profile_post
        ' . $sqlClauses['joinTables'] . '
        WHERE ' . $whereClause . '
        ORDER BY profile_post.post_date DESC
    ', $limitOptions['limit'], $limitOptions['offset']
), 'profile_post_id');

This issue could be easily fixed by simply adding to the query:

GROUP BY profile_post.profile_user_id

Do I just need to add the second code to the end of the first code?