Question

mysql 语句 求查询总数

SELECT a.* FROM pre_forum_thread a left join pre_forum_threadmod b on a.tid <> b.tid GROUP BY a.tid HAVING (a.subject like '%%') AND a.fid = 412 and a.sortid =2 ORDER BY a.tid asc LIMIT 0,15 这是可以查询到 数据的，我刚用group 不知奥怎么取总数，，求帮助啊
我擦，换个方法，特别简单，，不纠结这么复杂的SQL语句了

Answer 1

select count(*) from pre_forum_thread a left join pre_forum_threadmod b on a.tid <> b.tid GROUP BY a.tid HAVING (a.subject like '%%') AND a.fid = 412 and a.sortid =2

Answer 2

select count(*) 表名