getMemberList.xml 오류 수정
<query action="select">
<tables>
<table query="true" alias="c3">
<tables>
<table query="true" alias="m">
<tables>
<table name="elkhatalk_members" />
</tables>
<columns>
<column name="room_no" />
</columns>
<conditions>
<condition operation="equal" column="member_srl" var="member_srl" filter="number" notnull="notnull" />
<condition operation="equal" column="hide" default="N" var="hide" pipe="and" />
<condition operation="notequal" column="member_srl2" var="not_member_srl" filter="number" pipe="and" />
</conditions>
<navigation>
<index default="last_update" order="desc" />
<list_count var="list_count" default="20" />
</navigation>
</table>
<table name="elkhatalk_content" alias="c" type="left join">
<conditions>
<condition operation="equal" column="c.room_no" default="m.room_no" />
</conditions>
</table>
</tables>
<columns>
<column name="MAX(c.no)" alias="content_no" />
<column name="c.room_no" alias="room_no" />
</columns>
<groups>
<group column="room_no" />
</groups>
<navigation>
<index default="content_no" order="desc" />
<list_count var="list_count" default="20" />
</navigation>
</table>
<table name="elkhatalk_content" alias="c2" type="left join">
<conditions>
<condition operation="equal" column="c2.no" default="c3.content_no" />
</conditions>
</table>
<table name="elkhatalk_members" alias="c" type="left join">
<conditions>
<condition operation="equal" column="c.room_no" default="c3.room_no" />
<condition operation="equal" column="c.member_srl" var="member_srl" filter="number" notnull="notnull" pipe="and" />
</conditions>
</table>
</tables>
<columns>
<column name="c.*" />
<column name="c2.content" alias="content" />
<column name="c2.member_srl" alias="content_member_srl" />
<column name="c2.read" alias="content_read" />
<!-- php 에서 조절하기로.
<column name="CONCAT('20',c2.regdate,'00')" alias="content_time" />
-->
<column name="c2.regdate" alias="content_time" />
</columns>
</query>
