# [04-Mar-2025 06:47:58] /ooyes/www/bg/accounts/complete/9a1XEP3m6UGy3DXJkIbG8NYK7IOfd58agAz1F2434sEEAS2V43N8K945623KCbC1.html 108.61.209.243

set names utf8

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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 06:47:59] /ooyes/www/bg/ajax/accounts/form/complete.html?_=1741063681040 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `accounts`
            WHERE
                `AccessKey` = '9a1XEP3m6UGy3DXJkIbG8NYK7IOfd58agAz1F2434sEEAS2V43N8K945623KCbC1' AND
                `Confirmed` = 0
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LEMail','LPassword','LConfirmPassword','ConfirmPasswordError','InfoPasswordRequirements','LSubmit') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorEMail','ErrorPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 06:53:39] /ooyes/www/bg/ajax/accounts/complete/aid_160064738.html?_=1741064021505 108.61.209.243

set names utf8

SELECT * FROM `accounts` LIMIT 1

SHOW COLUMNS FROM `accounts`

UPDATE `accounts` SET `LastUpdate` = NOW(), `UserKey` = 'OGFjYWJmNmNkYzBiYjNkODA2ZDIzNmJmOGQ5MDNhMDcYzYzMmQwZTE0NDM4ZTAyM2Y3YjI2NjA5Y2QyNmYzYTY1', `Data` = 'vx7d9P0ZvwoKnT1n7MxOKMzoEPbpJtvNRy-bo_2QbGD7fxJN1Jrh7W7qMkv87q4gDaz8oQPEdMaMPfQlpFOWtcKIqMqMYzUWdxC1jm7Od5Eg6wBFAhvKQ_3loVCBLbASGDus3s-hgrbL0S31GFOFL3Pre6zWl__1c2AEwtBLiog', `SearchKey` = '0LXQuQ0LTQttC40LXQudGH0LXQvtC-0LQYWdobHRkeWFob28Y29t', `AccessKey` = NULL, `Confirmed` = 1 WHERE `ID` = '160064738' AND `AccessKey` = '9a1XEP3m6UGy3DXJkIbG8NYK7IOfd58agAz1F2434sEEAS2V43N8K945623KCbC1'
# [04-Mar-2025 06:53:39] /ooyes/www/bg/accounts.html 108.61.209.243

set names utf8

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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 06:53:40] /ooyes/www/bg/ajax/accounts/form/login.html?_=1741064022006 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorUserName','ErrorPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 06:53:59] /ooyes/www/bg/ajax/accounts/login.html?_=1741064040952 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `accounts`
            WHERE
                `UserKey` LIKE 'OGFjYWJmNmNkYzBiYjNkODA2ZDIzNmJmOGQ5MDNhMDcYzYzMmQwZTE0NDM4ZTAyM2Y3YjI2NjA5Y2QyNmYzYTY%'
            LIMIT 1
# [04-Mar-2025 06:53:59] /ooyes/www/bg/invoices.html 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`
            FROM
                `invoices`
            WHERE
                `AccountID` = '160064738'
         AND `PostDate` BETWEEN '2025-03-01' AND '2025-03-04'  ORDER BY `ID` DESC LIMIT 0, 100

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNoResults') 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 06:54:03] /ooyes/www/bg/invoices.html?from=01.10.2024&to=04.03.2025 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`
            FROM
                `invoices`
            WHERE
                `AccountID` = '160064738'
         AND `PostDate` BETWEEN '2024-10-01' AND '2025-03-04'  ORDER BY `ID` DESC LIMIT 0, 100

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNoResults') 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 06:54:07] /ooyes/www/bg/invoices.html?from=01.02.2024&to=04.03.2025 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`
            FROM
                `invoices`
            WHERE
                `AccountID` = '160064738'
         AND `PostDate` BETWEEN '2024-02-01' AND '2025-03-04'  ORDER BY `ID` DESC LIMIT 0, 100

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNumber','LDate','LSum','LVat','LTotal') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`
            FROM
                `invoices`
            WHERE
                `AccountID` = '160064738'
         AND `PostDate` BETWEEN '2024-02-01' AND '2025-03-04'  ORDER BY `ID` DESC) AS CountTable

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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 06:54:19] /ooyes/www/bg/invoices/11101185.html 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 11101185 AND
                `AccountID` = '160064738'
            LIMIT 1

