cat jawiki-latest-abstract.xml | sed -e ‘/<sublink.*<\/sublink>/D’ | sed -e ‘/^<links/D’ | sed -e ‘/<\/links/D’ | sed -e ‘/^<url/D’ | sed -e ‘/^<doc/D’ | sed -e ‘/^<\/doc/D’ | sed -e ‘s/<title>Wikipedia: /<title>/’ | sed -e ‘s/<title>/INSERT INTO wiki (title ,abstract) VALUES ("/’ | sed -e ‘s/<\/title>/", /’ | sed -e ‘s/<abstract>/"/’ | sed -e ‘s/<\/abstract>/");/’ > sql.xml
</html>