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