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') and a.areaidx='10' order by a.adyn desc, a.sort desc limit 0, 40