Search: clickhouse memory limit exceeded query fix

Public search query: clickhouse memory limit exceeded query fix

Problem outcome: unknown