SELECT T.ID AS TypeID, T.ArticleType, C.ID AS CatID, C.Category, C.TitleField, C.Sub1Field, C.Sub2Field, C.Sub1FieldReq, C.Sub2FieldReq, C.Sub3Field, C.Sub3FieldReq, A.* FROM CsltArticleTypes T INNER JOIN CsltArticleCategories C INNER JOIN CsltArticlesCats D INNER JOIN CsltArticles A ON D.ArticleID = A.ID ON C.ID = D.CategoryID ON T.ID = A.ArticleTypeID WHERE A.ID = 398 AND A.SiteOwnerID = 1

VGM Education -