INSERT INTO `databasename`.`wikka-pages-table`
SELECT "" as ID, `pagename` AS `tag`, FROM_UNIXTIME(`lastmodified`) AS `TIME`, `content` AS `body`, "UserName" AS `owner`, "USerName" AS `user`,"Y" AS `latest`, "write a descriptive note" AS `note`, "page" AS `HANDLER`
FROM `erfurt-wiki-table`
WHERE 1
ORDER BY `pagename` ASC , `version` ASC ;