select f_id, a.f_appid, f_access_count,f_ctime,b.f_productID,b.f_productName from t_stat_app_access a left join(select f_appid,f_id as f_productID,f_name as f_productName from t_product group by f_appid) b on a.f_appid=b.f_appid order by f_id desc