Edited by which field in database ?

[roxxx]

'Edited by',
which field is in database with user name who post edited ?

[nico_swd]

It's in the table called "editlog", the username field.

[roxxx]

$getposts=$db->query_read("
SELECT
    post.*,
    editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline
    FROM
        ". TABLE_PREFIX ."thread AS thread,
            ". TABLE_PREFIX ."post AS post,
                ". TABLE_PREFIX ."editlog AS editlog
    JOIN editlog ON post.postid = editlog.userid
    WHERE thread.forumid = 5 AND
                    post.postid = thread.firstpostid AND
                        post.visible = 1
                        GROUP BY
                            post.postid DESC
                            LIMIT
                                10");

above query is correct,
but when I add to this JOIN isn't correct
I'd like display who edited post but is problem with query.