0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

select p.UserId as user_id, count(p.id) comment_count, 5 as election_id
from comments p
where p.creationdate<='10-Feb-2014'
and p.UserId in (1065190,
1069068,
109702,
1104384,
1140579,
1223693,
1252759,
1271826,
1395941,
1711796,
1849664,
1864167,
206403,
2074608,
229044,
256196,
2581872,
2876565,
379693,
426671,
444991,
492405,
544198,
679449,
716216,
821057,
871050,
900873)
group by p.UserId;

fork query

edited dec 6 23

created dec 6 23 anonymous