---

WHERE 1 = 1

  AND NULLIF(:date_to, '') IS NOT NULL

  AND TO_DATE(:date_to, 'DD.MM.YYYY') BETWEEN b.start_date AND b.end_date

  AND TO_DATE(:date_to, 'DD.MM.YYYY') BETWEEN ish.begin_date
      AND COALESCE(ish.end_date, CAST('infinity' AS timestamp))

  AND (
      NULLIF(:schema_index, '') IS NULL
      OR ps.id = CAST(NULLIF(:schema_index, '') AS integer)
  )

  AND (
      NULLIF(:strategy, '') IS NULL
      OR s.id = CAST(NULLIF(:strategy, '') AS bigint)
  )