select  t1.userid,t1.id,t1.title,t1.RegType,t1.Salary,t1.SubjectID,t1.RefreshTime,t2.name,t2.logo,t2.[address],t2.CreateTime

    from info t1 inner join

    companyinfo t2 on t1.userid=t2.id

    where t1.id in

    (

        select top 1 info.id from info where userid = t1.userid order by refreshtime desc

    )

    and t1.userid in

    (

        select  distinct userid from PackageRecord where PackagePid=1 and getdate()<endtime

    )