Joomla!2WP

INSERT INTO wordpressdb.wp_posts
 SELECT
     id 'ID',
     1 'post_author',
     created 'post_date',
     created 'post_date_gmt',
     CONCAT(introtext, ' ', `fulltext`) 'post_content',
     title 'post_title',
     '' post_excerpt,
     'publish' post_status,
     'closed' comment_status,
     'closed' ping_status,
     '' post_password,
     alias 'post_name',
     '' to_ping,
     '' pinged,
     modified 'post_modified',
     modified 'post_modified_gmt',
     '' post_content_filtered,
     '0' post_parent,
     CONCAT('http://www.mysite.gr/', '?p=', id) AS guid,
     '0' menu_order,
     'post' AS 'post_type',
     '' post_mime_type,
     0 comment_count
 FROM
     joomladb.jos_content AS b
 ORDER BY
     id;

------ ΕΝΑ ΕΝΑ ΞΕΧΩΡΙΣΤΑ ΤΑ QUERY ---------------------------------------

 INSERT INTO wordpressdb.wp_terms
 SELECT
     c.id 'object_id',
     -- TO ID ΤΗΣ ΚΑΤΗΓΟΡΙΑΣ ΤΟΥ ΝΕΟΥ SITE, ΣΤΟ ΟΠΟΙΟ ΘΑ ΠΕΡΑΣΩ ΤΑ ΑΡΘΡΑ, ΠΧ ΑΣ ΠΟΥΜΕ ΕΔΩ 69 --
     69 'term_taxonomy_id',
     0 'term_order'
 FROM
    joomladb.jos_content c;