mantis_to_traccsvimport_sql_query

select t.category as type, t.date_submitted as time, t.last_updated as changetime, p.name as component, t.severity as severity, t.priority as priority, o.username as owner, u.username as reporter, '' as cc, '' as url, t.version as version, 'Pending' as milestone, t.status as status, t.resolution as resolution, t.summary as summary, HEX(tt.description) as decription, '' as keywords from mantis_bug_table as t INNER JOIN mantis_user_table as u ON u.id = t.reporter_id LEFT JOIN mantis_project_table as p ON p.id = t.project_id LEFT JOIN mantis_user_table as o ON o.id = t.handler_id LEFT JOIN mantis_bug_text_table as tt ON tt.id = t.bug_text_id INTO OUTFILE '/tmp/mantistestshit3.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';