SELECT
                CONCAT(`UploadID`, '/', `Image`) AS `Image`
            FROM
                `banners`
            WHERE
                `Position` = 0 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
            ORDER BY
                `PostDate` DESC
            LIMIT 1

SELECT
                CONCAT(`UploadID`, '/', `Image`) AS `Image`
            FROM
                `banners`
            WHERE
                `Position` = 1 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
            ORDER BY
                `PostDate` DESC
            LIMIT 1
# [04-Mar-2025 06:54:49] /ooyes/www/bg/accounts/complete/9a1XEP3m6UGy3DXJkIbG8NYK7IOfd58agAz1F2434sEEAS2V43N8K945623KCbC1.html 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoices') 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 06:54:49] /ooyes/www/bg/ajax/accounts/form/complete.html?_=1741064091562 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `accounts`
            WHERE
                `AccessKey` = '9a1XEP3m6UGy3DXJkIbG8NYK7IOfd58agAz1F2434sEEAS2V43N8K945623KCbC1' AND
                `Confirmed` = 0
            LIMIT 1
# [04-Mar-2025 06:58:17] /ooyes/www/bg/accounts/complete/9a1XEP3m6UGy3DXJkIbG8NYK7IOfd58agAz1F2434sEEAS2V43N8K945623KCbC1.html 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoices') 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 06:58:18] /ooyes/www/bg/ajax/accounts/form/complete.html?_=1741064300170 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `accounts`
            WHERE
                `AccessKey` = '9a1XEP3m6UGy3DXJkIbG8NYK7IOfd58agAz1F2434sEEAS2V43N8K945623KCbC1' AND
                `Confirmed` = 0
            LIMIT 1
# [04-Mar-2025 07:06:27] /ooyes/www/bg/accounts/complete/9a1XEP3m6UGy3DXJkIbG8NYK7IOfd58agAz1F2434sEEAS2V43N8K945623KCbC1.html 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `accounts`
            WHERE
                `AccessKey` = '9a1XEP3m6UGy3DXJkIbG8NYK7IOfd58agAz1F2434sEEAS2V43N8K945623KCbC1' AND
                `Confirmed` = 0
            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` = 'accounts' AND
	    		`meta`.`URLLabel` = 'completed'
         AND `meta`.`Visible` = 1 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` = 'accounts' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'completed' AND
                P1.`Visible` = 1

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoices') 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 07:07:47] /ooyes/www/bg/accounts/complete/9a1XEP3m6UGy3DXJkIbG8NYK7IOfd58agAz1F2434sEEAS2V43N8K945623KCbC1.html 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `accounts`
            WHERE
                `AccessKey` = '9a1XEP3m6UGy3DXJkIbG8NYK7IOfd58agAz1F2434sEEAS2V43N8K945623KCbC1' AND
                `Confirmed` = 0
            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` = 'accounts' AND
	    		`meta`.`URLLabel` = 'completed'
         AND `meta`.`Visible` = 1 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` = 'accounts' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'completed' AND
                P1.`Visible` = 1

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoices') 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 07:07:58] /ooyes/www/bg/accounts/complete/4feFoo94tLKEnWs6cLWjmEXpszdF9qj562XoSX6G8Rb4aIo9FnXvTo58z4XJxu3A.html 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `accounts`
            WHERE
                `AccessKey` = '4feFoo94tLKEnWs6cLWjmEXpszdF9qj562XoSX6G8Rb4aIo9FnXvTo58z4XJxu3A' AND
                `Confirmed` = 0
            LIMIT 1

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoices') 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 07:07:58] /ooyes/www/bg/ajax/accounts/form/complete.html?_=1741064880474 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `accounts`
            WHERE
                `AccessKey` = '4feFoo94tLKEnWs6cLWjmEXpszdF9qj562XoSX6G8Rb4aIo9FnXvTo58z4XJxu3A' AND
                `Confirmed` = 0
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LEMail','LPassword','LConfirmPassword','ConfirmPasswordError','InfoPasswordRequirements','LSubmit') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorEMail','ErrorPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 07:08:12] /ooyes/www/bg/ajax/accounts/complete/aid_040427202.html?_=1741064894231 108.61.209.243

set names utf8

SELECT * FROM `accounts` LIMIT 1

SHOW COLUMNS FROM `accounts`

