1

Please login or register to vote for this query.

(click on this box to dismiss)

Why not return the favour to the OP and upvote the question, since they accepted your answer?

Q&A for active researchers, academics and students of physics

select
  q.id as [Post Link], 
  format(a.creationdate,'MMM d yyyy') as [Date],
  q.score as [Question score],
  a.score as [Answer score],
  q.viewcount as Views
from posts q left join posts a on q.id=a.parentid
where 
  a.posttypeid=2 --answers 
  and a.owneruserid=##UserID## --by specified user
  and a.owneruserid <> q.owneruserid --not answered by me
  and q.AcceptedAnswerId = a.id  --mine is accepted
  and q.score <=0 --question score less than 1
order by q.viewcount desc

fork query

edited aug 12 18

created aug 12 18 ashleedawg