SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username
FROM houston_expat_forum_topics t, alloexpa_alloexpat.asia_users u, houston_expat_forum_posts p, alloexpa_alloexpat.asia_users u2
WHERE t.forum_id = 21
AND t.topic_poster = u.user_id
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u2.user_id
AND t.topic_type = 2
ORDER BY t.topic_last_post_id DESC Line : 321 File : viewforum.php
Register
Log in
FAQ
Search
Memberlist