select K.idx,T.title,K.sdate,K.stime from keijiban K, keijiban T where K.delflg = 0 and K.idx = T.idx and T.res = 0 and K.res = (select max(res) from keijiban where idx=K.idx and delflg = 0) and K.sdate > now() - interval '180 day' order by K.sdate desc ,K.stime desc
select K.idx,K.res,K.sdate,K.stime,K.handle,K.title,K.msg,K.nores,M.pointx,P.photo,P.sizeh,P.sizev,L.pagename,L.linkpage,K.good,K.bad,K.surprise,K.uniqid,K.invisible from keijiban K left outer join bbsmap M on M.idx = K.idx and M.res = K.res left outer join bbsphoto P on P.idx = K.idx and P.res = K.res and P.conf = 1 left outer join keijiban_link L on L.idx = K.idx and L.res = K.res where K.idx = 4796 and K.delflg <> 1 order by K.res
select K.idx,K.res,K.sdate,K.stime,K.handle,K.title,K.msg,K.nores,M.pointx,P.photo,P.sizeh,P.sizev,L.pagename,L.linkpage,K.good,K.bad,K.surprise,K.uniqid,K.invisible from keijiban K left outer join bbsmap M on M.idx = K.idx and M.res = K.res left outer join bbsphoto P on P.idx = K.idx and P.res = K.res and P.conf = 1 left outer join keijiban_link L on L.idx = K.idx and L.res = K.res where K.idx = 4799 and K.delflg <> 1 order by K.res
select K.idx,K.res,K.sdate,K.stime,K.handle,K.title,K.msg,K.nores,M.pointx,P.photo,P.sizeh,P.sizev,L.pagename,L.linkpage,K.good,K.bad,K.surprise,K.uniqid,K.invisible from keijiban K left outer join bbsmap M on M.idx = K.idx and M.res = K.res left outer join bbsphoto P on P.idx = K.idx and P.res = K.res and P.conf = 1 left outer join keijiban_link L on L.idx = K.idx and L.res = K.res where K.idx = 4798 and K.delflg <> 1 order by K.res
select K.idx,K.res,K.sdate,K.stime,K.handle,K.title,K.msg,K.nores,M.pointx,P.photo,P.sizeh,P.sizev,L.pagename,L.linkpage,K.good,K.bad,K.surprise,K.uniqid,K.invisible from keijiban K left outer join bbsmap M on M.idx = K.idx and M.res = K.res left outer join bbsphoto P on P.idx = K.idx and P.res = K.res and P.conf = 1 left outer join keijiban_link L on L.idx = K.idx and L.res = K.res where K.idx = 4797 and K.delflg <> 1 order by K.res
select K.idx,K.res,K.sdate,K.stime,K.handle,K.title,K.msg,K.nores,M.pointx,P.photo,P.sizeh,P.sizev,L.pagename,L.linkpage,K.good,K.bad,K.surprise,K.uniqid,K.invisible from keijiban K left outer join bbsmap M on M.idx = K.idx and M.res = K.res left outer join bbsphoto P on P.idx = K.idx and P.res = K.res and P.conf = 1 left outer join keijiban_link L on L.idx = K.idx and L.res = K.res where K.idx = 4795 and K.delflg <> 1 order by K.res
select K.idx,K.res,K.sdate,K.stime,K.handle,K.title,K.msg,K.nores,M.pointx,P.photo,P.sizeh,P.sizev,L.pagename,L.linkpage,K.good,K.bad,K.surprise,K.uniqid,K.invisible from keijiban K left outer join bbsmap M on M.idx = K.idx and M.res = K.res left outer join bbsphoto P on P.idx = K.idx and P.res = K.res and P.conf = 1 left outer join keijiban_link L on L.idx = K.idx and L.res = K.res where K.idx = 4794 and K.delflg <> 1 order by K.res
select K.idx,K.res,K.sdate,K.stime,K.handle,K.title,K.msg,K.nores,M.pointx,P.photo,P.sizeh,P.sizev,L.pagename,L.linkpage,K.good,K.bad,K.surprise,K.uniqid,K.invisible from keijiban K left outer join bbsmap M on M.idx = K.idx and M.res = K.res left outer join bbsphoto P on P.idx = K.idx and P.res = K.res and P.conf = 1 left outer join keijiban_link L on L.idx = K.idx and L.res = K.res where K.idx = and K.delflg <> 1 order by K.res