SELECT crr.item_id as term_id, cr.parent_id as glossar_id , crr.description , glt.source_text , glt.target_text , glt.dont_text , aco.creation_user , to_char(aco.last_modified , 'DD.MM.YY HH24:MI') as last_modified , p.first_names , p.last_name FROM gl_glossar_terms glt, cr_items cr, cr_revisions crr , acs_objects aco , persons p WHERE cr.latest_revision = crr.revision_id AND crr.revision_id = glt.term_id AND crr.revision_id = aco.object_id AND aco.creation_user = p.person_id AND cr.parent_id = :glossar_id $where_customer_id [template::list::filter_where_clauses -and -name gl_term] $where_format [template::list::page_where_clause -name gl_term] [template::list::orderby_clause -orderby -name gl_term] SELECT crr.item_id FROM cr_items cr, cr_revisions crr , gl_glossar_terms glt, acs_objects aco , persons p WHERE cr.latest_revision = crr.revision_id AND crr.revision_id = glt.term_id AND crr.revision_id = aco.object_id AND aco.creation_user = p.person_id AND cr.parent_id = :glossar_id [template::list::filter_where_clauses -and -name gl_term] select g.object_id, g.title as glossar_title, g.description as glossar_comment, g.source_category_id, g.target_category_id from gl_glossarsx g, cr_items i where g.context_id = :glossar_id and i.item_id = g.context_id and i.latest_revision = g.object_id select ci.item_id, cr.title, ci.name from cr_items ci, cr_revisions cr where ci.parent_id = :glossar_id and ci.live_revision = cr.revision_id postgresql 7.2