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_page.pid = :pid