Get the list of Template Fields which are corrupt (Shared, Unversioned)

listTemplateFieldsList.sql

SELECT DISTINCT fieldid
FROM   versionedfields
WHERE  fieldid IN (SELECT [itemid]
                   FROM   sharedfields s
                   WHERE  s.fieldid = '{BE351A73-FCB0-4213-93FA-C302D8AB4F51}'
                          AND s.value = '1'
                   UNION
                   SELECT [itemid]
                   FROM   sharedfields s
                   WHERE  s.fieldid = '{39847666-389D-409B-95BD-F2016F11EED5}'
                          AND s.value = '1')
UNION
SELECT DISTINCT fieldid
FROM   sharedfields
WHERE  fieldid IN (SELECT id
                   FROM   items
                   WHERE  templateid = '{455A3E98-A627-4B40-8035-E683A0331AC7}'
                   EXCEPT
                   SELECT DISTINCT [itemid]
                   FROM   sharedfields s
                   WHERE  s.fieldid = '{BE351A73-FCB0-4213-93FA-C302D8AB4F51}'
                          AND s.value = '1')
UNION
SELECT DISTINCT fieldid
FROM   unversionedfields
WHERE  fieldid IN (SELECT [itemid]
                   FROM   sharedfields s
                   WHERE  s.fieldid = '{BE351A73-FCB0-4213-93FA-C302D8AB4F51}'
                          AND s.value = '1')
UNION
SELECT DISTINCT fieldid
FROM   unversionedfields
WHERE  fieldid IN (SELECT id
                   FROM   items
                   WHERE  templateid = '{455A3E98-A627-4B40-8035-E683A0331AC7}'
                   EXCEPT
                   SELECT DISTINCT [itemid]
                   FROM   sharedfields s
                   WHERE  s.fieldid = '{39847666-389D-409B-95BD-F2016F11EED5}'
                          AND s.value = '1')