Comment 3 for bug 1515929

Revision history for this message
Robert Lyon (robertl-9) wrote :

Actually a slightly better sql query to find the duplicated user custom layouts:

  SELECT * FROM usr_custom_layout WHERE usr IN (SELECT usr FROM usr_custom_layout WHERE usr IS NOT NULL GROUP BY usr, layout HAVING COUNT(*) > 1) ORDER BY usr, layout;

This will ony return the places where there are duplication