# [20-Oct-2024 20:25:22] /ski/www/sKiEsnZ9sp2/bg/ajax/users/login.html?_=1729445121861 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
# [20-Oct-2024 20:25:22] /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
# [20-Oct-2024 20:25:29] /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
# [20-Oct-2024 20:25:31] /ski/www/sKiEsnZ9sp2/bg/ajax/offers/form/clone/1001.html?_=1729445131439 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
                *
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1001 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'offers'
            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` = 'offers' AND
                `meta`.`Language` = 'bg' AND
                `meta`.`ParentID` = 1 AND
                `pages`.`MenuLabel` <> ''
# [20-Oct-2024 20:32:14] /ski/www/sKiEsnZ9sp2/bg/ajax/meta/offers/1001.html?URLLabel=a29wYW9uaWtfc2tp&_=1729445533963 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'kopaonik_ski'  AND `ID` != '1001' AND `Module` = 'offers' AND `Language` = 'bg'
# [20-Oct-2024 20:33:11] /ski/www/sKiEsnZ9sp2/bg/ajax/offers/upload/9445131558.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
# [20-Oct-2024 20:37:36] /ski/www/sKiEsnZ9sp2/bg/ajax/offers/upload/9445131558.html 108.61.209.243

set names utf8

KILL 26084 -> Query: 

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [20-Oct-2024 20:37:44] /ski/www/sKiEsnZ9sp2/bg/ajax/offers/insert.html?_=1729445864059 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 MAX(`ID`) + 1 FROM `offers`
# [20-Oct-2024 20:37:51] /ski/www/sKiEsnZ9sp2/bg/ajax/offers/upload/9445131558.html 108.61.209.243

set names utf8

KILL 26085 -> Query: 

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [20-Oct-2024 20:39:00] /ski/www/sKiEsnZ9sp2/bg/offers/list.html 108.61.209.243

set names utf8

KILL 26087 -> Query: 

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
# [20-Oct-2024 20:39:02] /ski/www/sKiEsnZ9sp2/bg/ajax/offers/form/clone/1001.html?_=1729445942851 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
                *
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1001 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'offers'
            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` = 'offers' AND
                `meta`.`Language` = 'bg' AND
                `meta`.`ParentID` = 1 AND
                `pages`.`MenuLabel` <> ''
# [20-Oct-2024 20:39:17] /ski/www/sKiEsnZ9sp2/bg/ajax/offers/insert.html?_=1729445957094 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 MAX(`ID`) + 1 FROM `offers`
# [20-Oct-2024 20:39:22] /ski/www/sKiEsnZ9sp2/bg/ajax/offers/upload/9445942979.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
# [20-Oct-2024 20:41:52] /ski/www/sKiEsnZ9sp2/bg/articles/list.html 108.61.209.243

set names utf8

KILL 26091 -> Query: 

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`,
                `articles`.`Title`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `articles` ON
                    `articles`.`ID` = `meta`.`ID` AND
                    `articles`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'articles'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'articles'
            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`,
                `articles`.`Title`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `articles` ON
                    `articles`.`ID` = `meta`.`ID` AND
                    `articles`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'articles'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'articles'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC) AS CountTable
# [20-Oct-2024 20:43:36] /ski/www/sKiEsnZ9sp2/bg/ajax/articles/form.html?_=1729446216492 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`.`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` = 'articles' AND
                `meta`.`Language` = 'bg' AND
                `meta`.`ParentID` = 1 AND
                `pages`.`MenuLabel` <> ''
# [20-Oct-2024 20:46:01] /ski/www/sKiEsnZ9sp2/bg/ajax/articles/form.html?_=1729446360996 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`.`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` = 'articles' AND
                `meta`.`Language` = 'bg' AND
                `meta`.`ParentID` = 1 AND
                `pages`.`MenuLabel` <> ''
# [20-Oct-2024 20:46:35] /ski/www/sKiEsnZ9sp2/bg/ajax/meta/articles.html?URLLabel=0LrQsNGA0LDQvdC10YLQvi3QvdCwLdGB0LrQuC3QvNC-0LbQtS3QtNCwLdCy0Lgt0L_QvtC80L7Qs9C90LUt0LTQsC3QttC40LLQtdC10YLQtS3Qv9C-LdC00YrQu9Cz0L4&_=1729446395305 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'karaneto-na-ski-mozhe-da-vi-pomogne-da-zhiveete-po-dalgo'
# [20-Oct-2024 20:46:38] /ski/www/sKiEsnZ9sp2/bg/ajax/meta/articles.html?URLLabel=a2FyYW5ldG8tbmEtc2tpLW1vemhlLWRhLXZpLXBvbW9nbmUtZGEtemhpdmVldGUtcG8tZGFsZ28&_=1729446398006 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'karaneto-na-ski-mozhe-da-vi-pomogne-da-zhiveete-po-dalgo'
# [20-Oct-2024 20:49:57] /ski/www/sKiEsnZ9sp2/bg/ajax/articles/upload/9446361232.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
# [20-Oct-2024 20:50:17] /ski/www/sKiEsnZ9sp2/bg/ajax/articles/upload/9446361232.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
# [20-Oct-2024 20:50:33] /ski/www/sKiEsnZ9sp2/bg/ajax/articles/upload/9446361232.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