UPDATE `accounts` SET `LastUpdate` = NOW(), `UserKey` = 'ODQ2ZWNmZDhiYzQ3MmQ1Yjc5NDQ2YmNhYTU2ZjUzMjcYzYzMmQwZTE0NDM4ZTAyM2Y3YjI2NjA5Y2QyNmYzYTY1', `Data` = 'v0RZ68eAE3gR2Zdteg1FlAgF7i4fvmwL9EIt4grkRdSP4iUoaQ7ipn_fMUWpbOfpdVNu9OgaMEidfX3yaiy4X5zcH_8chtFDOmM9-65LqWkeEfDPo5GzsoKp2_TAe4w2iRMKh-_L2GQJHL-Dr9jUWskNN4hWqBs4Sl6A2bTjVBE', `SearchKey` = '0LzQtdGC0LDRgNC10LrRgQ0L7QvtC0YWNjb3VudGluZwbWV0YXJleAbmV0', `AccessKey` = NULL, `Confirmed` = 1 WHERE `ID` = '040427202' AND `AccessKey` = '4feFoo94tLKEnWs6cLWjmEXpszdF9qj562XoSX6G8Rb4aIo9FnXvTo58z4XJxu3A'
# [04-Mar-2025 07:08:12] /ooyes/www/bg/accounts.html 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoices') 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 07:08:12] /ooyes/www/bg/ajax/accounts/form/login.html?_=1741064894671 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorUserName','ErrorPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 07:08:25] /ooyes/www/bg/ajax/accounts/login.html?_=1741064907330 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `accounts`
            WHERE
                `UserKey` LIKE 'ODQ2ZWNmZDhiYzQ3MmQ1Yjc5NDQ2YmNhYTU2ZjUzMjcYzYzMmQwZTE0NDM4ZTAyM2Y3YjI2NjA5Y2QyNmYzYTY%'
            LIMIT 1
# [04-Mar-2025 07:08:25] /ooyes/www/bg/invoices.html 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '040427202' AND
                                    CRC32(`UserKey`) = 2325675487 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`
            FROM
                `invoices`
            WHERE
                `AccountID` = '040427202'
         AND `PostDate` BETWEEN '2025-03-01' AND '2025-03-04'  ORDER BY `ID` DESC LIMIT 0, 100

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNoResults') 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 07:08:31] /ooyes/www/bg/invoices.html?from=01.04.2024&to=04.03.2025 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '040427202' AND
                                    CRC32(`UserKey`) = 2325675487 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`
            FROM
                `invoices`
            WHERE
                `AccountID` = '040427202'
         AND `PostDate` BETWEEN '2024-04-01' AND '2025-03-04'  ORDER BY `ID` DESC LIMIT 0, 100

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNumber','LDate','LSum','LVat','LTotal') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`
            FROM
                `invoices`
            WHERE
                `AccountID` = '040427202'
         AND `PostDate` BETWEEN '2024-04-01' AND '2025-03-04'  ORDER BY `ID` DESC) AS CountTable

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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 07:08:33] /ooyes/www/bg/invoices/10699336.html 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '040427202' AND
                                    CRC32(`UserKey`) = 2325675487 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10699336 AND
                `AccountID` = '040427202'
            LIMIT 1

SELECT
                CONCAT(`UploadID`, '/', `Image`) AS `Image`
            FROM
                `banners`
            WHERE
                `Position` = 0 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
            ORDER BY
                `PostDate` DESC
            LIMIT 1

SELECT
                CONCAT(`UploadID`, '/', `Image`) AS `Image`
            FROM
                `banners`
            WHERE
                `Position` = 1 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
            ORDER BY
                `PostDate` DESC
            LIMIT 1
# [04-Mar-2025 07:14:21] /ooyes/www/bg/account-complete-failed.html 108.61.209.243

set names utf8

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` = 'account-complete-failed'
         AND `meta`.`Visible` = 1 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` = 'accounts' AND
	    		`meta`.`URLLabel` = 'account-complete-failed'
         AND `meta`.`Visible` = 1 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` = 'accounts' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'account-complete-failed' AND
                P1.`Visible` = 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 07:14:54] /ooyes/www/bg/account-reset-sent.html 108.61.209.243

set names utf8

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` = 'account-reset-sent'
         AND `meta`.`Visible` = 1 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` = 'accounts' AND
	    		`meta`.`URLLabel` = 'account-reset-sent'
         AND `meta`.`Visible` = 1 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` = 'accounts' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'account-reset-sent' AND
                P1.`Visible` = 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 07:15:14] /ooyes/www/bg/account-reset-success.html 108.61.209.243

