# [07-Jan-2026 13:17:40] /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
# [07-Jan-2026 13:17:47] /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
# [07-Jan-2026 13:17:55] /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
# [07-Jan-2026 13:18:02] /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
# [07-Jan-2026 13:18:06] /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
# [07-Jan-2026 13:19:41] /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
# [07-Jan-2026 13:20:05] /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
# [07-Jan-2026 13:20:19] /fin/ 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
# [07-Jan-2026 13:20:55] /fin/ 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
# [07-Jan-2026 13:21:50] /fin/ 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
# [07-Jan-2026 13:21:52] /fin/ 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
# [07-Jan-2026 13:22:08] /fin/ 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
# [07-Jan-2026 13:22:33] /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

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
# [07-Jan-2026 13:22:53] /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

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
# [07-Jan-2026 13:22:57] /fin/fN9v3p6D6/bg/invoices/type_1/2611.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` = 2611 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
# [07-Jan-2026 13:23:51] /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
# [07-Jan-2026 13:25: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`) = 3249993104 AND
                                RIGHT(`UserKey`, 1) = 9
                            LIMIT 1

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '0' 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` = '0' 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
# [07-Jan-2026 13:25:20] /fin/fN9v3p6D6/bg/ajax/invoices/form/clone/type_0/10481.html?_=1767785127452 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` = 10481 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
# [07-Jan-2026 13:26:17] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1767785184558 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
# [07-Jan-2026 13:26:54] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1767785221894 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
# [07-Jan-2026 13:29:28] /fin/fN9v3p6D6/bg/ajax/invoices/clients.html?keyword=petkoAngelov&_=1767785375878 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
                    `Data`,
                    `Client`
                FROM
                    `invoices`
                WHERE
                    `Client` LIKE '%cGV0a29hbmdlbG92%'
                GROUP BY
                    `Client`
                ORDER BY 
                    `ID` DESC
# [07-Jan-2026 13:29:31] /fin/fN9v3p6D6/bg/ajax/invoices/clients.html?keyword=petko-Angelov&_=1767785378204 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
                    `Data`,
                    `Client`
                FROM
                    `invoices`
                WHERE
                    `Client` LIKE '%cGV0a29hbmdlbG92%'
                GROUP BY
                    `Client`
                ORDER BY 
                    `ID` DESC
# [07-Jan-2026 13:29:32] /fin/fN9v3p6D6/bg/ajax/invoices/clients.html?keyword=petko-angelov&_=1767785379674 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
                    `Data`,
                    `Client`
                FROM
                    `invoices`
                WHERE
                    `Client` LIKE '%cGV0a29hbmdlbG92%'
                GROUP BY
                    `Client`
                ORDER BY 
                    `ID` DESC
# [07-Jan-2026 13:29:35] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1767785383052 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
# [07-Jan-2026 13:29:41] /fin/fN9v3p6D6/bg/ajax/invoices/clients.html?keyword=petkoangelov&_=1767785388290 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
                    `Data`,
                    `Client`
                FROM
                    `invoices`
                WHERE
                    `Client` LIKE '%cGV0a29hbmdlbG92%'
                GROUP BY
                    `Client`
                ORDER BY 
                    `ID` DESC
# [07-Jan-2026 13:29:43] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1767785390316 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` = '10484', `PostDate` = '2026-01-07', `LastUpdate` = '2026-01-07 13:29:43', `ParentID` = '', `Type` = '0', `Data` = '1Wq4Pp9vpTDwGdxJhkjEJ_mBY1oknKYrnus3zNlk-KxXdXvkcxt-rf0P8t58rWpcaYxkUpN2vCMBpOLlqhu6UpRB4XJITkdTVNpwQK-Atu2qhXpfunFSS-A3Twc0iXAQKoORRkVMjT6Au4NxhfgT-bTWGxDXQuFv_dwEx6PrpgWPU7FzO3F8tjEuyvPZoa_gficwLR_aa5hiaKbEymiyBnHAvP0uVU_urMzfNP2kT0rKUXBo9KAn0fnGnTeA-L1fWhfDqbvGlDrFT_ZrfQdZrg8Fd8WumhhegePK0Zp0RtHesZZxDa_hlbRRRyzf9rz6vJZ2MIFkrF8_cDHRwzQ_5r78wgvoLSxK7GNaMuYVh-uWSINNfgpO8h5r65_72CToRqrL86tS_AOhUPdROvME4RuTcwUSSTrpohAtZZSq4O6F6xgxiZ9OOHEgXsgcHHhTEoKWXbE3mXM6sDpxDhg_8V_3l7Wq32g7uoG1gtxmpBvJlMxbgRxTN7w6XC74mj0KKFJs8NvyBQOamhdqw0Ww-DgQ4iOlynoQj2x1SwX_kEX1w10ZuZPp1-W63L9xFK3UB3rHMTiA_41xUWzsFCh69ic90ew85-oKuGXAlHUJHbq3DVyTW7eGwHfhO31l3y9shLWfuB0KgiqEwyIbPkb4IwMsNlew4_nKdX0dvE5rmDNOgnNjGFUmqI4jBm8AfzrgH0YiYWNyh6HOYfq153CS8tfQvlA_M3BTy37g-LsIAdOxtWUeQGTTIEbr6tC-NJlWW1ec8hUEI_Ps7oRir5_dGF98DaDhcR33sIfoCg2clMbjMGgW8_7lZVvtaYAuilJ_KTzy8OQiGuhlC5i-RXSyZnQbAvrnQZdqvFhays_GbxyNYIPEsu5HCpdmOwIHmVgtXS4hBNdiXylsqHU2vl6puywNcrD5tdsEkMmeJQXLeRse86BI88dbua3XzSsMxGjyCThiwg_bUbWALyy0NR8Tems7EpQv8RZGtO0ub9PPS_xHlOquWjhAyoW6x4iTdbwybGoOgtAz97A3Q_sRVJswdXSrBmInnwAHach6nQJQbsbk3JB4mEEAoKTi_Na9PstAHCdkj_Xv4zVWWGYFV6xMZVrjtHU_D2PlURwwFTHcib3_Xu0_1RsNGrFYNxTc9IUHwRdLNWmR6XMgSycvAs1WVdePfwH2FnWvNoag8bf0sQBEPc2tn8nbUSmGwwuDf8kZoDjsKkpUfpxLQFkfNNfsZRWLbHe2-BiGa20NnPwht-c', `Keywords` = 'cGV0a29hbmdlbG920L_QtdGC0LrQvg0LDQvdCz0LXQu9C-0LI0LHQsw0LXQvtC-0LQ0L_QtdGC0LrQvg0L_QtdGC0LrQvtCyMTYwMDc0NTg20YPQv9GA0LDQstC70LXQvdC40LU0L3QsA0YDQtdC60LvQsNC80Lg0LfQsA0LzQtdGB0LXRhg0Y_QvdGD0LDRgNC4MjAyNtCz0YDQtdC60LvQsNC80LXQvQ0LHRjtC00LbQtdGC0LfQsAZmFjZWJvb2s0LfQsA0LzQtdGB0LXRhg0Y_QvdGD0LDRgNC4MjAyNtCz', `Client` = 'cGV0a29hbmdlbG920L_QtdGC0LrQvg0LDQvdCz0LXQu9C-0LI0LHQsw0LXQvtC-0LQ0L_QtdGC0LrQvg0L_QtdGC0LrQvtCyMTYwMDc0NTg2', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20.00', `Total` = 430
# [07-Jan-2026 13:29:43] /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`) = 3249993104 AND
                                RIGHT(`UserKey`, 1) = 9
                            LIMIT 1

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '0' 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` = '0' 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
# [07-Jan-2026 13:30:31] /fin/fN9v3p6D6/bg/invoices/type_0/10484.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` = 10484 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 ('Jan') 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
# [07-Jan-2026 13:33:08] /fin/fN9v3p6D6/bg/ajax/invoices/form/clone/type_0/10477.html?_=1767785595978 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` = 10477 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
# [07-Jan-2026 13:34:25] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1767785672284 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
# [07-Jan-2026 13:35:46] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1767785753175 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` = '10485', `PostDate` = '2026-01-07', `LastUpdate` = '2026-01-07 13:35:46', `ParentID` = '', `Type` = '0', `Data` = 'A_2sSbb5GbzLC6PG9i2-hzR1BwlJDvu9SRzOBrTng141VtFBwzPjXAzXLgLLiIrXF-u63n3avPlyr9U5K9NCnOgJm4zcCgHEG4nfAb1xWmeQhmdhRe6Rp0OzDGOj7gJnDCwz_QylAICa3SC9hJUNzSh7VQkl_B5NkVFv0pstFeHZd3kLe-TCAyHu1Ev5zTUhRAHfr2lsxd2JnPkpKPlqna81mSWKZ2V-ud3mAK6KA5FUgmSk1BOWGZfr5IQkVhL6NTYuxcFzskzeXXzdmwXZOWle7FRiLOjddY8F6qokZ56tdfeKixM-BWmki28nPhwtTfOernRQthBAaaygCCIopu0RU4LpCFj5hvYPUcBxnMS0-unD7wKFr0Ve-fe4FkdnsZdDNfjRpFJ0fA3LYRWehSBrSH-aI2_RscBVPi4B3RpDJm9lPu-R_KVgkhCBAN-PKF8QsYIq8AZR1C3fczFH49fBM7dX1Tqzucj_07MUhSrPTEYYJh2fHpUOF3IkbGPq_5dLujDHZLc2lSKHJoshqZtLk9wb9EvfBKKkrd25a2yLywlj_KRMY-L0wTHbQbWH3Nr8fFoQZavdWqWAJYbL7z83Jg5_Gu0FGkr6Dwb3iENx6CntKzOhmO-SnS4CAYveuPMv9s6hYmBLLmRYFcKf56roNT4Y2wEHHFeOIBLJpajMswLBuMeHTZ-Cww5zFg5gk5Swx-652laovScUZmZbTYaS-1BImZ4H3r9uztG14tv7U-jr4p4s958XPuX8d1TysvEioRll_Gz1Lk-5EVsVB0Ypz7qS_biCcPwTKx6jQffvZlH0INNHTps2jP-3tG_ln0_lTw4RjZv3XUzsdNZwqX6aFdn_DdI0mwVXzBbcNZuORUCVmOsMWMGlt7Hqr5W_gHg8PYhkRsHcs1wT3sl2euOreY4nVh772D5qHwC7w2gy9LnhkNLCu9CuKR2FE4VaenDTmUUdF7nL8WdpThV_0Mk9uECDUqywYRnao2gWVxfbYG9GH7fA1MPMZKEdEn1KicsbPjsMw5gyNJB9fsxI6Pa5WXcBYeqYy2tl3NReQMWLInUPpcYlvdT5O8-p46DjaWyoe7HahyOmZgA53vevWXpFw5KtpA7QLs9RQoDQETH7YhcpP2quDPrsWUHRZmGxfqkq2MmhkBRvy5z385AnEg', `Keywords` = 'c3Bpc2FuaWU40LrQu9GD0LE0L7QvtC00LPQsNC90LXRgtCw0YbQsNC90LXQstCw0YHRgtC-0Y_QvdC-0LLQsAMjAwNDIxMjc10YLQtdGF0L3QuNGH0LXRgdC60LA0L_QvtC00LTRgNGK0LbQutCw0LfQsA0LzQtdGB0LXRhg0LTQtdC60LXQvNCy0YDQuAMjAyNdCz0LrRitC80YPQtdCx0YHQsNC50YIc3Bpc2FuaWU4', `Client` = 'c3Bpc2FuaWU40LrQu9GD0LE0L7QvtC00LPQsNC90LXRgtCw0YbQsNC90LXQstCw0YHRgtC-0Y_QvdC-0LLQsAMjAwNDIxMjc1', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20.00', `Total` = 400
# [07-Jan-2026 13:35:46] /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`) = 3249993104 AND
                                RIGHT(`UserKey`, 1) = 9
                            LIMIT 1

