At

0

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

/*select top 20
Id from Posts
where PostTypeId=1
and AcceptedAnswerId is not null
and Score > 0
and Tags like '%<##Tag##%>'
order by Id asc*/



select top ##Top##
ParentId, Id, Score,CommentCount
from Posts
where PostTypeId=2
and ParentId in (select top ##TopFragen##
Id from Posts
where PostTypeId=1
and AcceptedAnswerId is not null
and Score > 0
and Tags like '%<##Tag##>%'
and Id >= ##LastFrageId##
order by Id asc)
order by ParentId,Id

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results