by ramonvel » Wed Jul 18, 2007 2:56 pm
Server section has >>>>> Local GMT: -5 (Do NOT Adjust for DST)
SELECT count(*),status,called_since_last_reset,list_id,gmt_offset_now from vicidial_list group by status,called_since_last_reset,list_id,gmt_offset_now; +----------+--------+-------------------------+---------+----------------+
| count(*) | status | called_since_last_reset | list_id | gmt_offset_now |
+----------+--------+-------------------------+---------+----------------+
| 2 | A | Y | 101 | 0.00 |
| 2 | CALLBK | Y | 101 | 0.00 |
| 1 | DEC | Y | 101 | 0.00 |
| 11 | DROP | Y | 101 | 0.00 |
| 6 | NA | Y | 101 | 0.00 |
| 2 | NEW | Y | 101 | 0.00 |
| 4846 | NEW | N | 101 | 0.00 |
+----------+--------+-------------------------+---------+----------------+
7 rows in set (0.03 sec)
Ray