select p.id, p.creationdate, p.score, p.viewcount, p.title,

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

select 
  p.id,
  p.creationdate,
  p.score,
  p.viewcount,
  p.title,
  p.answercount,
  p.commentcount,
  p.favoritecount,
  u.displayname as quest_name, 
  u.reputation as quest_rep, 
  u2.displayname as ans_name,
  u2.reputation as ans_rep
from 
  posts as p join posttags as pt 
  on 
    p.id = pt.postid
  join tags as t 
  on 
    pt.tagid = t.id
  left join posts as ans
  on 
    p.acceptedanswerid = ans.id
  left join users as u
  on 
    p.owneruserid = u.id
  left join users as u2
  on
    ans.owneruserid = u2.id
where 
  t.tagname = 'pandas' and 
  p.creationdate <'2015'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results