#!/usr/bin/python

import mitsfs

def main():
    d = mitsfs.dexdb()
    title_ids = list(d.cursor.execute(
        "select title_id from book natural join shelfcode"
        " where shelfcode_type='C' and not withdrawn group by title_id"
        " having count(book_id) > 2"
        ))
    line_ids = [
        (mitsfs.dexline(mitsfs.title(d, title_id)), title_id)
        for title_id in title_ids
        ]
    line_ids.sort()
    for (line, title_id) in line_ids:
        print line
if __name__ == '__main__':
    main()