Publications by month

SELECT COUNT(*) as count, MIN(edit_date) as oldest_date, MAX(edit_date) as newest_date FROM `yacs_links` AS links WHERE links.anchor LIKE 'category:26'
144: Table './openconsortium/yacs_links' is marked as crashed and last (automatic?) repair failed

SELECT COUNT(*) as count, MIN(edit_date) as oldest_date, MAX(edit_date) as newest_date FROM `yacs_links` AS links WHERE links.anchor LIKE 'category:24'
144: Table './openconsortium/yacs_links' is marked as crashed and last (automatic?) repair failed

SELECT COUNT(*) as count, MIN(edit_date) as oldest_date, MAX(edit_date) as newest_date FROM `yacs_links` AS links WHERE links.anchor LIKE 'category:22'
144: Table './openconsortium/yacs_links' is marked as crashed and last (automatic?) repair failed

SELECT COUNT(*) as count, MIN(edit_date) as oldest_date, MAX(edit_date) as newest_date FROM `yacs_links` AS links WHERE links.anchor LIKE 'category:8'
144: Table './openconsortium/yacs_links' is marked as crashed and last (automatic?) repair failed

SELECT COUNT(*) as count, MIN(edit_date) as oldest_date, MAX(edit_date) as newest_date FROM `yacs_links` AS links WHERE links.anchor LIKE 'category:5'
144: Table './openconsortium/yacs_links' is marked as crashed and last (automatic?) repair failed

SELECT COUNT(*) as count, MIN(edit_date) as oldest_date, MAX(edit_date) as newest_date FROM `yacs_links` AS links WHERE links.anchor LIKE 'category:2'
144: Table './openconsortium/yacs_links' is marked as crashed and last (automatic?) repair failed

SELECT * FROM `yacs_links` AS links WHERE links.anchor LIKE 'category:2' ORDER BY links.edit_date DESC, links.title LIMIT 0,30
144: Table './openconsortium/yacs_links' is marked as crashed and last (automatic?) repair failed