SELECT IA_ID,IA_Title,IT_ParentID,IA_Content,IA_CreateDate,IA_Author, 'http://'+ia.IA_CityCode+'.edushi.com/bang/info/'+it.IT_ParentPath+'-'+CAST(ia.IT_ID AS VARCHAR(10))+'-n'+CAST(ia.IA_ID as varchar(10))+'.html' AS WebSite,0 AS States FROM dbo.InfoArticle ia WITH (NOLOCK,INDEX=IX_CreateDate) LEFT JOIN dbo.InfoType it WITH (NOLOCK) ON ia.IT_ID = it.IT_ID WHERE 1=1 AND ia.IA_CreateDate BETWEEN '2016-06-01 00:00:00' AND '2016-06-06 00:00:00'