Changes between Version 13 and Version 14 of ippToPsps_Database

Timestamp:

Mar 21, 2012, 1:02:45 PM (14 years ago)

Author:

rhenders

Comment:

--

ippToPsps_Database

@@ -91 +91 @@
 SELECT config, batch_type, COUNT(*) FROM pending JOIN box ON (id = box_id) WHERE config = 'newmd4' GROUP BY batch_type;
 }}}
+
+== Find duplicated exposures ==
+
+{{{
+SELECT timestamp, exp_id, batch_type, batch_id,  COUNT(exp_id) AS NumOccurrences FROM detection JOIN batch USING (batch_id) WHERE dvo_db = 'LAP.ThreePi.20110809' AND loaded_to_datastore  GROUP BY exp_id HAVING NumOccurrences > 1 order by timestamp;
+}}}
+
+
+