<c:if test="false">
    <sql:query var="REQ_obj_banners"
               scope="request"
               sql="SELECT jcms_banners.*,
               CONCAT(title_) AS title,
               CONCAT(paragraph_) AS paragraph,
               CONCAT(media_library.file) AS file_bannermedia_library
               
               FROM jcms_banners

               INNER JOIN mtm_genv02_banners
               ON mtm_genv02_banners.genv02_cdid=?
               AND jcms_banners.enabled=1
               AND jcms_banners.cdid = mtm_genv02_banners.jcms_banner_cdid
               AND jcms_banners.period_begin<now()
               AND (now()<jcms_banners.period_end OR jcms_banners.period_end IS NULL)
               
               LEFT JOIN media media_library
               ON media_library.columnName='bannermedia_library'
               AND media_library.cdid = mtm_genv02_banners.jcms_banner_cdid
               AND tableName='jcms_banners'

               ORDER BY m2morder ASC">
        <sql:param value="" />
    </sql:query>

    <c:forEach items="" var="banner" varStatus="status" >
        <c:set var="banner_position" value="position_" />
        <c:set var="banner_attribute_name" value="banner_" />
        <c:set target="" property="" value="" />
        
        <c:if test="false">
            <c:set scope="request" var="REQ_PROCESS_PAGE_LEAFS_LINK_INFO_mIds" value="" />
            <c:if test="false">
    <sql:query var="req_obj_menu_leafs_details"
               scope="request"
               sql="select menus.*, cat.*, targets.tAction,
               IF(contentData128.lang_ IS NULL, menus.mdescription, contentData128.lang_) AS mDescriptionTranslation,
               concat( parentMenuDescriptions.lang_) AS mParentDescriptionTranslation,
               IF(menus_mnames_language.mname_translate IS NULL, menus.mname, menus_mnames_language.mname_translate) AS mNameTranslation,
               IF(parent_menus_mnames_language.mname_translate IS NULL, menuparent.mname, parent_menus_mnames_language.mname_translate) AS mNameParentTranslation,
               concat(catparent.cEngineView) AS parent_cEngineView

               from menus
               LEFT JOIN cat
               ON menus.mlink=cat.cid

               LEFT JOIN contentData128
               ON contentData128.menu_description=menus.mDescription

               LEFT JOIN  menus menuparent
               ON menuparent.mId=menus.mParent

               LEFT JOIN contentData128 parentMenuDescriptions
               ON parentMenuDescriptions.menu_description=menuparent.mDescription

               LEFT JOIN cat catparent
               on catparent.cId=menuparent.mLink


               LEFT JOIN targets
               ON targets.tId=menus.mTarget

               LEFT JOIN site_languages
               ON site_languages.language=?

               LEFT JOIN menus_mnames_language
               ON menus_mnames_language.menu_mid=menus.mid
               AND menus_mnames_language.language_id=site_languages.language_id

               LEFT JOIN menus_mnames_language parent_menus_mnames_language
               ON menus_mnames_language.menu_mid=menuparent.mid
               AND menus_mnames_language.language_id=site_languages.language_id

               WHERE menus.mName IN (null)
               OR menus.mId IN (null)" >
        <sql:param value=""></sql:param>
    </sql:query>

    <c:forEach items="" var="row" >
        <c:set target="{}" property="mid_" value="" />
    </c:forEach>
    </c:if>


<c:if test="false">

    <c:if test="">
        <c:set var="SQL_FIELDS_INTERNAL_CONTENT">
            CONCAT(contentData. sample_text_) AS sample_text,
            CONCAT(contentData.title_) AS title,
            media.file,
        </c:set>
        <c:set var="SQL_JOIN_INTERNAL_CONTENT">
            INNER JOIN catLinkContentData
            ON catLinkContentData.catId = menus.mLink
            AND catLinkContentData.tableName = 'contentData'

            INNER JOIN contentData
            ON contentData.cdid = catLinkContentData.cdid

            LEFT JOIN media
            ON media.columnName='media'
            AND media.cdid=contentData.cdid
            AND media.tableName='contentData'
        </c:set>
    </c:if>

    <sql:query var="req_obj_menu_leafs_internal_details"
               scope="request"
               sql="select 
               
               menus.*, cat.*, targets.tAction,
               concat( contentData128.lang_) AS mDescriptionTranslation,
               concat( parentMenuDescriptions.lang_) AS mParentDescriptionTranslation,
               IF(menus_mnames_language.mname_translate IS NULL, menus.mname, menus_mnames_language.mname_translate) AS mNameTranslation,
               IF(parent_menus_mnames_language.mname_translate IS NULL, menuparent.mname, parent_menus_mnames_language.mname_translate) AS mNameParentTranslation,
               concat(catparent.cEngineView) AS parent_cEngineView

               from menus
               LEFT JOIN cat
               ON menus.mlink=cat.cid

               LEFT JOIN contentData128
               ON contentData128.menu_description=menus.mDescription

               LEFT JOIN  menus menuparent
               ON menuparent.mId=menus.mParent

               LEFT JOIN contentData128 parentMenuDescriptions
               ON parentMenuDescriptions.menu_description=menuparent.mDescription

               LEFT JOIN cat catparent
               on catparent.cId=menuparent.mLink

               LEFT JOIN targets
               ON targets.tId=menus.mTarget

               LEFT JOIN site_languages
               ON site_languages.language=?

               LEFT JOIN menus_mnames_language
               ON menus_mnames_language.menu_mid=menus.mid
               AND menus_mnames_language.language_id=site_languages.language_id

               LEFT JOIN menus_mnames_language parent_menus_mnames_language
               ON menus_mnames_language.menu_mid=menuparent.mid
               AND menus_mnames_language.language_id=site_languages.language_id

               
               WHERE menus.mParent = (SELECT mid FROM menus WHERE mName=null)
               OR menus.mParent = null" >
        <sql:param value=""></sql:param>
    </sql:query>
