string SelectString = "SELECT Web_Article.ID, Web_SubWebInfo.SubWebName, Web_Space.Name, Web_Article.Title, Web_Article.Remark, CASE Web_Article.IsIndex WHEN '1' THEN 'is' WHEN '0' THEN 'No' END AS IsIndex, CASE Web_Article.Passed WHEN '1' THEN 'is' WHEN '0' THEN 'No' END AS Passed, Web_Article.PublicTime FROM Web_Article CROSS JOIN Web_Space INNER JOIN Web_SubWebInfo ON Web_Article.SubWebID = Web_SubWebInfo.ID AND Web_Article.SpaceID = Web_Space.ID WHERE Web_Article.SpaceId = 13 and Web_Article.subWebid <= 2 Order by Web_Article.id;
