# [28-Feb-2026 06:29:34] /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
# [28-Feb-2026 06:29:35] /fin/bg/ajax/users/form/login.html?_=1772252980346 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
# [28-Feb-2026 06:29:42] /fin/fN9v3p6D6/bg/ajax/users/login.html?_=1772252987546 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
# [28-Feb-2026 06:29:42] /fin/fN9v3p6D6/bg/invoices/list.html 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

set names utf8

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Feb-2026 06:29:57] /fin/fN9v3p6D6/bg/ajax/invoices/form/clone/type_0/10488.html?_=1772253002648 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10488 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
# [28-Feb-2026 06:29:59] /fin/fN9v3p6D6/bg/ajax/invoices/numbers/type_1.json?_=1772253004833 108.61.209.243

set names utf8

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

SELECT
                MAX(`ID`) AS `MaxID`
            FROM
                `invoices`
            WHERE
                `Type` = 1
            GROUP BY
                SUBSTRING(LPAD(`ID`, 10, '0'), 1, 1)
            ORDER BY
                `MaxID` ASC
# [28-Feb-2026 06:30:06] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1772253011747 108.61.209.243

set names utf8

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

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

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

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

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '2633', `PostDate` = '2026-02-28', `LastUpdate` = '2026-02-28 06:30:06', `ParentID` = '10488', `Type` = '1', `Data` = 'n4lOSyMR7LK-J8Bgj5PmEjJVKq4wHqlbjFvTlxX_p_pw6o101JeuiVCn26fAI3TO2nQocwmEQd-8jt3SzA2oD2kkOIt80QYTy5lmxXpnkyZXKKtvQwkelgRhV3LwylmB1lSrEqdSw5_zLSaASCuuuwJKlkqXdhSX3a1Uvepkifa1tbLYKaD_nCPstFdPnOmKRgPl6Ld4N_v7DuZD7AEkZk3UpprrHlroNJf5f2zKyKzOk8UHIks2mMrcE_UVJoehEA5SMDUG2ZGbaebjAT1k5It11hNm3Xx0MMSfJ3oSv5yft4n_Bs0QW0-qDcRis3T_5LD0O6OydxTDLmht6FcYJt9zUal5fKU33F6Oo3XFf9hqP1peAMsHifm9eJDOVQDBgmxaje9WHtbly2CCtr8xY9KXusFR6kU6RZ1vhPAXhkSd4ydVNbzHUVjp11qPh3PzZJybUsRbNIKGuqIArwiOSC00DMmVdRvWHkN-P9aPFaHK-k0mIerPScXpEaB3kn6Oom8rkkyfEYs8rSYA1fXBVwzjtfgCRy9RAHN7-UEjgCCEHLPjP90uzG6UfqCw3yxkZ9L-21aGWiirwrUkrqkMEU5VqBeCpsZDwNVtK3r7akgigjXCLat4bhnTlJ0cAnR7rzqPTghhuGuY0GXI_Wz86iLrhsv-n0J88fr9Y1fCixCfRskBByeF_BmC3V4kK5v63Yp0Ws1--i3LTYtDexiP9OpB3B5lVN6xyHJhQwWCvgQ7HPEbqx2Y5GxieL-DLOhiF4Rw29xtK8iBCYrbJInhMuShkJEO6PsCPsBPx6f2cUCFqrxzafQCxjrQXqwjBvV28MA0BARe_zKz0w6C9H8MS8xEvh33XNtupzc62nhFlQAv32dqKoBuU5bnGNey_Ij42mVvvmF8NhpSyAxyMAHWWCv3xeOmBOfhINW4VAVRq8dHiwNeVmA1td7sWslrSGvch3kjXAaZtIh0ooL0wZg1DPBZDZVcZ7OfR4aEuIkyLluDLM0hNSnTQ0HEGod0E2S3YElmmuAAHI5tIsQIU9Zwsw6xdND_rQP0RiiglkLD6rtcRfUk2w0Vjsi_QmJZnXANbnvYhDYkhS59OPwTlyhICpzDS8mPoxg_0_89p60-hIT2p_BsrHjOcE0u6j7cWKaaVz8X6pcg8uW5K81_AJyED8UI0Q2cOcgytTMQOvWBuKPTXHtwZhQyDXFUCUIIEfAAhtGcSTtnizvc23VDBMZcP3XRuQ5qcHJZ3ThC0wRYoAC1aAfG4Y5LXiVFwpFMT2xsBh9F718KDfiEvacFroTbFhLgsiC6S_tf7nHcb4XB6s7iJTqzq3WarNpZcsJ-g99J_Cn39USB4aNl1nsnOg72rA', `Keywords` = 'bW9uZWE0LzQvtC90LXQsA0LzQsNC90LjRhNC10LrRh9GK0YDQuNC90LM0L7QvtC00LvRjtC00LzQuNC70LA0YXRgNC40YHRgtC-0LLQsAMjA0ODk5ODc00YDQsNC30YDQsNCx0L7RgtC60LA0L3QsA0LTQvtC_0YrQu9C90LjRgtC10LvQvdCw0YTRg9C90LrRhtC40L7QvdCw0LvQvdC-0YHRgg0LrRitC80YPQtdCx0YHQsNC50YIbW9uZWE', `Client` = 'bW9uZWE0LzQvtC90LXQsA0LzQsNC90LjRhNC10LrRh9GK0YDQuNC90LM0L7QvtC00LvRjtC00LzQuNC70LA0YXRgNC40YHRgtC-0LLQsAMjA0ODk5ODc0', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20.00', `Total` = 1000
# [28-Feb-2026 06:30:06] /fin/fN9v3p6D6/bg/invoices/list.html?type=1 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

