select *
from t_assistant_article as a,
(select max(base_id) as base_id, max(create_time) as create_time from t_assistant_article as b group by base_id ) as b
where a.base_id=b.base_id and a.create_time = b.create_time
select *
from t_assistant_article as a,
(select max(base_id) as base_id, max(create_time) as create_time from t_assistant_article as b group by base_id ) as b
where a.base_id=b.base_id and a.create_time = b.create_time