# [07-May-2025 13:41:07] /tsauto/www/tSN1w0Du5X4a/bg/ajax/users/login.html?_=1746614467553 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'NzkzYjAzNGI1NTAwNmYyNjE4ZTE0YTgxNTRhMjY0MTIYjFhNTYxNzFmZThiOWY0YjI0NWU5MzU5Mzg0NTk5NTc%'
            LIMIT 1
# [07-May-2025 13:41:07] /tsauto/www/tSN1w0Du5X4a/bg/pages/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `pages`.`Action`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         ORDER BY `meta`.`PostDate` ASC
# [07-May-2025 13:41:10] /tsauto/www/tSN1w0Du5X4a/bg/services/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`Parent`.`URLLabel` IS NULL, `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `services`.`Title`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `services` ON
                    `services`.`ID` = `meta`.`ID` AND
                    `services`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'services'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'services'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` ASC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`Parent`.`URLLabel` IS NULL, `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `services`.`Title`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `services` ON
                    `services`.`ID` = `meta`.`ID` AND
                    `services`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'services'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'services'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` ASC) AS CountTable
# [07-May-2025 13:41:11] /tsauto/www/tSN1w0Du5X4a/bg/ajax/services/form/10000.html?_=1746614471727 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                *
            FROM
                `meta`
                INNER JOIN `services` ON
                    `services`.`ID` = `meta`.`ID` AND
                    `services`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 10000 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'services'
            LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`ParentID`,
                `meta`.`Module`,
                `pages`.`MenuLabel` AS `Label`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`Module` = 'services' AND
                `meta`.`Language` = 'bg' AND
                `meta`.`ParentID` = 1 AND
                `pages`.`MenuLabel` <> ''
