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.art_page_id = AND cms_article_type.type_name = AND cms_article.brss = ORDER BY #arguments.orderByField# #arguments.orderByOrder# ORDER BY RAND() LIMIT #arguments.limit#