# [12-Mar-2026 06:26:17] /fin/fN9v3p6D6/ 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2026 18:02:17] /fin/fN9v3p6D6/ 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2026 18:02:18] /fin/bg/ajax/users/form/login.html?_=1773331348667 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail','ErrorPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2026 18:06:45] /fin/fN9v3p6D6/bg/ajax/users/login.html?_=1773331615772 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'uS¤AQv"R(C>Pcp;(iJJL;p[l6&g=h{@Vjii¼G¡m_;2k\\]E:9ªDx}5_}#b>¾eDN8#i%'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorUserPass') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2026 18:06:46] /fin/fN9v3p6D6/bg/ajax/users/login.html?_=1773331616463 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'NzkzYjAzNGI1NTAwNmYyNjE4ZTE0YTgxNTRhMjY0MTIYjFhNTYxNzFmZThiOWY0YjI0NWU5MzU5Mzg0NTk5NTc%'
            LIMIT 1
# [12-Mar-2026 18:06:46] /fin/fN9v3p6D6/bg/invoices/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876878 AND
                                CRC32(`UserKey`) = 3480059298 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                    `invoices`.*,
                    `Parent`.`Type` AS `ParentType`
                FROM
                    `invoices`
                    LEFT JOIN `invoices` AS `Parent` ON 
                        `invoices`.`ParentID` = `Parent`.`ID`
                WHERE
                    1
             AND `invoices`.`Type` = '1' ORDER BY `invoices`.`PostDate` DESC, `invoices`.`ID` DESC LIMIT 0, 100

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

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10488 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

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

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10480 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10477 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10465 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10483 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10455 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10479 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10478 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10481 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10482 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10466 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10454 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10476 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10475 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10474 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10381 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 2150 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 2247 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 2447 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10467 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10473 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10472 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10469 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10468 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10471 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10458 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10464 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10450 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10457 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10462 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10460 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10463 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10461 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10456 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
                SELECT
                    `invoices`.*,
                    `Parent`.`Type` AS `ParentType`
                FROM
                    `invoices`
                    LEFT JOIN `invoices` AS `Parent` ON 
                        `invoices`.`ParentID` = `Parent`.`ID`
                WHERE
                    1
             AND `invoices`.`Type` = '1' ORDER BY `invoices`.`PostDate` DESC, `invoices`.`ID` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2026 18:06:57] /fin/fN9v3p6D6/bg/invoices/list.html?type=0&from=&to=&keyword= 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876878 AND
                                CRC32(`UserKey`) = 3480059298 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                            `invoices`.*,
                            `Original`.`ID` AS `OriginalID`
                        FROM
                            `invoices`
                            LEFT JOIN `invoices` AS `Original` ON 
                                `invoices`.`ID` = `Original`.`ParentID` AND
                                `Original`.`Type` = 1
                        WHERE
                            1
                     AND `invoices`.`Type` = '0' ORDER BY `invoices`.`PostDate` DESC, `invoices`.`ID` DESC LIMIT 0, 100

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

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

SELECT COUNT(*) AS NumRows FROM (
                        SELECT
                            `invoices`.*,
                            `Original`.`ID` AS `OriginalID`
                        FROM
                            `invoices`
                            LEFT JOIN `invoices` AS `Original` ON 
                                `invoices`.`ID` = `Original`.`ParentID` AND
                                `Original`.`Type` = 1
                        WHERE
                            1
                     AND `invoices`.`Type` = '0' ORDER BY `invoices`.`PostDate` DESC, `invoices`.`ID` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2026 18:08:01] /fin/fN9v3p6D6/bg/ajax/invoices/form/clone/type_0/10485.html?_=1773331691795 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876878 AND
                                CRC32(`UserKey`) = 3480059298 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10485 AND
                `Type` = 0
            LIMIT 1

