|
|
发表于 2010 年 11 月 22 日 11:46:58
|
显示全部楼层
select author, count(*) from pre_forum_post_2 as b where b.fid='105' and b.tid='863265' and first=0 and mod(( select count(*) as dd from pre_forum_post_2 as a where a.fid='105' and a.tid='863265' and a.pid<b.pid order by pid) ,25)=0 group by author
' a$ v5 t' m+ Y: Q9 X' C$ T
, P2 D, q6 |1 t' lselect ( select count(*) as dd from pre_forum_post_2 as a where a.fid='105' and a.tid='863265' and a.pid<b.pid order by pid) as xuhao, author from pre_forum_post_2 as b where b.fid='105' and b.tid='863265' and first=0 and mod(( select count(*) as dd from pre_forum_post_2 as a where a.fid='105' and a.tid='863265' and a.pid<b.pid order by pid) ,25)=0
& ]2 e4 h( |# R7 y2 _这个是显示发帖的楼层数9 R5 {5 @ t8 U# U) }; J
|
|