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 = 4771 and K.delflg <> 1 order by K.res
日時:2024年3月22日(金)
17:30開場18:00開演
場所:宮前市民館 ホール
(東急田園都市線 宮前平から徒歩10分)
『予約不要』『入場料無料』
チケットなしでも当日入場可能🎶
曲目:
・宝島
・ラプソディ・イン・ブルー
・Sing Sing Sing
・ディズニープリンセスメドレー
・Moonlight Serenade(熱帯ジャズ楽団ver.)など
指揮者体験も実施予定🎶
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 = 4770 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 = 4769 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 = 4766 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 = 4768 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 = 4767 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 = 4765 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