HomeContact UsSite Map 繁體 简体
SELECT a.SiteMapID, a.SiteMapName, NASiteMapLC.NewSiteMapName, a.URL, a.NewWin, a.SiteMapNo,a.SitemapLevel FROM (SELECT SiteMapID, SiteMapName, URL, NewWin, SiteMapNo,SitemapLevel FROM NASiteMap WHERE (SiteMapNo LIKE (SELECT Left(SiteMapNo,8) as siteroot FROM NASiteMap WHERE (SiteMapID = N'{2795602A-AB6F-4B15-BB63-76D6164122FC}')) + '%') AND (MenuBarHidden = 0)) a LEFT OUTER JOIN NASiteMapLC ON a.SiteMapID = NASiteMapLC.SiteMapID AND ISNULL(NASiteMapLC.LCID, 'EN') = N'EN' WHERE (LEN(a.SiteMapNo) >=8) AND (LEN(a.SiteMapNo) <= 16) AND ISNULL(NASiteMapLC.Display, 1) = 1ORDER BY a.SitemapLevel
SELECT a.SiteMapID, a.SiteMapName, NASiteMapLC.NewSiteMapName, a.URL, a.NewWin, a.SiteMapNo,a.SitemapLevel FROM (SELECT SiteMapID, SiteMapName, URL, NewWin, SiteMapNo,SitemapLevel FROM NASiteMap WHERE (SiteMapNo LIKE (SELECT Left(SiteMapNo,8) as siteroot FROM NASiteMap WHERE (SiteMapID = N'{6B97994D-AA1B-45EE-BA66-A9B7175B1018}')) + '%') AND (MenuBarHidden = 0)) a LEFT OUTER JOIN NASiteMapLC ON a.SiteMapID = NASiteMapLC.SiteMapID AND ISNULL(NASiteMapLC.LCID, 'EN') = N'EN' WHERE (LEN(a.SiteMapNo) >=8) AND (LEN(a.SiteMapNo) <= 16) AND ISNULL(NASiteMapLC.Display, 1) = 1ORDER BY a.SitemapLevel
SELECT a.SiteMapID, a.SiteMapName, NASiteMapLC.NewSiteMapName, a.URL, a.NewWin, a.SiteMapNo,a.SitemapLevel FROM (SELECT SiteMapID, SiteMapName, URL, NewWin, SiteMapNo,SitemapLevel FROM NASiteMap WHERE (SiteMapNo LIKE (SELECT Left(SiteMapNo,8) as siteroot FROM NASiteMap WHERE (SiteMapID = N'{9B65220A-A9F5-4FD0-BE0B-9C48380319E4}')) + '%') AND (MenuBarHidden = 0)) a LEFT OUTER JOIN NASiteMapLC ON a.SiteMapID = NASiteMapLC.SiteMapID AND ISNULL(NASiteMapLC.LCID, 'EN') = N'EN' WHERE (LEN(a.SiteMapNo) >=8) AND (LEN(a.SiteMapNo) <= 16) AND ISNULL(NASiteMapLC.Display, 1) = 1ORDER BY a.SitemapLevel
SELECT a.SiteMapID, a.SiteMapName, NASiteMapLC.NewSiteMapName, a.URL, a.NewWin, a.SiteMapNo,a.SitemapLevel FROM (SELECT SiteMapID, SiteMapName, URL, NewWin, SiteMapNo,SitemapLevel FROM NASiteMap WHERE (SiteMapNo LIKE (SELECT Left(SiteMapNo,8) as siteroot FROM NASiteMap WHERE (SiteMapID = N'{D489D74A-9DFC-4202-A79C-9C4D7E44F8A4}')) + '%') AND (MenuBarHidden = 0)) a LEFT OUTER JOIN NASiteMapLC ON a.SiteMapID = NASiteMapLC.SiteMapID AND ISNULL(NASiteMapLC.LCID, 'EN') = N'EN' WHERE (LEN(a.SiteMapNo) >=8) AND (LEN(a.SiteMapNo) <= 16) AND ISNULL(NASiteMapLC.Display, 1) = 1ORDER BY a.SitemapLevel
SELECT a.SiteMapID, a.SiteMapName, NASiteMapLC.NewSiteMapName, a.URL, a.NewWin, a.SiteMapNo,a.SitemapLevel FROM (SELECT SiteMapID, SiteMapName, URL, NewWin, SiteMapNo,SitemapLevel FROM NASiteMap WHERE (SiteMapNo LIKE (SELECT Left(SiteMapNo,8) as siteroot FROM NASiteMap WHERE (SiteMapID = N'{A17AF7A5-D646-4D24-A68D-3ADC06A07A1B}')) + '%') AND (MenuBarHidden = 0)) a LEFT OUTER JOIN NASiteMapLC ON a.SiteMapID = NASiteMapLC.SiteMapID AND ISNULL(NASiteMapLC.LCID, 'EN') = N'EN' WHERE (LEN(a.SiteMapNo) >=8) AND (LEN(a.SiteMapNo) <= 16) AND ISNULL(NASiteMapLC.Display, 1) = 1ORDER BY a.SitemapLevel
SELECT a.SiteMapID, a.SiteMapName, NASiteMapLC.NewSiteMapName, a.URL, a.NewWin, a.SiteMapNo,a.SitemapLevel FROM (SELECT SiteMapID, SiteMapName, URL, NewWin, SiteMapNo,SitemapLevel FROM NASiteMap WHERE (SiteMapNo LIKE (SELECT Left(SiteMapNo,8) as siteroot FROM NASiteMap WHERE (SiteMapID = N'{61323268-90CB-48AD-B796-8F43F30A1BEA}')) + '%') AND (MenuBarHidden = 0)) a LEFT OUTER JOIN NASiteMapLC ON a.SiteMapID = NASiteMapLC.SiteMapID AND ISNULL(NASiteMapLC.LCID, 'EN') = N'EN' WHERE (LEN(a.SiteMapNo) >=8) AND (LEN(a.SiteMapNo) <= 16) AND ISNULL(NASiteMapLC.Display, 1) = 1ORDER BY a.SitemapLevel
SELECT a.SiteMapID, a.SiteMapName, NASiteMapLC.NewSiteMapName, a.URL, a.NewWin, a.SiteMapNo,a.SitemapLevel FROM (SELECT SiteMapID, SiteMapName, URL, NewWin, SiteMapNo,SitemapLevel FROM NASiteMap WHERE (SiteMapNo LIKE (SELECT Left(SiteMapNo,8) as siteroot FROM NASiteMap WHERE (SiteMapID = N'{CA945DA2-00DD-4F56-961C-5FC644B08181}')) + '%') AND (MenuBarHidden = 0)) a LEFT OUTER JOIN NASiteMapLC ON a.SiteMapID = NASiteMapLC.SiteMapID AND ISNULL(NASiteMapLC.LCID, 'EN') = N'EN' WHERE (LEN(a.SiteMapNo) >=8) AND (LEN(a.SiteMapNo) <= 16) AND ISNULL(NASiteMapLC.Display, 1) = 1ORDER BY a.SitemapLevel
SELECT a.SiteMapID, a.SiteMapName, NASiteMapLC.NewSiteMapName, a.URL, a.NewWin, a.SiteMapNo,a.SitemapLevel FROM (SELECT SiteMapID, SiteMapName, URL, NewWin, SiteMapNo,SitemapLevel FROM NASiteMap WHERE (SiteMapNo LIKE (SELECT Left(SiteMapNo,8) as siteroot FROM NASiteMap WHERE (SiteMapID = N'{881D5498-4162-4FE7-81B7-7449F3CB77BD}')) + '%') AND (MenuBarHidden = 0)) a LEFT OUTER JOIN NASiteMapLC ON a.SiteMapID = NASiteMapLC.SiteMapID AND ISNULL(NASiteMapLC.LCID, 'EN') = N'EN' WHERE (LEN(a.SiteMapNo) >=8) AND (LEN(a.SiteMapNo) <= 16) AND ISNULL(NASiteMapLC.Display, 1) = 1ORDER BY a.SitemapLevel
SELECT a.SiteMapID, a.SiteMapName, NASiteMapLC.NewSiteMapName, a.URL, a.NewWin, a.SiteMapNo,a.SitemapLevel FROM (SELECT SiteMapID, SiteMapName, URL, NewWin, SiteMapNo,SitemapLevel FROM NASiteMap WHERE (SiteMapNo LIKE (SELECT Left(SiteMapNo,8) as siteroot FROM NASiteMap WHERE (SiteMapID = N'{33DC83EC-2D34-4E90-BB9E-D69AA9970EC0}')) + '%') AND (MenuBarHidden = 0)) a LEFT OUTER JOIN NASiteMapLC ON a.SiteMapID = NASiteMapLC.SiteMapID AND ISNULL(NASiteMapLC.LCID, 'EN') = N'EN' WHERE (LEN(a.SiteMapNo) >=8) AND (LEN(a.SiteMapNo) <= 16) AND ISNULL(NASiteMapLC.Display, 1) = 1ORDER BY a.SitemapLevel


 

Sitemap

Products

 
News Room

 
Investor Relations
- Monthly Sales
- Quarterly Report
- Annual Report
- Stock Information
- Analyst Coverage
- Monthly sales
- Quarterly Earning release
- Presentation at Seminars
- Annual General Meeting



Careers

 
About Novatek

 
Foundation





  Copyright © 2000-2010 Novatek Microelectronics Corp. All Rights Reserved.
  Terms of UsePrivacy