Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 35365)
+++ trunk/ippTools/share/Makefile.am	(revision 35397)
@@ -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: trunk/ippTools/share/releasetool_listrelexp.sql
===================================================================
--- trunk/ippTools/share/releasetool_listrelexp.sql	(revision 35365)
+++ trunk/ippTools/share/releasetool_listrelexp.sql	(revision 35397)
@@ -25,4 +25,5 @@
     warpRun.warp_id,
     warpRun.state as warp_state,
+    warpRun.tess_id,
     rawExp.filter,
     rawExp.dateobs,
Index: trunk/ippTools/share/releasetool_listrelstack.sql
===================================================================
--- trunk/ippTools/share/releasetool_listrelstack.sql	(revision 35397)
+++ trunk/ippTools/share/releasetool_listrelstack.sql	(revision 35397)
@@ -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)