Possible Prepositions Voters

0

Please login or register to vote for this query.

(click on this box to dismiss)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

select count(a.id) as TagCount, u.displayname, sum(score) as TagScore from posts a 
inner join 
(select p.id from posts p inner join 
(select postid from posttags where tagid = 287) as pt --Preposition tag
on p.id=pt.postid) as q
ON a.parentid=q.id
inner join users u on a.owneruserid=u.id
GROUP BY u.displayname
ORDER BY TagScore DESC

Enter Parameters

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