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 upgrade script scripts wrongly creates duplicates inactive values for (This might be fixed now/NAA 2014-10-07):
<pre>
SELECT DISTINCT