with one
as
(
SELECT
     p.id
    ,d.polename1
    ,p.use_from
    ,p.use_to
    ,p.premession_text
    ,coalesce(use_from,'1') as Permit
    ,row_number() over(
                partition by
                         p.id
                        ,use_from
                        ,use_to
                         order by
                         use_from) as rn


FROM devices as d
left join permitsa as p
)
SELECT



     id
    ,polename1
    ,use_from
    ,use_to
    ,premession_text
    ,CASE
        WHEN use_from<=GETDATE()>=p.use_to THEN 'PERMITTED'
        WHEN Permit=1, THEN 'NEVER'
        ELSE NOT 'PERMITTED'
    END as permitted_text
    ,LAG(Athlete) OVER (PARTITION BY gender
        ORDER BY Year ASC) AS Last_Champion

FROM one
where rn=1