More than one answer by the same user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Monero Meta

Q&A about the site for developers and users of the secure, private and untraceable cryptocurrency Monero

select question.Id as [Post Link], 
   answer.owneruserid as [User Link], 
   count(answer.id) as answers
from Posts question
join Posts answer on (answer.parentid = question.id)
where answer.OwnerUserId != 0
group by question.id, answer.owneruserid
having count(answer.id) >= 2
order by answers desc

Enter Parameters

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