Changeset 20727

Timestamp:

Nov 13, 2008, 2:13:07 PM (17 years ago)

Author:

Paul Price

Message:

Fixing SQL.

File:

• trunk/tools/warp_inputs.pl (modified) (1 diff)

trunk/tools/warp_inputs.pl

@@ -54 +54 @@
 my $sql = "SELECT" .
     " chipProcessedImfile.path_base AS chip_path_base," .
-    " class_id, " .
+    " class_id," .
     " camProcessedExp.path_base AS cam_path_base" .
     " FROM warpRun" .
+    " JOIN warpSkyCellMap USING(warp_id)" .
     " JOIN fakeRun USING(fake_id)" .
     " JOIN camRun USING(cam_id)" .
-    " JOIN chipRun USING(chip_id)" .
+    " JOIN chipProcessedImfile USING(chip_id, class_id)" .
     " WHERE warp_id = $warp_id" .
     " AND skycell_id = $skycell_id";