SELECT
                *
            FROM
                `invoices`
            WHERE
                1
         AND `Type` = '0' 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` = '0' 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
# [07-Jan-2026 13:35:53] /fin/fN9v3p6D6/bg/invoices/type_0/10485.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` = 10485 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 ('Jan') 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
# [07-Jan-2026 13:58:15] /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
# [07-Jan-2026 13:58:15] /fin/bg/ajax/users/form/login.html?_=1767787102707 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
# [07-Jan-2026 13:58:22] /fin/fN9v3p6D6/bg/ajax/users/login.html?_=1767787109135 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'NzkzYjAzNGI1NTAwNmYyNjE4ZTE0YTgxNTRhMjY0MTINGUxYWEyNGU5MmVhYjM2OWNiOTc2Yjk4YjQwODg3ZmM%'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorUserPass') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-Jan-2026 13:58:26] /fin/fN9v3p6D6/bg/ajax/users/login.html?_=1767787113838 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
# [07-Jan-2026 13:58:26] /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
# [07-Jan-2026 13:58:29] /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
# [07-Jan-2026 13:59:18] /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
# [07-Jan-2026 13:59:23] /fin/fN9v3p6D6/bg/ajax/invoices/form/type_1.html?_=1767787170909 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
                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
# [07-Jan-2026 14:00:10] /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
# [07-Jan-2026 14:01:46] /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
# [07-Jan-2026 14:01:52] /fin/fN9v3p6D6/bg/ajax/invoices/form/type_1.html?_=1767787319844 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
                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
# [07-Jan-2026 14:01:55] /fin/fN9v3p6D6/bg/ajax/invoices/clients.html?keyword=hydromat&_=1767787322934 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
                    `Data`,
                    `Client`
                FROM
                    `invoices`
                WHERE
                    `Client` LIKE '%aHlkcm9tYXQ%'
                GROUP BY
                    `Client`
                ORDER BY 
                    `ID` DESC
# [07-Jan-2026 14:02:14] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1767787341904 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` = '2617', `PostDate` = '2026-01-07', `LastUpdate` = '2026-01-07 14:02:14', `ParentID` = '', `Type` = '1', `Data` = 'cH5NUpjqeCsKU2KjxLxLvRZ9UZC713gvGhThVZ2MoAfUDQ3ldcWouITsd_hIF1Kw6ziilYFKrBIewtyiude8Zxol7iN230tZUPv0qVD6BcTuYxGnXU4Eip2IQWcCn-viyd4SQNsEeih7wi_jCWVLN0WBbeS1mHCkcb7xR8iHne5G5RmSIlDAZ5Pdh8vPIUbHre5J35ScFAoE2ICH61oKitTF7GL2JDEPvrhqm8q5JSVh3aq0C1MksPhc3J-GjQydvtnVfOgI9IrkvhzzlAQdQfdF_HbJyDyv5mpMmOX8pzY7dlYqZp7YjjCCkV4Vy5aCSh08m0ZILktkjPo5FY6FoL2aBMHgtQpdnGRP0U5sesim2hxWK7bdHCiTuku3fMcSNhrNfhcvbqA2DGWtWj7uLIVVHpsZ5vQOkqLYTNtnMPPMQGR02-FhVLV8SEL37EYMPD55XUtecF5BeesQRoNu8Tv5c2pXVdXQLaJODx2SZhv0n-Aa4lyg5IAtLOVzBKhxgFk_2N9fuk4vCkZn9CyQnv-VZXiYnsrnoehnsjpfW1ehDCzy77LN71Y5rzUczPPKUxUTxQptSOk3rXhnjVYuIbsp-Ma_zfT02enJOz-OC2k7MlZH5pKJJ63VKTwHpZ2M19YCLD4hU-1if2fp_aj_PzjQBECqWaY_K5ANHDX5Ks3wIAZRx_qhjV-gBxpk7U8WjcSSPcX7lcxooLUMajj7Hw-5HzjeVB_I6EB90Ch6zaUV1nFlw7aMMhsCTvRSuyaTl0N3UhOeDCYtOIqTjndmA--aUnXi6X8FjXlgRkd22vIyojtvCWhoY0TGqjlCGt2XvtC0pJHHLGPqdGF16nst1RalbLiDNo57v8NL8oynCPY8HXNh7ALezay39_RokNxq9c5tDF99TdwcJOV42ojnebBYEGQ2eZ2TK_rUfZUvH9fN-zt5hpGvjCyi23Nj8TeuCgmU59w25jnqnSy35XmmHAwTpI2qqZUOaWkgMp7DPzkV-osGLtUQYDrbTkeDLppOTmImxfNn3RrKghnJxBzOi7x2-rpkJ6jgiZhdkKVO6gZThtGNdTXfYESWS6_Nk7AucbePH6JsMtUgsyZU1oepv7ZNkNhFZOjLG1QmIPNeSFEhRIkxOOs7sh58pkfQnmKr', `Keywords` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw0YPQv9GA0LDQstC70LXQvdC40LU0L3QsA0YDQtdC60LvQsNC80L3QsA0LrQsNC80L_QsNC90LjRjw0LfQsA0LzQtdGB0LXRhg0Y_QvdGD0LDRgNC4MjAyNg', `Client` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20', `Total` = 60
# [07-Jan-2026 14:02:28] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1767787355566 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` = '2617', `PostDate` = '2026-01-07', `LastUpdate` = '2026-01-07 14:02:28', `ParentID` = '', `Type` = '1', `Data` = 'q3mrg6PHisJNOjcKVwGEsHW2J9OkezwKXI5sK6vnRVErCqwKw56zLJnajp11J7KxbLzTSClIGZhEWEPBsI5ontQXS7ldTAZ7w-fHCKGIbjOWbxYGt0gLRJT0mEe-A0jyARhRMxpZMuT5e72T6mr5xumBvp1HI50oiA5SuIjmHGihxBPuHwWD_0ePyobyYRpnvT1Q6IPaAPudEnPHpfnpuwsE78K9gpJmfPoFcue5XqAbQPu4GjE-O61LPtN2omg35ZjO0swfYGmoHFUncPxBAitsEyZgPmHykoxSw2Z1dbalfr6HLvCqpnY1VKXl36nqlJzy9Y7zhKks064ylBv15As679A6RjnGubYYKfHgpoNAtdMG0kjXq5acFYNOQWLc23HCJtrv-fb-1rQMMqERm5_bPIb13UsiCKyx6DjOS-cf0BNdvXW3oWV1QHRG6Dxwp0wAfqgVdv9j44HkkOJVvRJ4IYOBaQ0s-b4eQbx3zED0tHrk-Kve1SUULEqbMll4joPak6fJ1B5k3woNOW2lJPVzGOCOwsh7YCMKLedbdKj3LQO8zsqAHBS0NW1pojXuRFZCeXn4gT5ee9oH5iW5Jfs5xA2ElAshLlKy16_gZQu8npBnYfCm0IywMiDibfyC7KKIMWf5y9itkXLmRRzrvxljAVCOBtMHh76qcoSPPvVm_uxsMSlw44nAMB8EcxLzD1moOI2nXehwHKLphjq_9PpeIlVAuUvAG96PLdt3fQlWOJQSyDzHbgO6bCyxKqC-5qwmAcEKDta-1aDbPTxYGZFK7JfGdkulwM80fpHKh1vREdg24k9oGTwrRRdRXhAtEtXm7EjbslAxIJPaXmViu-_JrznYVq0ywbMeEZuylxinfcjaVvD-j6ajxnt51XOAK2tuJ-sxPkCNFqlZIeaORK2yJVDj_sG5wZvQ5r4bqHvUE_rnj68SVjOO5lfCQnLN-0JPpaaBLalYqkX7bNHq6InRGg0J7tsdTzeiYeN4yqmJCGLwX2r7S-Fg2_jPL_mte-dBgkQ1RkSg6jCaSkL15wrDtAZUT5ttIxzHgngORfzL1Dm0qO3tjQQhGdNDEtzQkDnnj9nJLknMqiSfvlxajaSCbHl7VNGudMN6tBzwY_9FZmEwbZM0MsaJNVU5riYd', `Keywords` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw0YPQv9GA0LDQstC70LXQvdC40LU0L3QsA0YDQtdC60LvQsNC80L3QsA0LrQsNC80L_QsNC90LjRjw0LfQsA0LzQtdGB0LXRhg0Y_QvdGD0LDRgNC4MjAyNg', `Client` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20', `Total` = 60
# [07-Jan-2026 14:02:45] /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
# [07-Jan-2026 14:02:53] /fin/fN9v3p6D6/bg/invoices/type_1/2617.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` = 2617 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
# [07-Jan-2026 14:04:33] /fin/fN9v3p6D6/bg/ajax/invoices/form/type_1.html?_=1767787480724 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
                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
# [07-Jan-2026 14:04:36] /fin/fN9v3p6D6/bg/ajax/invoices/clients.html?keyword=hydromat&_=1767787483900 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
                    `Data`,
                    `Client`
                FROM
                    `invoices`
                WHERE
                    `Client` LIKE '%aHlkcm9tYXQ%'
                GROUP BY
                    `Client`
                ORDER BY 
                    `ID` DESC
