Index: branches/czw_branch/20101203/ippTools/share/chiptool_find_rawexp.sql
===================================================================
--- branches/czw_branch/20101203/ippTools/share/chiptool_find_rawexp.sql	(revision 29965)
+++ branches/czw_branch/20101203/ippTools/share/chiptool_find_rawexp.sql	(revision 29982)
@@ -1,9 +1,10 @@
 -- this query is used to find potental rawExps to be queued for chiptool
 -- processeing
-SELECT
+SELECT DISTINCT 
     rawExp.*,
     newExp.label
 FROM rawExp
 JOIN newExp using (exp_id)
+LEFT JOIN chipRun USING (exp_id)
 WHERE
     rawExp.fault = 0
Index: branches/czw_branch/20101203/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- branches/czw_branch/20101203/ippTools/share/pxadmin_create_tables.sql	(revision 29965)
+++ branches/czw_branch/20101203/ippTools/share/pxadmin_create_tables.sql	(revision 29982)
@@ -9,4 +9,5 @@
     uri VARCHAR(255),
     epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    use_compress SMALLINT,
     PRIMARY KEY(camera, telescope)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
Index: branches/czw_branch/20101203/ippTools/share/regtool_pendingburntoolimfile.sql
===================================================================
--- branches/czw_branch/20101203/ippTools/share/regtool_pendingburntoolimfile.sql	(revision 29965)
+++ branches/czw_branch/20101203/ippTools/share/regtool_pendingburntoolimfile.sql	(revision 29982)
@@ -25,5 +25,5 @@
 	    LEFT JOIN newImfile USING(exp_id)
             LEFT JOIN rawExp USING(exp_id, exp_name)
-            LEFT JOIN rawImfile ON (rawImfile.exp_name = rawExp.exp_name AND rawImfile.tmp_class_id = newImfile.tmp_class_id)
+            LEFT JOIN rawImfile ON (rawImfile.exp_name = newExp.tmp_exp_name AND rawImfile.tmp_class_id = newImfile.tmp_class_id)
        WHERE
              summitExp.dateobs >= '@DATE@T00:00:00'
Index: branches/czw_branch/20101203/ippTools/share/regtool_pendingexp.sql
===================================================================
--- branches/czw_branch/20101203/ippTools/share/regtool_pendingexp.sql	(revision 29965)
+++ branches/czw_branch/20101203/ippTools/share/regtool_pendingexp.sql	(revision 29982)
@@ -39,4 +39,5 @@
         newExp.state = 'run'
         AND rawExp.exp_id IS NULL
+	AND rawImfile.data_state = 'full'
 -- where hook %s
     GROUP BY