0

Please login or register to vote for this query.

(click on this box to dismiss)

Looks for posts with more than half the amount of downvotes as they have upvotes Ordered by upvotes

Q&A for anime and manga fans

select top 200 p.body,p.title,p.tags from posts AS p
inner join posttags  AS PT
on pt.postid = P.id
where title != ''
AND pt.tagid < 30
GROUP BY P.title,P.body,P.tags

fork query

edited jan 26 12 anonymous

created may 20 10 sam.saffron