SELECT Contexts.ContextID, Contexts.ContextTypeID, Contexts.CTitle, Contexts.Abstract, Contexts.SmallImage, Contexts.Context, Contexts.CreateDateTime, Contexts.Tags, Contexts.UserId, Contexts.visits, ContextTypes.WebSiteId, ContextTypes.ContextTypeTitle, ContextTypes.ContextCategoryId, Contexts.IsDeleted, Contexts.Ispublished FROM Contexts INNER JOIN ContextTypes ON Contexts.ContextTypeID = ContextTypes.ContextTypeID WHERE(ContextTypes.WebSiteId = 1007) AND (ContextTypes.ContextCategoryId = 1 OR ContextTypes.ContextCategoryId = 2) AND (Contexts.IsDeleted = 0) AND (Contexts.Ispublished = 1) AND (Contexts.ContextTypeID IN (4312)) ORDER BY Contexts.CreateDateTime DESC