Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 28089)
+++ trunk/ippTools/share/Makefile.am	(revision 28091)
@@ -289,4 +289,9 @@
      stacktool_sumskyfile.sql \
      stacktool_tosum.sql \
+     staticskytool_definebyquery_select.sql \
+     staticskytool_definebyquery_inputs.sql \
+     staticskytool_inputs.sql \
+     staticskytool_todo.sql \
+     staticskytool_result.sql \
      warptool_change_skyfile_data_state.sql \
      warptool_change_run_state.sql \
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 28089)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 28091)
@@ -1617,5 +1617,5 @@
 -- A static sky analysis set
 CREATE TABLE staticskyRun (
-      ss_id BIGINT AUTO_INCREMENT, -- unique identifier
+      sky_id BIGINT AUTO_INCREMENT, -- unique identifier
       state VARCHAR(64) NOT NULL,  -- state of run (new, full, etc.)
       workdir VARCHAR(255) NOT NULL, -- working directory
@@ -1626,5 +1626,5 @@
       note VARCHAR(255),             -- note
       registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered
-      PRIMARY KEY(ss_id),
+      PRIMARY KEY(sky_id),
       KEY(state),
       KEY(label),
@@ -1635,9 +1635,9 @@
 -- Inputs for static sky analysis
 CREATE TABLE staticskyInput (
-      ss_id BIGINT,             -- static sky identifier
+      sky_id BIGINT,             -- static sky identifier
       stack_id BIGINT,          -- stack identifier
-      PRIMARY KEY(ss_id,stack_id),
+      PRIMARY KEY(sky_id,stack_id),
       KEY(stack_id),
-      FOREIGN KEY(ss_id) REFERENCES staticskyRun(ss_id),
+      FOREIGN KEY(sky_id) REFERENCES staticskyRun(sky_id),
       FOREIGN KEY(stack_id) REFERENCES stackSumSkyfile(stack_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1645,5 +1645,5 @@
 -- Result of static sky analysis
 CREATE TABLE staticskyResult (
-      ss_id BIGINT,             -- static sky identifier
+      sky_id BIGINT,             -- static sky identifier
       path_base VARCHAR(255) NOT NULL, -- root name for outputs
       dtime_phot FLOAT,                -- elapsed time for photometry
@@ -1654,9 +1654,9 @@
       quality SMALLINT NOT NULL,       -- bad quality flag
       fault SMALLINT NOT NULL,         -- fault code
-      PRIMARY KEY(ss_id),
+      PRIMARY KEY(sky_id),
       KEY(good_frac),
       KEY(fault),
       KEY(quality),
-      FOREIGN KEY(ss_id) REFERENCES staticskyRun(ss_id)
+      FOREIGN KEY(sky_id) REFERENCES staticskyRun(sky_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
Index: trunk/ippTools/share/staticskytool_definebyquery.sql
===================================================================
--- trunk/ippTools/share/staticskytool_definebyquery.sql	(revision 28089)
+++ trunk/ippTools/share/staticskytool_definebyquery.sql	(revision 28091)
@@ -1,14 +1,22 @@
-SELECT
-    tess_id,
-    skycell_id,
-    COUNT(*) AS num,
-    COUNT(DISTINCT filter) AS num_filter
-FROM stackRun
-JOIN stackSumSkyfile USING(stack_id)
-WHERE stackRun.state = 'full'
-    AND stackSumSkyfile.fault = 0
-    AND stackSumSkyfile.quality = 0
--- WHERE hook %s
-GROUP BY
-    tess_id,
-    skycell_id
+SELECT 
+       tess_id,	
+       skycell_id, 
+       num_filter 
+FROM (
+  SELECT
+      tess_id,
+      skycell_id,
+      COUNT(DISTINCT filter) AS num_filter
+  FROM stackRun
+  JOIN stackSumSkyfile USING(stack_id)
+  WHERE stackRun.state = 'full'
+      AND stackSumSkyfile.fault = 0
+      AND stackSumSkyfile.quality = 0
+  -- WHERE hook 1 %s 
+  -- restrict by stackSumSkyfile.good_frac, stackRun.skycell_id, stackRun.label
+  GROUP BY
+      tess_id,
+      skycell_id
+  ) AS TMP
+WHERE num_filter == %d
+
Index: trunk/ippTools/share/staticskytool_definebyquery_inputs.sql
===================================================================
--- trunk/ippTools/share/staticskytool_definebyquery_inputs.sql	(revision 28091)
+++ trunk/ippTools/share/staticskytool_definebyquery_inputs.sql	(revision 28091)
@@ -0,0 +1,14 @@
+  SELECT
+      MAX(stack_id) as stack_id,
+      tess_id,
+      skycell_id,
+      filter
+  FROM stackRun
+  JOIN stackSumSkyfile USING(stack_id)
+  WHERE stackRun.state = 'full'
+      AND stackSumSkyfile.fault = 0
+      AND stackSumSkyfile.quality = 0
+      AND stackRun.tess_id = '%s'
+      AND stackRun.skycell_id = '%s'
+  -- WHERE hook %s
+  GROUP BY stackRun.filter
Index: trunk/ippTools/share/staticskytool_definebyquery_select.sql
===================================================================
--- trunk/ippTools/share/staticskytool_definebyquery_select.sql	(revision 28091)
+++ trunk/ippTools/share/staticskytool_definebyquery_select.sql	(revision 28091)
@@ -0,0 +1,22 @@
+SELECT 
+       tess_id,	
+       skycell_id, 
+       num_filter 
+FROM (
+  SELECT
+      tess_id,
+      skycell_id,
+      COUNT(DISTINCT filter) AS num_filter
+  FROM stackRun
+  JOIN stackSumSkyfile USING(stack_id)
+  WHERE stackRun.state = 'full'
+      AND stackSumSkyfile.fault = 0
+      AND stackSumSkyfile.quality = 0
+  -- WHERE hook 1 %s 
+  -- restrict by stackSumSkyfile.good_frac, stackRun.skycell_id, stackRun.label
+  GROUP BY
+      tess_id,
+      skycell_id
+  ) AS TMP
+WHERE num_filter = %d
+
Index: trunk/ippTools/share/staticskytool_inputs.sql
===================================================================
--- trunk/ippTools/share/staticskytool_inputs.sql	(revision 28091)
+++ trunk/ippTools/share/staticskytool_inputs.sql	(revision 28091)
@@ -0,0 +1,6 @@
+SELECT
+  staticskyRun.*,
+  stackSumSkyfile.path_base
+FROM staticskyRun
+JOIN staticskyInput USING(sky_id)
+JOIN stackSumSkyfile USING (stack_id)
Index: trunk/ippTools/share/staticskytool_result.sql
===================================================================
--- trunk/ippTools/share/staticskytool_result.sql	(revision 28091)
+++ trunk/ippTools/share/staticskytool_result.sql	(revision 28091)
@@ -0,0 +1,11 @@
+SELECT
+    staticskyResult.*,
+    staticskyRun.state,
+    staticskyRun.tess_id,
+    staticskyRun.skycell_id,
+    staticskyRun.filter,
+    staticskyRun.workdir,
+    staticskyRun.label,
+FROM staticskyRun
+JOIN staticskyResult
+USING(stack_id)
Index: trunk/ippTools/share/staticskytool_todo.sql
===================================================================
--- trunk/ippTools/share/staticskytool_todo.sql	(revision 28091)
+++ trunk/ippTools/share/staticskytool_todo.sql	(revision 28091)
@@ -0,0 +1,15 @@
+SELECT
+    staticskyRun.sky_id,
+    staticskyRun.workdir,
+    staticskyRun.reduction,
+    staticskyRun.label,
+    staticskyRun.state
+FROM staticskyRun
+JOIN staticskyInput USING (sky_id)
+JOIN stackRun USING (stack_id)
+LEFT JOIN staticskyResult USING(sky_id)
+WHERE
+   (staticskyRun.state = 'new' AND staticskyResult.sky_id IS NULL)
+    -- WHERE hook %s
+GROUP BY sky_id
+HAVING SUM(IF(stackRun.state = 'full', 1, 0)) = COUNT(staticskyInput.sky_id)