select a.*, b.usernm
from goods a
inner join users b on a.useridx=b.idx
where a.delyn='N' and a.outyn='N' and ((a.adyn='Y' and a.idx in (4258,2482)) or a.adyn ='N') and ( a.useyn='Y' or a.useridx='0')
order by a.adyn desc, a.sort desc
limit 0, 40
더보기