SELECT p.id, p.title, p.body, p.posted, p.morebody, p.username, p.allowcomments, p.released, p.alias FROM #variables.tableprefix#BlogEntries p WHERE p.blog = SELECT c.name, c.email, c.comment, c.posted as commentPosted, c.website FROM #variables.tableprefix#BlogComments c WHERE entryidfk = SELECT c.categoryname, l.categoryidfk FROM #variables.tableprefix#BlogEntriesCategories l LEFT OUTER JOIN #variables.tableprefix#BlogCategories c ON l.categoryidfk = c.categoryid WHERE l.entryidfk = SELECT title, blogname, posturl, excerpt, created FROM #variables.tableprefix#BlogTrackBacks WHERE entryid = -------- AUTHOR: #username# TITLE: #title# BASENAME: #lcase(replace(alias, '-', '_', 'ALL'))# STATUS: PublishDraft ALLOW COMMENTS: #allowcomments# CONVERT BREAKS: richtext ALLOW PINGS: #variables.allowpings# PRIMARY CATEGORY: #cats.categoryName[1]# CATEGORY: #categoryName# DATE: #dateformat(posted, 'MM/DD/YYYY HH:MM:SS')# ----- BODY: #body# ----- EXTENDED BODY: #morebody# ----- EXCERPT: ----- KEYWORDS: ----- COMMENT: AUTHOR: #name# EMAIL: #email# URL: #website##chr(10)# #comment# ----- PING: TITLE: #title# URL: #posturl# BLOG NAME: #blogname# DATE: #dateformat(created, 'MM/DD/YYYY HH:MM:SS')##chr(10)# #excerpt# -----