www.pankoeasia.com을 작업중인데 main 좌측 하단에 

서브쿼리 xml을 만들었는데 정상적으로 동작하지 않습니다..

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

SELECT 

 *

FROM

 xe_documents

WHERE

 xe_documents.document_srl in

 (

  select 

   document_srl 

  from 

   xe_document_extra_vars 

  where 

   xe_document_extra_vars.var_idx=2

   and 

   xe_document_extra_vars.value like '$args->tourist_nation' 

   and

   xe_document_extra_vars.eid like 'tourist_nation'

 )

 

 and

 

 xe_documents.document_srl in

 (

  select 

   document_srl 

  from 

   xe_document_extra_vars 

  where 

   xe_document_extra_vars.var_idx=3

   and 

   xe_document_extra_vars.value like '$args->tourist_city' 

   and

   xe_document_extra_vars.eid like 'tourist_city'

 )

이거를

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

    <tables>

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

    </tables>

    <columns>

        <column name="documents.*" />

    </columns>

    <conditions>

        <condition operation="equal" column="documents.module_srl" var="module_srl" filter="number" notnull="notnull" pipe="and" />

  <condition operation="in" column="documents.document_srl" pipe="and" />

  <query alias="documentExtraVars">

   <table>

    <table name="document_extra_vars" alias="document_extra_vars">

   </table>

   <columns>

    <column name="document_extra_vars.document_srl">

   </columns>

   <conditions>

    <condition operation="equal" column="document_extra_vars.var_idx" var="var_idx1" pipe="and">

    <condition operation="like" column="document_extra_vars.value" var="var_value1" pipe="and">

    <condition operation="equal" column="document_extra_vars.var_idx" var="var_idx2" pipe="or">

    <condition operation="like" column="document_extra_vars.value" var="var_value2" pipe="and">

   </conditions>

  </query>

    </conditions>

    <navigation>

  <index var="sort_index" default="documents.list_order" order="order_type" />

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

    </navigation>

</query>

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

왜동작을 안할까요 ㅠㅠ?