Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT users.userid as user_id, users.username, forum_profile.title, forum_profile.posts, forum_profile.avatar, forum_profile.from, forum_post.id as forum_id, forum_post.id as post_id, forum_post.content, forum_post.user_id, forum_post.updated, forum_post.created FROM users, forum_profile, forum_post WHERE forum_profile.user_id=users.userid AND forum_post.user_id=forum_profile.user_id AND forum_post.topic_id=? ORDER BY forum_post.id ASC LIMIT 20 OFFSET 0
- to
- SELECT u.userid as user_id, u.username, fp.title, fp.posts, fp.avatar, fp.from, p.id as forum_id, p.id as post_id, p.content, p.user_id, p.updated, p.created FROM users u, forum_profile fp, forum_post p WHERE fp.user_id=u.userid AND p.user_id=fp.user_id AND p.topic_id=1
- ORDER BY forum_post.id ASC
- LIMIT 20 OFFSET 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement