# [06-Jan-2026 09:35:30] /fin/ 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
# [06-Jan-2026 09:35:30] /fin/bg/ajax/users/form/login.html?_=1767684935780 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
# [06-Jan-2026 09:35:36] /fin/fN9v3p6D6/bg/ajax/users/login.html?_=1767684941978 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
# [06-Jan-2026 09:35:36] /fin/fN9v3p6D6/bg/invoices/list.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' ORDER BY `PostDate` DESC, `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
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' ORDER BY `PostDate` DESC, `ID` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jan-2026 09:35:45] /fin/fN9v3p6D6/bg/invoices/list.html?type=1&from=&to=&keyword=mygregor 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' AND `Keywords` LIKE '%bXlncmVnb3I%' ORDER BY `PostDate` DESC, `ID` DESC LIMIT 0, 100

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jan-2026 09:35:47] /fin/fN9v3p6D6/bg/invoices/list.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' ORDER BY `PostDate` DESC, `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
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' ORDER BY `PostDate` DESC, `ID` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jan-2026 09:36:26] /fin/fN9v3p6D6/bg/invoices/list.html?type=1&from=&to=&keyword=bulinfo 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' AND `Keywords` LIKE '%YnVsaW5mbw%' ORDER BY `PostDate` DESC, `ID` DESC LIMIT 0, 100

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' AND `Keywords` LIKE '%YnVsaW5mbw%' ORDER BY `PostDate` DESC, `ID` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jan-2026 09:36:29] /fin/fN9v3p6D6/bg/ajax/invoices/form/clone/type_1/2406.html?_=1767684995085 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2406 AND
                `Type` = 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

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
# [06-Jan-2026 09:38:10] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1767685095327 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876878 AND
                                CRC32(`UserKey`) = 3249993104 AND
                                RIGHT(`UserKey`, 1) = 9
                            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','InvoiceSupplierVATNumber') 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` = '2615', `PostDate` = '2026-01-06', `LastUpdate` = '2026-01-06 09:38:10', `ParentID` = '', `Type` = '1', `Data` = 'hNstPKdosFgE4eixMPDvXTP4UvMsPDxb7fIVx3DYXSkry8LAomHUvT4L8FQRXY2FvkrjxpxiP1PTHtPHdsQ0FslT7yZnmEfohtABJU_dcIJ4bEBrIqcBS0RW18bbHiJB6LA9zqeHm9HbydB7dMHOalXQwGe3x3iioysf_oyVkFJwYeks-Lxl0x9v5oQbYkiDXB5fPz1ehPrYITpiqzPHMojU4PGPC7SAKzzM3afQ7AwJvDXWG70JdtGEeVHPBSaIDiOsLGSeGL3ZlJjjGIF6aaQhcUS5fuq_751zAT0M2jpLvu3YL4QCUG8zSoDYrIPm5ATHbD9ZeBs4CK3BsppUflVHSocj2KFRSZMNTKTonirLuwAWmZbFCzY7zJRDl7O8QWpgOUPm9hJOF8Uc9QBQP7ofdp9Eec6aACUwmD2t6VpXS3n4gdvvobXmBBS0e0Sa_e39XGJY9tbMD9Alirndl4NnrELwUVmxQqOIXCvjbnbrWJQEP9LpED4ccFCzJgQ2MfkZW8A8eWN9QAv1Vd6QASJ5q14zG58D2521pg26V09sSBfUpDou3yFOU8EOTia_DVa-uMTTtOM7Pc0iwuc2_mz7V-Kizm_ROShEwYPmIkOhzJNQPZla1yv5rcxDJ3ZR8_HRfEH2bzBe7vhOgvNVQ4p_f1zz8woiCUKpePXGaHlMGB5iHj5ohNj21DhY_RiMM-v03oq-_gNdts1Jp2YTyRoVoAS8Gk5Bq8tvmDNZg2ZRNGx8wETAwPb-f4QzWEE3EmfK4EZ7BQOxr32DMdv6y8f6m7Hj7bAjJlvAK2yr1RYqA84WOwR1OL50zm6nI8mMqXsmijgTmQY9u8Fw3uGSKhWPF07uvKUU029T0u86aotInv7bH0MaA3olp4e5nCuAdhVdGSut6Fy6E3Zlzw9up7AO9uYcGXi8oxRRDkGos6bkdgIwkueYyoTDy0jgwf_fBGlGqlmUAx8bNYZKBCStoFDNS7nzDo1YzRy9jFLEeaaVBFj4xmygpCoOrt1jHAv2WepYP-M-VpWxOOwjDJlrHi8tbYhlSSgUZU62bHClJmnYnm0Bh_LYuWd2vhY2PwPF-LCn8ahA4sCTWe2Miz3lHyaU7Q-cY38CMgxPOtLN-TsdOj_88VXHRblm6l9-ejY3PH1whj-AiUHpG2bSuRIZNdyaRahYhDF8fe1q3kA7Fv7Py9Z4-N4a9RS7cgAIqLdH0uckKxmd4fTILiH5En3gyIGGsfpWevk4kVV8xPugnJw72CN8L2H5SoqONVvksjVh', `Keywords` = 'YnVsaW5mbw0LHRg9C70LjQvdGE0L40LXQvtC-0LQ0L3QuNC60L7Qu9Cw0Lk0L3QtdC00Y_Qu9C60L7QsgMTIxNTc2NTEw0YLQtdGF0L3QuNGH0LXRgdC60LA0L_QvtC00LTRgNGK0LbQutCw0LrRitC80YPQtdCx0YHQsNC50YIbXlncmVnb3IY29t0LfQsA0L_QtdGA0LjQvtC00L7Rgg0LXQtNC90LA0LPQvtC00LjQvdCwY29va2llYm90bXlncmVnb3IY29tc3Vic2NyaXB0aW9uc2l6ZQ', `Client` = 'YnVsaW5mbw0LHRg9C70LjQvdGE0L40LXQvtC-0LQ0L3QuNC60L7Qu9Cw0Lk0L3QtdC00Y_Qu9C60L7QsgMTIxNTc2NTEw', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20.00', `Total` = 960
# [06-Jan-2026 09:38:10] /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`) = 3249993104 AND
                                RIGHT(`UserKey`, 1) = 9
                            LIMIT 1

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' ORDER BY `PostDate` DESC, `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
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' ORDER BY `PostDate` DESC, `ID` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jan-2026 09:38:15] /fin/fN9v3p6D6/bg/invoices/type_1/2615.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2615 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 ('Jan') 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
# [06-Jan-2026 09:55:36] /fin/fN9v3p6D6/bg/invoices/list.html?type=1&from=01.01.2026&to=31.01.2026&keyword= 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `PostDate` >= '2026-01-01' AND `PostDate` <= '2026-01-31' AND `Type` = '1' ORDER BY `PostDate` DESC, `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
                *
            FROM
                `invoices`
            WHERE
                1
         AND `PostDate` >= '2026-01-01' AND `PostDate` <= '2026-01-31' AND `Type` = '1' ORDER BY `PostDate` DESC, `ID` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jan-2026 09:55:40] /fin/fN9v3p6D6/bg/invoices/list.html?type=1&from=01.01.2025&to=31.01.2026&keyword= 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `PostDate` >= '2025-01-01' AND `PostDate` <= '2026-01-31' AND `Type` = '1' ORDER BY `PostDate` DESC, `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
                *
            FROM
                `invoices`
            WHERE
                1
         AND `PostDate` >= '2025-01-01' AND `PostDate` <= '2026-01-31' AND `Type` = '1' ORDER BY `PostDate` DESC, `ID` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jan-2026 09:55:43] /fin/fN9v3p6D6/bg/invoices/list.html?type=1&from=01.01.2025&to=31.01.2025&keyword= 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `PostDate` >= '2025-01-01' AND `PostDate` <= '2025-01-31' AND `Type` = '1' ORDER BY `PostDate` DESC, `ID` DESC LIMIT 0, 100

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `PostDate` >= '2025-01-01' AND `PostDate` <= '2025-01-31' AND `Type` = '1' ORDER BY `PostDate` DESC, `ID` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jan-2026 09:56:18] /fin/fN9v3p6D6/bg/invoices/type_1/2407.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2407 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 ('Jan') 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 ('CurrencyBGN') 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
# [06-Jan-2026 09:56:43] /fin/fN9v3p6D6/bg/invoices/list.html?type=1&from=01.01.2025&to=31.01.2025&keyword=ifm 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `PostDate` >= '2025-01-01' AND `PostDate` <= '2025-01-31' AND `Type` = '1' AND `Keywords` LIKE '%aWZt%' ORDER BY `PostDate` DESC, `ID` DESC LIMIT 0, 100

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `PostDate` >= '2025-01-01' AND `PostDate` <= '2025-01-31' AND `Type` = '1' AND `Keywords` LIKE '%aWZt%' ORDER BY `PostDate` DESC, `ID` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jan-2026 09:56:51] /fin/fN9v3p6D6/bg/invoices/type_1/2404.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2404 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 ('Jan') 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 ('CurrencyBGN') 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
# [06-Jan-2026 09:57:00] /fin/fN9v3p6D6/bg/ajax/invoices/form/clone/type_1/2404.html?_=1767686226070 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2404 AND
                `Type` = 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

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
# [06-Jan-2026 09:58:37] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1767686322633 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876878 AND
                                CRC32(`UserKey`) = 3249993104 AND
                                RIGHT(`UserKey`, 1) = 9
                            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','InvoiceSupplierVATNumber') 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` = '2616', `PostDate` = '2026-01-06', `LastUpdate` = '2026-01-06 09:58:37', `ParentID` = '', `Type` = '1', `Data` = '2XL-0YC5nsKVgCDf_wPl5XfiD84fv3FA38P8m7ZipYFhBaiUoAcJqTxgzrQzEOto4BiHJmM49g7ZIFtRBoZ8wylJia47GZ0yPX9VY6vBNr6NoPlP7jHgONbCY5Vyw4e4eV1aYRJWlETXi23w88m-NxHMZ8Mn9G6x9fIKMF6ZqZIJ8lujIAOAHvRVul9Ktab4Be0S4jvhbP6hM0KKHLQcnuw_g2PeLT2QWy0qUSYs3cmHjBhXLLKKNjdnzUMSgyva-P-vIE3scaOtipWFJhhj_9d4X8M8JK-bUhKkrzIsvuEkEZuXwGTw-bkR5T_bOWeuRdZigwotLjwGbEwoL6gTWbXL3xJJTs-_4jqpS9l6yjPi3n2uqhys_dWuHEi5THCx-OGaflhIH3HNuLmqzQ15PzK-sijjYOBMQeNAg4iGH5GrOOVhFQC6KhjCNSlFK7H5W8X1e5J86SMr99XJqFjBzafMmXT6B7DDvUfpaTpEBgJd0HM0hPWvnvaDjEW9FoVWc8q0dUFvIZcuiZBWo0EsUXp9TEnUDOZpg3YKtsXgORrF5dK32haiGeAx8oNkpjiGzzDpZVNSSAfv1O5i_nkDg3sqDrWeB1KUoO-jRueLyTYtyU1XneuLu4ydqNik-rmhkBQ7FHc5AynOXOt3nsqjS9khXlfj5zUqjqfnP6Bwt_uRf9atEW2dFfHJsLf7JRk1JS8VhVuYQr-W_Q0ktlamrtCIbtEaFCbmYFbIkfQM_vwz0h6waU8xkhB37xvvIQn8885BzDhBKZs36T3_0U5OugNa_FBoYzm-rrp3r1RF21FcM_MZ4FGFNi9rC9ShMazCO985Ke4CApkGVoi4TDBEOdSyH5fgerWkuKmL-9WoUbA2A1LvlWY1BlT7txQU4y1P1VZ3R7aDnmHuxr7bDJUEz-HgGxvqM6te6fSgBJeX_EFUGfq9ZZPjQUWEefO-XUz6fi-j-D5eT13NspHxQtnBhI4omHd3X9CGJ1yEpbNe9SEPCktUOVJ2p1-PhJDnarD8huWxCu6rvSxc140AR7OODo4NtX-ivsdyxLBCEpEYQxQJECOutBcDBPwqdZie0sG-edicmnQBLQ0WWEARc1wTJHe1hm_9QLghByTv4XyGJQADuVpypoH1k5qHmiQkJWAadcMCXNH7G36Xe6xfKVP43_PnDGL3snloNTr2tKcgd4XwHhWXuD3_fI-GENovkhKu', `Keywords` = 'aWZt0YPQtA0LjQvdCy0LXRgdGC0YTQvtC90LQ0LzQtdC90LjQtNC20LzRitC90YI0LDQtA0LDQu9C10LrRgdCw0L3QtNGK0YA0LLQuNC60YLQvtGA0L7QstC40Yc0LzQsNC50YHRgtC10YAMTc1MjU2MDk20YLQtdGF0L3QuNGH0LXRgdC60LA0L_QvtC00LTRgNGK0LbQutCw0LrRitC80YPQtdCx0YHQsNC50YIaWZt0LfQsA0L_QtdGA0LjQvtC00L7Rgg0LXQtNC90LA0LPQvtC00LjQvdCw', `Client` = 'aWZt0YPQtA0LjQvdCy0LXRgdGC0YTQvtC90LQ0LzQtdC90LjQtNC20LzRitC90YI0LDQtA0LDQu9C10LrRgdCw0L3QtNGK0YA0LLQuNC60YLQvtGA0L7QstC40Yc0LzQsNC50YHRgtC10YAMTc1MjU2MDk2', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20.00', `Total` = 300
# [06-Jan-2026 09:58:37] /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`) = 3249993104 AND
                                RIGHT(`UserKey`, 1) = 9
                            LIMIT 1

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' ORDER BY `PostDate` DESC, `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
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' ORDER BY `PostDate` DESC, `ID` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jan-2026 09:58:43] /fin/fN9v3p6D6/bg/invoices/type_1/2616.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2616 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 ('Jan') 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
# [06-Jan-2026 11:24:24] /fin/fN9v3p6D6/bg/invoices/type_1/2616.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2616 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 ('Jan') 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
# [06-Jan-2026 11:24:35] /fin/fN9v3p6D6/bg/invoices.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876878 AND
                                CRC32(`UserKey`) = 3249993104 AND
                                RIGHT(`UserKey`, 1) = 9
                            LIMIT 1
# [06-Jan-2026 11:24:38] /fin/fN9v3p6D6/ 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876878 AND
                                CRC32(`UserKey`) = 3249993104 AND
                                RIGHT(`UserKey`, 1) = 9
                            LIMIT 1
# [06-Jan-2026 11:25:14] /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
# [06-Jan-2026 11:25:14] /fin/bg/ajax/users/form/login.html?_=1767691520225 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
# [06-Jan-2026 11:25:21] /fin/fN9v3p6D6/bg/ajax/users/login.html?_=1767691527128 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
# [06-Jan-2026 11:25:21] /fin/fN9v3p6D6/bg/invoices/list.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' ORDER BY `PostDate` DESC, `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
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' ORDER BY `PostDate` DESC, `ID` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jan-2026 11:59:39] /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
# [06-Jan-2026 11:59:39] /fin/bg/ajax/users/form/login.html?_=1767693585441 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
# [06-Jan-2026 12:26:25] /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
# [06-Jan-2026 12:26:25] /fin/bg/ajax/users/form/login.html?_=1767695191923 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
# [06-Jan-2026 12:26:31] /fin/fN9v3p6D6/bg/ajax/users/login.html?_=1767695197009 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
# [06-Jan-2026 12:26:31] /fin/fN9v3p6D6/bg/invoices/list.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' ORDER BY `PostDate` DESC, `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
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' ORDER BY `PostDate` DESC, `ID` DESC) AS CountTable

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

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `PostDate` >= '2025-12-01' AND `PostDate` <= '2025-12-31' AND `Type` = '1' ORDER BY `PostDate` DESC, `ID` DESC LIMIT 0, 100

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `PostDate` >= '2025-12-01' AND `PostDate` <= '2025-12-31' AND `Type` = '1' ORDER BY `PostDate` DESC, `ID` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jan-2026 12:26:50] /fin/fN9v3p6D6/bg/invoices/type_1/2607.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2607 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 ('Dec') 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 ('CurrencyBGN') 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
# [06-Jan-2026 14:34:29] /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
# [06-Jan-2026 14:34:29] /fin/bg/ajax/users/form/login.html?_=1767702875827 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
# [06-Jan-2026 14:34:34] /fin/fN9v3p6D6/bg/ajax/users/login.html?_=1767702880242 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
# [06-Jan-2026 14:34:34] /fin/fN9v3p6D6/bg/invoices/list.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' ORDER BY `PostDate` DESC, `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
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '1' ORDER BY `PostDate` DESC, `ID` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jan-2026 14:34:39] /fin/fN9v3p6D6/bg/invoices/type_1/2614.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2614 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 ('Jan') 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
