fix export query
@@ -661,7 +661,7 @@ public abstract class CommonSqlStatements implements SqlStatements {
*/
@Override
public String exportContent() {
- return "SELECT * FROM content c "
+ return "SELECT DISTINCT(c.contentId), c.canonicalHash, c.contentHash, c.content FROM content c "
+ "JOIN versions v ON v.contentId = c.contentId "
+ "WHERE v.tenantId = ?";
}
