WITH tbl1 AS (
  SELECT
    channel,
    id,
    full_date,
    efir_date,
    efir_time,
    type,
    program_id,
    program_smi,
    name,
    duratel,
    TLN_PLAYRUN
  FROM
    [dbo].[broadcast_out_rm_2023_KS_view]
  WHERE
    (
      TLN_PLAYRUN = '1'
      AND type = 'Программа'
      AND convert(
        varchar(10),
        efir_date,
        102
      ) >= (
        DATEADD(
          DAY,
          -31,
          convert(
            varchar(10),
            getdate(),
            102
          )
        )
      )
    )
)
LEFT JOIN [dbo].[bv_dealcontent_view] ON tbl1.program_id = bv_dealcontent_view.prog_id