SELECT ci.item_id , ci.title , ci.year , ci.pub_location , ci.script , fi.file_id , fi.file_name , fi.toc_order , fi.folder_name , gt.master_id , mi.incipit , mi.recital , gt.header , gt.item_page FROM canon_items ci , item_files fi , ginan_texts gt , ginans.master_index mi WHERE 1=1 AND ci.item_id = fi.item_id AND fi.file_id = gt.file_id AND gt.master_id = mi.master_id AND ci.item_id = 30 ORDER BY fi.toc_order Canon of Published Texts of Ginans - Ginans