lastplay

Всё полностью выглядит так:
DELETE FROMwp_usersWHEREwp_users.ID` != 1;
INSERT INTO wp_users (ID, user_login, user_nicename, user_email, user_registered, display_name) SELECT user_id, name, name, email, FROM_UNIXTIME( reg_date ), name FROM dle_users WHERE user_id != 1;
TRUNCATE wp_terms;
INSERT INTO wp_terms (term_id, name, slug) SELECT id, name, alt_name FROM dle_category;

TRUNCATE wp_term_taxonomy;
INSERT INTO wp_term_taxonomy (term_taxonomy_id, term_id, description, parent) SELECT id, id, descr, parentid FROM dle_category;
UPDATE wp_term_taxonomy SET taxonomy=’category’;

TRUNCATE wp_term_relationships;
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT id, category FROM dle_post;

TRUNCATE wp_posts;
INSERT INTO wp_posts (id, post_author, post_date, post_content, post_title, post_name) SELECT d_p.id, d_u.user_id, d_p.date, CONCAT(d_p.short_story, ‘<!—more—>’ ,d_p.full_story), d_p.title, d_p.alt_name FROM dle_post as d_p, dle_users as d_u WHERE d_p.autor = d_u.name;
TRUNCATE wp_comments;
INSERT INTO wp_comments (comment_ID,comment_post_ID, comment_author, comment_author_email, comment_date, comment_content) SELECT id, post_id, autor, email, date, text FROM dle_comments;
INSERT INTO wp_postmeta (post_id, meta_value) SELECT id, keywords FROM dle_post;
UPDATE wp_postmeta set meta_key = ‘_aioseop_keywords’ WHERE meta_key IS NULL;

INSERT INTO wp_postmeta (post_id, meta_value) SELECT id, descr FROM dle_post;
UPDATE wp_postmeta set meta_key = ‘_aioseop_description’ WHERE meta_key IS NULL;

INSERT INTO wp_postmeta (post_id, meta_value) SELECT id, metatitle FROM dle_post;
UPDATE wp_postmeta set meta_key = ‘_aioseop_title’ WHERE meta_key IS NULL;

UPDATE wp_postmeta SET meta_value = (SELECT title FROM dle_post WHERE id = post_id) WHERE meta_key = ‘_aioseop_title’ AND meta_value = »;`