# [09-Nov-2024 00:19:59] /ski/www/sKiEsnZ9sp2/bg/ajax/users/login.html?_=1731104399394 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'MDdiMjRmNjFlZDU5NjQwOTJlMzM4ZmYzZTliNTZjY2QYzFiNTQ4ZWQyZjdlNTg4NzFkN2ZhM2M1MmMyZmY5M2M%'
            LIMIT 1
# [09-Nov-2024 00:19:59] /ski/www/sKiEsnZ9sp2/bg/pages/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 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')
         ORDER BY `meta`.`PostDate` ASC
# [09-Nov-2024 00:20:04] /ski/www/sKiEsnZ9sp2/bg/offers/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 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`,
                `offers`.`StartFrom`,
                `offers`.`EndTo`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC 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`,
                `offers`.`StartFrom`,
                `offers`.`EndTo`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC) AS CountTable
