Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 16588)
+++ trunk/ippTools/share/Makefile.am	(revision 16613)
@@ -12,4 +12,5 @@
 	chiptool_processedimfile.sql \
 	chiptool_revertprocessedimfile.sql \
+	chiptool_unmasked.sql \
 	detselect_search.sql \
 	detselect_select.sql \
@@ -20,4 +21,5 @@
 	dettool_normalizedstat.sql \
 	dettool_raw.sql \
+	dettool_runs.sql \
 	dettool_revertdetrunsummary.sql \
 	dettool_revertnormalizedexp.sql \
Index: trunk/ippTools/share/chiptool_unmasked.sql
===================================================================
--- trunk/ippTools/share/chiptool_unmasked.sql	(revision 16613)
+++ trunk/ippTools/share/chiptool_unmasked.sql	(revision 16613)
@@ -0,0 +1,43 @@
+-- SELECT
+--  *
+-- FROM
+--  (SELECT 
+--      chipMask.label as label, 
+--      count(chipRun.chip_id) as n_chipruns
+--   FROM 
+--      chipMask 
+--   LEFT JOIN 
+--      chipRun 
+--   USING 
+--      (label) 
+--   WHERE chipRun.chip_id IS NOT NULL 
+--   GROUP BY label) as chipMask
+
+-- SELECT
+--  *
+-- FROM
+--  SELECT 
+--      chipRun.*, 
+--      rawExp.*,
+--      chipRun.chip_id as n_chipruns
+--   FROM 
+--      chipRun 
+--   JOIN rawExp ON chipRun.exp_id = rawExp.exp_id
+--   LEFT JOIN chipMask 
+--   USING (label) 
+--   WHERE chipMask.label IS NULL 
+--   AND filter = 'r'
+--   AND chipRun.exp_id = 61
+--  GROUP BY chipRun.label) as chipUnmask
+
+SELECT
+ *
+FROM
+ (SELECT 
+     chipRun.label, 
+     count(chipRun.chip_id) as n_chipruns
+  FROM chipRun 
+  LEFT JOIN chipMask 
+  USING (label) 
+  WHERE chipMask.label IS NULL 
+  GROUP BY chipRun.label) as chipUnmask
Index: trunk/ippTools/share/dettool_runs.sql
===================================================================
--- trunk/ippTools/share/dettool_runs.sql	(revision 16613)
+++ trunk/ippTools/share/dettool_runs.sql	(revision 16613)
@@ -0,0 +1,2 @@
+
+SELECT * from detRun