>>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 DESC