select * , (select count(*) from TBP_CINEMA_YEYAK where y_showcode = VIEW_SHOW.sh_code and y_id = '') as YEYAK_CHK FROM VIEW_SHOW WHERE SH_USE='Y' AND IN_NAME = '완주문화예술회관' order by SH_CODE desc limit 265,5