# [07-Jan-2026 14:04:56] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1767787503982 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','InvoiceSupplierEIK','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` = '2618', `PostDate` = '2026-01-07', `LastUpdate` = '2026-01-07 14:04:56', `ParentID` = '', `Type` = '1', `Data` = 'aiqKmqcVtscb3H-4CInj84UAWA5RfPN5_li3DjkavrUDjg-pfO8Rr18wGxIgbKl0xJdrgWz6t6idrwEJ3fhmf9fw9EahQFO3JAZmyLKNcHHJo9kH3hg6qYk-WrTWQ7B2oq00u2c-TmsaZcjNzmDXJJMm7Mz-pwagbdMedjkKObuwfb_jZhz1M2j1KU0-Qym9nsBVO_dFvA6s50BSJrHNPBwxEkm-5-TbI4hIJS8RpMhJ04U8NYK7y_zKrgXKOxqBjedHD0T1P-YFhMZoYIOqRvg0RI6ZD2myWELlqe3fBlYHV1z37vO6bnyHK7G5hKMF92ODDgwT8PdYuHwCS_E7kmjMAFgQUSKq4xs42HxP9pLsWD69N3Buu84QTngKAngit8-ieyTh3l-9vQe_KcI0CiLSnX88TPpkLzUcWEmlNzLAL0hTLf24Vda9GSfTuGXO89QKBe4i4PR_B0vVgWJtRDmRXqS93oGhuS9kPY6nkzm6dIMd7rx71GQITmmvnnkcsWRvG1cd_IZZ2h2eygAR6rybXNCudyIBx0A7uQXXg2sPLGYiYdB0moqeRKGMVgY4TULssmCjm_enAJkCMflXprcHcwLv6-0UasBrSyJwHmj3UPj0tG8hlQZ72y2anUvomNubc5zOdrCcKS5ck35VrVh9eAlLMPWu0oLgIIOLmGnvIceUOu0RKt-M2ahYdpervGuMqDRK_odgDvKtDQISOndtFSrx1Fo-A0E26MWP6nAK63jy8Hwfa0Bzbd254B22Hi45qYvMHjX1BjvmjqkjN_cNqVwYH7MtYzDOmJH67TdxIzCT1vn25S7c_YSctxwequNkLqhTccuUXP9updAz-wDll9kCc6kENQZksbuTINkdEtgZxcRUoGhZSsWjRngjxx6cYBFI-aw_6727RGMgTbXvfPtbRpEynfhLvWzW-iNRNrST8GMpaUJv_AVOeFZQr90gHnRjv20_KJd3jtrPU8NlvqQvGZd6aXlyDE-i8ILpxuJsE8oSrwTJJWEVwLiQraRZV-3iioh-YLigP-gU4NbLwml5NLMrqPYHuOpWGKjFxfTRZWtJk7wvhx7MwCi8AXOjtmAVJVLmWjPkpV62HE0LlctzcJhgJ1lgw8Zj_Gq2w_iOkTIp72TsgJsGpPE6Y1zbBVCUZlDiDr8HHiCKCA', `Keywords` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw0YPQv9GA0LDQstC70LXQvdC40LU0L3QsA0YDQtdC60LvQsNC80L3QsA0LrQsNC80L_QsNC90LjRjw0LfQsA0LzQtdGB0LXRhg0Y_QvdGD0LDRgNC4MjAyNg', `Client` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20', `Total` = 50
# [07-Jan-2026 14:04:57] /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
# [07-Jan-2026 14:05:00] /fin/fN9v3p6D6/bg/invoices/type_1/2618.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` = 2618 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
# [07-Jan-2026 14:05:31] /fin/fN9v3p6D6/bg/invoices/type_1/2618.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` = 2618 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
# [07-Jan-2026 14:05:40] /fin/fN9v3p6D6/bg/ajax/invoices/delete/type_1/2618.html?_=1767787548012 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

DELETE FROM `invoices` WHERE `ID` = 2618 AND `Type` = 1
# [07-Jan-2026 14:05:41] /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
# [07-Jan-2026 14:05:43] /fin/fN9v3p6D6/bg/ajax/invoices/delete/type_1/2617.html?_=1767787550852 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

DELETE FROM `invoices` WHERE `ID` = 2617 AND `Type` = 1
# [07-Jan-2026 14:05:43] /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
# [07-Jan-2026 14:11:23] /fin/fN9v3p6D6/bg/ajax/invoices/form/type_1.html?_=1767787890008 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
                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
# [07-Jan-2026 14:11:25] /fin/fN9v3p6D6/bg/ajax/invoices/clients.html?keyword=hydromat&_=1767787892714 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
                    `Data`,
                    `Client`
                FROM
                    `invoices`
                WHERE
                    `Client` LIKE '%aHlkcm9tYXQ%'
                GROUP BY
                    `Client`
                ORDER BY 
                    `ID` DESC
# [07-Jan-2026 14:11:35] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1767787902703 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','InvoiceSupplierEIK','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` = '2617', `PostDate` = '2026-01-07', `LastUpdate` = '2026-01-07 14:11:35', `ParentID` = '', `Type` = '1', `Data` = 'FvJVgTadA5RspqDOLfk78qzsIdNZPcEGhqf38WavrXEmMnfy3dzcMQKBOzljmdG2JTY2T2tYO0lW0vd03E3qhdiCtmLrl45SdwVVSLQ0f2YKplOQSUvy9kDKHlrcNSH-VJ8EX3t_i4HxxlPfvgwC2hKv9Ns01oMsU7AHLmh53ksuOhlV7W3Or5DDyvZry5HQYdanCsSNrA_UlaK1eyJ77Uv0L6l5f4cAETNHWjwSYsXLKwg5H8ZrEhQacVJX6_bQxduP_IVjpo-8V1xeMmMyQXVyLzdb61E35qwjWhk_hAByftNXqN5qaA45tMelPIbD5QvALeJ4egRb3uRYfS2a91_WNw1hK7j9cKHsa2KCjFrB82IoGJxxTRlSsbEh-CaN4R1esK3jJMplGKaGMx9lMCFCMU-oKjHs5jgpCLTm4FJVtYwIDRlcp_5qYpPBefTtSGl_tk26Es0wojssr9nBGfgOG1lpKorpooWuSYCccyoYk87Z-b0hrG-l8kp3A3oS293-ctDB6YFT8_qVCryRptPzpfLSlOAjNl0ifRjlI-nWwj_9cxYYPOdMN2kwVWSkY47mvZHwvd5bT1iKKwEsy856Xk69ukLkeGoiW2ObnsAuB7TnGu2K84UaLLHJm58XQcQBJ8kkYZnrjpkikQvyCe1Xhzzs4GohdDNHaEWUBTJKkUmUyKdiFlRUeWvaXrHmwAV7AzBgrFBrtWtTm7Yi6DXbDF2r7a33EhOq5SPxBCDGJT8YPgwbEmsnQ_BAscXc7kbZdyaAN4Dkc2ByBECjrOIHz3qBI0ybjYhiWQSCnSoUXsNz9VfHjsVQplX7rQal43bbvFwxy2f02Rf6OpNS1S58dNGMv_I_KG-C7NIFKcyur-uLmf3YB_rNDww1DWCS7o8ZXUfdcmifwYHm5y5dTjys22wHVADDVNRe-C6bhQo3-j3-D8YuBIBBWGqNE9G6dRI_hxoWZnFt_nJ9Dj33u3liJAoswi9L_-HDV1BQ5r9A0LPdC9WEthzJtKtS5WQNaH_5bMnqymB4u6I_wSYrnBUGtkGzachcrf0UWrQxmFXOrGmDex7UF_4uyvAzW38dR3eeup6FiUV835JaBg9VbPahXSaXpCr36QCTMdZeNL9zw8MsSu-a6F16y6AzFscMau2k--kHTUDCsm6lpIImHg', `Keywords` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw0YPQv9GA0LDQstC70LXQvdC40LU0L3QsA0YDQtdC60LvQsNC80L3QsA0LrQsNC80L_QsNC90LjRjw0LfQsA0LzQtdGB0LXRhg0Y_QvdGD0LDRgNC4MjAyNg', `Client` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20', `Total` = 60
# [07-Jan-2026 14:11:35] /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
# [07-Jan-2026 14:11:38] /fin/fN9v3p6D6/bg/ajax/invoices/form/type_1/2617.html?_=1767787905164 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` = 2617 AND
                `Type` = 1
            LIMIT 1

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
# [07-Jan-2026 14:11:41] /fin/fN9v3p6D6/bg/ajax/invoices/update/2617.html?_=1767787908800 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 ID = '2617' AND Type = '1' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '26171', '1LF6BTt4Nx1ADX9FegEFMjhKYTJvjDzQClAOA40C-Oa-cn4jDG7HEc7EpHpq4VA0fjrC9L7iq979lifHJInKTCkToWN3_TMRdqjwM9YP0u_x6gW3cHHAyfnI9uaCH5ZukEUpGQMYUJkT5fl4cYqd7xXjdiNWCYtrMUzTMzbLCuvu8p1QlYy14ANXyDhGemyBc6pu8Oy3GhAfmHJ7Xuk_qUkASgbWCaaVTkbXtAyZc0ic-jgJTdsWV35YbIsX6x8QfpKk2yOGRDYXaBAz5KIxkdFihJQRjqJL-61CHJNQ1QdWt8zss5JmThBDHQDsEOMTz3-q5PzDAc8NJdlTSXikyrvN-NDOBtXtgQvHiiO938JWCFDxesVY-JS5gHzUk_Jsbg-jCrBLPmXYZZy1tiUcyk0-VvuJ8hroXnohpzQTcgvu-TfSv-sDmdkx4R1uFGdffXLwRdaZc3R-zxu_xrmcnSKbVlJM44yPOBXF6Y64jWeHX1Ek6gTQk05TQ0PpVOBK-nY9rptRFgZy_zLFgUTJD59vSar_2LovusDGiyKq7oksSGaCrKfCZb2Wj3blxwnNdqa5_5bJsZMC8bUnE9-kBqysCpc4goSkYlhmCEXIfPw055huejobm1FjJ1x1N3E2reQkzCpYYsZJaNmQiQc546whrAEEyIwfmovVt0Mw92Ke85AuNbz4gSOAIrw9pcA6OnEZeDmK5WkOrNcQiHFo44etIeHSmhjVxeLM9EcCVy184u-RC3zn_BlDb6d418l4Fn1iBb8HvF65ex23lobtrCc0e5Vk0qzUDazK0vDrfLuRhZcKF5dJ7AhiVBp8zmVn3p8ge1xORS0bCBYGH5wwdIOh_IYYW3ZsEQ1VTjjiKWUY7rRIBXy0ccn-hFiH02V5maTdjqlaktPF6kuZrW4431cUEuYfzGpoi1yWmCZWdIo3pZZVXZKINShmSyvZ_oTh_CRgP21DYS0aUyOw2ZZzR22tAdCfB_4YO0HkkYCeV1swhFiayOlcVFIJREgYMuziFpi6WrhzQhshtA3fG2YU8pZIgn5399-D7xmz4ckxMK7fb9dGmhy4Vq7sLBv3drQidn7JgfrW-Gdl1YBIHLaVsk_4FU1qa5T1KpTKdRjXLLtBYBraTKoKfWes2A4Uo_EueJzeuPqLGjLDhiDrnqRQTiYPJz0IRhExAzFEn_NxkYSQtJ6_w_t_WX3-pONRhrLPmqMqk7bY9FTHVzyq46WGqdzxYMvfs6i8ktqPORnGLiO4sqybcMjosGOviy_F1i8Aja6cz3SqwF_S9NvJONAjAu84dEEZKt856_ayseJZyYsPua_QHFpUAOfSYZR895lyr0qD3sODwri_gG-9aZJrTO2kBTkDPFfvkpynm-U2zZ3n48bbxJT3n-WLDiv9IX6b29_eVNf6vVQd4Ytcy__E3l0WlUTcYTLvowjv_GrhQmT_ZblO8eDafxnpwvgDzPp7I11nzrYYJWd8aF3eQFmO9VFg0gdKj-gQ_OIWJ1xyZIv2tSVZQmsfb9UYDOhwLt_NFm7uy4R12G2Te7y9MFUe6X8dlxulC_NOV11MPwdt1XCDfnk7U2OpslqjWdFYxUM3-rh98BJcS1EitTUPrRRgGfd8oJXA971sYKf0RAkwK7xPbQvciogahcdeeAAaR2dCOFDkvvynPTGfkkZE3VD8EPI-wRvBidc0M9gdhIyEszLxUWTQQenpDOKd0hqfjIOXE9EMNGZ-Bm2C2EsvmxjhoaJL2ZZtUIVD0AqO8I5yyoJ8BpE-WSPhLbtAWSjUUIG7m-VZ7WmITW5VluyOrjoVC6toGouQZm49_f1X68ZDJ7yMGEWNQnyzuQyhgDEwV2GYlModBoa4tRpN2ArQFH8emfjbfWpyFpFvHgp_ecpcqt_wZWiX4xp4jyF7GZ3rOIqJxjrdhjsg9qX5VZDei80yvC-aidDi1rkL4fo_X0ckmVE14k6oJ7ZG2GBHMkAXIEpWsgOlSzDjck2lC4b9MAF8FarXqnQi26Xe_lUwo58F7y4jrcfgQcJUY758DDfLn09yYWzcUmA6x4kES610UrJn4NPvdLo5tyK8_ZRIN1q_WqBsh__d5UNeWKPvoLdL1Y_0Tw6ex3UmZ11nkJuPTOTzXFSC9eigxYC4-6VBxos_qhwO7Y6gdWLSirJBOir4C6p_4WtoSuUnhdOaFmlLrQE_rvKGcJHo9_DaagPzE_EcaZ5wNqCe3LJGMGuDrjEtfeTYXRO7qd5JG3kCmiNBPBPngDW7RIfOuIoTUmgGiVDZauY')
# [07-Jan-2026 14:11:47] /fin/fN9v3p6D6/bg/ajax/invoices/update/2617.html?_=1767787914991 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 ID = '2617' AND Type = '1' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '26171', '3kutFHgq39DB3EbJrrYLBnYXD5D8zZtaCvvyJQARh2LftZ43GKI31OyAgDNfLrwckojye42BLrs0I0Sn3jOUR2GBdVGw0KMmc_Gh2T3-f1Tdq4NvII4PQho0HGMFZLVO46F-rLMO6GihO-ReDmaYEgHDj1eBOoOPCHwEPboSHXPxVuNyWb74FS6UJK1oj9Sx6LiBxv4XI1jrXN8MDuT3gFgZlRyY71JmQFaT28SjihQ3nF21t6u2RiMwzXd_Ci67Sn3jrE2JRu192uWNzjh8NQQ6AoDuxP8xGUN5sowtBY2VlI51Pf6AX0-PORUg8cQV5YZ9UVjOcU2QqyhZpxRAWOvVtE-Xn-VExp9X7ULVry1f1CdpswyrnuJ68wo_SvqfvkmAvKEQYBHOIwCimocYKvD_Vxlq2c9LpzOApzalyoBHbAS8-Alkt7GkX-m7UOConsBi_aDqtPZa3JXQIqzH_lM0Mkc4az9ltOhtbOyQ04hduE262-zGXPODE9yDvRAZAJpJ62GvnHHygb10MugQ9Rsmmy8f3GuY60RyzUkkReWgTCM0U3uuZ7E8knXw7B-ZjtgAYXHdK-qKF6RPjcTrxVk_2sf66d9b_P4Xt38HCcNjgmobyJ47DvFZaZGh8cwPjFRgTqxuiD6Xubx2ub6BzLs7Fjd_I8v7-5xvSrq_l6TwoPQkdkoGZQHTouBTYa4SLECHZusS0CBWll31HFQsBW3ySJ3c_xB6BmO0LcbBoOzU2uT2U38y-n3ygvDRYYlAH3ICluc6yUswQmNaPY6yJBYrqtAJiS1vUMCoFxZykIMW3yypTJcxOHDMoOhu9tGneGBrq-440UGq34SRkUC8JwhS-s7YEYbzzlI5r2jteZFBUSCiCb2oIl1filWghtB7B1G5apfHUXK_6F1U71nNAX8EThyo5TL6kNPwgqQNUCS53gmy1CvMQ6xTTnDuqcXYEGFZa538PRzfoCF0O1GFz67u7wNccYES8s3VGFwgweBmKqNP5c79wPkC_gnXmp1uel4XTaiwXz_3OEWWHZsU6wbPBnki_z1dZlAkarRHqGZ6bdgMUVn3PpSAZQJioHnEL679m5mXq_piN75QDuwucWaurxIHMku6Wr154kRZZG3_Tqmp0rw98QjRGWwLDTtLLWPOrbyT3QocUJS-xbtZZPP_MHPZDhUZ_AnVIafINyHwwZ9W21Yk6pTRdBTDzK61UdB31u2bU4zezoANdQrmvREDBDBxz393y1q1xQmCe8tPciRVDiLrN3khDC1Df3TGA4Hfy8VkG7JP08girduAuAIrqsZTUCjAggQ3jEE7gaqgM7ZvG8fEj_AohQBVIeu8IU2uW3aNGL3vDq9eap9-2ZBbDrxCj0-XcNUREzUDKru5QLM0lx4S0Uz0A0E03Oda0WxjlxR5mjnEVjL-_zlXgNOQtN-NOAXTr6XYj2CE_GI6svXQpcgRWa3ABVs7GqREohnRccRyh1Hl61FDIu1a-Eph9KXL019JawRUQBsTGZmSbZTvV86DiukwhvxjW-f2IqIHR6FAFUyaJ0zNdmScgfsrOQ-VP3zUGX36C4sL23jEmQOfxxyKJejwMEQZHQVbthTokeJHkDZkiNtQK3EOr9zuKIaOH1EVjZ89gMEskp-E1kYHLfMtpwOYrJkCTvoxcgg_9fRGD8TdH7A1OwlFO0sZV4HcBtqgaZBX_hlJh1wQdX2LFnKSUzCVyhqyJibMaEUv31zahLX5qwDpsOismJlTtTdgu1iV4pCjy1zWt2zgC0rOuG0sTjfm_cGgX7fgE88Y_kT2Fj1K9v9IukErf5R2zgNze9IG2QPOaFmTJQ2EU7W_8fvf9TBzzyWOXuszHAuRjakTEmIbTiSGzhY2duvHAxXiyAtVGIlVFdoRihXcuurgOFvtRGfE_6CsCyWjwewPAjaCHkkQ5nDKunHW0BJMMPp-ZK2Ra07YRYg7CivcOP1GSsS-FI5j9Z5J5jQ91cXyPb7ZFtWy7sgq5dungyJlg2gorbLh50e_Iy2W1YymBKlEuTNO8rdxx677WZxOM_FgsAEnlnUz1nV_Kmnuce1wQokYcHvKU_YRumkkP7KNlWAUe585HR0-4CQt9mRC8W9Ut9DS3dykoTG72bJ6-A5ajLIOehgqK0LSGppkKCoCWntGx-0jXGnW_hCL9qk1Yx1mIkxBQXLmkw6Vyb1T99uVZ1KEqVK8ba06l1NrjJ8SXsJ7doKX9QB_lqIyF6xvOD5y3wzpgU9qWDt7mZlzreqg3Hv0x0FHzM7QwsYetl0')
# [07-Jan-2026 14:13:04] /fin/fN9v3p6D6/bg/ajax/invoices/update/2617.html?_=1767787991905 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 ID = '2617' AND Type = '1' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '26171', '0X67D3sEK_TN8YDri1ndXli77JqrtY4vuHZ_ItDNsUCwDxf8WIW67AjgJA9aay0ceTgs-M0Ro8G7ou69Q_mS-yc5f_TEu8Fkra0KrFplQQtoXRiImTLqi5fQD8Tsui3nMJrM2-sfTUkdumR22v9ROWpTKDuqaj1id-LjylFf7WKfeb1DfSWCA2Sya0IS4wEM3E6vZg0jkADtohi8UJWN3l0ehJ0Avfggpk8U_3utQACeQ9hC9es9nT6QxU8y9P_wgmY8NreGK2xaBP4Kula3z_Hcr7SVYs-wSkZ-vM1rSxID4XSXblbYTd1ZEv-WFXCpbB19oC09P7lSOxHygLxGFUOHIjIljAz44Bofb3hLpTyoXLt_y4MR7HDaKnhU-qvDVzNlfPDt058CP3dw85DM4Tn4fNNPT1x4F9kdMQZt4l0dAP46lBt11WDeGXCvGr7lQtr6nWCkTmooRpqbrjwlBasO5lliJ7lLzcnRqXUAiExFR4meAg31wachifXqhtNYNYGHy2qs6okv2bI5vLV3yGv8OJ4WmEZf6icHiV7RWiJbAN4RfazkXKZ_NhD6qz6c8LoP70XoW7Xmt8RavK-K7GbzFAabfsZvrLdKB8DA74PsFtxWyWZSd7Ea5jOXdy_BqYYDXKY9eecbQsDDlN815aJZ47H3_WLdYgBoP3HmbNUA3ZxKfLRDCz70cauWVIVfHwqsyGB5iHN5n4U94RHqS9QxtTHBG2eObYEP8XSZY79si-jzeLGTcg7vc-C5pZFF8AmtHQieM0kojIxjtehbFb_q8WxTxLt714feZGS6Pk-mbOjLeOUYWC5xh4l_SYGCuKLuW6nHI8Trc9o53k28gBne0JooSalcOLM_JjsjsdTQX3f6fzBvUUqFhUfNhuyc0ri5AcHOquDf7DeraxKB9fce9cqvRljLUqiUVpGGwqdws40CBL7ZBl3RvfeVVdif465-ktnpMfqg6tzAt7rw77r6eb5EAA76Lo81Ml4Ms45GvcvKlK77qsBT2RM3DktHXcLG6ZPOfzDcoeEOSjJMXWZsgGOfnBWdBWRfuRQeD4HYhdQ-YcAlavKH5wd0tb7NwK9K3qH1oHtI_YeKqmbfogBog7YZ-DzGilN-tQEESAqjeGadyR2eB6Ux7hjeYvQ0RSmdM96UZlH9DExiO68RMarY75c7uOod4RT1x6PkL-_yJLo5HW25-juEwiCbvBBDLx6JwTFvFjc604i593sRCdDsOqvsrbwY0tqN-7aioMBztdqF0uK36jTYMC7Pnck-cqB1mlnKaniU6cOoeumfh3R5T95OUHf28CIdXwvQ8r2ZMsTkxYvkD4DY9y5EEt0tT4eKVCUaBu-Da0InXUGxz8dU-Pd7Pbx8drYCGBhGmSgtHY9C1vhFgayTU5klh-cVa1IbZNFaYq7yTM4WspBnzRaQfgUaehgQXzOduABh7vQC5Vf4eXDKUnSH_u2Nqr0qWhTW6gW1QyeEf0xYJ4yZ8u1y0HpzlXBMCaM0-a_C40ol5b5fJAsg5mjby4b0KO0DkA0f82ZPY3tI4g-k77Cv9zhFjp3gDfbmIUo65BfG0ijfJuSrG7M4_8S079FYShjNhSnOxr_rs7zGFVVaQlXh_4yaRpbA_0FgHxHSQjgp7lJTnellXk3ZGTGJWByXtEMC8uoTaZyIXVKJ03FGnMJiVJ7xVUBEa8z17dq67Zmr5LiyCZf1fAGJ1UH2thS_VY-7VcDPsvca6s4S2ZcTyEfj71mgJTyesHt6Vxv-Cw0NkONcpZzFf3v1AOVRuQOdwmXnNYn-Idz11QO8e7B522c7h1LPeGYvkG3yr3Z3QZmQKt6uKfXh_yLewBxpNFDZ2z0NyfrmZT9EbDxnaHaePeoOba7n44S-cZISqaUvkv0243KM3s1r9WzC2QH8ioskZGgpz8AW5e3guWfMZ8uTT422uPjD2uM7fngs3rJrSlZQU01Sq7VPlW1tJ1WjIeofDZPyfnGHPNH3OiPqAE0Cff92zOvKZXHD9U_zjRDKm6NxPVI44YaMxZz5VGreJwv7p6nSuBG_QW27LJgbP9M5vwvnUOVoPHD8CTzJ_qKMDPAocLgPfRoI8nRZKmCCqttHVK0Q7drrwxd2JNBucRhrJQUXyWbDPwDgRmo8mavyhAJfAy8QibOsW9Y3u-KA_vhqQMlJKpPc3L1hIJjtYFWCkncFmrMc6ud9lUi3boqhUrW59doPVTbb0wfZP7mmLDCWs0Hg7lZ0iz2_buCI7npGFEvm9t_kxSa6gib3HDrcq9XCHrg')

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') 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`

UPDATE `invoices` SET `ID` = 2617, `PostDate` = '2026-01-07', `LastUpdate` = '2026-01-07 14:13:04', `ParentID` = '', `Type` = '1', `Data` = 'cotq74Etaee-VCzNUZ_Z8rDFLU4eL0BWYPTKLwEvbWFa92lW_MUvVE9lfyHp-1EBVVi2JrCBubitiI-BQCTAAXIHcKK28JM24zi8hUhiW7j3Of3gow-84Kwpsh90IgQBDOGFr9Nv3HgUw4qQiLec_7ZOe4nCmRPNhrCXh1CubxBZvQrRPKrxvNrJFS4R6qDZ3sDAgal4cu9TBsOM7OUqJTMHNcSrsNHRa8WPNTnnxZ0oHVhT3yZoQeXPAPX5SonU8Ji_RqeTovjCZcypOB1DIcmbWIQ6lfzGCliUBLQyrRoSAI4J-SyQA2xQ0gnmogJ0Ra57FI9NyarqiFw1ZD2cQqiYXD1C-Lm8xBXZ-h088Plg2uRgAioQT129ufeiOWsoszj6zc85u8jVy1fc-M2wJ5q7YbszycncZceNRCyJ62G-RyxesiEfSBI9C-8oW13XM5BB4Y2pvtGanaYDUikr9Q7JiXlzM_JZ8rwlET4PK3G7b8wP6A8B5AYlaX3ks1jNVT73aT-fQYNv6iaWsbpkrv3Vb6WqCkgF30OYttkH3x0RsWC4YJlCtOeZEgnFp7m0mmn5cogshz1Ysvp2V-k66jVjX7sypTq2thvAJKF6csFNGn9Ejqm6Cj6JhDV1Am7fYsvFkAFZVHljm-nzx6hxC3oK4RR-_CeHjqusfbmbKm3E6E2AZxfiNZ6ZlVVm8kUzrruOp7oUja5mkEGuX9I0OeSgkhaywlSeQM4F3X8S4Ts-y2WQ3kzYx26AR90x9WlZPoGppn2B_-WiWpH6FAkI-PgmkKLC8sk6X2oV7Bi1FKx91UBGqBeZyos9kHD3sttyWIkwDmy6ugYoiZiTe57SACQJDbZBoEcrwcPJzMR7IFPz2kxB8GlFiMW-JMZGhYNAXB7Y5IOS1yclYBJlHmmcbdiHBh6POHxW5z2LHR7ULs2rVtjE0VJF96GN1JMDyFSrJSjrUF2__kYuRwKjjgUPPk9nrExkw-z1tMFwdLYTfmAMVlFeamZTjsiKVXs7TNlUFpf18KNFdHQbFC7ISaNDVDQMXvOxRnFXJSjmTz1d8wk3zH1BpBCEOQB06CWS-utcsHhvWw8u_NeuOLNtPLvgWjaG3j5cgoSPVJzovGxuwJsY4sCrYO542B9LUkGGTlkEhK6a4k7XkA7W_GQ7VTZY9A', `Keywords` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw0YPQv9GA0LDQstC70LXQvdC40LU0L3QsA0YDQtdC60LvQsNC80L3QsA0LrQsNC80L_QsNC90LjRjw0LfQsA0LzQtdGB0LXRhg0Y_QvdGD0LDRgNC4MjAyNgMTIz', `Client` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20.00', `Total` = 60 WHERE `ID` = 2617 AND `Type` = '1'
# [07-Jan-2026 14:13:05] /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
# [07-Jan-2026 14:14:53] /fin/fN9v3p6D6/bg/ajax/invoices/form/type_1/2617.html?_=1767788100613 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` = 2617 AND
                `Type` = 1
            LIMIT 1

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
# [07-Jan-2026 14:14:58] /fin/fN9v3p6D6/bg/ajax/invoices/update/2617.html?_=1767788105877 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 ID = '2617' AND Type = '1' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2617-1', '9VaEdUW1IFLFbITJIc6YipmkJLDKOY72EXIFRMF9FP61mswatBUeZ0dCbX6q6yElJTn7nkRHrwqV410FNVwFQ4Ccjc9FCIuBBDxH8fUvS7RGXMgm4-Lhxryv43RkbRr29BTXQCD4XgJHUVXz2K4T6pjeqfLQK4TbFX0X2ZUdQn7lONhjCFfRx8T33ZrMRGoe1I46taq_CUSNz-uK99kIFyeSQMyXEx4vaXG3TumJlLX0mK4mB9gdx0Gz5lULOR0N931haGfRwE7IZ1S8HHZCVsXN6BRnYakGF1PJjaPCmKSmxbm_ID2g77jdV6_kR1tRVFm9cDaMdM2L8jjM48-Ki0rayNXef-LUgG-su6Tf2p_H32c85bG0p7K7xGsJo2YZCLcgJoCg4C-5MmjQyqGDHj1BuytBdWw493waQWve6kgZ-7EDxkxgnYteiPM_PZ_z1LI4iY4zn4PRApmHCJePdeuTZxSCYbs1-fqf1bBgtie3XM68cZtZGNeri32E0hxnX7wDRM7GQfBDqN9L_YY6_5IYWZsLzY79MgNhf13IuQc9RA96VgEh2JvHN9IjF4z6gOrxV9uJRDzDLDAVGDw23wV7e6UVsrbwZygcAVtLNQx3bkfMDVbXEBI-koK2HmyuoHYImhgkM2UdZHzlM6yHv9i31ve3hdR4SYijP1mlMEazsMqubgHYYwnA7PnwEhv9ClzROblDZzVhobLweeooTk8ofU5Ixf1AnquFJa4ZzDnaBH1BQ9wyay1nEu29fAR3zi3bvU0CSomIWXBQRE586KKO03kzJVptvN5MwJWYpGQKVz_jh_tRcX5iAJqcM-AuKNwl6fIbMsioWrAkTcCqx-qZrW_fYx7-FmwplKKyxx9x92Xh74oCLlQ7e6JhYkDLQwfl8DpKRK12L02mdw-_J9_Pzr1AE4AQISp8CQzGCtrWA0YpsPRuMdJ7Do0uibki97T4IKz_rg0mDyJfxjzTbSvLivodrpU1sRE3_LaSpNITNx-nNGVKpqgm1-3Y0oAddODR1Ug3zsK7pbThHcvZsi-xuuouzwviNIzN-eYLILOFtnP2OBrnGU1j9j2mxJyC82BOncKGA-_-i2QIoAIO8WjeesSLW9_QvJxr8NsXoLkbxyOZQQZ5JeX6bUpm4q6jUywzHUPkWGWw_WIMjWtvDhI4DLIMs72Q_ZGk-qg4lAAdeWmAjRx9r5f_h-a-IzUHIElI6gHWJAreGcJ24dQPiFqcNmt8b0uFUWo2TaESMBKM3cWJzAK6YiPPyaV5Z7172VcPcoVH-n7gf3HUBaeiWvDzICyuhxwY7WcdBeUs6FmANg8YkOOH6LbYtYC47t048z4iBEfxhxv7W_gJUf4tK27vacLiDfLDAteP_wO2REE7aKnvLavdElZfpWNkQLeITa-bZwVitt32KKyB0vDMjE4R3LMbwt87Ktena0wWTCmV9aikKGqbOSisnA9JLwoVsGZoq-PUJPmDo_cT_1bs_rTq6zykDA5ulc7WfwnZhhwxq_f6ka1e49SrwOwR-tmQ7xf9qnJGrA3fgwcKyMTeQhd1oWuF2n3D4QpuHUIVZG-iU-39UiAr7ahuKzHId63q2k9Zq7AHVAXT845HBF9biv0S9hv6rPw0WBSDj-hTCWbWyIKkd73FCbkPGcT4W5oFcdJBTqVaIFVh_--fJgPR1ILPKUenYSXs1PbwiMTgN5PjhvVGnFIwlX4t9Trp1SZj39vao3ggiXELs8a13dJ6XS0Gcyko3G44xbSgY5BYtqERigPI0NAZe13-JkzDKWMcvNZZBJ3aH-mM5FFrfmNY208tRr9-lz9S1KsjDbrnKg6YvFqQfUDNUimvEq9XcpTRnHio0R2NHb-btUiD-LD_DoVD6-dw4fueTIUi9e4TcCs3O_PymLDcRy30u-IQO_BXfhPJRJF7WMOT50rPLhlVoXLmyUGon28bGieQK9g_RYgqYXbwsGaD3kxiMm2hFCcz06PssjxqGQxuh4juWqURWk5xf3Li3YAiu7sQlcnyPyiggHiPXIM7y6pQtwR1_uiH3H1D6fKB6PKknoxiQouzPL7HSsE7k-EhgtcnALnxcNCdKde79CAgfMpxP5ymhy6w0h-KrncRu8hD3wp8Ftti4whFDljw1GF3zIWniSF6RxR0Cph6fQD9hxaZ_c1rl7h5cmmyQy7KAvJ1l94zuisFuVeKe6-rgnRi1n_Vg9fKBWi4BpzjbvyDSegcT65XxPa1Z1YRZdA6T-1-LmFkCyW6uCwZdXINgZ7PZHWYuHj8pZY')

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') 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`

UPDATE `invoices` SET `ID` = 2617, `PostDate` = '2026-01-07', `LastUpdate` = '2026-01-07 14:14:58', `ParentID` = '', `Type` = '1', `Data` = 'Jsd7hOJTNUCDhY7zyZoPyu5Uadielt92qsvUXc6VGcBNm_MeWWqOcWpp0awlWOV9X3xr2YLAIAqGMtMCqh8nFhB0ePVf6c8AeT-_tnQYjgSXnOUYz7ZZb-ryOtKUeDzHAgYC_6tnbvpxcdqMWJMUrWjVljPVuFCDCyraWs9WNO5942qK_x3wIcNDMWyh5HYSYqHFRMwmY8Izb-5jSFEwkvaJzgRjbVlzLYOPaVl_oY9nket5AOeijEIKp6b9c2CB5bbSVjSTWnZ1TO7klR97VgfkRG_ax9EzO3gIkCe70q4Zhs7wJfi1sUTnrVj_n-V9c1RfDaBEiQtSDqCD-yObxCHYhZ-HTka7uayJrPmK0ByuXFMYTHtBMzULRvrxdV3Sb5tamIva2P3_nYGF1Lf5mUDML9ZgMZgkGgYaqEfHgGJTcXw2YLQRrjV02zZ4r-2zo8qyKBDqvQiPY6-gPcL-0aN79qvxSfRlalFdkZLjLHXJKoCWFvbiK4dkMQwx1rJfnVD4FhASKUlLW91Ia2rbDlNRLLQQhhEm1P65r4I7LHn2CCo7k-tdtlcIOf-nKxrDEJ0GWH5X3CpJl4i_JuIo4a9nlQvRpMQPMlG6MKqWB64XJ1PhKmBI0eu0rN0DAybGzhuLadtl4O8_cMCg-JKnxm06MDGxAdrgwgCFluWrlpEl9YDRvoBDCSxzUZjwdXH_jhT_B8lMJb_47Hr8VPQB70qAfHqCloGRhBMB2krQks8_FEjYQW_uKhVRA-oofY588-rHJ7XWXZ1_LCcdPds-Yb-wDqVVtBcdQxSoxpGDwcTGAe5kAAV-3p4laKUxAva5knm4RzjTF2QwN-DQa33-vvLF5qZRkCzrgxZhPKamYUkeYSFQfI9FjL21yqg94zLHLBmhTDfumj5Mb4m8a8ydHSsI6_7nFzPtRZlw3qNV5cUxhOq4OaiT_1vahzCU7D1U_Td0vPjEnBcyV7PxZO-ElN4zfZp_FJ5VXqdxtjPPpwskETx58wSlR618gcROnc28kCHcLfpw9_HiNnv_bOuXj2Gd66XIEvtdxCm8rbx-QU10b9uF7IK_X4SmUF-eLSPOdaKNbjQIvqxRZ5LqDNIW-L6d08Ron2lDdoSaTyM5E3emjeGGwIgY9hOo3A46R-FDXfcdEAavgOExv1AT0bv6JQ', `Keywords` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw0YPQv9GA0LDQstC70LXQvdC40LU0L3QsA0YDQtdC60LvQsNC80L3QsA0LrQsNC80L_QsNC90LjRjw0LfQsA0LzQtdGB0LXRhg0Y_QvdGD0LDRgNC4MjAyNgMjM0', `Client` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20.00', `Total` = 60 WHERE `ID` = 2617 AND `Type` = '1'
# [07-Jan-2026 14:14:58] /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
# [07-Jan-2026 14:15:21] /fin/fN9v3p6D6/bg/ajax/invoices/delete/type_1/2617.html?_=1767788128044 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 ID = '2617' AND Type = '1' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2617-1', 'R5urXudJ1G8vehNL31jBBomDbjKcYOQpYEvTEafWtcuwgC_sre6WdkZ8HiUQbnEG4sgjEFXxUKh-j6DDYRhtEn-khb4mh5n3p1DlGw4gx6viHjVBSg_xZ-Uo35sZrXQWzHYQiD6_Zf0_ohbbezPyV3O4BRB1WhF0FwM1Fuq3MlZprHNNX3l7rCxxi2VORGTAJ7Quaxggnp2gCvKaxMDBAJgpwQiLeCKLGo9l1KZ9rpTq-LjESb5fBSPWOgQHZ59fhmZvYeGbZIKqgnIoqkryQrOEdg3SSUtntOgbA6WY_wAX6B1WSAEa2LTqlfD1WMGZTmRIwqr_-0glKPj072-WtlbKQFpIWcGzctOIGgfJdezbfBVt4LTGB96derxac13223xRDOPmicI64YMeYDwEjP6hR7qzmwmsmz8xjg9YWOfa3IFFY4b6FYnWa8GFlwSkVmUqxsHq07qm2AzqTtU29GDGjuYv6WJ_9Sp2Prz9nQRrNViqWqqZD2lZxauyb0oLxTFM2FInUIqlqipMUUDmxrURv3rER0EaPUxN8upQMQVuUnkzoINdHIZqFpsnG4FvLiHxy3AsE2M5jxs7I77kNXuoKNpwOwpX9smjSSdfrkfdkOJoQlAt-WFxj3FWq-l26iYk1i7SD0udCk-TrLGi5SmqotpBbCCE8IvSL5GfVOy5OLjpMQGS_WsbSSI9lgtDI8BjDsBRvMQvdXhIPSSh5bIecm43wHAMELInf453VWujA4QCRHN5cnGjwRqKhw3vXdL20yBIeZP37RO3--QZza72vjl-vpDRYjfMpQ7vVtzlwGEbHO7AFOoDLwD_t7BgOIdhb541dOGM67ASMgUkJWih5f79A_YO1Q50ZHV7mE4B1yFjOJLWXQiH79gtzsKQ_f9nerdwZaEJkcFQcu-1iInzmIXc2bJykra_Ts1fjmPhcDWnXzHo2EEPKENRgIaUaEUVTPeU1tRcBKsOOS8C0obSzOfFRQiiuKVouQfrnP6-9mKkLwmXIjge34tK_oANwRTsSrnlsYAUFEkZtoKp2KvsWEuk7ne0dxBlmkpZo_MQ5V-GiRD01FgDUomYkrsTqd1FNgqpkfOEHhgKtut4jNAaFzuLavD-9roR2cP2rjVcZgJAbLKKIX82R70NJbKKqcYPHu4ecZqJ9iSi963WKtjy0dhOWIQNBgwlyeTr8JANpEdol4t7yugRWzivDfaCI4su_V5bujNAtI0TnOI1zD_NZtQzmwDmRhItAjVpboTA4wVlQ_Ql0fYYfrCoGBxI6r426YRlyrMjXa2a5nc3jdLsqTrNpAUV0jZzTQFIXI1MedvQm6sRhjk7UTWpnvDmuQfI-cmS2YD7qk6UC_cNiBoKPseA849ByxRpzEMxatVJu4vFWcrx71LSnVtmqQOVj3VWpm0Tx-8mNHgRmc_PcmfyjneNni3Q3tmmpzW-_CaVAq_kXYnnd7YvaVfUi5fDPcwm88dBHLyZppnS3RQ2xA-i09bePcMByhPZ1K_Vazg2fR-llB280PvUCrM7Osa6yIf5dcZ9MIgKPM7cBGWY7kiQkXlWb1jKvc87cE79_M_Hehty4aCla3MCN966lpWH-9z_-QRPZgyMmaYz6mzOpxgXNkQEEf_oPbLydbiyGlIUcJ6SHjrrWQIRfbaDS1GjbAPE9el1svWvqW9dV_rhFF_5lDSVoKZq1C-P0r1Ip0chNc6CqPDsrbTKdSfJFHVfiIKIAK76jA50m7aNNyfA24zgWMZXAOcido9MWNEu4ShCADpyc9XaPi5YMoTzoZRY_cGdnUsnBjOeGjbx0LblWOMi8VAPSeHNjPMcc93ao321RlzoAoTFGl26u7zCTHoAsTErI2oNBM5eKNJT90n0vomh5pdajEom5G3HjK2Iwbjk2tP6OUN0Datn410uXxBFUnqEeWV38UI53P7awQAgDErJvf0I-ulexRgMA9nfRaNuVXO49ORkuWZNoxfFdU0oVNdu3InHk-yfI2pGOEW-Iln2rSp0P9S75F9740fxGKe6OG2IdBDfptgJJzC2QT4pWYfnh30iZ_9k-VEboMUaIny5UDmRPEts85Myl9ya1_MICaKagjxxVSTWNcyWX99Zc5BCt8zWvcMxBpBob6bolo1QTRVu2mE7Af-VAIC7K9lv6WWYckFYIw-7ScrJrzP7bfu7g939twP4_qR_AIRPqeWwKSotQCRXL64RHxnpRjZc4O47Y3dWDHXSZcf99ty_ujvIQYdXty7-wVtcjH4JQ3LgzOkSdqnZGMsQqEu_yTU')

