IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 6 and Version 7 of ippToPsps_Database


Ignore:
Timestamp:
Mar 8, 2012, 8:45:03 AM (14 years ago)
Author:
rhenders
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ippToPsps_Database

    v6 v7  
    6565SELECT ra_center, COUNT(*) AS num  FROM box JOIN pending ON (id = box_id) WHERE config = 'new3pi' GROUP BY ra_center;
    6666}}}
     67
     68== See what each client is working on ==
     69
     70{{{
     71SELECT clients.config, host, timestamp, ra_center FROM stripe JOIN clients ON (client_id = id) ORDER BY ra_center;
     72}}}