SELECT *,FlashNews.Language, FlashNews.BeginDate, FlashNews.EndDate, FlashNews.Priority, FlashNews.Pages,FlashNews.CountView FROM FlashNews WHERE (((FlashNews.Language)='#Language#') AND ((FlashNews.BeginDate)<= GetDate()) AND ((FlashNews.EndDate) > GetDate()) AND ((FlashNews.Pages) Like '%#LocalScript_Name#%') AND ((FlashNews.Status)=1)) and align='right' ORDER BY FlashNews.Priority DESC SELECT top 1 NavImu,Navmetatit#language# as Navmetatit,Navmetades#language# as Navmetades,Navmetakey#language# as Navmetakey,navpagename,NavLevel1#language# as NavLevel1xx,NavLevel2#language# as NavLevel2xx,NavLevel3#language# as NavLevel3xx,NavLevel4#language# as NavLevel4xx, Navurl1#language# as Navurl1xx,Navurl2#language# as Navurl2xx,Navurl3#language# as Navurl3xx,Navurl4#language# as Navurl4xx, NavLevel1,NavLevel2,NavLevel3,NavLevel4 FROM NavigationPF WHERE NavPageName= '#xpagesave#' SELECT top 1 NavImu,Navmetatit#language# as Navmetatit,Navmetades#language# as Navmetades,Navmetakey#language# as Navmetakey,navpagename,NavLevel1#language# as NavLevel1xx,NavLevel2#language# as NavLevel2xx,NavLevel3#language# as NavLevel3xx,NavLevel4#language# as NavLevel4xx, Navurl1#language# as Navurl1xx,Navurl2#language# as Navurl2xx,Navurl3#language# as Navurl3xx,Navurl4#language# as Navurl4xx, NavLevel1,NavLevel2,NavLevel3,NavLevel4 FROM NavigationPF WHERE NavLevel1 = #xlevel1# and NavLevel2 = #xlevel2# and NavLevel3 = #xlevel3# and NavLevel4 = #xlevel4# SELECT TOP 1 Redirect#Language# as Redirect FROM Pages WHERE (Page = '#Page#') " & ""> SELECT top 1 navpagename,navimu FROM NavigationPF WHERE NavLevel1 = #GetNavigation.NavLevel1# and NavLevel2 = 0 and NavLevel3 = 0 and NavLevel4 = 0 " & ""> " & ""> SELECT top 1 navpagename,navimu FROM NavigationPF WHERE NavLevel1 = #GetNavigation.NavLevel1# and NavLevel2 = #GetNavigation.NavLevel2# and NavLevel3 = 0 and NavLevel4 = 0 " & ""> " & ""> SELECT top 1 navpagename,navimu FROM NavigationPF WHERE NavLevel1 = #GetNavigation.NavLevel1# and NavLevel2 = #GetNavigation.NavLevel2# and NavLevel3 = #GetNavigation.NavLevel3# and NavLevel4 = 0 " & ""> " & ""> SELECT top 1 navpagename,navimu FROM NavigationPF WHERE NavLevel1 = #GetNavigation.NavLevel1# and NavLevel2 = #GetNavigation.NavLevel2# and NavLevel3 = #GetNavigation.NavLevel3# and NavLevel4 = #GetNavigation.NavLevel4# " & ""> " & ""> ">
>","")>#xbreadcrum#