Change Details

This is probably one of the bigger offenders with the parent task. Take, for example the enwiki preference statistics, taken today: {P5802} The **only** valid values here are monobook, vector, cologneblue, modern and the various minervas (which should be merged, see {T171644}). After solving the subtask, we could run the following query on all wikis: ``` lang=sql DELETE FROM user_properties WHERE up_property = 'skin' AND up_value NOT IN ('monobook', 'vector', 'cologneblue', 'modern', 'minerva'); /* Or whatever minerva's correct name should be */ ```

This is probably one of the bigger offenders with the parent task. Take, for example the enwiki preference statistics, taken today: {P5802} The **only** valid values here are monobook, vector, cologneblue, modern and the various minervas (which should be merged, see {T171644}). After solving the subtask, we could run the following query on all wikis: ``` lang=sql DELETE FROM user_properties WHERE up_property = 'skin' AND up_value NOT IN ('vector', 'monobook', 'minervaneue', 'minerva', 'timeless', 'modern', 'cologneblue', '0', '2'); ```

This is probably one of the bigger offenders with the parent task. Take, for example the enwiki preference statistics, taken today: {P5802} The **only** valid values here are monobook, vector, cologneblue, modern and the various minervas (which should be merged, see {T171644}). After solving the subtask, we could run the following query on all wikis: ``` lang=sql DELETE FROM user_properties WHERE up_property = 'skin' AND up_value NOT IN (''vector', 'monobook'', 'minervaneue', 'vector''minerva', 'cologneblue''timeless', 'modern', 'cologneblue', 'minerva');'0', /* Or whatever minerva's correct name should be */'2'); ```