SELECT
a.siteid,
a.sitename,
s.viewcount,
s.latestViewTime,
a.SiteUrl,
a.StaffName
from AdInfo as a
inner join (select SiteID, count(*) as viewcount, max(ViewTime) as latestViewTime from ViewLog group by SiteID) as s
on s.SiteID = a.siteid
a.siteid,
a.sitename,
s.viewcount,
s.latestViewTime,
a.SiteUrl,
a.StaffName
from AdInfo as a
inner join (select SiteID, count(*) as viewcount, max(ViewTime) as latestViewTime from ViewLog group by SiteID) as s
on s.SiteID = a.siteid