DELETE FROM `invoices` WHERE `ID` = 2617 AND `Type` = 1
# [07-Jan-2026 14:15:21] /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
# [07-Jan-2026 14:19:05] /fin/fN9v3p6D6/bg/ajax/invoices/form/type_1.html?_=1767788352503 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
                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
# [07-Jan-2026 14:19:09] /fin/fN9v3p6D6/bg/ajax/invoices/clients.html?keyword=hydromat&_=1767788356169 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
                    `Data`,
                    `Client`
                FROM
                    `invoices`
                WHERE
                    `Client` LIKE '%aHlkcm9tYXQ%'
                GROUP BY
                    `Client`
                ORDER BY 
                    `ID` DESC
# [07-Jan-2026 14:19:17] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1767788364644 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','InvoiceSupplierEIK','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` = '2617', `PostDate` = '2026-01-07', `LastUpdate` = '2026-01-07 14:19:17', `ParentID` = '', `Type` = '1', `Data` = 'jNfbR2vGiej8dwppCMzieU40jCsby1p475LvohRalFGjoLcSn5gnBNy8on0yy6dN2VYfzS1GWjk7REHe2ityWKK3V0DjDm5IozfqsaeX0zgA5X0hD--nVMDsM8aAd7kWkvPVyfIxhSrpRexUv-LzYDwfSWY9JXsloFXh19fBeTuRfmJdGbV15vZ6bv9es47ISmy47bUW9FTLbeaDE6VvWG2k3i2WEZYWgo1s2Sg5Kyym7kgCVtXBWG0a2LadkEAt8imik-fXrjMwPsbhvoUPFDeKinLc87kCPvqbIfHJ87S2O5lowemSdcDff3B-EClUpqHX6mbwj3o7PJPUMYv-NGwG7_79dRlWURW1r2kDorfgO_qCrWVU8vZ2a7lLfYckBX_EDLUsjUmDIT8VvKcg-ZFr-eA1_QxIuq6bOTX-8HGqcy9z2LiL3GoBIKY-5vnGipu2auSIFBsd8XskmeE9EJrdFfSPMoJNGP3aTUvbv9HlB02apxA7mBHPHOOVwmbOV-xW8NM1vJSl5UWHF6sQ1T_kza8UUm_vXvT3dE9lJEVJ6VedbbKcxpt8t1eShK5ycFC3AMiDd_vjakDjlKnMMlA7vGGUMYybO1NIhDMhE7mdcUFSb7yYI8L42EuyxNIRT0R-zZxhzjH3VpzWDKz6PKWpRZIpe5vcuAthjMXL4vEgXMlWGagfx8aasmYVpF0Gxi0lfb1E0dP6FAI2xEh4ZgltpuZj9Ync-DHO_yk-_Ub-_YLOXa67Eau4IRh236-48xYWOyiRnE5Ga5iH9TZI-T-GDiPv4_KG-cFY7dKPV2jC_PpqWgtF_JuGtldNTlLWnEOnzXdy-QVVoxbmHg1Oore3aiEC_oN4b87ISA3JkrHqD92NRwNL1XgcA17LwGRp94dEycMsffXmC5EYwghAT4tHCWBTwOfzqaAGyG9yI0oF1ljcS0G0_KaVLUFA7u3JZmxbNO1eUvucwUAo8yOKq_OORZxINSZHXAA2-cgPvn6G-HtLR1PJKFnWG8V3h3ag697aB6HDZ0BBL8habvAILtnDbn41lR9CwIPrssTM47WCq4AweLISfQGhW2eme7Sm0GOgXtMXnvGNfBpIH-mPYLvmd1XLIRxUs_aYN1hQ7ChWoUar13KuyscvjD-bpnA7DNucNnwoQTnNjduCKMSr6A', `Keywords` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw0YPQv9GA0LDQstC70LXQvdC40LU0L3QsA0YDQtdC60LvQsNC80L3QsA0LrQsNC80L_QsNC90LjRjw0LfQsA0LzQtdGB0LXRhg0Y_QvdGD0LDRgNC4MjAyNg', `Client` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20', `Total` = 50
# [07-Jan-2026 14:19:17] /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
# [07-Jan-2026 14:19:19] /fin/fN9v3p6D6/bg/ajax/invoices/form/type_1/2617.html?_=1767788367009 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` = 2617 AND
                `Type` = 1
            LIMIT 1

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
# [07-Jan-2026 14:19:23] /fin/fN9v3p6D6/bg/ajax/invoices/update/2617.html?_=1767788370269 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 ID = '2617' AND Type = '1' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Action`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2617-1', 'update', '2E3_ygV-q_pikFiynRUGrwcwkk175Ki9b6poq7aG963P7LTSeQqZIIhY-7YZRWl3S6BaXQ-R76KqKoH4-WweFPMJf0sCc1-ASREDsywu-J8WC2sCiWwsB2YHX8YLL8lZREuZfrf9NLYM4EsInfWz-cnPGORaGTYSfrcRyzSfpwpyuS7t-yAFaL_vVONT8fCVDC9JTjfHGLXxpg82T8lp8PqgmNftD2-ZYgC-SXy5nlKZhW0Y3ITWloFF-yDssEt1PHyStHJcCpt5tRy6VL2U962gpCUd5AQvG56LnlA3wEsecSbgr0BJEkmEBYrFlaCBrJkZGu1WH63PXtLyzRL6zVd3X4eYOIqXMs1VOGnErczRXv55EMZfTmwbjDoLdMrmp6u9k3Jl1_BnrwIdxZZ2FMuUA6vriN5hzFo674sfbkMFy3lgz4sUtKLar72u7RzpXfmyYGU5PJcSBE6q7On3u77DgI98HSTDY6QJu8pB7hbHqn6tsdzQSX7x9m4On39QtPnQ2G8tg5K95kVynHKfKpYR3xK_82qfuZLIe5xHfzO0iFECMh2KNctwir1mLVwDb4ug5Orb2QpshRsj48EFKQ7uWaTx_KG-I0AjGR42Bz79buxbOrTacuwK2xYZGpXhATbImVnS7t0vb6S2qHUWZQzZW8MQydf42ivBy9MyK9hy68PpVQE9imePxJa5JXYP3JzgrlciInV9Gf_uxWG4iviq6f9ACwRya6cZ2l-PfN4N6FQns4E4XfpUJWNnPkVDpZvuna-2vgubldmNghhArcaEiPaIlyKfcINttiddekjcvx0uplElz5rwEoFsoGx3hW4Zen9jO-mbZZ54MOM6xgba221N96ftURSWNO0mqzOn4AfLkXOE934tLBAV2Zm8mOFwS6tvTn0kr-LK2-hG5Iuy7BEPH6Ss33R30XAoiCX3Dt-T_Kt54vu7KUPMj2fAgTZ8CfaJzAOYixO5TIQ06S4fVe8U6yarc48sYP2dcnnzLJXP63f-GYBh_q0DGD6rvEOwyLDwWbqxn98wQpdGmHb60HpKT697SfdQXhwmHcY9zYaE39cwE5VvYx4qoebhnHccmNRZNcKSSvAtcWMRTpcANq1VyKjpLPMYNVK9NashEO1hoP5MQo2Yx3uXeHKpxfnM5XwERyu-zDYf4z-f9Fztu0dphU7U5DyjRdO2CR02baUZgi8STn3KOMGeSXB7ZBNp3VpR0ZCrHoEO0R9tSoeA4_Zn7o6WbYWjdqRSd4gIYoC6muL553nPUwTg5CL3jj7K_LFYGlXNH3oDzGz3uszLewL8cxuG9izaQ4Dwf4Wwq451ka3ZX5YUQ_XF8t9kEvlAhH7TrX6o9HmK0VH_S1A7hwI0U1PnGcuvDJ1o7ksJKK6Y424B5OvND9AxOjwLcw_KMVx8L-d8rJg_oy0pn3DydBalre-WB4LgsI7FSlhBrOSuWj9DPMJxueSfp6-RcNSPcPeh0S9ktwAZncGi6mycG6bg_KSoqaz96HdgghkNR7F4svsENiKbqLEL--p86QdNZDTTmqmjwUGxLAM4YvZwtJvaEI8VUXjD3vWHlt66jm1ymGt9T4Uidfzb6nyIQ_xzropQPnDKPqxGMe74kQyz4MucGVlSRhefUtk1QyNoo3jwP5sJAC0nfK0AbAfPXp7pgNOFKd6Ode-2-nYEoERUg-eT9OZTYcUJR7VBJ6fd5QtaY-Lv5ZsOK0zhtxmOpa3eoZlPrC-2M8bO-jrZQApSvtcDJNv82ewpIVVOvqmZp4ulLLtXYtV3RCcKMebDpJxyGIGznxx5hamJMwTbYd8-GRD4HXJu-yJ6BE0gIZf-cBKDYIaqGm2Pdq03I8XpTiDRiT54rx4eZnBNuqyU49wdZPQk5xwrLgkqUrSX56VIwErdO4bjSyiN-jniFVKl7mUeVCoaexkgbN0pv-og1RdJmz7l8gmkJC6YgQN8O_V_6U0DhxDRgmCLZFc14Qi4ELbFxxu086atWfUZzckShgle-ZbvtyfIZ0pHQH1Ga7mc5ieXyIaA-CNe5n7zayhTyiZtDjocM6i4fLdtZUTkgLPRKPeZSxZPFx3ERrN5gAc1kgFF8kPwYy3n8g08uGwH-_fGW1mJpILb72XUlLeyoKgCVHMAXj971rateJBwE6bR3GsduVDENSkXAOr9vb8WYAAzJknKLOHVeleg5vgwnKKU9M1Z5MWzss265zspKYMTK8A_Gj6P1j22oV2TB_HncI5SDrIUwkh5Fgku-Eu3CFCiVIIbPfxsVQ9q1D3ZhHo')

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') 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`

