Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 29568)
+++ trunk/ippTools/share/Makefile.am	(revision 29611)
@@ -251,6 +251,8 @@
 	magicdstool_definecopy_chip.sql \
 	magicdstool_definecopy_warp.sql \
+	magicdstool_destreakedfile.sql \
 	magicdstool_getrunids.sql \
 	magicdstool_getskycells.sql \
+	magicdstool_listrun.sql \
 	magicdstool_revertdestreakedfile.sql \
 	magicdstool_revertupdated.sql \
Index: trunk/ippTools/share/magicdstool_destreakedfile.sql
===================================================================
--- trunk/ippTools/share/magicdstool_destreakedfile.sql	(revision 29611)
+++ trunk/ippTools/share/magicdstool_destreakedfile.sql	(revision 29611)
@@ -0,0 +1,17 @@
+SELECT 
+    magicDSFile.*,
+    CONCAT_WS('.', CONCAT(outroot, '/', exp_id), 'mds', magic_ds_id, stage_id, component) AS path_base,
+    magicDSRun.magic_id,
+    magicDSRun.inv_magic_id,
+    magicDSRun.state,
+    magicDSRun.stage,
+    magicDSRun.stage_id,
+    magicDSRun.cam_id,
+    magicDSRun.label,
+    magicDSRun.data_group,
+    magicDSRun.outroot,
+    magicDSRun.re_place,
+    magicDSRun.fault as run_fault,
+    magicDSRun.note
+FROM
+    magicDSRun JOIN magicDSFile USING(magic_ds_id) JOIN magicRun USING(magic_id)
Index: trunk/ippTools/share/magicdstool_listrun.sql
===================================================================
--- trunk/ippTools/share/magicdstool_listrun.sql	(revision 29611)
+++ trunk/ippTools/share/magicdstool_listrun.sql	(revision 29611)
@@ -0,0 +1,4 @@
+SELECT 
+    magicDSRun.*
+FROM
+    magicDSRun