一条MYSQL一对多的SQL语句，请高手赐教。

select *

from m_tb

left join

(

select id, title, mid, max(times) as 最近时间

from m_vs

group by mid

) on (m_tb.id=m_vs.mid)

in后边的sql有问题。

你试试单独运行“select pid from repost group by pid order by count(pid) desc limit 0, 3”。估计会保错。

---