Argh, I should have known better than to hope that gmail wouldn't
munch the tables.
The category/status table is:
mysql> select all_id.status, substring(rfcq.category, 1, 40) as "Category",
count(all_id.status) as "Num" from rfcq, all_id where all_id.docname =
rfcq.docname group by all_id.status, rfcq.category;
+-----------+------------------------------------------+-----+
| status | Category | Num |
+-----------+------------------------------------------+-----+
| active | INDEPENDENT SUBMISSIONS UNDER RFC EDITOR | 7 |
| expired | INDEPENDENT SUBMISSIONS UNDER RFC EDITOR | 18 |
| rfc | IAB DOCUMENTS (by date received) | 1 |
| rfc | NON-WORKING GROUP INFORMATIONAL/EXPERIME | 25 |
| rfc | NON-WORKING GROUP STANDARDS TRACK (by da | 10 |
| rfc | WORKING GROUP INFORMATIONAL/EXPERIMENTAL | 24 |
| rfc | WORKING GROUP STANDARDS TRACK (by date r | 56 |
| withdrawn | NON-WORKING GROUP INFORMATIONAL/EXPERIME | 1 |
| iesg | IAB DOCUMENTS (by date received) | 1 |
| iesg | INDEPENDENT SUBMISSIONS UNDER RFC EDITOR | 12 |
| iesg | NON-WORKING GROUP INFORMATIONAL/EXPERIME | 21 |
| iesg | NON-WORKING GROUP STANDARDS TRACK (by da | 2 |
| iesg | WORKING GROUP INFORMATIONAL/EXPERIMENTAL | 47 |
| iesg | WORKING GROUP STANDARDS TRACK (by date r | 61 |
+-----------+------------------------------------------+-----+
14 rows in set (0.05 sec)
and the date table is:
mysql> select min(all_id.lastup) as "Updated", substring(rfcq.category, 1, 50)
as "Category" from rfcq, all_id where all_id.docname = rfcq.docname and
all_id.status != 'rfc' group by rfcq.category;
+------------+----------------------------------------------------+
| Updated | Category |
+------------+----------------------------------------------------+
| 2004-10-22 | IAB DOCUMENTS (by date received) |
| 2003-07-01 | INDEPENDENT SUBMISSIONS UNDER RFC EDITOR REVIEW ( |
| 2001-07-24 | NON-WORKING GROUP INFORMATIONAL/EXPERIMENTAL/BCP ( |
| 2004-10-01 | NON-WORKING GROUP STANDARDS TRACK (by date receive |
| 2002-10-11 | WORKING GROUP INFORMATIONAL/EXPERIMENTAL/BCP (by d |
| 2002-09-11 | WORKING GROUP STANDARDS TRACK (by date received) |
+------------+----------------------------------------------------+
6 rows in set (0.04 sec)
Bill
_______________________________________________
Ietf mailing list
Ietf(_at_)ietf(_dot_)org
https://www1.ietf.org/mailman/listinfo/ietf