select b.no, c.sav_nm, b.link1 as link
from mf_main_pick a
inner join mf_good b on a.good_no = b.no and b.use_yn='Y' and b.del_yn='N'
left outer join mf_good_thmb c on b.no = c.good_no and c.pos=1 and c.del_yn='N'
where a.reg_br = '0003' and a.del_yn='N' and a.ord=1
order by a.sort asc
limit 0, 2
