Need a database query to get the list of experiments with status in E-Notebook

Need a database query to get the list of experiments with status in E-Notebook

SELECT collection_name "Notebook-ExpID",
  '<collection key="'
  || cs.collection_key
  || '"/>' "Notebook-ExpID_link",
  c.name,
  creation_date - (creation_tzb / 1440.0) "Creation Date",
  creation_tzb,
  transition_type_name "Last Transition",
  transition_date - (transition_tzb / 1440.0) "Transition Date",
  transition_tzb
FROM ENV_collection_states cs,
  ENV_collection_creation_dates ccd,
  ELN_collections c,
  ELN_states s,
  eln_collections t,
  ELN_People pl
WHERE cs.collection_key           = c.section_set_key
AND ccd.collection_key            = c.section_set_key
AND cs.state_key                  = s.primary_key
AND (s.existing_annotation_level <> 0
OR s.new_annotation_level        <> 0)
AND c.section_set_key            <> c.collection_type_key
AND c.is_active                   = 1
AND c.is_template                 = 0
and c.collection_type_key= t.section_set_key
and t.name like '%xperiment%'
AND pl.primary_key            = c.owner_key
ORDER BY lower(collection_name)