>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 >Exactly. I thought about the same query last night, but it was after I already turned off the computer and didn't want to return back.