# [19-May-2025 15:18:59] /ooyes/www/oY3Dz0MfT1a/ 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
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages' AND
	    		`meta`.`URLLabel` = 'index'
         LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'pages' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            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
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'services' AND
                `pages`.`Action` = 'index'
         LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`UploadID`,
                `meta`.`URLLabel`,
                `services`.`Icon`,
                `services`.`Title`,
                `meta`.`Visible`
            FROM
                `services`
                INNER JOIN `meta` ON
                    `services`.`ID` = `meta`.`ID` AND
                    `services`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'services'
            WHERE
                `meta`.`Language` = 'bg'
        
            GROUP BY
                `services`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                *
            FROM
                `documents`
            WHERE
                `Language` = 'bg' AND
                `DocType` = 0

             ORDER BY `PostDate` DESC

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `projects`.`Images`,
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabel`,
                `projects`.`Title`,
                `projects`.`Annotation`,
                `meta`.`Visible`
            FROM
                `projects`
                INNER JOIN `meta` ON
                    `projects`.`ID` = `meta`.`ID` AND
                    `projects`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'projects'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'projects'
            WHERE
                `meta`.`Language` = 'bg'
        
            GROUP BY
                `projects`.`ID`
            ORDER BY
                `projects`.`HomePage` DESC,
                `meta`.`PostDate` ASC
         LIMIT 0, 3

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            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
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'projects' AND
                `pages`.`Action` = 'index'
         LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('September') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('October') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ID`,
                `UploadID`,
                `Rate`,
                `Image`,
                `FullName`,
                `Review`,
                `Media`,
                `MediaURL`,
                `HomePage`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg'
         AND `HomePage` = 1 ORDER BY `PostDate` DESC LIMIT 0, 4

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`,
                `meta`.`Visible`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'reviews' AND
	    		`meta`.`URLLabel` = 'reviews'
         LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Phone','LSendRequest') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            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
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'contacts' AND
                `pages`.`Action` = 'index'
         LIMIT 1

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`,
                `meta`.`Visible`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'contacts' AND
	    		`meta`.`URLLabel` = 'kontakti'
         LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogin') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            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
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
        
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            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
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'contacts' AND
                `pages`.`Action` = 'index'
         LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
        
            ORDER BY
                `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPartOf','Address','LFollowUs','FacebookURL','InstagramURL','EMail','LFooterInfo','LOurOffices','LContactUs','LServices','LProductCatalog','LBusinessHours','BusinessHours','WorkingDays','LSubscribe','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-May-2025 15:19:07] /ooyes/www/oY3Dz0MfT1a/bg/pages/list.html 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
                `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
