Changes between Version 8 and Version 9 of ippToPsps_Database

Timestamp:

Mar 8, 2012, 1:23:53 PM (14 years ago)

Author:

rhenders

Comment:

--

ippToPsps_Database

@@ -71 +71 @@
 SELECT clients.config, host, timestamp, ra_center FROM stripe JOIN clients ON (client_id = id) ORDER BY ra_center;
 }}}
+
+== Counts of pending stuff for a given config ==
+
+
+{{{
+SELECT config, batch_type, COUNT(*) FROM pending JOIN box ON (id = box_id) WHERE config = 'newmd4' GROUP BY batch_type;
+}}}