select variable_id from logger_entries le, acs_objects ao where ao.creation_date = (select max(ao.creation_date) from logger_entries le, acs_objects ao where ao.object_id = le.entry_id [ad_decode $project_clause "" "" "and $project_clause"] ) and ao.object_id = le.entry_id [ad_decode $project_clause "" "" "and $project_clause"] select lp.name as label, lp.project_id as project_id, (select count(*) from logger_entries e where e.project_id = lp.project_id and variable_id = :variable_id) as count from logger_projects lp, logger_project_pkg_map lppm where lp.project_id = lppm.project_id and lppm.package_id = :package_id order by lp.name select lv.name || ' (' || lv.unit || ')' as name, lv.variable_id as unique_id from logger_variables lv, logger_projects lp, logger_project_var_map lpvm where lp.project_id = lpvm.project_id and lv.variable_id = lpvm.variable_id and exists (select 1 from logger_project_pkg_map where project_id = lp.project_id and package_id = :package_id ) group by lv.variable_id, lv.name, lv.unit select submitter.first_names || ' ' || submitter.last_name as label, submitter.user_id as user_id from cc_users submitter, logger_entries le, acs_objects ao where ao.object_id = le.entry_id and submitter.user_id = ao.creation_user and exists (select 1 from logger_project_pkg_map where project_id = le.project_id and package_id = :package_id) group by submitter.user_id, submitter.first_names, submitter.last_name select p.projection_id, p.name, to_char(p.start_time, 'YYYY-MM-DD') as start_date_ansi, to_char(p.end_time, 'YYYY-MM-DD') as end_date_ansi from logger_projections p where p.project_id = :project_id order by p.start_time, p.end_time, lower(p.name)