# [19-May-2025 15:19:30] /ooyes/www/oY3Dz0MfT1a/bg/products/list.html 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
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                 CONCAT(`Parent`.`URLLabel`, '/', `Group`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabel`,
                `products`.`Title`,
                `products`.`Specifications`,
                `products`.`RelatedProducts`,
                `products`.`FAQ`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `products` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Group` ON
                    `meta`.`ParentID` = `Group`.`ID` AND
                    `meta`.`Language` = `Group`.`Language` AND
                    `Group`.`Module` = 'groups'
                INNER JOIN `meta` AS `Parent` ON
                    `Group`.`ParentID` = `Parent`.`ID` AND
                    `Group`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            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`,
                 CONCAT(`Parent`.`URLLabel`, '/', `Group`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabel`,
                `products`.`Title`,
                `products`.`Specifications`,
                `products`.`RelatedProducts`,
                `products`.`FAQ`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `products` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Group` ON
                    `meta`.`ParentID` = `Group`.`ID` AND
                    `meta`.`Language` = `Group`.`Language` AND
                    `Group`.`Module` = 'groups'
                INNER JOIN `meta` AS `Parent` ON
                    `Group`.`ParentID` = `Parent`.`ID` AND
                    `Group`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC) AS CountTable
# [19-May-2025 15:19:35] /ooyes/www/oY3Dz0MfT1a/bg/groups/list.html 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
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                `groups`.`Title`,
                `meta`.`URLLabel`,
                `meta`.`Visible`,
                `Parent`.`URLLabel` AS `ParentURLLabel`
            FROM
                `meta`
                INNER JOIN `groups` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language`
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `groups`.`Language` = 'bg' AND
                `meta`.`Module` = 'groups'
         ORDER BY `meta`.`PostDate` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                `groups`.`Title`,
                `meta`.`URLLabel`,
                `meta`.`Visible`,
                `Parent`.`URLLabel` AS `ParentURLLabel`
            FROM
                `meta`
                INNER JOIN `groups` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language`
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `groups`.`Language` = 'bg' AND
                `meta`.`Module` = 'groups'
         ORDER BY `meta`.`PostDate` ASC) AS CountTable
# [19-May-2025 15:19:41] /ooyes/www/oY3Dz0MfT1a/bg/specifications/list.html 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
                *
            FROM
                `specifications`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC
# [19-May-2025 15:20:00] /ooyes/www/oY3Dz0MfT1a/bg/products/list.html 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
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                 CONCAT(`Parent`.`URLLabel`, '/', `Group`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabel`,
                `products`.`Title`,
                `products`.`Specifications`,
                `products`.`RelatedProducts`,
                `products`.`FAQ`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `products` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Group` ON
                    `meta`.`ParentID` = `Group`.`ID` AND
                    `meta`.`Language` = `Group`.`Language` AND
                    `Group`.`Module` = 'groups'
                INNER JOIN `meta` AS `Parent` ON
                    `Group`.`ParentID` = `Parent`.`ID` AND
                    `Group`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            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`,
                 CONCAT(`Parent`.`URLLabel`, '/', `Group`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabel`,
                `products`.`Title`,
                `products`.`Specifications`,
                `products`.`RelatedProducts`,
                `products`.`FAQ`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `products` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Group` ON
                    `meta`.`ParentID` = `Group`.`ID` AND
                    `meta`.`Language` = `Group`.`Language` AND
                    `Group`.`Module` = 'groups'
                INNER JOIN `meta` AS `Parent` ON
                    `Group`.`ParentID` = `Parent`.`ID` AND
                    `Group`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC) AS CountTable
# [19-May-2025 15:20:03] /ooyes/www/oY3Dz0MfT1a/bg/groups/list.html 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
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                `groups`.`Title`,
                `meta`.`URLLabel`,
                `meta`.`Visible`,
                `Parent`.`URLLabel` AS `ParentURLLabel`
            FROM
                `meta`
                INNER JOIN `groups` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language`
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `groups`.`Language` = 'bg' AND
                `meta`.`Module` = 'groups'
         ORDER BY `meta`.`PostDate` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                `groups`.`Title`,
                `meta`.`URLLabel`,
                `meta`.`Visible`,
                `Parent`.`URLLabel` AS `ParentURLLabel`
            FROM
                `meta`
                INNER JOIN `groups` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language`
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `groups`.`Language` = 'bg' AND
                `meta`.`Module` = 'groups'
         ORDER BY `meta`.`PostDate` ASC) AS CountTable
# [19-May-2025 15:20:09] /ooyes/www/oY3Dz0MfT1a/bg/produkti/preparati.html 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
                `meta`.`Module`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`URLLabel` = 'produkti'
         LIMIT 1

SELECT
                `meta`.`Module`
            FROM
                `meta`
                INNER JOIN `services` ON
                    `services`.`ID` = `meta`.`ID` AND
                    `services`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`URLLabel` = 'preparati'
         LIMIT 1

SELECT
                `meta`.`Module`
            FROM
                `meta`
                INNER JOIN `groups` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`URLLabel` = 'preparati'
         LIMIT 1

