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@xxxxxxxx https://www1.ietf.org/mailman/listinfo/ietf