# [08-Oct-2024 13:38:30] /techco/unicat/ 108.61.209.243

set names utf8

SELECT CONCAT_WS('/', `UploadID`, `Image`) AS `BackgroundURL`
            FROM
                `background`
            WHERE
                `Visible` = 1
            ORDER BY `LastUpdate` DESC
            LIMIT 1

SELECT
				`products`.`ID`
			FROM
				`products`
				INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
				INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
				INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
			WHERE
				(`PromoStart` IS NOT NULL OR `PromoEnd` IS NOT NULL) AND
				(`PromoStart` IS NULL OR `PromoStart` <= NOW()) AND
				(`PromoEnd` IS NULL OR `PromoEnd` >= NOW()) AND
				`product_texts`.`Language` = 'bg' AND
				`products`.`Visible` = 1 AND
				`groups`.`Visible` = 1
			LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `product_texts`.`Language` = 'bg' AND
                `products`.`selected` = 1
            GROUP BY `products`.`ID`
            ORDER BY `products`.`PostDate` DESC
# [08-Oct-2024 13:38:57] /techco/unicat/uC3nF1pZa6/bg/ajax/users/login.html?_=1728383937574 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vDkMOXw4LCpMOdwrbDjcK_w5rCu8OVw5PDlcK6woLCrMK1%'
            LIMIT 1
# [08-Oct-2024 13:38:58] /techco/unicat/uC3nF1pZa6/bg/products/list.html 108.61.209.243

set names utf8

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

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`LastUpdate` ASC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`LastUpdate` ASC) AS CountTable
# [08-Oct-2024 13:38:58] /techco/unicat/uC3nF1pZa6/bg/products/list/page_2.html 108.61.209.243

set names utf8

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

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`LastUpdate` ASC LIMIT 100, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`LastUpdate` ASC) AS CountTable
# [08-Oct-2024 13:39:01] /techco/unicat/uC3nF1pZa6/bg/ajax/products/form/4.html?_=1728383941510 108.61.209.243

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 4 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 4

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 674
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                FROM
                    `product_params`
                    INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
                WHERE
                    `product_params`.`ProductID` = 4 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
# [08-Oct-2024 14:30:39] /techco/unicat/uC3nF1pZa6/ 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881436 AND
                                CRC32(`UserKey`) = 1326687556 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [08-Oct-2024 14:30:40] /techco/unicat/bg/ajax/users/form/login.html?_=1728387039703 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881436 AND
                                CRC32(`UserKey`) = 1326687556 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [08-Oct-2024 14:30:43] /techco/unicat/uC3nF1pZa6/bg/ajax/users/login.html?_=1728387042751 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vDkMOXw4LCpMOdwrbDjcK_w5rCu8OVw5PDlcK6woLCrMK1%'
            LIMIT 1
# [08-Oct-2024 14:30:43] /techco/unicat/uC3nF1pZa6/bg/products/list.html 108.61.209.243

set names utf8

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

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`LastUpdate` ASC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`LastUpdate` ASC) AS CountTable
# [08-Oct-2024 14:30:43] /techco/unicat/uC3nF1pZa6/bg/products/list/page_2.html 108.61.209.243

set names utf8

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

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`LastUpdate` ASC LIMIT 100, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`LastUpdate` ASC) AS CountTable
# [08-Oct-2024 14:30:44] /techco/unicat/uC3nF1pZa6/bg/ajax/products/form/4.html?_=1728387044415 108.61.209.243

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 4 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 4

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 674
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                FROM
                    `product_params`
                    INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
                WHERE
                    `product_params`.`ProductID` = 4 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