SELECT
                *
	        FROM
	        	`groups`
                INNER JOIN `meta` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'groups'
	    	WHERE
	    		`meta`.`URLLabel` = 'preparati'
        
            GROUP BY
                `groups`.`ID`
            LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'groups' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'preparati' AND
                P1.`Visible` = 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `products`.`Images`,
                `meta`.`URLLabel`,
                `products`.`Title`,
                `products`.`Annotation`,
                `meta`.`Visible`
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`URLLabel` = 'preparati'
            WHERE
                `meta`.`Language` = 'bg'
        
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` DESC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogin') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            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
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
        
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            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
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'contacts' AND
                `pages`.`Action` = 'index'
         LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
        
            ORDER BY
                `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPartOf','Address','LFollowUs','FacebookURL','InstagramURL','Phone','EMail','LFooterInfo','LOurOffices','LContactUs','LServices','LProductCatalog','LBusinessHours','BusinessHours','WorkingDays','LSubscribe','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-May-2025 15:20:17] /ooyes/www/oY3Dz0MfT1a/bg/ajax/groups/form/10035.html?_=1747657219349 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` = 10035 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-May-2025 15:20:39] /ooyes/www/oY3Dz0MfT1a/bg/products/list.html 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
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                 CONCAT(`Parent`.`URLLabel`, '/', `Group`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabel`,
                `products`.`Title`,
                `products`.`Specifications`,
                `products`.`RelatedProducts`,
                `products`.`FAQ`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `products` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Group` ON
                    `meta`.`ParentID` = `Group`.`ID` AND
                    `meta`.`Language` = `Group`.`Language` AND
                    `Group`.`Module` = 'groups'
                INNER JOIN `meta` AS `Parent` ON
                    `Group`.`ParentID` = `Parent`.`ID` AND
                    `Group`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            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`,
                 CONCAT(`Parent`.`URLLabel`, '/', `Group`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabel`,
                `products`.`Title`,
                `products`.`Specifications`,
                `products`.`RelatedProducts`,
                `products`.`FAQ`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `products` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Group` ON
                    `meta`.`ParentID` = `Group`.`ID` AND
                    `meta`.`Language` = `Group`.`Language` AND
                    `Group`.`Module` = 'groups'
                INNER JOIN `meta` AS `Parent` ON
                    `Group`.`ParentID` = `Parent`.`ID` AND
                    `Group`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC) AS CountTable
# [19-May-2025 15:20:53] /ooyes/www/oY3Dz0MfT1a/bg/ajax/products/form/10042.html?_=1747657255176 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
                *
            FROM
                `meta`
                INNER JOIN `products` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 10042 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'products'
            LIMIT 1

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

SELECT
                `ID`,
                `TabLabel`,
                `Annotation`
            FROM
                `specifications`
            WHERE
                `ID` IN ('10075') AND
                `Language` = 'bg'
            ORDER BY
                FIELD(`ID`, '10075')

SELECT
                `ID`,
                `Title`,
                `Annotation`
            FROM
                `products`
            WHERE
                `ID` IN ('10040','10041','10043','10044','10045','10046') AND
                `Language` = 'bg'
            ORDER BY
                FIELD(`ID`, '10040','10041','10043','10044','10045','10046')
# [19-May-2025 15:22:23] /ooyes/www/oY3Dz0MfT1a/bg/ajax/products/form.html?_=1747657344902 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
                `meta`.`ID`,
                `meta`.`ParentID`,
                `meta`.`Module`,
                `groups`.`Title` AS `Label`
            FROM
                `meta`
                INNER JOIN `groups` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`Module` = 'groups' AND
                `meta`.`Language` = 'bg'
# [19-May-2025 15:22:38] /ooyes/www/oY3Dz0MfT1a/bg/ajax/meta/products.html?URLLabel=Zmx1c2gtbWFnaWMt0LTQtdC30L7QtNC-0YDQuNGA0LDRiS3RgdC_0YDQtdC5&_=1747657359611 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'flush-magic-dezodorirasht-sprey'
# [19-May-2025 15:48:51] /ooyes/www/oY3Dz0MfT1a/bg/ajax/products/insert.html?_=1747658933153 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 MAX(`ID`) + 1 FROM `products`
