select ftop_key, count(*) as ftop_rep_count from t_frm_rep left join t_frm_top on t_frm_top.ftop_key=t_frm_rep.fk_frm_top group by ftop_key

Got error 12 from storage engine