by ramonvel » Wed Jul 18, 2007 9:52 am
mysql> 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