SELECT
                MAX(`ID`) AS `MaxID`
            FROM
                `invoices`
            WHERE
                `Type` = 0
            GROUP BY
                SUBSTRING(LPAD(`ID`, 10, '0'), 1, 1)
            ORDER BY
                `MaxID` ASC

SELECT
                `Code`,
                COALESCE(`labels`.`Value`, `NativeName`) AS `Name`
            FROM
                `invoice_countries`
                LEFT JOIN  `labels` ON
                    `invoice_countries`.`Name` = `labels`.`Label`
            WHERE
                `labels`.`Language` = 'bg'
            ORDER BY
                `Name` ASC
# [12-Mar-2026 18:08:04] /fin/fN9v3p6D6/bg/ajax/invoices/numbers/type_1.json?_=1773331694979 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876878 AND
                                CRC32(`UserKey`) = 3480059298 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                MAX(`ID`) AS `MaxID`
            FROM
                `invoices`
            WHERE
                `Type` = 1
            GROUP BY
                SUBSTRING(LPAD(`ID`, 10, '0'), 1, 1)
            ORDER BY
                `MaxID` ASC
# [12-Mar-2026 18:08:21] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1773331711331 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876878 AND
                                CRC32(`UserKey`) = 3480059298 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT `ID` FROM `invoice_countries` WHERE `Code` = 'BG' AND `EU` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('InvoiceSupplierName','InvoiceSupplierAddress','InvoiceSupplierPerson','InvoiceSupplierPersonCode','InvoiceSupplierEIK','InvoiceSupplierVATNumber','InvoiceSupplierPhone','InvoiceSupplierEMail','InvoiceSupplierWebsite') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '2644', `PostDate` = '2026-03-12', `LastUpdate` = '2026-03-12 18:08:21', `ParentID` = '10485', `Type` = '1', `Data` = 'zSWxpEXjw0_FqArgnDOEJxh_Milb9t39hxd_CAczhMFlH_bB8VKnvICkyFy7NK8h1K6Ie9FJQ3hZ7OZj7OZ9-r9MRPuQnUyKLVjSjnlv4lBxDH92wFXlFL81TCiQvu-ZL1XoFTtWtY1kvIxGoqIo9fTDtBllKJIJEBMgYkYYUmIlLPbwiXNvoehyHVHPfHT2K0WZsWbR0EQqBf4Fdm03xd2m-Pv3Xj11Br2OPMvzMgIM5KwxV7cR5Tt_u0jQK7554-X9VbYlIy8F3-YpDMndrvfTnHNu26c-Lr-JEtDdKmc2pqGCux2uZvfmUQ1KuyXTpditZcryZ2MbhmVj1ajHrN2A1x6F1qpbpUkWVDiDpbJOXUYPxl195pBLQBsf9q_NmDMGMHLe875uq8I7wk5bYt0THvpQKB6OOLgM4LrvI5lbUfcgYADcLXpFMNaTQOAUjkMlRm5OQRmSs1ou3FtBbi89EPak1TB34Wl1LeW3ZPtldgcsAPccFr-QlFevRShD5Oj2s-5mkrxYqoj9u5hetVkES1ujBxPGktmmLamz4y8cV6Nu0l2dc5FzbT73vfZR4pafXu1xbL3NooOdLq6xBP-gO24AIk_eyUXKxHustRMnQ5cxKZxTr0YGIT_ERkimFaI5xxxJHvd5TzJ_0FOV0CnerIFaqCiJASCrknV2TCjWhd23aNbv5k2WeNBxijx59rBw6cZbmZiXVydI1uO106BIOahY0JKQXe7vFZZFr5rHX_r0Y8EZIHZqwsn2fxMF-zyVU6r7wQfefNrUiL2VdnopeI4gVhGfU5GgurNwzsNav2v0scLYU5-DydgYTEBzHIYEy8DduEQpijj5S2DXUOZjwo4RAVSmdpzxV0raI1RdVBcygYAHh3z2Z3W1SFe1UgCZgbozskXHuWI9vPtsLF7G5wOg2HLutsEmIiGKQcWOZ9j41FZ4epXQhA3FBAfVSzHy8UPGdbSqnXf6FPnA74zCiKeesjHzBREZYD-6jqqA5LVQJmvNYylyA6Qp0X-4oY8-VTJ7OfAM06z4fkYWjgCjNmWwN4K8FWwTxCWmwmGzN29SCs7Wn7DKCxm8obGBOxrGJixv9sFhLNd5R6IyLe4W2bNDWSxdQgIJLKHSfqweb6y6J5RWtYNhqXjOABCwZIFl6BlAY0KDOMwtwU7YY5PRAgMtPkKnXF6fRerIKeApADC_dvsCu_2BwIdzEwA7udmYAPpB2123krY8EG4wm_uhsZNusWNCjgIRCthVECUZc2vi4vzZdERjGuSkjFruKR-Vwa7__38l1O4OB1AVzXtAhb0T5l0Le7wcUtu-Xog', `Keywords` = 'c3Bpc2FuaWU40LrQu9GD0LE0L7QvtC00LPQsNC90LXRgtCw0YbQsNC90LXQstCw0YHRgtC-0Y_QvdC-0LLQsAMjAwNDIxMjc10YLQtdGF0L3QuNGH0LXRgdC60LA0L_QvtC00LTRgNGK0LbQutCw0LfQsA0LzQtdGB0LXRhg0LTQtdC60LXQvNCy0YDQuAMjAyNdCz0LrRitC80YPQtdCx0YHQsNC50YIc3Bpc2FuaWU4', `Client` = 'c3Bpc2FuaWU40LrQu9GD0LE0L7QvtC00LPQsNC90LXRgtCw0YbQsNC90LXQstCw0YHRgtC-0Y_QvdC-0LLQsAMjAwNDIxMjc1', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20.00', `Total` = 400
# [12-Mar-2026 18:08:22] /fin/fN9v3p6D6/bg/invoices/list.html?type=1 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876878 AND
                                CRC32(`UserKey`) = 3480059298 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                    `invoices`.*,
                    `Parent`.`Type` AS `ParentType`
                FROM
                    `invoices`
                    LEFT JOIN `invoices` AS `Parent` ON 
                        `invoices`.`ParentID` = `Parent`.`ID`
                WHERE
                    1
             AND `invoices`.`Type` = '1' ORDER BY `invoices`.`PostDate` DESC, `invoices`.`ID` DESC LIMIT 0, 100

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

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10485 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10488 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

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

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10480 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10477 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10465 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10483 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10455 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10479 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10478 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10481 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10482 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10466 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10454 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10476 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10475 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10474 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10381 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 2150 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 2247 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 2447 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10467 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10473 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10472 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10469 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10468 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10471 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10458 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10464 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10450 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10457 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10462 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10460 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10463 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10461 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10456 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
                SELECT
                    `invoices`.*,
                    `Parent`.`Type` AS `ParentType`
                FROM
                    `invoices`
                    LEFT JOIN `invoices` AS `Parent` ON 
                        `invoices`.`ParentID` = `Parent`.`ID`
                WHERE
                    1
             AND `invoices`.`Type` = '1' ORDER BY `invoices`.`PostDate` DESC, `invoices`.`ID` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2026 18:08:29] /fin/fN9v3p6D6/bg/invoices/type_1/2644.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876878 AND
                                CRC32(`UserKey`) = 3480059298 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2644 AND
                `Type` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LCompanyVatNumber','LCompanyNumber','LCompanyPerson','LInvoiceDescription','LInvoiceQuantity','LInvoicePrice','LInvoiceSum','LInvoiceSubTotal','LInvoiceVAT','LInvoiceTotal','LInvoicePaymentMethod','LInvoiceReceived','LInvoiceComposed') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

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

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