Index: branches/pap/ippTools/share/warptool_definebyquery.sql
===================================================================
--- branches/pap/ippTools/share/warptool_definebyquery.sql	(revision 23511)
+++ branches/pap/ippTools/share/warptool_definebyquery.sql	(revision 23651)
@@ -1,37 +1,35 @@
-SELECT
-    *
-FROM
-    (SELECT DISTINCT
-        fakeRun.*,
-        chipRun.chip_id,
-        rawExp.camera,
-        rawExp.telescope,
-        rawExp.dateobs,
-        rawExp.exp_tag,
-        rawExp.exp_name,
-        rawExp.exp_type,
-        rawExp.filelevel,
-        rawExp.filter,
-        rawExp.airmass,
-        rawExp.ra,
-        rawExp.decl,
-        rawExp.exp_time,
-        rawExp.sat_pixel_frac,
-        rawExp.bg,
-        rawExp.bg_stdev,
-        rawExp.bg_mean_stdev,
-        rawExp.alt,
-        rawExp.az,
-        rawExp.ccd_temp,
-        rawExp.posang,
-        rawExp.object,
-        rawExp.sun_angle
-    FROM fakeRun
-    JOIN camRun
-        using(cam_id)
-    JOIN chipRun
-        using(chip_id)
-    JOIN rawExp
-        using(exp_id)
-    WHERE
-        fakeRun.state = 'full') as Foo
+SELECT DISTINCT
+    fakeRun.*,
+    chipRun.chip_id,
+    rawExp.camera,
+    rawExp.telescope,
+    rawExp.dateobs,
+    rawExp.exp_tag,
+    rawExp.exp_name,
+    rawExp.exp_type,
+    rawExp.filelevel,
+    rawExp.filter,
+    rawExp.airmass,
+    rawExp.ra,
+    rawExp.decl,
+    rawExp.exp_time,
+    rawExp.sat_pixel_frac,
+    rawExp.bg,
+    rawExp.bg_stdev,
+    rawExp.bg_mean_stdev,
+    rawExp.alt,
+    rawExp.az,
+    rawExp.ccd_temp,
+    rawExp.posang,
+    rawExp.object,
+    rawExp.sun_angle
+FROM fakeRun
+JOIN camRun
+    using(cam_id)
+JOIN chipRun
+    using(chip_id)
+JOIN rawExp
+    using(exp_id)
+WHERE camRun.state = 'full'
+AND chipRun.state = 'full'
+