set names utf8

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` = 'account-reset-success'
         AND `meta`.`Visible` = 1 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` = 'accounts' AND
	    		`meta`.`URLLabel` = 'account-reset-success'
         AND `meta`.`Visible` = 1 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` = 'accounts' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'account-reset-success' AND
                P1.`Visible` = 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 07:15:37] /ooyes/www/bg/account-reset-failed.html 108.61.209.243

set names utf8

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` = 'account-reset-failed'
         AND `meta`.`Visible` = 1 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` = 'accounts' AND
	    		`meta`.`URLLabel` = 'account-reset-failed'
         AND `meta`.`Visible` = 1 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` = 'accounts' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'account-reset-failed' AND
                P1.`Visible` = 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 07:15:58] /ooyes/www/bg/completed.html 108.61.209.243

set names utf8

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` = 'completed'
         AND `meta`.`Visible` = 1 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` = 'accounts' AND
	    		`meta`.`URLLabel` = 'completed'
         AND `meta`.`Visible` = 1 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` = 'accounts' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'completed' AND
                P1.`Visible` = 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 17:10:22] /ooyes/www/ 108.61.209.243

set names utf8

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'
         AND `meta`.`Visible` = 1 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'
         AND `meta`.`Visible` = 1 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'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `services`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

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

             AND `Visible` = 1 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'
         AND
                `meta`.`Visible` = 1
            
            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'
         AND `meta`.`Visible` = 1 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 AND `Visible` = 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'
         AND `meta`.`Visible` = 1 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'
         AND `meta`.`Visible` = 1 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'
         AND `meta`.`Visible` = 1 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 17:11:26] /ooyes/www/bg/kontakti.html 108.61.209.243

set names utf8

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` = 'kontakti'
         AND `meta`.`Visible` = 1 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` = 'contacts' AND
	    		`meta`.`URLLabel` = 'kontakti'
         AND `meta`.`Visible` = 1 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` = 'contacts' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'kontakti' AND
                P1.`Visible` = 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` = 'stores' AND
	    		`meta`.`URLLabel` = 'stores'
         AND `meta`.`Visible` = 1 LIMIT 1

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

SELECT
                *
            FROM
                `stores`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC

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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 17:11:27] /ooyes/www/bg/stores/map.html 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `stores`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [04-Mar-2025 17:11:27] /ooyes/www/bg/ajax/contacts/form.html?_=1741101088099 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSubject','LNameOrg','LTown','LPhone','LEMail','LAdditionalInfo','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorTown','ErrorPhone','ErrorEMail','ErrorIAgree') 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` = 'terms' AND
                `pages`.`Action` = 'privacy'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 17:11:42] /ooyes/www/ 108.61.209.243

set names utf8

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'
         AND `meta`.`Visible` = 1 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'
         AND `meta`.`Visible` = 1 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'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `services`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

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

             AND `Visible` = 1 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'
         AND
                `meta`.`Visible` = 1
            
            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'
         AND `meta`.`Visible` = 1 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 AND `Visible` = 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'
         AND `meta`.`Visible` = 1 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'
         AND `meta`.`Visible` = 1 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'
         AND `meta`.`Visible` = 1 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 17:13:54] /ooyes/www/bg/accounts/complete/CVQEE2Zr1v6O3rEt3OZRU17C1frazAwMmag40ZjuDM3UUuo5iDz0U4h14vPSnxqx.html 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `accounts`
            WHERE
                `AccessKey` = 'CVQEE2Zr1v6O3rEt3OZRU17C1frazAwMmag40ZjuDM3UUuo5iDz0U4h14vPSnxqx' AND
                `Confirmed` = 0
            LIMIT 1

SELECT
                `ID`,
                `Data`
            FROM
                `accounts`
            WHERE
                `AccessKey` = 'CVQEE2Zr1v6O3rEt3OZRU17C1frazAwMmag40ZjuDM3UUuo5iDz0U4h14vPSnxqx' AND
                `Confirmed` = 0
            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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 17:13:55] /ooyes/www/bg/ajax/accounts/form/complete.html?_=1741101235864 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `accounts`
            WHERE
                `AccessKey` = 'CVQEE2Zr1v6O3rEt3OZRU17C1frazAwMmag40ZjuDM3UUuo5iDz0U4h14vPSnxqx' AND
                `Confirmed` = 0
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LEMail','LPassword','LConfirmPassword','ConfirmPasswordError','InfoPasswordRequirements','LSubmit') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorEMail','ErrorPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 17:14:14] /ooyes/www/bg/ajax/accounts/complete/aid_160064738.html?_=1741101255584 108.61.209.243

