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>