</c:if>


<c:if test="false">

    <sql:query var="req_obj_menu_leafs_all_internal_details"
               scope="request"
               sql="SELECT 
               contentData156.*, 
               CONCAT(contentData156.title_) AS head_title,
               CONCAT(contentData156.paragraph_) AS head_paragraph,

               menus.*,
               cat.cEngineView,
               cat.cEngineObject,
               if(contentData128.lang_<> '', contentData128.lang_, menus.mDescription) AS mDescriptionTranslation,
               concat( parentMenuDescriptions.lang_) AS mParentDescriptionTranslation,
               IF(menus_mnames_language.mname_translate IS NULL, menus.mname, menus_mnames_language.mname_translate) AS mNameTranslation,
               IF(parent_menus_mnames_language.mname_translate IS NULL, menuparent.mname, parent_menus_mnames_language.mname_translate) AS mNameParentTranslation,

               media.file,
               CONCAT(globalimagestranslations.lang_) AS media_alt,
               jcms_global_texts.freetext,
               CONCAT(media_med.file) AS file_medium,
               CONCAT(media_small.file) AS file_small

               from menus
               LEFT JOIN cat
               ON menus.mlink=cat.cid

               LEFT JOIN contentData128
               ON contentData128.menu_description=menus.mDescription

               LEFT JOIN  menus menuparent
               ON menuparent.mId=menus.mParent

               LEFT JOIN contentData128 parentMenuDescriptions
               ON parentMenuDescriptions.menu_description=menuparent.mDescription

               LEFT JOIN cat catparent
               on catparent.cId=menuparent.mLink

               LEFT JOIN targets
               ON targets.tId=menus.mTarget

               LEFT JOIN site_languages
               ON site_languages.language=?

               LEFT JOIN menus_mnames_language
               ON menus_mnames_language.menu_mid=menus.mid
               AND menus_mnames_language.language_id=site_languages.language_id

               LEFT JOIN menus_mnames_language parent_menus_mnames_language
               ON menus_mnames_language.menu_mid=menuparent.mid
               AND menus_mnames_language.language_id=site_languages.language_id

               LEFT JOIN contentData156
               ON contentData156.cdid = menus.mid

               LEFT JOIN media
               ON media.tableName='contentData156'
               AND media.columnName='media'
               AND media.cdId = contentData156.cdid
               AND media.datedeleted=0

               LEFT JOIN globalimagestranslations
               ON media.mId = globalimagestranslations.cdid

               LEFT JOIN jcms_global_texts
               ON jcms_global_texts.column_cdid = media.mid
               AND jcms_global_texts.table_name='media'
               AND jcms_global_texts.column_name='media'

               LEFT JOIN media media_med
               ON media_med.cdid = contentData156.cdid
               AND media_med.columnName='media_medium'
               AND media_med.tablename='contentData156'

               LEFT JOIN media media_small
               ON media_small.cdid = contentData156.cdid
               AND media_small.columnName='media_small'
               AND media_small.tablename='contentData156'


               WHERE menus.mParent = 
               (SELECT mid FROM menus WHERE mName='-1')
               OR menus.mParent = '-1'

               ORDER BY torder, mid" >
        <sql:param value=""></sql:param>
    </sql:query>

    <c:remove var="REQ_PROCESS_PAGE_ALL_INTERNAL_LEAFS_LINK_INFO_mIds" scope="request" />
    <c:remove var="REQ_PROCESS_PAGE_ALL_INTERNAL_LEAFS_LINK_INFO_mNames" scope="request" />
</c:if>


