select p.UserId as user_id, count(p.id) comment_count, 7 ...

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 p.UserId as user_id, count(p.id) comment_count, 7 as election_id
from comments p
where p.creationdate<='9-Nov-2015'
and p.UserId in (1026459,
109702,
1380752,
1849664,
189134,
1952862,
2057919,
2174085,
2193767,
2301450,
2371861,
2422776,
3093387,
476,
572,
774078,
871050,
995926)
group by p.UserId;

Enter Parameters

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