Changeset 26670 for trunk/tools/wiki_nightly_stacks_table.pl

Timestamp:

Jan 22, 2010, 11:38:51 AM (16 years ago)

Author:

watersc1

Message:

"Final" version of the nightly stacks code. I may add more forcing later, if we have a lot of faults to skip through.

File:

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

trunk/tools/wiki_nightly_stacks_table.pl

@@ -133 +133 @@
 
 #warps
-$sth = "select rawExp.dateobs,warpRun.state,rawExp.filter,count(warpRun.state),warpRun.data_group,warpRun.dist_group from warpRun JOIN fakeRun using (fake_id) JOIN camRun using (cam_id) JOIN chipRun using (chip_id) JOIN rawExp using (exp_id)  where warpRun.label LIKE '%nightlystack' GROUP BY data_group,filter ORDER BY data_group,filter"; 
+$sth = "select rawExp.dateobs,warpRun.state,rawExp.filter,count(warpRun.state),warpRun.data_group,warpRun.dist_group from warpRun JOIN fakeRun using (fake_id) JOIN camRun using (cam_id) JOIN chipRun using (chip_id) JOIN rawExp using (exp_id)  where warpRun.label LIKE '%nightlystack' GROUP BY data_group,filter,state ORDER BY data_group,filter"; 
 $data_ref = $db->selectall_arrayref( $sth );