distinct order by 好句共享 select distinct tv_id,max(created) as c from ep2tvs group by tv_id order by c desc