set names utf8

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

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

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

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

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

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

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Feb-2026 06:35:30] /fin/fN9v3p6D6/bg/ajax/invoices/form/type_1/2633.html?_=1772253335728 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2633 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
# [28-Feb-2026 06:35:34] /fin/fN9v3p6D6/bg/ajax/invoices/update/2633.html?_=1772253340083 108.61.209.243

set names utf8

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Action`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2633-1', 'update', '-lQWT1KbNqxgJaVcBqKQ6NsNKui_0aJPDstWG6CWN98y6tXeh_vxr159GhnC49XQf9FuB7_GZz1xCkoviWjzPwV9ec6c9W3G8fBzGx50S2impLdnGHyYPUKpP6ar2CjgZaOHx3WOdZnMrM1LX48STn7FBNtTOUm4gM8-jWf7lG92m57gumCzMAHbSEhruuoDPygc_5kekO4XFwQOEDUQRAlzGV0lV1p7RHqf4TqHZZanxoMorH1FDVI_SLsVGh1z_yfmFO0gaHPi6i2-0y_56vrTvrJRQ8K9z5gRoEZHeEEs4tJFYUAc0PcSzRquMNBtTupCAtocrOpi7QmlIM2znLt2Bz2HiXdTJujFynOeuUgNel_K4avmVpFOrfCNjKKLKMEbEjTBCIjNI-v0jaGKb5el55lKfF34nCkoELw9bX-xNRaBbuJfYK8keaR4rV5p8BKx68R36R0fBdzGjjLVBaFxZM_NiYHE9IkFMRNuppjEw75Npqw-c3qhsLE7exDQcDx26Qixo6DQUxosfa2wGI6bMJqyWdmfaaw3JvoPc54L0uLKVebVJcEGWL36jCvF3yKl_iQQs7gOHK-k7sr-2aWXw7GmfIX2jqPE4TXsdSdGRHP_JyRoaO4d-8Ck9DV-4wmvoLhp81KbGjnV0Lhf3e_TCs_fOdixKESeeSogKT_zqSz-GVOq4AeCChD4NYx_FVpFjLYzNk5LcyesbIcErtbOl5Xu8b9s3Vf1ae8iF6Js0DbezixOvmh4a4LyqpoCI4WV6Rzjr8HUdO8gq9NhDjNwJnc0LoT-KOKHYx8hkExxeIqC-3kRnu_ZDnefGSdaYBUzL-VSmqQNVL60fq6mtuQQIA4eZin6kmJ1A0jwI8xHv2uMxn0WzA08w0DohoxID1GrG3OlDMEW29vhw8-BhExtqTbBurHpOcWe8yDGP1YOoMjinDaV9D5PE_qeYRjdc4MxhDRga0QhjfrMNA8h_aFZoD1QC7o1ukve-2V-Fy9pPDEfPIACJnUCVuUW7fuSuQoyd5FjXpnQv8bRLHgKNkn40XRDMEQI2HFa24yLsHBfjdMbqwXEV-3yHbIHakJk5baiFQsRr9r-s4RCwLgtH3wEjgXiPQC_yU3FEMIBEB59-CfeYdJHZqXt5iD17BEuWi6fYRQr0QfbciAcFtoWmrEUZCd2OlNWPCK7nZwg-VhIoTZc0Q-Upa63BmVUrJA5rhAI9NuiA-vgBSsOnprwL2ekzgot7S6jYJ8rYkfukVFQeI-uzyQwZsp-gkeTeeLusDaPd8spHP12vZmz1SJ2qHHHSbX6d91A2U097cGsJ1YJ_tYl39H5GQDNT5gzmFK-TvZTgSx_vkxuz3JlA5jU5sl7D6pGJDbHJTpZdPDrd-C9Vg2ajdrWi7oseAyhUzrI8zPauWK4Rwr6hQUC23gnorEWa9toTwR9QiquGmIRaYRRgDlLOfXz1GSEGgED2lXFcpfBMeL_frjqElQ3MBzokGfc_T7IlgFqcNiCnP4CaMj4EmVEz9BWk_UND9X_ixgTs18VROrzD41dYqL70nHXfyy8YQn1-Z7K88e10nZrE69dh6Bm2zyJKGG8F4OpxDRieVcAhPCvtvQwEIcLgS5BF1KRDjmIefxO-Pvq4tLhEgsN85uHjvO7FWOB5O8IoqKmWg-4ee6dWTFh_H6uGIcqneovdPdQa_7MtQlBcwkvMr8nnafwIoMIHzLKlHJ-AR3R7xi7U8tWrJBZfluDM-4yWWpWCHTyXbDNFaKFxXNdjKjLW0S2h0yn9x-hACSWbQMLHdpRfkGck4rY3aHyeGI03tKg_rZUezK50222VagkcPmdtLRO6YrVN55jbqEcVqiAHfEQszTdyVcn8-1KQPNqbPfwS98hFdGgrv-FvhEGF8khfqeX2vNg7XgjB7qJ7p_aeTsx10ctt3e2nBTeOZJvrRQHY6ouhNK1PiyPh7-T74EoE9nKuDxhY8uTmkUFDzDl4k660X5l5RX3Fmjg0HYRq6N-4klXILHpdTt5SDoz3x1SS3mjBE_VGzSyH2-w3ZLx3OzFO9_6zXWbEdvEJxqpFsp2ItFK1cV0yc3rTlJcHL2RJSu7DQTXFKbyuCrKIUe5aWv5hnQmH0liXM7nrgCxxc8_A2KH8P_6IOFcWRWLZ2ld3KN01nlJZAEChFe060h0lr2hAqetjBi9Xp2FnGN5I1bj3RH-BR_BsdMPp6lYX7cK5-_nO-1WXs29yHEYhLlBJFb9T6MIFS0YiF32vAzk4kvSizphIl3c6wmct2yuJQGqC_VD5Sq-z9yq2o-QxOMvz2gUwufchroGxow8gT8ZHROeAzS9YGEJnQ4Vgcw6_d6tZ46zRabniS2qwksOe05ZZbooMsfUTo7T6yZ52xRV0oWjDVad5riULiDELR7c8WJZL63YWeQ3CvOPd7nmfvH1oXACRgvUoPHeRad4a_UTeFbDvGixNxtUrra1y8gnkKG5icogvQbdnLtU4d5weSDWWpPilwLpAPeVuuHVQlfI212V0ZEZldrAV_H5plCcqi0oh8cWahQ_CE5PQlVg2JQQP9NdsHC_-kREc2J1qFu8sP_WTdf7Z_AomEu7mnlRPx_tQ4VSvcQX-xUIfDjVGY3Ml87bYkEl3rxbLBsMTgzw-jmU8xfz0Xa2PSxcePBFIaE')

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

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

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

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = 2633, `PostDate` = '2026-02-27', `LastUpdate` = '2026-02-28 06:35:34', `ParentID` = '10488', `Type` = '1', `Data` = 'UiGbO10oB_svK9mqr_pWOK9r5aNGC3gn_FIzPW2NgN1OXrvfQ7pIJClm9gn29AKouRDO-Ky416AqKEKdyFgT2tNn_s1T8xkRPPyv3gW3oMmWPoF-Nl309iBxRPJyf7Trxc5W-KalD2WCKlS74fx82ff2SqZl8miUiQqmGmTYpId5tZB3nqBUs6WcaKH2e5IKoDEe8OkwSSRPXxvAf9n-79OwvUazyDKoyK9POdIdZxC3lnxo3UlRGgYoPZNFHmXREkBnf4nUWt_q69LsktpMr4vesByYuedg2nkmxXLC4_QuT-_wrRgNBBQdIEIatajyqEjIRQ7BTPmjMqKA3MrxUAIhkWvE_yVphJPdg8tkgxVvkPzrUCC6Cxs9jM-eBUOjNZUuLRn-9DtqSw5wf5b6-VpIuovttaowPsJl2gWA5u3vJzKxSMGjUO8eLWBGIBFBAd2MXgdoMLeb-KuxtTwDYISdNY1YuUtlPJmXnHoHpkp7Y7yRrXjwl2h3smzmTcTYWh1fzh37Xso3Yj7-YiL4bdKvsBbQ1Z5tfWKmTBis4QTe18RPCKbJTqrGUMNSL_wEP_Ewop-eBZQ-4nm8qex7oum-gbKtDW9R9dcla18HvoP4vta4pGYcJwNXOF-v1t_7t0wQkaEWlEwmddHTYwNOnnxKzbNPTi2GdJdRs9A0mpQhGig7uom-E9l75Dw-cKeSsaVXKj9pfCl0MDpTDhf2PHdqv0bvCtuWu9tGJcxrG63LpAYu4mkJPYCyJZfj8Jg1yIqXLAnixdj5yUayMXDSi1pAMvOon1Xdw6kNNccj41gcul4CuDAChA0o8qPrPHQ9BJybN2VEtloLIuiffJYQsQ-UyRQk5fJxxgOZx-an5ifAT-strqe-WHgsS9sGC7DIDt652XZBjV5Ow0ydJa5866_-l0IZrky5MJo6SckMnIEMOyUEE4ftDrjQ_-iRkApW2wXqmnY65Dm6eSnfcBkrdSYWYatsb8GrM6_ttV99yQ-TUUnsh7iSzI4SNz7c3qKfvQbIl_3iyy_VjeMDYlMsQZGaQImwb2Rc4HQDTy1z9-yQy1mN0CAGvXPQAGdaYH-60DG0QwCh4OBA4mwYZX4nozqvRtK2THB-E_Ly-5yzf_k2dWzKUKcwXeI7whOTF_YRw6txYydiHESiHDPk5WfotUCi0gZhrjhKB14SqmafU8DtsbM9hlaqyFX8tQQGmMAFkvItu_5Bo-HbNMZMlJiZkcDgShYn0kf14Vo8YJg5M80G7oeo4Tlhp4e88K9g3X2Pz-7q4Nh9SsMSfU7970qWKwfIoIpBw6xQC7eaHCfoupj4oHnwtnVCtLpHWIZmfT3G9DXp0eM31b47znk-lOxSug', `Keywords` = 'bW9uZWE0LzQvtC90LXQsA0LzQsNC90LjRhNC10LrRh9GK0YDQuNC90LM0L7QvtC00LvRjtC00LzQuNC70LA0YXRgNC40YHRgtC-0LLQsAMjA0ODk5ODc00YDQsNC30YDQsNCx0L7RgtC60LA0L3QsA0LTQvtC_0YrQu9C90LjRgtC10LvQvdCw0YTRg9C90LrRhtC40L7QvdCw0LvQvdC-0YHRgg0LrRitC80YPQtdCx0YHQsNC50YIbW9uZWE', `Client` = 'bW9uZWE0LzQvtC90LXQsA0LzQsNC90LjRhNC10LrRh9GK0YDQuNC90LM0L7QvtC00LvRjtC00LzQuNC70LA0YXRgNC40YHRgtC-0LLQsAMjA0ODk5ODc0', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20.00', `Total` = 1000 WHERE `ID` = 2633 AND `Type` = '1'
# [28-Feb-2026 06:35:34] /fin/fN9v3p6D6/bg/invoices/list.html?type=1&from=&to=&keyword= 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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