#
# Search Page
#
# a) List of forms: {{form:S}}='', {{formIdHistory:S}}=''
# b) Edit Form: {{form:S}} - Open form {{form:S}} with record {{r:S}} - typically the FormEditor
#
# {{form:S}}

# Search value in FormElement, Form, tt_content and pages
#


form={{form:SE}}

# Check if enableSwitch is given from QFQ. Only created if file is given over variable.
10 {
    sql = SELECT 'p:{{pageAlias:T}}&file=_formEditor|G:glyphicon-arrow-right|s|b|t:FormEditor' AS _link
            FROM (SELECT '') AS fake
            WHERE '{{enableSwitch:XE}}' = 'yes'
}

# Check for first page load and define defaults
20 {
    sql = SELECT IF('{{firstPageLoad:CE:alnumx}}' = '', 'yes', 'no') AS _firstPageLoad
                 , IF('{{file:SE}}' != '', '{{file:S::w}}', '{{file:UE}}') AS '_=file'
}

30 {
    # GET parameter: {{search}}
    sql = SELECT REPLACE(REPLACE(TRIM('{{search:CE:allbut}}'), '"', '"'), "'", ''') AS _displaySearch
                , TRIM('{{search:CE:allbut}}') AS _search
                , TRIM('{{excludedContent:CE:allbut}}') AS _excludedContent
                , IF('{{checkExactMatch:CE:allbut}}' = 'yes', 'checked', '') AS _checkExactMatchState
                , IF('{{checkLimit:CE:allbut}}' = 'yes', 'checked', '') AS _checkLimitState
                , IF('{{checkLimit:CE:allbut}}' = 'yes', 'LIMIT 100', '') AS _queryLimit
                , IF('{{checkFormElement:CE:allbut}}' = 'yes' OR '{{firstPageLoad:RE:alnumx}}' = 'yes', 'checked', '') AS _checkFormElementState
                , IF('{{checkForm:CE:allbut}}' = 'yes' OR '{{firstPageLoad:RE:alnumx}}' = 'yes', 'checked', '') AS _checkFormState
                , IF('{{checkTtContent:CE:allbut}}' = 'yes' OR '{{firstPageLoad:RE:alnumx}}' = 'yes', 'checked', '') AS _checkTtContentState
                , IF('{{checkPages:CE:allbut}}' = 'yes' OR '{{firstPageLoad:RE:alnumx}}' = 'yes', 'checked', '') AS _checkPagesState

    # Creates a small form that redirects back to this page
    40 {
        sql = SELECT ''
        head =  <form action='index.php' class='form-inline'>
                    <div class='form-group'>
                        <table>
                            <tr>
                                <td>
                                    <label for='search'>Search for:</label>
                                </td>
                                <td>
                                    <label for='excludedContent'>Ignore:</label>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    <input class='form-control' type='text' id='search' name='search' placeholder='String' value="{{displaySearch:RE:all}}" autofocus='autofocus' style='width:90%;'>
                                </td>
                                <td>
                                    <input class='form-control' type='text' id='excludedContent' name='excludedContent' placeholder='Optional' value='{{excludedContent:RE:alnumx}}' style='width:80%;'>
                                    <input class='btn btn-default form-control' type='submit' value='Search' style='width:15%;'>
                                </td>
                            </tr>
                        </table>
                        <label for="table">Table:</label>&emsp;
                        <input name='checkFormElement' type='checkbox' id='checkFormElement' value='yes' {{checkFormElementState:RE:all}}><label for="checkFormElement"> FormElement</label>&emsp;
                        <input name='checkForm' type='checkbox' id='checkForm' value='yes' {{checkFormState:RE:all}}><label for="checkForm"> Form</label>&emsp;
                        <input name='checkTtContent' type='checkbox' id='checkTtContent' value='yes' {{checkTtContentState:RE:all}}><label for="checkTtContent"> tt_content (Report)</label>&emsp;
                        <input name='checkPages' type='checkbox' id='checkPages' value='yes' {{checkPagesState:RE:all}}><label for="checkPages"> pages</label><br>
                        <label for="table">Options:</label>&emsp;
                        <input name='checkExactMatch' type='checkbox' id='checkExactMatch' value='yes' {{checkExactMatchState:RE:all}}><label for="checkExactMatch"> Exact match</label>&emsp;
                        <input name='checkLimit' type='checkbox' id='checkLimit' value='yes' {{checkLimitState:RE:all}}><label for="checkLimit"> Limit 100 records</label><br><br>
                        <input name='id' value='{{pageId:T}}' type='hidden'>
                        <input name='firstPageLoad' value='loaded' type='hidden'>
                    </div>
                </form><br>
                 <table id='description' class="table" style="width: 50%;">
                     <tr><th>Table name</th><th>Search locations</th></tr>
                     <tr><td>FormElement</td><td>label, note, value, sql1, parameter, modeSql</td></tr>
                     <tr><td>Form</td><td>title, forwardPage, parameter, tableName</td></tr>
                     <tr><td>T3 tt_content</td><td>bodytext, header, subheader</td></tr>
                     <tr><td>T3 pages</td><td>title, subtitle, alias</td></tr>
                 </table>
    }


    # Prepare value with or without wildcard
    50 {
        sql = SELECT IF('{{checkExactMatchState:RE:alnumx}}' = 'checked', '{{search:RE:allbut}}', CONCAT('%', '{{search:RE:allbut}}', '%')) AS _finalSearch
    }

    # Check for empty search and first page load
    60 {
        sql = SELECT '' FROM (SELECT '') AS fake WHERE '{{firstPageLoad:RE:alnumx}}' = 'no' AND '{{search:RE:allbut}}' != ''

        # Search from checked tables
        70 {
            sql = SELECT '' FROM (SELECT '') AS fake WHERE '{{checkFormElementState:RE:alnumx}}' = 'checked'

            # Table Header
            80 {
                sql = SELECT '<th class="filter-false sorter-false"></th>' AS _noWrap
                           , '<th class="filter-false sorter-false"></th>' AS _noWrap
                           , 'ID', 'FormId', 'Name', 'Enabled', 'Class', 'Found'
                        FROM FormElement AS fe

                        WHERE '{{finalSearch:RE:all}}' <> ''
                          AND (fe.label LIKE '{{finalSearch:RE:all}}'
                          AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.label NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                          OR fe.note LIKE '{{finalSearch:RE:all}}'
                          AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.note NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                          OR fe.value LIKE '{{finalSearch:RE:all}}'
                          AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.value NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                          OR fe.sql1 LIKE '{{finalSearch:RE:all}}'
                          AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.sql1 NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                          OR fe.parameter LIKE '{{finalSearch:RE:all}}'
                          AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.parameter NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                          OR fe.modeSql LIKE '{{finalSearch:RE:all}}'
                          AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.modeSql NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1))

                        LIMIT 1

                head = <div class="panel panel-info" style="width: min-content;min-width: fit-content;"><div class="panel-heading"><h2 style="margin:0;">FormElement</h2><span class="result-box-counter" data-box-id="fe-box-counter"></span></div><div class="panel-body"><table class="table table-hover qfq-table-50 tablesorter tablesorter-filter tablesorter-pager" id="{{pageAlias:TE}}-fe"><thead><tr>
                tail = </tr></thead>
                fbeg = <th>
                fend = </th>
            }


            # SQL statement will find and list all the relevant persons (only executed if a search term is entered)
            90 {
                sql = SELECT CONCAT('p:{{pageAlias:T}}&form=formElement&r=', fe.id,'|s') AS '_pagee'
                           , CONCAT('p:{{pageAlias:T}}&form=form&r=', fe.formId,'|s|b|t:Edit Form') AS '_link'
                           , fe.id
                           , fe.formId
                           , fe.name
                           , fe.enabled
                           , fe.class
                           , CONCAT(
                               IF(fe.label LIKE '{{finalSearch:RE:all}}'
                                    AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.label NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                                    , CONCAT('<strong>Label:</strong><br>', QMARK(fe.label, '{{search:RE:allbut}}')), '')
                               , IF(fe.note LIKE '{{finalSearch:RE:all}}'
                                    AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.note NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                                    , CONCAT('<strong>Note:</strong><br>', QMARK(fe.note, '{{search:RE:allbut}}')), '')
                               , IF(fe.value LIKE '{{finalSearch:RE:all}}'
                                    AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.value NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                                    , CONCAT('<strong>Value:</strong><br>', QMARK(fe.value, '{{search:RE:allbut}}')), '')
                               , IF(fe.sql1 LIKE '{{finalSearch:RE:all}}'
                                    AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.sql1 NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                                    , CONCAT('<strong>SQL1:</strong><br>', QMARK(fe.sql1, '{{search:RE:allbut}}')), '')
                               , IF(fe.parameter LIKE '{{finalSearch:RE:all}}'
                                    AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.parameter NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                                    , CONCAT('<strong>Parameter:</strong><br>', QMARK(fe.parameter, '{{search:RE:allbut}}')), '')
                               , IF(fe.modeSql LIKE '{{finalSearch:RE:all}}'
                                    AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.modeSql NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                                    , CONCAT('<strong>ModeSql:</strong><br>', QMARK(fe.modeSql, '{{search:RE:allbut}}')), ''))
                        FROM FormElement AS fe

                        WHERE '{{finalSearch:RE:all}}' <> ''
                          AND (fe.label LIKE '{{finalSearch:RE:all}}'
                          AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.label NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                          OR fe.note LIKE '{{finalSearch:RE:all}}'
                          AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.note NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                          OR fe.value LIKE '{{finalSearch:RE:all}}'
                          AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.value NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                          OR fe.sql1 LIKE '{{finalSearch:RE:all}}'
                          AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.sql1 NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                          OR fe.parameter LIKE '{{finalSearch:RE:all}}'
                          AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.parameter NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                          OR fe.modeSql LIKE '{{finalSearch:RE:all}}'
                          AND IF('{{excludedContent:RE:alnumx}}' <> '', fe.modeSql NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1))

                        {{queryLimit:RE:alnumx}}



                head = <tbody>
                tail = </tbody></table></div></div><input id='fe-box-counter' value='{{20.50.60.80.line.count}}' type='hidden'>
                rbeg = <tr>
                rend = </tr>
                fbeg = <td>
                fend = </td>
            }
        }

        100 {
            sql = SELECT '' FROM (SELECT '') AS fake WHERE '{{checkFormState:RE:alnumx}}' = 'checked'

            # Table Header
            110 {
                sql = SELECT '<th class="filter-false sorter-false"></th>' AS _noWrap
                   , 'ID', 'Name', 'TableName', 'Found'
                FROM Form AS f

                WHERE '{{finalSearch:RE:all}}' <> ''
                  AND (f.title LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' <> '', f.title NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                  OR f.forwardPage LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' <> '', f.forwardPage NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                  OR f.tableName LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' <> '', f.tableName NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                  OR f.parameter LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' <> '', f.parameter NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1))

                LIMIT 1

                head = <div class="panel panel-info" style="width: min-content;min-width: fit-content;"><div class="panel-heading"><h2 style="margin:0;">Form</h2><span class="result-box-counter" data-box-id="f-box-counter"></span></div><div class="panel-body"><table class="table table-hover qfq-table-50 tablesorter tablesorter-filter tablesorter-pager" id="{{pageAlias:TE}}-form"><thead><tr>
                tail = </tr></thead>
                fbeg = <th>
                fend = </th>
            }

            # SQL statement will find and list all the relevant persons (only executed if a search term is entered)
            120 {
                sql = SELECT CONCAT('p:{{pageAlias:T}}&form=form&r=', f.id,'|s') AS '_pagee'
                   , f.id
                   , f.name
                   , f.tableName
                   , CONCAT(IF(f.title LIKE '{{finalSearch:RE:all}}'
                                AND IF('{{excludedContent:RE:alnumx}}' <> '', f.title NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                            , CONCAT('<strong>Title:</strong><br>', QMARK(f.title, '{{search:RE:allbut}}')),'')
                            , IF(f.forwardPage LIKE '{{finalSearch:RE:all}}'
                                AND IF('{{excludedContent:RE:alnumx}}' <> '', f.forwardPage NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                            , CONCAT('<strong>Forward Page:</strong><br>', QMARK(f.forwardPage, '{{search:RE:allbut}}')),'')
                            , IF(f.parameter LIKE '{{finalSearch:RE:all}}'
                                AND IF('{{excludedContent:RE:alnumx}}' <> '', f.parameter NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                            , CONCAT('<strong>Parameter:</strong><br>', QMARK(f.parameter, '{{search:RE:allbut}}')),'')
                            , IF(f.tableName LIKE '{{finalSearch:RE:all}}'
                                AND IF('{{excludedContent:RE:alnumx}}' <> '', f.tableName NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                            , CONCAT('<strong>TableName:</strong><br>', QMARK(f.tableName, '{{search:RE:allbut}}')),''))
                FROM Form AS f

                WHERE '{{finalSearch:RE:all}}' <> ''
                  AND (f.title LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' <> '', f.title NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                  OR f.forwardPage LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' <> '', f.forwardPage NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                  OR f.tableName LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' <> '', f.tableName NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                  OR f.parameter LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' <> '', f.parameter NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1))

                {{queryLimit:RE:alnumx}}


                head = <tbody>
                tail = </tbody></table></div></div><input id='f-box-counter' value='{{20.50.100.120.line.count}}' type='hidden'>
                rbeg = <tr>
                rend = </tr>
                fbeg = <td>
                fend = </td>
            }
        }

        # Search from used table
        130 {
            sql = SELECT '' FROM (SELECT '') AS fake WHERE '{{checkTtContentState:RE:alnumx}}' = 'checked'

            # Table Header
            140 {
                sql = SELECT '<th class="filter-false sorter-false"></th>' AS _noWrap
                             ,'ID', 'PageId', 'Header', 'Subheader', 'Disabled', 'Found'

                FROM {{dbNameT3:Y}}.tt_content AS r

                WHERE '{{finalSearch:RE:all}}' != ''
                  AND (r.bodytext LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' != '', r.bodytext NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                  OR r.header LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' != '', r.header NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                  OR r.subheader LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' != '', r.subheader NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1))

                LIMIT 1

                head = <div class="panel panel-info" style="width: min-content;min-width: fit-content;"><div class="panel-heading"><h2 style="margin:0;">T3 tt_content (Report)</h2><span class="result-box-counter" data-box-id="r-box-counter"></span></div><div class="panel-body"><table class="table table-hover qfq-table-50 tablesorter tablesorter-filter tablesorter-pager" id="{{pageAlias:TE}}-report"><thead><tr>
                tail = </tr></thead>
                fbeg = <th>
                fend = </th>
            }

            # SQL statement will find and list all the relevant persons (only executed if a search term is entered)
            150 {
                sql = SELECT CONCAT('i:uid=', r.uid, '|b:btn btn-default') AS _link
                   , r.uid
                   , r.pid
                   , r.header
                   , r.subheader
                   , IF(r.hidden = 0, 'No', 'Yes')
                   , CONCAT(IF(r.bodytext LIKE '{{finalSearch:RE:all}}'
                                AND IF('{{excludedContent:RE:alnumx}}' <> '', r.bodytext NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                            , CONCAT('<strong>Bodytext:</strong><br>', QMARK(r.bodytext, '{{search:RE:allbut}}')),'')
                            , IF(r.header LIKE '{{finalSearch:RE:all}}'
                                AND IF('{{excludedContent:RE:alnumx}}' <> '', r.header NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                            , CONCAT('<strong>Header:</strong><br>', QMARK(r.header, '{{search:RE:allbut}}')),'')
                            , IF(r.subheader LIKE '{{finalSearch:RE:all}}'
                                AND IF('{{excludedContent:RE:alnumx}}' <> '', r.subheader NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                            , CONCAT('<strong>Subheader:</strong><br>', QMARK(r.subheader, '{{search:RE:allbut}}')),''))

                FROM {{dbNameT3:Y}}.tt_content AS r

                WHERE '{{finalSearch:RE:all}}' != ''
                  AND (r.bodytext LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' != '', r.bodytext NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                  OR r.header LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' != '', r.header NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                  OR r.subheader LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' != '', r.subheader NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1))
                  AND r.deleted = 0

                {{queryLimit:RE:alnumx}}


                head = <tbody>
                tail = </tbody></table></div></div><input id='r-box-counter' value='{{20.50.130.150.line.count}}' type='hidden'>
                rbeg = <tr>
                rend = </tr>
                fbeg = <td>
                fend = </td>
            }
        }

        # Search from used table
        160 {
            sql = SELECT '' FROM (SELECT '') AS fake WHERE '{{checkPagesState:RE:alnumx}}' = 'checked'

            # Table Header
            170 {
                sql = SELECT 'ID', 'Parent<br>PageId', 'Title', 'Subtitle', 'Alias', 'Disabled', 'Found', 'TT-Contents'

                FROM {{dbNameT3:Y}}.pages AS p

                WHERE '{{finalSearch:RE:all}}' != ''
                  AND (p.title LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' != '', p.title NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                  OR p.subtitle LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' != '', p.subtitle NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                  OR p.alias LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' != '', p.alias NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1))
                  AND p.deleted = 0

                LIMIT 1

                head = <div class="panel panel-info" style="width: min-content;min-width: fit-content;"><div class="panel-heading"><h2 style="margin:0;">T3 pages</h2><span class="result-box-counter" data-box-id="p-box-counter"></span></div><div class="panel-body"><table class="table table-hover qfq-table-50 tablesorter tablesorter-filter tablesorter-pager" id="{{pageAlias:TE}}-report"><thead><tr>
                tail = </tr></thead>
                fbeg = <th>
                fend = </th>
            }

            # SQL statement will find and list all the relevant pages (only executed if a search term is entered)
            180 {
                sql = SELECT p.uid
                   , p.pid
                   , p.title
                   , p.subtitle
                   , p.alias
                   , IF(p.hidden = 0, 'No', 'Yes')
                   , CONCAT(IF(p.title LIKE '{{finalSearch:RE:all}}'
                                AND IF('{{excludedContent:RE:alnumx}}' <> '', p.title NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                            , CONCAT('<strong>Title:</strong><br>', QMARK(p.title, '{{search:RE:allbut}}')),'')
                            , IF(p.subtitle LIKE '{{finalSearch:RE:all}}'
                                AND IF('{{excludedContent:RE:alnumx}}' <> '', p.subtitle NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                            , CONCAT('<strong>Subtitle:</strong><br>', QMARK(p.subtitle, '{{search:RE:allbut}}')),'')
                            , IF(p.alias LIKE '{{finalSearch:RE:all}}'
                                AND IF('{{excludedContent:RE:alnumx}}' <> '', p.alias NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                            , CONCAT('<strong>Alias:</strong><br>', QMARK(p.alias, '{{search:RE:allbut}}')),''))
                   , p.uid AS _pageId

                FROM {{dbNameT3:Y}}.pages AS p

                WHERE '{{finalSearch:RE:all}}' != ''
                  AND (p.title LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' != '', p.title NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                  OR p.subtitle LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' != '', p.subtitle NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1)
                  OR p.alias LIKE '{{finalSearch:RE:all}}'
                  AND IF('{{excludedContent:RE:alnumx}}' != '', p.alias NOT LIKE CONCAT('%', '{{excludedContent:RE:alnumx}}', '%'), 1=1))
                  AND p.deleted = 0

                {{queryLimit:RE:alnumx}}


                head = <tbody>
                tail = </tbody></table><input id='p-box-counter' value='{{20.50.160.180.line.count}}' type='hidden'>
                rbeg = <tr>
                renr = </tr>
                fbeg = <td>
                fend = </td>

                # Iterate over all tt_contents from each page and build edit button
                190 {
                    sql = SELECT CONCAT('i:uid=', r.uid, '|t:', r.uid, '|b:btn btn-default') AS _link
                                 , ' '
                            FROM {{dbNameT3:Y}}.pages AS p, {{dbNameT3:Y}}.tt_content AS r
                            WHERE p.uid = {{pageId:R0}}
                              AND p.uid = r.pid
                              AND r.deleted = 0
                    shead = <td>
                    stail = </td>
                }
            }
        }
    }

    200 {
        sql = SELECT '<script> $(document).ready(function() {
                                    var resultBoxes = document.getElementsByClassName("result-box-counter");
                                    Array.from(resultBoxes).forEach(setCounter);
                                    function setCounter(element) {
                                        if (element.dataset !== undefined) {
                                            var value = document.getElementById(element.dataset.boxId).value;
                                            if (value >= 100) {
                                                element.innerText = "100 or more rows reached!";
                                            } } } }); </script>'
    }
}