Index: branches/eam_branches/ipp-20130307/ippTools/share/Makefile.am
===================================================================
--- branches/eam_branches/ipp-20130307/ippTools/share/Makefile.am	(revision 35350)
+++ branches/eam_branches/ipp-20130307/ippTools/share/Makefile.am	(revision 35412)
@@ -473,4 +473,5 @@
 	releasetool_definerelstack.sql \
 	releasetool_definerelstack_with_skycal.sql \
+	releasetool_listrelstack.sql \
 	releasetool_definerelgroup_select_lap.sql \
 	releasetool_definerelgroup_select_data_group.sql \
Index: branches/eam_branches/ipp-20130307/ippTools/share/pstamptool_completedreq.sql
===================================================================
--- branches/eam_branches/ipp-20130307/ippTools/share/pstamptool_completedreq.sql	(revision 35350)
+++ branches/eam_branches/ipp-20130307/ippTools/share/pstamptool_completedreq.sql	(revision 35412)
@@ -8,4 +8,5 @@
     	SELECT count(*) FROM pstampJob 
 	WHERE pstampJob.req_id = pstampRequest.req_id
-		AND pstampJob.state != 'stop'
+		AND pstampJob.state != 'stop' 
+                AND pstampJob.state != 'cancel'
 	) = 0
Index: branches/eam_branches/ipp-20130307/ippTools/share/pstamptool_getdependent.sql
===================================================================
--- branches/eam_branches/ipp-20130307/ippTools/share/pstamptool_getdependent.sql	(revision 35350)
+++ branches/eam_branches/ipp-20130307/ippTools/share/pstamptool_getdependent.sql	(revision 35412)
@@ -1,3 +1,3 @@
 SELECT DISTINCT pstampDependent.*
 FROM pstampDependent
-WHERE pstampDependent.state = 'new'
+WHERE (pstampDependent.state = 'new' OR pstampDependent.state = 'hold')
Index: branches/eam_branches/ipp-20130307/ippTools/share/releasetool_listrelexp.sql
===================================================================
--- branches/eam_branches/ipp-20130307/ippTools/share/releasetool_listrelexp.sql	(revision 35350)
+++ branches/eam_branches/ipp-20130307/ippTools/share/releasetool_listrelexp.sql	(revision 35412)
@@ -25,4 +25,5 @@
     warpRun.warp_id,
     warpRun.state as warp_state,
+    warpRun.tess_id,
     rawExp.filter,
     rawExp.dateobs,
Index: branches/eam_branches/ipp-20130307/ippTools/share/releasetool_listrelstack.sql
===================================================================
--- branches/eam_branches/ipp-20130307/ippTools/share/releasetool_listrelstack.sql	(revision 35412)
+++ branches/eam_branches/ipp-20130307/ippTools/share/releasetool_listrelstack.sql	(revision 35412)
@@ -0,0 +1,18 @@
+SELECT
+    release_name,
+    surveyName,
+    relStack.*,
+    stackSumSkyfile.path_base AS stack_path_base,
+    stackSumSkyfile.quality,
+    stackRun.state AS stack_state,
+    stackRun.data_group AS stack_data_group,
+    skycalResult.path_base AS skycal_path_base,
+    skycalRun.data_group AS skycal_data_group,
+    'GPC1' AS camera
+FROM relStack
+JOIN ippRelease USING(rel_id) 
+JOIN survey USING(surveyID)
+JOIN stackRun USING(stack_id, filter, tess_id, skycell_id)
+JOIN stackSumSkyfile USING(stack_id)
+LEFT JOIN skycalRun USING(skycal_id)
+LEFT JOIN skycalResult USING(skycal_id)
Index: branches/eam_branches/ipp-20130307/ippTools/share/releasetool_pendingrelgroup.sql
===================================================================
--- branches/eam_branches/ipp-20130307/ippTools/share/releasetool_pendingrelgroup.sql	(revision 35350)
+++ branches/eam_branches/ipp-20130307/ippTools/share/releasetool_pendingrelgroup.sql	(revision 35412)
@@ -5,2 +5,3 @@
     JOIN ippRelease USING(rel_id)
 WHERE relGroup.state = 'new'
+    AND relGroup.fault = 0