select a.*, b.file_name from dog a left join (select * from file_manage where file_tb_name='dog') b on a.d_idx=b.file_tb_idx where 1=1 and d_who='d' order by d_idx desc limit 0, 20