>What about:
>
>

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

I hope CROSS APPLY results in the same query, but this way it's explicit and simple enough.