Joomla to WordPress

------ MIGRATING JOOMLA v1.5.# CONTENT TO WORDPRESS v3.2.# ------
------ http://www.joellipman.com/articles/web-development/wordpress/importing-joomla-articles-to-wordpress-posts.html ------

------------ POSTS ------------
 INSERT INTO my_wordpress_db.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,
 CASE state WHEN '1' THEN 'publish' ELSE 'draft' END 'post_status',
 'open' comment_status,
 'open' 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://demo.joellipman.com/wordpress/', '?p=', id) AS guid,
 '0' menu_order,
 'post' AS 'post_type',
 '' post_mime_type,
 0 comment_count
 FROM
 my_joomla_db.jos_content
 ORDER BY
 id

----------- CATEGORIES ----------------
SET @CountCategoriesAlreadyEntered:=(SELECT MAX(term_id) FROM my_wordpress_db.wp_terms);

 INSERT INTO my_wordpress_db.wp_terms
 SELECT
 (a.id + @CountCategoriesAlreadyEntered) 'term_id',
 a.title 'name',
 a.alias 'slug',
 0 'term_group'
 FROM
 my_joomla_db.jos_categories a
 ORDER BY
 a.id;