select page.title, page.urlizedTitle, USS_submission.dateSubmitted,
 USS_submission.title, USS_submission.username, USS_submission.userId,
 USS_submission.USS_submissionId, USS_submission.status, 
 left(USS_submission.content,100), USS_submission.image from USS_submission 
 left join USS on USS_submission.USS_Id=USS.USS_Id left join wobject on
 USS.wobjectId=wobject.wobjectId left join page on page.pageId=USS_submission.pageId 
 where USS_submission.status='approved' order by USS_submission.dateSubmitted desc limit 7

and here is another:

 select page.title, page.urlizedTitle, USS_submission.dateSubmitted, 
 USS_submission.title, USS_submission.username, USS_submission.userId, 
 USS_submission.USS_submissionId, USS_submission.status, 
 left(USS_submission.content,100), USS_submission.image from USS_submission
 left join USS on USS_submission.USS_Id=USS.USS_Id left join wobject on
 USS.wobjectId=wobject.wobjectId left join page on wobject.pageId=page.pageId
 where USS_submission.status='approved' order by USS_submission.dateSubmitted
 desc limit 7

 <tmpl_if displayTitle>
   <h1><tmpl_var title></h1>
 </tmpl_if>

 <tmpl_if description>
    <tmpl_var description><p />
 </tmpl_if>

 <tmpl_if debugMode>
        <ul>
        <tmpl_loop debug_loop>
                <li><tmpl_var debug.output></li>
        </tmpl_loop>
        </ul>
 </tmpl_if>

 <table width="100%">
 <tmpl_loop rows_loop>
        <tr><td>
                <a href="^/;<tmpl_var row.field.urlizedTitle.value>"><tmpl_var row.field.title.value></a> ^D(%M/%D/%Y,<tmpl_var row.field.dateSubmitted.value>);<br />
 <tmpl_var row.field.left(USS_submission.content,100).value><br />
        </td></tr>
 </tmpl_loop>
 </table>

 <tmpl_if pagination.pageCount.isMultiple>
  <div class="pagination">
    <tmpl_var pagination.previousPage>   <tmpl_var pagination.pageList.upTo20>  <tmpl_var pagination.nextPage>
  </div>
 </tmpl_if>