I have the following but I thought there would be a way to make it simpler:
DECLARE @NoSite Integer
DECLARE @NoAlbum Integer
SET @NoSite=2
SET @NoAlbum=0
SELECT TOP 3 Temp.Title,Temp.Url,Temp.NoProvince,Temp.Code,Temp.City,Temp.Date,Temp.NoCompany,
Temp.Company,Temp.Url,Temp.NoAlbum,Temp.AlbumUrl
FROM
(SELECT Event.Title,Event.Url,Event.NoProvince,Province.Code,Event.City,Event.Date,Event.NoCompany,
Company.Title AS Company,Event.NoAlbum,Album.Url AS AlbumUrl,
(SELECT COUNT(*) FROM Photo WHERE Album.Numero=Photo.NoAlbum) AS 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
WHERE Event.NoSite=@NoSite AND Event.NoAlbum>@NoAlbum) Temp
WHERE Temp.PhotoCount>=7
ORDER BY Date DESC
