# comment
INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_content,
comment_date, comment_date_gmt, comment_author_email, comment_author_url,
comment_author, comment_author_IP)
SELECT XXX+id, YYY+article_id, normalized_text, DATE, DATE + INTERVAL - 16 HOUR,
user_email, user_url, user_name, client_ip FROM plog_articles_comments
 
# post
INTO wp_posts (ID, post_author, post_date, post_date_gmt, post_modified,
post_modified_gmt, comment_count)
SELECT YYY+id, 2, DATE, DATE + INTERVAL - 16 HOUR, DATE,
DATE + INTERVAL - 16 HOUR, num_comments FROM plog_articles
 
UPDATE wp_posts, plog_articles_text
SET wp_posts.post_title = plog_articles_text.topic
WHERE wp_posts.ID = plog_articles_text.id + YYY
 
UPDATE wp_posts, plog_articles_text
SET wp_posts.post_content = plog_articles_text.TEXT
WHERE wp_posts.ID = plog_articles_text.id + YYY
 
# fill out guid
UPDATE wp_posts
SET wp_posts.guid = CONCAT("<a href="http://www.YourDomain.com/blog/archives/">http://www.YourDomain.com/blog/archives/</a>", wp_posts.ID)
WHERE wp_posts.guid = ""
 
# clean out [@more@]
UPDATE wp_posts SET post_content=REPLACE(post_content,'[@more@]',"");