Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. 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
  2.  
  3. to
  4.  
  5. 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
  6. ORDER BY forum_post.id ASC
  7. LIMIT 20 OFFSET 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement