<query id="getNewestDocuments" action="select">
    <tables>
        <table name="modules" />
        <table name="documents" />
        <table name="comments" />
        <table name="document_categories" />
    </tables>
    <columns>
        <column name="modules.site_srl" alias="site_srl"/>
        <column name="modules.mid" alias="mid"/>
        <column name="comments.content" alias="commnet"/>
        <column name="max(comments.comment_srl)" alias="last_cnt"/>
        <column name="document_categories.title" alias="categorie"/>
        <column name="documents.*" />
    </columns>
    <conditions>
        <condition operation="equal" column="modules.site_srl" var="site_srl" />
  <condition operation="not_in" column="documents.module_srl" default="0" pipe="and" />
        <condition operation="in" column="documents.module_srl" var="module_srl" filter="number" pipe="and" />
        <condition operation="equal" column="comments.document_srl" default="documents.document_srl" pipe="and" />
        <condition operation="equal" column="document_categories.category_srl" default="documents.category_srl" pipe="and" />
        <condition operation="equal" column="comments.parent_srl" default="0" pipe="and" />
        <condition operation="equal" column="modules.module_srl" default="documents.module_srl" filter="number" pipe="and" />
    </conditions>
    <groups>
         <group column="comments.document_srl" />
    </groups>

    <navigation>
        <index var="sort_index" default="documents.list_order" order="order_type" />
        <list_count var="list_count" default="20" />
    </navigation>
</query>

---------------------------------------------------------------------------------------

현재 저한테 맞는  위젯을 만들기 위해 최근문서위젯을 수정하고 있습니다

컨셉은 최신 댓글(댓글의 댓글은 제외)과 댓글이 달린 게시물을  가져 오는것인데

SQL을 위의 처럼  작성 했지만 계속  첫번째 댓글을 가져 옵니다

어떻게 수정 해야 할까요 도움 부탁드립니다