# [20-Feb-2026 11:05:58] /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
# [20-Feb-2026 11:05:58] /fin/bg/ajax/users/form/login.html?_=1771578367132 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
# [20-Feb-2026 11:06:10] /fin/fN9v3p6D6/bg/ajax/users/login.html?_=1771578379452 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
# [20-Feb-2026 11:06:10] /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
                `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` = 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
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10452 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` = 10453 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` = 10451 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
# [20-Feb-2026 11:06:16] /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
# [20-Feb-2026 11:06:20] /fin/fN9v3p6D6/bg/ajax/invoices/form/clone/type_0/10486.html?_=1771578389271 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` = 10486 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
# [20-Feb-2026 11:08:19] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1771578508066 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` = '10487', `PostDate` = '2026-02-20', `LastUpdate` = '2026-02-20 11:08:19', `ParentID` = '', `Type` = '0', `Data` = 'bzN43dPdM1syjpodhQfGwH50rZPytBD8Vts3IEfksEiBGjpaR-2TTzzcGkT2RRSQljdQ98aC1s2lBjRaruh7UV-iYSES69kzFLnVIjhd8GX4241-FEc22RCoAT80oXbk-H6J9XdVnRaiLZzqQcWv89Hv0294DLegRHQtKJ-IfjNbN6BHd9oUV0ZIkZZMqaP8dcZbAIeTvkQLbdzPdI59OEykXcc9-fRBVoXTkgg2n7I9XCCKN97Aib4HDu1NA4XI6v_jxNI-NC45Sc-Q-7jwqnnCMCATipdMBbmq7B-ITRH2X6saAtDGtgpYXZfvc_dlaXZ8kW_HMXGO9eEtnQEigPtKWE6ySVgzqfnrou_CaUF9Wb3K7okn61_ng4niyr_F3Y7hcQ8VswzrvwWSu-iIFWjhINxVGg0ewNNYMZIrFE8SzLTaJgR31gPQF5xPkibnjvVNiHTcMgZvQM3pq74mgGp-IwBCXT8gwx47FRkZUk6UccWbfI_BPAUi31n0qKiyKom2mk_ymAXA2MeFcms19rrAyOVrTiZAP4QVYQuL8NUC2jFTpeD3V1vI_ppNY5DNgeIDxHR9ionHU6FcXutKmmhFONWOZc6eym_aO-mcL8vWJsr2E9gmGgHOc7dwwVPob7bOZN9AvNHx8EWyZH2IOmRght9SAEZ0fJdTn2k6zT6Vp6WOjX9MW7CdrKsikAs93sBbKzlqrud9tu4rqzYHPfGsSHJof4mS8IN87j2CNWsi-7RbtIBg9KY9GLrO8BcqAQQg-SW63BlxkzKgUkv-O7Npdqfo8U62MqLtl92LV4j8wxy94PFjvcOgAfWJNeDPe2duy2WyDEnqzMfxdrcfrnFAcKOkzZtO4HPXplcBgo4YQ0OIv5NTV7nyexqEAY4dUaRNNUHg66LJVmis2KSZ02mEhdB-qAVLDQuUwebOqjXMCZhzv9cppmaLHW_xkAB0n3p3UmHnmcW8vGm0KHJGwwR1L0V-SmokeGHQaDbahbwedefMwDceaBO4GYtQYbzJ0iJF9Xy8bXastC3yyYmEEekk2IePNkCw-FgcZkDb4NNG3Bn18R5pQ9E4mxaIdVPv9d8kC5FCO8LCxJ9ikTNzBeEPNaIFtX94RPXTKixxHU2csxGf3Iov4G7M8TdkbITjCzKXamgPtluENx3-1xeoWIGNBmUV7FmcfDp7aiXiHsWdNZHrGkMCANE8Az4wqAouoZP2WyR511-rOGjXW5ePmspUnxpk4cHthwG9gMnVnw4It79YCiSloLwskbdI8xll', `Keywords` = 'c3Bpc2FuaWU40LrQu9GD0LE0L7QvtC00LPQsNC90LXRgtCw0YbQsNC90LXQstCw0YHRgtC-0Y_QvdC-0LLQsAMjAwNDIxMjc10YHRitC30LTQsNCy0LDQvdC10L3QsA0LfQsNC70LA0LrRitC80YPQtdCx0YHQsNC50YIZXZlbnRzc3Bpc2FuaWU4', `Client` = 'c3Bpc2FuaWU40LrQu9GD0LE0L7QvtC00LPQsNC90LXRgtCw0YbQsNC90LXQstCw0YHRgtC-0Y_QvdC-0LLQsAMjAwNDIxMjc1', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20.00', `Total` = 300
# [20-Feb-2026 11:08:19] /fin/fN9v3p6D6/bg/invoices/list.html?type=0 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
# [20-Feb-2026 11:08:24] /fin/fN9v3p6D6/bg/invoices/type_0/10487.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` = 10487 AND
                `Type` = 0
            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 ('InvoiceTypeProforma') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') 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
