select pr.ID,pr.TITLE,rpdu.DESTINATION,rpdu.SIGNALTYPE, sp.id as ID_SP, sp.SUBDIVISION,
	 CASE WHEN spr.ID is NULL THEN CAST(0 as BIT) ELSE CAST(1 AS BIT) END PrPresent
    from [MSK-DB1].[Qlik_tsdb].[dbo].[Program] pr
          inner join [MSK-DB1].[Qlik_tsdb].[dbo].[REPORT_BROADCASTING] br on br.PROGRAM_ELID = pr.ELID
		  inner join [MSK-DB1].[Qlik_tsdb].[dbo].[REPORT_HARDWARE_RPDU] rpdu on rpdu.DEVICE_ELID = br.TRANSMITTER_ELID
		  inner join [MSK-DB1].[Qlik_tsdb].[dbo].[REPORT_HARDWARE] h on h.ELID = rpdu.DEVICE_ELID
		  inner join [MSK-DB1].[Qlik_tsdb].[dbo].[setupplace] sp on sp.ID = h.ID_SETUPPLACE
		  left outer join [dbo].[signal_program] spr on spr.ID_PROGRAM = pr.ID and spr.ID_FILIAL = @pID_FILIAL and spr.[STATUS] = 1 and spr.ID_SP = sp.ID
    where sp.ID_FILIAL = @pID_FILIAL and rpdu.SIGNALTYPE = 'аналоговый' and pr.id = @pID_PROGRAM and UPPER(rpdu.DESTINATION) = @pDEST
    order by sp.SUBDIVISION