<query id="getRankUploadedCount" action="select">

    <tables>

        <table name="files" alias="files" />

        <table name="modules" alias="modules" />

        <table name="member" alias="member" />

        <table name="member_group_member" alias="member_group" />

    </tables>

    <columns>

        <column name="member.*" />

        <column name="count(*)" alias="count" />

    </columns>

    <conditions>

        <condition operation="equal" column="modules.site_srl" var="site_srl" pipe="and" />

        <condition operation="equal" column="modules.module_srl" default="files.module_srl" pipe="and" />

        <condition operation="equal" column="files.member_srl" default="member.member_srl" pipe="and" />

        <condition operation="more" column="files.regdate" var="regdate" pipe="and" />

        <condition operation="equal" column="member_group.site_srl" var="site_srl" default="0"  pipe="and" />

        <condition operation="in" column="member_group.group_srl" var="selected_group_srl" pipe="and" />

        <condition operation="equal" column="member_group.member_srl" default="member.member_srl" pipe="and" />

    </conditions>

    <groups>

        <group column="files.member_srl" />

    </groups>

    <navigation>

        <index var="sort_index" default="count" order="desc" />

        <list_count var="list_count" default="20" />

    </navigation>

</query>

랭킹위젯 중 업로드된 갯수를 파악해서 랭킹을 나열하도록
되어 있는 것 같습니다.

혹시 예) zip 파일만 카운팅 하려면 ?
.zip 을 like ? 하면 될 것 같긴한데.. XE 문법은 잘 모르겠네요^^

부탁드립니다.