Delect bb_library.lid, slug, lname, bb_register.rid, rname, syear, eyear, rtype, bb_page.pid, fnum, image, bb_borrowing.bnid, bb_borrowing.oid, bb_borrowing.pageorder, transcription, bday, bmonth, byear, rday, rmonth, ryear from bb_library, bb_register, bb_page, bb_borrowing where bb_library.lid = bb_register.lid and bb_register.rid = bb_page.rid and bb_page.pid = bb_borrowing.pid and bb_library.isactive = 'Y' and bb_register.isactive = 'Y' and bb_page.isactive = 'Y' and bb_borrowing.isactive = 'Y' and bnid in(?) order by FIELD(bnid,41971)