I will remove the seal number from the retired entries to fix my issue but the query should be fixed for future people encountering the same.