select tpa.application_name, vip.ia_issue_number, tgws.state_name from t_gps_applications tpa, t_instances ti, t_gps_instances tgi, v_instance_props vip, t_gps_workflow_types tgwt, t_gps_workflow_states tgws, t_project_task tpt where tpa.application_name like 'Cavium Support Project' and tpa.application_id = ti.application_id and ti.instance_id = tgi.instance_id and tgi.instance_present = 1 and vip.instance_id = ti.instance_id and tpa.application_id = tgwt.application_id and tgwt.workflow_type_id = tgws.workflow_type_id and tgi.current_state_id = tgws.state_id and tpt.instance_id = ti.instance_id and tpt.state_id = tgws.state_id