Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 19152)
+++ trunk/ippTools/share/Makefile.am	(revision 19160)
@@ -145,4 +145,5 @@
      stacktool_sumskyfile.sql \
      stacktool_tosum.sql \
+     warptool_definebyquery.sql \
      warptool_donecleanup.sql \
      warptool_exp.sql \
Index: trunk/ippTools/share/warptool_definebyquery.sql
===================================================================
--- trunk/ippTools/share/warptool_definebyquery.sql	(revision 19160)
+++ trunk/ippTools/share/warptool_definebyquery.sql	(revision 19160)
@@ -0,0 +1,36 @@
+SELECT
+    *
+FROM
+    (SELECT DISTINCT
+        fakeRun.*,
+        chipRun.chip_id,
+        rawExp.camera,
+        rawExp.telescope,
+        rawExp.dateobs,
+        rawExp.exp_tag,
+        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.solang
+    FROM fakeRun
+    JOIN camRun
+        using(cam_id)
+    JOIN chipRun
+        using(chip_id)
+    JOIN rawExp
+        using(exp_id)
+    WHERE
+	fakeRun.state = 'full') as Foo