SELECT n.ID, n.CatID, n.Headline, n.Description, n.ImageUrl, n.Tags, c.ContentDesk, n.Posted, c.CategoryName, c.XCode FROM CmsNews AS n INNER JOIN CmsCategory AS c ON n.CatID = c.CatID WHERE (n.Status = 1) AND (c.XCode LIKE N'giaiphap%') ORDER BY n.Posted DESC;xcode=giaiphap;catid=0