# [19-Jun-2025 09:52:31] /ooyes/www/oY3Dz0MfT1a/bg/ajax/groups/form/10048.html?_=1750315951225 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `users`
                                WHERE
                                    `ID` = '200876880' AND
                                    CRC32(`UserKey`) = 1191984090 AND
                                    RIGHT(`UserKey`, 1) = 9
                                LIMIT 1

SELECT
                *,
                (SELECT GROUP_CONCAT(`SectorID` separator ',') as `Sectors` FROM `group-sectors` WHERE `GroupID` = `groups`.`ID`) AS `Sectors`
            FROM
                `meta`
                INNER JOIN `groups` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 10048 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'groups'
            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` = 'products' AND
                `meta`.`Language` = 'bg' AND
                `meta`.`ParentID` = 1 AND
                `pages`.`MenuLabel` <> ''

SELECT
                `meta`.`ID`,
                `meta`.`ParentID`,
                `meta`.`Module`,
                `services`.`Title` AS `Label`
            FROM
                `meta`
                INNER JOIN `services` ON
                    `services`.`ID` = `meta`.`ID` AND
                    `services`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`Module` = 'services' AND
                `meta`.`Language` = 'bg' AND
                `services`.`Icon` <> ''
# [19-Jun-2025 15:46:06] /ooyes/www/oY3Dz0MfT1a/bg/ajax/groups/form/10048.html?_=1750337165267 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `users`
                                WHERE
                                    `ID` = '200876880' AND
                                    CRC32(`UserKey`) = 1191984090 AND
                                    RIGHT(`UserKey`, 1) = 9
                                LIMIT 1

SELECT
                *,
                (SELECT GROUP_CONCAT(`SectorID` separator ',') as `Sectors` FROM `group-sectors` WHERE `GroupID` = `groups`.`ID`) AS `Sectors`
            FROM
                `meta`
                INNER JOIN `groups` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 10048 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'groups'
            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` = 'products' AND
                `meta`.`Language` = 'bg' AND
                `meta`.`ParentID` = 1 AND
                `pages`.`MenuLabel` <> ''

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