WordPress database error: [Incorrect key file for table 'wp_post2cat'; try to repair it]
SELECT DISTINCT post_id, cat_ID FROM wp_categories, wp_post2cat WHERE category_id = cat_ID AND post_id IN (610,609,608,607)

WordPress database error: [Incorrect key file for table 'wp_post2cat'; try to repair it]
# sem_theme_init SELECT categories.*, COUNT( DISTINCT post2cat.post_id ) as num_posts FROM wp_categories AS categories INNER JOIN wp_post2cat AS post2cat ON post2cat.category_id = categories.cat_ID INNER JOIN wp_posts AS posts ON posts.ID = post2cat.post_id WHERE posts.post_status = 'publish' AND posts.post_date_gmt <= '2010-03-11 22:51:59' AND ( categories.cat_name REGEXP '^(blog|archives|buzz|gallery|resources|links|projects|downloads|solutions|services|about|contact|legal)$' OR categories.category_nicename REGEXP '^(blog|archives|buzz|gallery|resources|links|projects|downloads|solutions|services|about|contact|legal|home|sidebar|highlights)$' ) GROUP BY cat_ID HAVING num_posts > 0