Changeset 36040 for trunk/ippTools/share

Timestamp:

Aug 27, 2013, 1:44:43 PM (13 years ago)

Author:

bills

Message:

join back to find the #$!#$ camera

File:

• trunk/ippTools/share/stacktool_summary.sql (modified) (1 diff)

trunk/ippTools/share/stacktool_summary.sql

@@ -4 +4 @@
        stackAssociation.filter,
        stackSummary.path_base,
-       stackAssociation.data_group
+       stackAssociation.data_group,
+       rawExp.camera
 FROM stackRun 
     JOIN stackAssociationMap USING(stack_id) 
     JOIN stackAssociation USING(sass_id, filter)
     JOIN stackSummary using(sass_id, projection_cell)
-
--- WHERE stackRun.label ='lap.threepi.20130717' and skycell_id like 'skycell.0635%' and filter = 'r.00000'\G
--- WHERE stackRun.label ='lap.threepi.20130717' and projection_cell = 'skycell.0635' and filter = 'r.00000'\G
+    JOIN stackInputSkyfile using(stack_id)
+    JOIN warpRun USING(warp_id)
+    JOIN fakeRun USING(fake_id)
+    JOIN camRun USING(cam_id)
+    JOIN chipRun USING(chip_id)
+    JOIN rawExp USING(exp_id)