- SELECT bf2142.forum_topics.forum_id, bf2142.forum_topics.topic_id,
- bf2142.forum_topics.topic_title, bf2142.forum_topics.topic_poster,
- bf2142.forum_topics.topic_views, bf2142.forum_topics.topic_replies,
- bf2142.forum_topics.topic_last_post_id, bf2142.forum_topics.topic_time,
- users1.id as topic_author_id, users1.username as topic_author_username,
- users2.id as last_post_author_id, users2.username as last_post_author_username
- FROM bf2142.forum_topics, gc.users as users1, gc.users as users2
- WHERE EXISTS (
- SELECT bf2142.forum_posts.post_id
- FROM bf2142.forum_posts
- WHERE (
- bf2142.forum_posts.topic_id = bf2142.forum_topics.topic_id
- AND bf2142.forum_posts.post_time >= 1186228133
- )
- )
- AND users1.id = bf2142.forum_topics.topic_poster
- AND users2.id = (
- SELECT bf2142.forum_posts.poster_id
- FROM bf2142.forum_posts
- WHERE bf2142.forum_topics.topic_last_post_id = bf2142.forum_posts.post_id
- )
By: Arieh | Date: Aug 6 2007 16:36 | Format: None | Expires: never | Size: 1.25 KB | Hits: 1175
Latest pastes
15 hours ago
16 hours ago
1 days ago
2 days ago
4 days ago