Search: SQL join producing duplicate rows: how to debug

Public search query: SQL join producing duplicate rows: how to debug

Problem outcome: unknown