SELECT cms_article.* , cms_user.username, cms_user.DisplayName, cms_user.email, cms_page.pagename FROM cms_article INNER JOIN cms_article_type ON cms_article.art_type_id = cms_article_type.type_id INNER JOIN cms_user ON cms_article.userid = cms_user.userid INNER JOIN cms_page ON cms_article.art_page_id = cms_page.pageid WHERE cms_article.bPublished = 1 AND cms_article.brss = 1 ORDER BY dtCreated DESC http://www.cfeclipse.org/ News about CFEclipse en-us Copyright 2004-#DateFormat(Now(), "yyyy")#CFEclipse.org #dateFormat(Now(), "ddd, dd mmm yyyy")# #TimeFormat(Now(), "HH:mm:ss")# EST #XMLFormat(art_description)# http://#CGI.SERVER_NAME#/index.cfm?event=page&page#pagename#&contentid=#art_id# #DisplayName# #xmlFormat(dateFormat(DTCREATED, "ddd, dd mmm yyyy"))# #XmlFormat(TimeFormat(DTCREATED, "HH:mm:ss"))# AND cms_article_type.type_name = ORDER BY RAND() Limit #maxrows# --->