SELECT TOP 3 Event.Title, Event.Url, Event.NoProvince, Province.Code, Event.City, Event.Date, Event.NoCompany, Company.Title AS Company, Event.Url, Event.NoAlbum, Album.Url AS AlbumUrl, F.PhotoCount FROM Event (NOLOCK) LEFT JOIN Province ON Event.NoProvince = Province.Numero LEFT JOIN Company ON Event.NoCompany = Company.Numero INNER JOIN Album ON Event.NoAlbum = Album.Numero INNER JOIN ( SELECT Photo.NoAlbum, COUNT(*) as PhotoCount FROM Photo GROUP BY Photo.NoAlbum ) F ON F.NoAlbum = Album.Numero WHERE Event.NoSite = @NoSite AND Event.NoAlbum > @NoAlbum AND F.PhotoCount >= 7 ORDER BY Event.Date DESC