<query id="getFilePoint" action="select">
    <tables>
        <table name="files" />
    </tables>
    <columns>
        <column name="module_srl" />
        <column name="member_srl" />
        <column name="count(*)" alias="count" />
    </columns>
    <conditions>
		<condition operation="notequal" column="member_srl" default="0" />
        <condition operation="equal" column="isvalid" default="Y" notnull="notnull" pipe="and" />
    </conditions>
    <groups>
        <group column="module_srl" />
        <group column="member_srl" />
    </groups>
</query>
