Delect bb_register.rid, bb_library.lid, lname, rname, bb_page.pid, bb_page.pageorder, bb_page.fnum, bb_page.image, bb_page.nextpage, bb_page.prevpage, bb_pageprev.pid as prevpid, bb_pageprev.fnum as prevfnum, bb_pageprev.pageorder as prevpageorder, bb_pagenext.pid as nextpid, bb_pagenext.fnum as nextfnum, bb_pagenext.pageorder as nextpageorder from bb_library, bb_register, bb_page left join bb_page as bb_pageprev on bb_page.prevpage = bb_pageprev.pid left join bb_page as bb_pagenext on bb_page.nextpage = bb_pagenext.pid where bb_library.lid = bb_register.lid and bb_register.rid = bb_page.rid and bb_library.isactive = 'Y' and bb_register.isactive = 'Y' and bb_page.isactive = 'Y' and bb_library.bbversion <= :version and bb_register.bbversion <= :version and bb_page.bbversion <= :version and (bb_pageprev.bbversion <= :version or bb_pageprev.bbversion is null) and (bb_pagenext.bbversion <= :version or bb_pagenext.bbversion is null) and bb_page.pid = :pid