# [25-Apr-2025 09:29:24] /tsauto/www/tSN1w0Du5X4a/bg/ajax/users/login.html?_=1745562564277 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
# [25-Apr-2025 09:29:24] /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
# [25-Apr-2025 09:29:27] /tsauto/www/tSN1w0Du5X4a/bg/labels/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
                `LabelsBG`.`Label`,
                `LabelsBG`.`Value` AS `LabelsBGValue`,
                `LabelsEN`.`Value` AS `LabelsENValue`
            FROM
                `labels` AS `LabelsBG`
                LEFT JOIN `labels` AS `LabelsEN` ON `LabelsEN`.`Language` = 'en' AND `LabelsEN`.`Label` = `LabelsBG`.`Label`
            WHERE
                `LabelsBG`.`Language` = 'bg'
         ORDER BY `LabelsBG`.`Label` ASC
# [25-Apr-2025 09:29:29] /tsauto/www/tSN1w0Du5X4a/bg/ajax/labels/form.html?label=Address&_=1745562569104 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
                LabelsBG.`Label`,
                LabelsBG.`Value` AS `ValueBG`,
                LabelsEN.`Value` AS `ValueEN`
            FROM
                `labels` AS LabelsBG
                LEFT JOIN `labels` AS LabelsEN ON LabelsEN.`Language` = 'en' AND LabelsEN.`Label` = LabelsBG.`Label`
            WHERE
                LabelsBG.`Language` = 'bg' AND
                LabelsBG.`Label` = 'Address'
            LIMIT 1
