Context Navigation

dqstatstool_get_run.sql

Timestamp:

Mar 29, 2010, 3:55:49 PM (16 years ago)

Author:

eugene

Message:

update merges from trunk

Location:

branches/eam_branches/20100225

Files:

Property svn:mergeinfo changed

/branches/pap_stack (added)	merged: 27401,27405-27406,27409-27416
/trunk (added)	merged: 27088-27260,27262,27273-27280,27282-27290,27293-27294,27297-27304,27307-27311,27313-27335,27341-27349,27354-27356,27358-27367,27369-27371,27387-27389,27391-27396,27399-27400,27402-27404,27407-27408,27417-27420,27426-27427,27431-27436,27438-27439,27441-27486,27491,27503-27506,27510-27512

r26378	r27517
1		SELECT * from dqstatsRun
2		WHERE state = 'new' AND (fault = 0)
	1	SELECT DISTINCT dqstatsRun.*,rawExp.camera from dqstatsRun
	2	JOIN dqstatsContent USING(dqstats_id)
	3	JOIN rawExp USING(exp_id)
	4	WHERE dqstatsRun.state = 'new' AND (dqstatsRun.fault = 0)

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