<query id="getDocumentsForPlanner_all" action="select">
    <tables>
        <table name="modules" />
        <table name="documents" />
        <table name="document_extra_vars" alias="extra_vars_t1"  type="left join" >          
            <conditions>
                <condition operation="equal" column="extra_vars_t1.module_srl" default="documents.module_srl" />
                <condition operation="equal" column="extra_vars_t1.document_srl" default="documents.document_srl" pipe="and" />     
                <condition operation="equal" column="extra_vars_t1.var_idx" var="var_idx1" pipe="and" />                 
            </conditions>
        </table>         
        <table name="document_extra_vars" alias="extra_vars_t2"  type="left join">
            <conditions>
                <condition operation="equal" column="extra_vars_t2.module_srl" default="documents.module_srl" />
                <condition operation="equal" column="extra_vars_t2.document_srl" default="documents.document_srl" pipe="and" />     
                <condition operation="equal" column="extra_vars_t2.var_idx" var="var_idx2" pipe="and" />                 
            </conditions>
        </table>         
        <table name="document_extra_vars" alias="extra_vars_t7"  type="left join">
            <conditions>
                <condition operation="equal" column="extra_vars_t7.module_srl" default="documents.module_srl" />
                <condition operation="equal" column="extra_vars_t7.document_srl" default="documents.document_srl" pipe="and" />     
                <condition operation="equal" column="extra_vars_t7.var_idx" var="var_idx7" pipe="and" />                 
            </conditions>
        </table>         
        <table name="document_extra_vars" alias="extra_vars_t8"  type="left join">
            <conditions>
                <condition operation="equal" column="extra_vars_t8.module_srl" default="documents.module_srl" />
                <condition operation="equal" column="extra_vars_t8.document_srl" default="documents.document_srl" pipe="and" />     
                <condition operation="equal" column="extra_vars_t8.var_idx" var="var_idx8" pipe="and" />                 
            </conditions>
        </table>         
    </tables>

    <columns>
        <column name="modules.site_srl" alias="site_srl" />
        <column name="modules.mid" alias="mid" />
        <column name="documents.*" />
        <column name="extra_vars_t1.value" var="extra_vars_t1.value" alias="extra_value_start"/> 
		<column name="extra_vars_t2.value" var="extra_vars_t2.value" alias="extra_value_end"/> 
		<column name="extra_vars_t7.value" var="extra_vars_t7.value" alias="extra_value_time"/> 
 		<column name="extra_vars_t8.value" var="extra_vars_t8.value" alias="extra_value_group"/> 
    </columns>

    <conditions>
	    <condition operation="equal" column="modules.site_srl" var="site_srl" />
	    <condition operation="not_in" column="documents.module_srl" default="0" pipe="and" />
        <condition operation="in" column="documents.module_srl" var="module_srl" filter="number" pipe="and" />
        <condition operation="equal" column="modules.module_srl" default="documents.module_srl" filter="number" pipe="and" />

	    <condition operation="equal" column="extra_vars_t1.module_srl" default="documents.module_srl" pipe="and" />
        <condition operation="equal" column="extra_vars_t1.document_srl" default="documents.document_srl" pipe="and" />

        <condition operation="in"  column="category_srl" var="var_category_srl" pipe="and"  />

	    <group pipe="and">
        <condition operation="less"  column="extra_vars_t1.value" var="var_period_end" notnull="notnull" />
        <condition operation="more"  column="extra_vars_t2.value" var="var_period_start" notnull="notnull" pipe="and" />
        <condition operation="more"  column="extra_vars_t2.value" var="var_fld_null" pipe="and" />

        <condition operation="more"  column="extra_vars_t1.value" var="var_period_start" notnull="notnull" pipe="or" />
        <condition operation="less"  column="extra_vars_t1.value" var="var_period_end" notnull="notnull" pipe="and" />
        <condition operation="below" column="extra_vars_t2.value" var="var_fld_null" pipe="and" />
        </group>

 	    <group pipe="and">
        <condition operation="like"  column="documents.title" var="var_search_title" />
        <condition operation="like"  column="documents.content" var="var_search_content" pipe="or" />
        <condition operation="like"  column="documents.user_name" var="var_search_user_name" pipe="or" />
        <condition operation="like"  column="documents.nick_name" var="var_search_nick_name" pipe="or" />
        <condition operation="like"  column="documents.user_id" var="var_search_user_id" pipe="or" />
        <condition operation="like"  column="documents.tags" var="var_search_tags" pipe="or" />
        </group>
    </conditions>

    <navigation>
        <index var="sort_index_1" default="sort_index_default_1" order="order_type_1" />
        <index var="sort_index_2" default="sort_index_default_1" order="order_type_2" />
        <index var="sort_index" default="sort_index_default" order="order_type" />
        <list_count var="list_count" default="200" />
        <page_count var="page_count" default="10" />
        <page var="page" default="1" />
    </navigation>
</query>