set names utf8

SELECT * FROM `accounts` LIMIT 1

SHOW COLUMNS FROM `accounts`

UPDATE `accounts` SET `LastUpdate` = NOW(), `UserKey` = 'OGFjYWJmNmNkYzBiYjNkODA2ZDIzNmJmOGQ5MDNhMDcYzYzMmQwZTE0NDM4ZTAyM2Y3YjI2NjA5Y2QyNmYzYTY1', `Data` = 'V-UL0OyQ7Yl-d-Kr53UUGyRYvrM6ADz9DyzYQ0mcDVtM3tvRZ2KBiDoWOdDI3RR2EEZd7VWtnmljTV_u1xsbROd7pA2rcBW9WM3XeAiCpcNNbOKVKNux3quZfyIuRNYg5qHPARmRHe28CkF8Us0Ed7aSr2zkhQKN_IqWu1o9W7E', `SearchKey` = '0LXQuQ0LTQttC40LXQudGH0LXQvtC-0LQYWdobHRkeWFob28Y29t', `AccessKey` = NULL, `Confirmed` = 1 WHERE `ID` = '160064738' AND `AccessKey` = 'CVQEE2Zr1v6O3rEt3OZRU17C1frazAwMmag40ZjuDM3UUuo5iDz0U4h14vPSnxqx'
# [04-Mar-2025 17:14:14] /ooyes/www/bg/accounts.html 108.61.209.243

set names utf8

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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 17:14:15] /ooyes/www/bg/ajax/accounts/form/login.html?_=1741101256087 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorUserName','ErrorPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 17:14:31] /ooyes/www/bg/ajax/accounts/login.html?_=1741101272812 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `accounts`
            WHERE
                `UserKey` LIKE 'OGFjYWJmNmNkYzBiYjNkODA2ZDIzNmJmOGQ5MDNhMDcYzYzMmQwZTE0NDM4ZTAyM2Y3YjI2NjA5Y2QyNmYzYTY%'
            LIMIT 1
# [04-Mar-2025 17:14:32] /ooyes/www/bg/invoices.html 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`
            FROM
                `invoices`
            WHERE
                `AccountID` = '160064738'
         AND `PostDate` BETWEEN '2025-02-02' AND '2025-03-04'  ORDER BY `ID` DESC LIMIT 0, 100

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNoResults') 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 17:14:36] /ooyes/www/bg/invoices.html?from=02.02.2025&to=04.03.2025 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`
            FROM
                `invoices`
            WHERE
                `AccountID` = '160064738'
         AND `PostDate` BETWEEN '2025-02-02' AND '2025-03-04'  ORDER BY `ID` DESC LIMIT 0, 100

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNoResults') 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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 17:14:43] /ooyes/www/bg/invoices.html?from=01.11.2023&to=04.03.2025 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`
            FROM
                `invoices`
            WHERE
                `AccountID` = '160064738'
         AND `PostDate` BETWEEN '2023-11-01' AND '2025-03-04'  ORDER BY `ID` DESC LIMIT 0, 100

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNumber','LDate','LSum','LVat','LTotal') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`
            FROM
                `invoices`
            WHERE
                `AccountID` = '160064738'
         AND `PostDate` BETWEEN '2023-11-01' AND '2025-03-04'  ORDER BY `ID` DESC) AS CountTable

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`)
         AND `meta`.`Visible` = 1
            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'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT DISTINCT
                `FooterLabel`
            FROM
                `stores`
            WHERE
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1
            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','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 17:15:48] /ooyes/www/bg/invoices/11101185.html 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 11101185 AND
                `AccountID` = '160064738'
            LIMIT 1
# [04-Mar-2025 17:15:57] /ooyes/www/bg/invoices/11101185.html 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 11101185 AND
                `AccountID` = '160064738'
            LIMIT 1
# [04-Mar-2025 17:16:37] /ooyes/www/bg/invoices/11101185.html 108.61.209.243

set names utf8

SELECT
                                    `ID`
                                FROM
                                    `accounts`
                                WHERE
                                    `ID` = '160064738' AND
                                    CRC32(`UserKey`) = 1716429356 AND
                                    RIGHT(`UserKey`, 1) = 1
                                LIMIT 1

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 11101185 AND
                `AccountID` = '160064738'
            LIMIT 1
