Untitled

Select from the same table for two different values (mysql)
SELECT
    forum_topics.primkey,
    forum_topics.title,
    forum_topics.creatorid,
    forum_topics.last_reply_poster,
    users.username,
    users.avatar,
    forum_tracks.lastmark
FROM
    users,
    forum_topics
    LEFT JOIN forum_tracks
        ON forum_tracks.userid='".$_SESSION['loggeduserkey']."'
        AND forum_tracks.topic_id=forum_topics.primkey
WHERE
    forum_topics.cat_id='".$forum_id."'
    AND users.userkey=forum_topics.creatorid
ORDER BY ...;

SELECT
    forum_topics.primkey,
    forum_topics.title,
    forum_topics.creatorid,
    forum_topics.last_reply_poster,
    users.username,
    users.avatar,
    u2.username,
    u2.avatar,
    forum_tracks.lastmark
FROM
    users,
    users as u2,
    forum_topics
    LEFT JOIN forum_tracks
        ON forum_tracks.userid='".$_SESSION['loggeduserkey']."'
        AND forum_tracks.topic_id=forum_topics.primkey
WHERE
    forum_topics.cat_id='".$forum_id."'
    AND users.userkey=forum_topics.creatorid
    AND u2.userkey=forum_topics.last_reply_poster
ORDER BY ...;