>DECLARE @NoSite Integer >DECLARE @NoSite2 Integer >DECLARE @Enabled Bit >DECLARE @NoSite3 Integer >DECLARE @Enabled2 Bit >DECLARE @NoSite4 Integer >DECLARE @Enabled3 Bit >DECLARE @NoSite5 Integer >DECLARE @NoSite6 Integer > >SET @NoSite=2 >SET @NoSite2=2 >SET @Enabled=1 >SET @NoSite3=2 >SET @Enabled2=1 >SET @NoSite4=2 >SET @Enabled3=1 >SET @NoSite5=2 >SET @NoSite6=2 > >SELECT TOP 40 News.Title_E,News.Title_F,News.Url,News.AddDate AS Date,News.Url2,1 AS Type, >News.NoSite,'' AS Title2 >FROM News WHERE News.NoSite=@NoSite >UNION >SELECT TOP 40 Event.Title AS Title_E,Event.Title AS Title_F,Event.Url,Event.AddDate AS Date, >convert(char(74),'') AS Url2,2 AS Type,Event.NoSite,'' AS Title2 >FROM Event >LEFT JOIN Province ON Event.NoProvince=Province.Numero >WHERE Event.NoSite=@NoSite2 AND Event.Enabled=@Enabled >>