Duplicate enumvalues cause import issues i.e. empty fields, which are difficult to detect due to there are no error messages
This query should be exported as documentation of the values of the four affected enumcategories that the which inactive enumvalues there before and after upgrade scripts wrongly creates inactive values for (NAA 2014-10-07):
<pre>
SELECT DISTINCT