0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

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 = 'iText' and 
  p.creationdate <'2013'

fork query

created sep 23 19 anonymous