<c:if test="false">

    <sql:query var="req_obj_menu_leaf_details"
               scope="request"
               sql="SELECT 
               contentData156.*, 
               CONCAT(contentData156.title_) AS head_title,
               CONCAT(contentData156.paragraph_) AS head_paragraph,
               
               menus.*,
               if(contentData128.lang_<> '', contentData128.lang_, menus.mDescription) AS mDescriptionTranslation,
               concat( IF(parentMenuDescriptions.lang_<>'', parentMenuDescriptions.lang_, menuparent.mDescription)) AS mParentDescriptionTranslation,
               IF(menus_mnames_language.mname_translate IS NULL, menus.mname, menus_mnames_language.mname_translate) AS mNameTranslation,
               IF(parent_menus_mnames_language.mname_translate IS NULL, menuparent.mname, parent_menus_mnames_language.mname_translate) AS mNameParentTranslation,

               media.file,
               CONCAT(globalimagestranslations.lang_) AS media_alt,
               jcms_global_texts.freetext

               from menus
               LEFT JOIN cat
               ON menus.mlink=cat.cid

               LEFT JOIN contentData128
               ON contentData128.menu_description=menus.mDescription

               LEFT JOIN  menus menuparent
               ON menuparent.mId=menus.mParent

               LEFT JOIN contentData128 parentMenuDescriptions
               ON parentMenuDescriptions.menu_description=menuparent.mDescription

               LEFT JOIN cat catparent
               on catparent.cId=menuparent.mLink

               LEFT JOIN targets
               ON targets.tId=menus.mTarget

               LEFT JOIN site_languages
               ON site_languages.language=?

               LEFT JOIN menus_mnames_language
               ON menus_mnames_language.menu_mid=menus.mid
               AND menus_mnames_language.language_id=site_languages.language_id

               LEFT JOIN menus_mnames_language parent_menus_mnames_language
               ON menus_mnames_language.menu_mid=menuparent.mid
               AND menus_mnames_language.language_id=site_languages.language_id

               LEFT JOIN contentData156
               ON contentData156.cdid = menus.mid

               LEFT JOIN media
               ON media.tableName='contentData156'
               AND media.columnName='media'
               AND media.cdId = contentData156.cdid
               AND media.datedeleted=0

               LEFT JOIN globalimagestranslations
               ON media.mId = globalimagestranslations.cdid

               LEFT JOIN jcms_global_texts
               ON jcms_global_texts.column_cdid = media.mid
               AND jcms_global_texts.table_name='media'
               AND jcms_global_texts.column_name='media'

               WHERE menus.mId = (SELECT mid FROM menus WHERE mName='-1')
               OR menus.mId = '-1'

               ORDER BY torder, mid" >
        <sql:param value=""></sql:param>
    </sql:query>

    <c:forEach items="" var="row" >
        <c:set target="{}" property="mid_" value="" />
    </c:forEach>
    </c:if>


<c:if test="false">

    <c:if test="">
        <c:set var="SQL_FIELDS_INTERNAL_CONTENT">
            CONCAT(contentData.sample_text_) AS sample_text,
            CONCAT(contentData.title_) AS title,
            media.file,
            CONCAT(media_sample.file) AS file_sample,
        </c:set>
        <c:set var="SQL_JOIN_INTERNAL_CONTENT">
            INNER JOIN catLinkContentData
            ON catLinkContentData.catId = menus.mLink
            AND catLinkContentData.tableName = 'contentData'

            INNER JOIN contentData
            ON contentData.cdid = catLinkContentData.cdid

            LEFT JOIN media
            ON media.columnName='media'
            AND media.cdid=contentData.cdid
            AND media.tableName='contentData'

            LEFT JOIN media media_sample
            ON media_sample.columnName='media_sample'
            AND media_sample.cdid=contentData.cdid
            AND media_sample.tableName='contentData'
        </c:set>
    </c:if>

    <sql:query var="req_obj_menu_leaf_rows_info"
               scope="request"
               sql="select 
               
               menus.*, cat.*, targets.tAction,
               concat( contentData128.lang_) AS mDescriptionTranslation, 
               concat( parentMenuDescriptions.lang_) AS mParentDescriptionTranslation,
               IF(menus_mnames_language.mname_translate IS NULL, menus.mname, menus_mnames_language.mname_translate) AS mNameTranslation,
               IF(parent_menus_mnames_language.mname_translate IS NULL, menuparent.mname, parent_menus_mnames_language.mname_translate) AS mNameParentTranslation,
               concat(catparent.cEngineView) AS parent_cEngineView

               from menus
               LEFT JOIN cat
               ON menus.mlink=cat.cid

               LEFT JOIN contentData128
               ON contentData128.menu_description=menus.mDescription

               LEFT JOIN  menus menuparent
               ON menuparent.mId=menus.mParent

               LEFT JOIN contentData128 parentMenuDescriptions
               ON parentMenuDescriptions.menu_description=menuparent.mDescription

               LEFT JOIN cat catparent
               on catparent.cId=menuparent.mLink

               LEFT JOIN targets
               ON targets.tId=menus.mTarget

               LEFT JOIN site_languages
               ON site_languages.language=?

               LEFT JOIN menus_mnames_language
               ON menus_mnames_language.menu_mid=menus.mid
               AND menus_mnames_language.language_id=site_languages.language_id

               LEFT JOIN menus_mnames_language parent_menus_mnames_language
               ON menus_mnames_language.menu_mid=menuparent.mid
               AND menus_mnames_language.language_id=site_languages.language_id

               
               WHERE menus.mId = ? 
               OR menus.mId = null" >
        <sql:param value=""></sql:param>
        <sql:param value="" />
    </sql:query>
</c:if><c:set target="" property="linkinfo" value="" /> 
        </c:if>
        
    </c:forEach>
</c:if>