select 'News Center' as st,title as stitle,title as sstitle,content as stitles,'news_details_'+cast(id as varchar(max))+'.html' as slinks from tb_news_en  

union all

 select 'Quality' as st,'Quality Control Framework' as stitle,'Quality Control Framework' as sstitle,content as stitles,'quality.html' as slinks from tb_info_en where id=61  

union all 

select top 1 'Quality' as st,'Quality Process Control' as stitle,'Quality Process Control' as sstitle,content as stitles,'quality_control.html' as slinks from tb_info_en where id=73

union all 

select top 1 'Quality' as st,'Quality System Certification' as stitle,'Quality System Certification' as sstitle,files_name+'    等' as stitles,'quality_auth.html' as slinks from tb_quality_auth_en   

union all 

select top 1 'Quality' as st,'Quality Harmful Control' as stitle,'Quality Harmful Control' as sstitle,files_name+'    等' as stitles,'quality_harmful.html' as slinks from tb_quality_harmful_en   

union all

select 'Bidding' as st,t.name as stitle,t.name as sstitle,tt.title as stitles,'tender_'+cast(tt.type_id as varchar(max))+'.html' as slinks from tb_tender_type_en t inner join tb_tender_en tt on t.id=tt.type_id   

union all 

select 'About Us' as st,menu as stitle,menu as sstitle,name as stitles,'about.html' as slinks from tb_info_en where id=62   

union all 

select 'About Us' as st,menu as stitle,menu as sstitle,name as stitles,'organization.html' as slinks from tb_info_en where id=63   

union all 

select 'About Us' as st,'Development History（'+title+'）' as stitle,content as sstitle,content as stitles,'history.html' as slinks from tb_history_en    

union all 

select top 1 'About Us' as st,'Production Base' as stitle,'Production Base' as sstitle,title+'    等' as stitles,'factory.html' as slinks from tb_factory_en   

union all 

select 'About Us' as st,'Application Area' as stitle,'Application Area' as sstitle,name as stitles,'market.html' as slinks from tb_market_en   

union all 

select 'About Us' as st,'Galaxy Honor' as stitle,'Galaxy Honor' as sstitle,intro as stitles,'honor.html' as slinks from tb_honor_en  

union all 

select 'About Us' as st,'Major Customers' as stitle,'Major Customers' as sstitle,title as stitles,'customer.html' as slinks from tb_customer_en   

union all 

select 'IRM' as st,'Periodic Report' as stitle,'Periodic Report' as sstitle,intro as stitles,'report_'+type_id+'.html' as slinks from tb_report_en   

union all 

select 'IRM' as st,'Company Announcement' as stitle,'Company Announcement' as sstitle,intro as stitles,'notice.html' as slinks from tb_notice_en   

union all 

select 'IRM' as st,'Stock Trend' as stitle,'Stock Trend' as sstitle,'Stock Trend' as stitles,'stock.html' as slinks    

union all 

select 'Contact Us' as st,'Contacts' as stitle,'Contacts' as sstitle,'Contacts' as stitles,'contact.html' as slinks   

union all 

select 'Contact Us' as st,'Feedback' as stitle,'Feedback' as sstitle,'Feedback' as stitles,'feedback.html' as slinks   

union all 

select 'Contact Us' as st,'Recruitment' as stitle,'Recruitment' as sstitle,'Recruitment' as stitles,'hr.html' as slinks