0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

select 
creationdate as CDate,
posthistorytypeid as Type,
id as Id,
postid as Connect,
userid as Actor,
text as Content,
comment
from posthistory
where postid in (select id from posts 
                  where id 
in
(
4661818,
4670369,
4670873,
4769432,
5033906,
5207430,
5263363,
5308597,
5423094,
5460418,
5627234,
5658529,
5928061,
6045728,
6134755,
6212326,
7051577,
7410037,
8023094,
8360710,
8478943,
9399597
)

                  or parentid 
in
(
4661818,
4670369,
4670873,
4769432,
5033906,
5207430,
5263363,
5308597,
5423094,
5460418,
5627234,
5658529,
5928061,
6045728,
6134755,
6212326,
7051577,
7410037,
8023094,
8360710,
8478943,
9399597
)
 )
order by id, creationdate

fork query

created may 7 12 hyaku