Mine

my index.tcl file:

template::list::create -name note -elements {
     title {
     }
}

db_multirow note get_list_of_note {
      select ci.item_id, n.title from   cr_items ci, notex n where  n.revision_id = ci.live_revision
}