SELECT dbo.tblArticles.articleTitle, dbo.tblArticles.articleDate, dbo.tblArticles.body, dbo.tblArticles.bylineID, dbo.tblArticles.picture1, dbo.tblArticles.picture2, dbo.tblArticleBylines.bylineName, dbo.tblArticleBylines.company, dbo.tblArticleBylines.email, dbo.tblImages.filename, dbo.tblImages.width, dbo.tblImages.height, tblImages_1.filename AS filename1, tblImages_1.width AS width1, tblImages_1.height AS height1, tblArticles.issueID, tblArticleIssues.currentIssue, tblArticleCategories.category, tblArticles.categoryID FROM dbo.tblArticles LEFT OUTER JOIN dbo.tblArticleBylines ON dbo.tblArticles.bylineID = dbo.tblArticleBylines.bylineID LEFT OUTER JOIN dbo.tblImages tblImages_1 ON dbo.tblArticles.picture2 = tblImages_1.imageID LEFT OUTER JOIN dbo.tblImages ON dbo.tblArticles.picture1 = dbo.tblImages.imageID LEFT JOIN tblArticleIssues ON tblArticles.issueID = tblArticleIssues.issueID LEFT JOIN tblArticleCategories ON tblArticles.categoryID = tblArticleCategories.categoryID WHERE dbo.tblArticles.articleID = SELECT dbo.tblArticleRelated.related, dbo.tblArticles.articleID, dbo.tblArticles.articleTitle, tblArticleCategories.category FROM dbo.tblArticleRelated INNER JOIN dbo.tblArticles ON dbo.tblArticleRelated.related = dbo.tblArticles.articleID LEFT JOIN tblArticleCategories ON tblArticles.categoryID = tblArticleCategories.categoryID WHERE dbo.tblArticleRelated.articleID =

Credit Today Articles

#articleTitle# By #bylineName#	#category# - Issue Date: #dateformat(articleDate)#
#body#
About the author:

Name:	#bylineName#
Company:	#company#
Email:	#email#
Related Articles:
#related.currentRow#. #articleTitle#

?#urldecode(listlast(session.ref, "^"))#">