UPDATE `invoices` SET `ID` = 2617, `PostDate` = '2026-01-07', `LastUpdate` = '2026-01-07 14:19:23', `ParentID` = '', `Type` = '1', `Data` = 'PBzxYiQZsfqLPqG5AzRg8-PxVm2HHcZTZGWcLxB9lKZyDgM-tcCqzDMmkAZ3UQwAlTgdQUD6sDZ6bIovZV1NR6TzJ7S4BqwIfDdNIhFLhcUqv6MwMw-dr6p6cB6pZWH8yoxgztdJigxdUwSthT_b1ekj0hrZohn9Bi-TgVg3gwOvxP_sMlLKerDgV9Slr20YeWQzjKLRpziAKrv-ThBlBn72LV7Ck5yXd5VgxQy527NfhyS79HnXoIXGjpiF0pIcUKn2GbkBreghdfO4qulxns07NbVrlume5XvMqYb6-8EtuOnolpyzQiAYVSgFI5IWQ4CbYGdWxFDgB15Nf_n6sPDm0PE4XMldTsY0Grira5WVE85WtTl3YBKFaAioFdrtVyTMdQTGRLyhy0vZoN1C5CltFBoM0g-q8ny3Jlvw5ral25C1EU4FkC4L4q4wAcKA-gFpW43VnqM2YpxE-LT0XjbM-RuQuRy05yMovOPyWVWNF48377XMIloysLD9mPk3_eeqzIBfnA9cAXjRg8nM93IX1jKd7FuiYhir5tilMIB3RR3Qoxl_blxdMDk47iadYAc83LE3ndyQzttpIOEnPDD1TWbaneBwJjUZzwcBtuI1zcE_hk1pIqcaiEkgL8Ep-fzYCStYkC64irGAGCU0JMBVxqr5zLKFIHuP3q0BFukP6UlRCQbiWxQCYz0pe1c_VdWsw99i8R1FoLSEcsin2lRmgM-ooax2vjJFR71g_oS4MEQ1zyCr3fU9W-CXY86i8izNEV--Tkl1FaFF2C9rGdclGeUfjyRck3FK2cXs3ewqSKWXtEsdklTH-Z-L_d3QLX5xvgPv5PULXsfQv0P56VyefvEyfrmKQdUFGbnmK4kbeXxRr2LeNdgaCf4134s79lBc4KhFg1veZH2hueh_iLmp-iPkVmiSXcFbcxwW17xu5WLroOwlkQYQcSFwz_AaH3gVx0sz7MlZO0cQ1eewSmlnvwNG5TCwXOedPalwPqfpHhpn1Dt2-KGe_Agif8o4cV_V-3M8wL-Vm6BSpDomLvOkEDakA-HyOW3l1lHe0SR1RaynCw1sX3uDEPl1s5zCI-GBcdzQWKrZD9VnUd1BjQhtbCQeioU1JJW-t9swWJx_bnEhDjUF52VJ4dvDhn1gG32_DYm_mWrkrQ_jFQMBzg', `Keywords` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw0YPQv9GA0LDQstC70LXQvdC40LU0L3QsA0YDQtdC60LvQsNC80L3QsA0LrQsNC80L_QsNC90LjRjw0LfQsA0LzQtdGB0LXRhg0Y_QvdGD0LDRgNC4MjAyNgMTIz', `Client` = 'aHlkcm9tYXQ0YXQuNC00YDQvtC80LDRgg0L7QvtC00LDQvdGC0L7QvQ0LzQsNGB0LvQtdCyMDQwOTkwNzIw', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20.00', `Total` = 50 WHERE `ID` = 2617 AND `Type` = '1'
# [07-Jan-2026 14:19:23] /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
# [07-Jan-2026 14:19:34] /fin/fN9v3p6D6/bg/ajax/invoices/delete/type_1/2617.html?_=1767788381849 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 ID = '2617' AND Type = '1' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Action`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2617-1', 'delete', 'HKaw73FuFl_vWSPuk3n1L9kPMOwubv_jntdpCC1W-20r_PsU6dbV01qJiaRqWCrtOrx_q6DW94yg6IKRGEace7iKfS1XOmLEC9rUza5fK1bCgeWyY_1jpb8Sww7heKUZtv4SNNhVA1nU72NlIgZBV-nd8_5np_ez2HsL1kUuRKkLz1TlA0srURrAhcESkeAv6alJ0euBY3Gm2Z44arPwHxMul_IQYEyxhFUc5Vd2OVMUtG53_jd8pzjvqRVlzgSDfu2YnsoIVQVAPhnWH32jczkbwU8l56CPvCecZNhVEkapE8y4LU6dQNEYFSM1AW93byRRYV3tnoX0yN4DfoDZS70HmjwmKJQWzQ_9WNxrjwujpdEx5gmZhA_7gYRU-7u1Y4zEv2-qoDSQydQ4nSKZTdNbu1btxTKgj6USfQ5bOCt0TtkpF8uoHSY2AyuOcKw0dvsq3AzPv69Dztst2VJ_zktRGohJ7HuLLcDL1JP7b02TyRlgQdb28LaaHh4qZe2GCCvfQx-NR3haXfFwPFlOfsqXJ-QPmDFEi6adFmhbHftH4cZXgojqzBX28Lb_CuaO1RLUPLXmsjOsgrqN5dCr0rrRnlqR850z6bl-jMtKfadrb9TGntXLPGUyGQ9ORg6qttKTCHJr3cQgegMsBLxPrAmXcQC0KPHH3bpxVXZjgsp8qbdSmHI3wk4t8lcXf5X704U-QKtz2f1Mh2rFvezGPamtjR6ECpGjYq7OpZtDlhUoyzKZVpVSDKZhMy6KmC0S76u-nPLDROkkyIoLg-k3DS63I2Sxs54njQihYl8PWQJquZ_TWSJ7FRqd9uFhYq_CruEiPyX_WWinoFeZmeYaDtzCCV3LwTpSdGdz6jAe_nTdusB4ZyLY8waJvuEkIhQhMvCYDdXwZkfc-at588_8D6e1y5Qt7Sc8aly3HvJ7euHGa2V97PVNqdbCWzIptpRVuFiUdr_ba7Au0gSkjCmOjxW81cTMHLoliLbD2qzB_U6o4CKD4js_7Gi6iUzJKTirtZRiifmBrMsH6YEESu2JXkaZeB95BohC0mcn7AtY0T-xZSohnc76ADgfEjwrlhR4kI8WHJXlpZsqPExERjnUXZPBdfFbzoa9-Eb2YZFA6w0ng6RgWjSJLeDp3o6Hhf1voxDfd2AwG4OPAtXY4cr0dCNzOl-GAfqQmIZbSale7BUxpBmtLE6OV1OGoJnjvg6ShAALJBIec-VdTE1y3yZHWrzDnMHuSggpjMcgVDrekXVBIqHTV7JNLZ447HXS96zntq3cIgUJTUcVnJsLK2wHlJSSjyL_V4UpTw2m17eJ8o4pUfCfVzm5UbIyQ-Gl8a987yXN_mZV8uHkcmJQwMS-tjRz6J9KOO1u8YZFuCsGRoXcmTfSHDjFsfcePHILBdaE-zVLxGvsgo3csHKY7UTkry6VONENDwN_DF-Rou_Eo2_9ZofuHm9gNARXRh2XUz6WEcz0jD-I8on10MGPHJcj-_BX2Zki_xLU806oPpuO5aoLcBsQMSJRzV1ER6V-DPxz-p_MIyaD1zC1ite2tI-SVynutKztz1Qbas3txjapIY-ZOwCp6Pu7WcEX6I8SAGFrmFhHTa0VgqE-TJoAa8QMj72NWpeU6kDpQa9AO5eG8v90g4Bb7sXoBZAv2wI9rJ3Sz_W3QlggHzfRNro_6WZPhn3_O8jdEpuldjet7AuReq8QSNu75d-Fc-eyEFkTVM8xvu-7k7jeFen_SCobCm_wjeB9le_y-BaC3fZ0I5b9NVqRMPIRRl-VBUgBb_RxRcxODYvqLbLD6pOrDanfPddiLysYZi_bRf5LQ3zhUOW8prP8HuTu1fj5cBO9Y4D6eLApvRfOUmE3y4hLB3dGc8HvJb8AXlA3ac73c-DCER1stTtVexo5J9b-nyhOXdvZTXHuBMGRu6jhD5gKOJbjigPRym2XA-XmLNTZFRX7LdgBjq9H4MnKYGkIxwPji_iKLryT1ZtF2hQjx-ExJwoLViNiknlrFKyuaW_K8QsK1TTiiIZGkB4RrK98FU9u-x-_17ohE3txukRL_Ud9jjsL-yGrmTEPGo8KHVnoKiFWkiLMFSakspmzvdDHwMsU5yBXvNOx1NhNX2RdRhdRCqbLXAFQ1zj_6nXEnkdKiicmI9ngCDyFd6Mpk6ctpYZLwtvOXzEruVq60rnI8LHNfIPq08nTs0JzF372zZ5t_CIXm2KVY7ZoVR8rMa2DkrtP-6UVs2P-smiXr_WBhfefP-ry5F8Wd45MbWR0-N2CEGS-3GFs0lw')

DELETE FROM `invoices` WHERE `ID` = 2617 AND `Type` = 1
# [07-Jan-2026 14:19:34] /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
# [07-Jan-2026 14:19:55] /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
# [07-Jan-2026 14:44:57] /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
# [07-Jan-2026 14:44:58] /fin/bg/ajax/users/form/login.html?_=1767789905136 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
