0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

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.answercount = 1 and p.creationdate <= '2014'

fork query

edited sep 25

created may 8 anonymous