>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 >CROSS APPLY (SELECT COUNT(*) as PhotoCount FROM Photo WHERE Album.Numero=Photo.NoAlbum) F > WHERE Event.NoSite=@NoSite AND Event.NoAlbum>@NoAlbum > AND F.PhotoCount >=7 > ORDER BY Event.Date DESCAS PhotoCount resolves it. Thanks