SELECT 1
from smth
CROSS APPLY (SELECT TOP (1)
    1
  FROM dbo.point_plugins ppp
  WHERE ppp.addendum_id = pa.addendum_id
    AND ppp.active_from < @date_to
    AND COALESCE(ppp.active_to, @max_date) > @date_to
  ORDER BY ppp.active_from DESC
    ,COALESCE(ppp.active_to, @max_date) DESC
    ,ppp.point_plugin_id DESC
  UNION
  SELECT TOP (1)
  	1
  FROM dbo.point_plugins ppp1  
  WHERE ppp1.addendum_id = pa.addendum_id
    AND NOT EXISTS(SELECT 1
      FROM dbo.point_plugins ppp
      WHERE ppp.addendum_id = pa.addendum_id
        AND ppp.active_from < @date_to
        AND COALESCE(ppp.active_to, @max_date) > @date_from)
  ORDER BY ppp1.active_from DESC
    ,COALESCE(ppp1.active_to, @max_date) DESC
    ,ppp1.point_plugin_id DESC
) pp