Context Navigation

staticskytool_result.sql

Timestamp:

Jun 19, 2012, 5:24:19 PM (14 years ago)

Author:

mhuber

Message:

merging latest r34040 trunk changes to branch

Location:

branches/meh_branches/ppstack_test

Files:

Property svn:mergeinfo changed

/branches/eam_branches/ipp-20120405 (added)	merged: 33724,33734-33739,33788,33797-33799,33807,33819-33820,33823-33824,33827-33828,33834-33835,33849,33868-33876,33878,33880,33882,33885-33888,33891-33893,33895-33907,33911-33912,33936,33942-33954
/trunk	merged: 33409-33411,33414,33417,33424-33426,33432-33436,33438-33439,33441-33444,33455,33457,33462-33463,33465,33470,33486-33502,33504,33506,33508-33509,33511-33512,33516-33517,33521-33531,33533,33541,33550,33553-33562,33573,33575-33579,33586-33590,33593-33595,33598-33599,33602,33617-33619,33624-33627,33636,33642-33693,33700-33702,33704-33723,33725-33731,33733,33740-33748,33750-33755,33757-33761,33763-33787,33789-33796,33800-33806,33808-33810,33814-33818,33821,33825-33826,33830-33833,33836-33848,33850-33851,33853,33855-33856,33858-33860,33862-33863,33865-33867,33877,33879,33881,33883-33884,33889-33890,33894,33908,33910,33913-33927,33929-33930,33932,33934-33935,33937-33940,33955-33959,33962-33969,33971-33972,33974-33975,33979-33980,33986-33991,33993-33994,34006-34008,34010-34018

-              r33415
+              r34041
     stackRun.tess_id,
     stackRun.skycell_id,
+    count(stackRun.filter) AS num_filters
+    count(stackRun.filter) AS num_filters,
+    skycell.glong,
+    skycell.glat
 FROM staticskyRun
 JOIN staticskyResult USING(sky_id)
 JOIN staticskyInput USING(sky_id)
+JOIN stackRun using(stack_id)
+JOIN stackRun USING(stack_id)
+LEFT JOIN skycell USING(tess_id, skycell_id)

Note: See TracChangeset for help on using the changeset viewer.