# [26-Feb-2026 09:04:35] /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
# [26-Feb-2026 09:04:35] /fin/bg/ajax/users/form/login.html?_=1772089481603 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
# [26-Feb-2026 09:04:45] /fin/fN9v3p6D6/bg/ajax/users/login.html?_=1772089491095 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
# [26-Feb-2026 09:04:45] /fin/fN9v3p6D6/bg/invoices/list.html 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Feb-2026 09:05:09] /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
# [26-Feb-2026 09:05:27] /fin/fN9v3p6D6/bg/ajax/invoices/form/clone/type_0/10480.html?_=1772089533264 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` = 10480 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
# [26-Feb-2026 09:05:30] /fin/fN9v3p6D6/bg/ajax/invoices/numbers/type_1.json?_=1772089535753 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
# [26-Feb-2026 09:05:39] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1772089545058 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` = '2630', `PostDate` = '2026-02-26', `LastUpdate` = '2026-02-26 09:05:39', `ParentID` = '10480', `Type` = '1', `Data` = 'uMB7VDFInjO70vrWfMoq3R23VYaoH-6giz4jQgsOwDSMkRKywfrOi-cERDfH8flH6gQH4RxcNc7hry7v0UN_kgwrVew8yWllQqgmhBBEtbJw4IZdDbXJfX_kQhlnmvLT4sWbTeD5t2vQspnLf6h026gpV-YuPdFPkVDbr83tzkItP8shfEXfqNU4P-q7c5tN0VLtzwjE_YGkTcZx9zL41BIC6ALF1YWrc4kDaIouBMLVzTrHG01OXjscGZqoGk6rEmer87UOmRAQEz6mdQ4SN0Qi2JwbOI83jDdRYUtqAwo6Seg8z0amLAB7sfAqL2GoLeMfrq75xw2sJFCekXEN4fCkuT7PNCor5BLnPxuzH4r_xwCpfyFmTbX6PceXvQI4grDX6_pZyY1vHfYD13nyj-WlXsS_CJqgnF2a1U33D8Ud-8iEPEfjc3eYXGPm8rauWUtsmikg_F443X0awa4VcfBv2OUe5ge0EgBPfDjyJsU52lVK2wbEoHgBx2Ss3KfqkGVSxA3Mk4FTwBFKZcHHBA_N-mYOq9NesSGE5Aw3agDNurTAC5TjLKGXrk4k1bDaAyPGLLvuaB-_wHREfM2myA6hsO2IW0oVvh8cTM2vT6Nic7NMYqffpN_NxsjDt3VQMricYNsT1Bb0O4DmMpaWTdWvt_NrZdAKJSbRoz6KkbXBrDgZQfiryAOElKvAPrHrSjgCpiz43D9BfOnryvSEtvVX3p8y3P51Xi69A9kuo-uSHtH_Me7zKFdQkyTVdIUTcRO8YwaHrp_LJSJBsCGA8i5VIWZGbJyLrabFPdaw7nhydk1O5R8FPQqTztNno44gB0g8xzYqDc7t_lske5jP4mCyBP545MS2LX8p9K10RUkTnPmd2ZXy3SPa-x76k5jecDRPWM1E38FulJJGlnTCLsBrOi4WM2wkCgBOnwRQ8ipeUJ9sxaweupVjH72eRWaLyo1IsMh9ECmS_1RyB3aEDxIviRD5j8lTS-Mqf8xzS9L9up2ZaW1Yzzn12QoTV_mkteWLTGYAv98RTVTat7957Ri79hMjNzWa57_wn5ZpFZnbOjQe8AXNytymRUg6n8hm1R5oQ790qZVZNg-9ktpPOEEv7W_ywOCtvTACZQUbEX6jl81ZjyUnRTlkzPY9CGoEoVWKsDYdD7PsP5WZ2bNrUHqsGeAFub4TIyB1yiAnOcjGnODLB83dpXYtX7xye27D-4q-WlPu5cKfq3NUui77SOneJOgU4tgh8MfCf9JZ9NsgCLdJaa47VAd-rGmGKQ0HAFDI9scz4oG0GTHwwInDBA', `Keywords` = 'c3Bpc2FuaWU40LrQu9GD0LE0L7QvtC00LPQsNC90LXRgtCw0YbQsNC90LXQstCw0YHRgtC-0Y_QvdC-0LLQsAMjAwNDIxMjc10YLQtdGF0L3QuNGH0LXRgdC60LA0L_QvtC00LTRgNGK0LbQutCw0LfQsA0LzQtdGB0LXRhg0L3QvtC10LzQstGA0LgMjAyNdCz0LrRitC80YPQtdCx0YHQsNC50YIc3Bpc2FuaWU4', `Client` = 'c3Bpc2FuaWU40LrQu9GD0LE0L7QvtC00LPQsNC90LXRgtCw0YbQsNC90LXQstCw0YHRgtC-0Y_QvdC-0LLQsAMjAwNDIxMjc1', `Payment` = '0', `Currency` = 'BGN', `VAT` = '20.00', `Total` = 800
# [26-Feb-2026 09:05:39] /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 ('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
                `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` = 10477 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Feb-2026 09:05:45] /fin/fN9v3p6D6/bg/invoices/type_1/2630.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2630 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 ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoiceBank') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Feb-2026 09:08:36] /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
# [26-Feb-2026 09:57:57] /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
# [26-Feb-2026 09:57:57] /fin/bg/ajax/users/form/login.html?_=1772092685671 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
# [26-Feb-2026 09:58:04] /fin/fN9v3p6D6/bg/ajax/users/login.html?_=1772092692640 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
# [26-Feb-2026 09:58:04] /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 ('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
                `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` = 10477 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2576 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 ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoiceBank') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Feb-2026 09:58:50] /fin/fN9v3p6D6/bg/invoices/type_1/2630.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2630 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 ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoiceBank') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Feb-2026 10:42:10] /fin/fN9v3p6D6/bg/invoices/type_1/2576.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2576 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 ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoiceBank') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Feb-2026 10:44:43] /fin/fN9v3p6D6/bg/ajax/invoices/form/clone/type_1/2576.html?_=1772095491352 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` = 2576 AND
                `Type` = 1
            LIMIT 1

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

SELECT
                `Code`,
                COALESCE(`labels`.`Value`, `NativeName`) AS `Name`
            FROM
                `invoice_countries`
                LEFT JOIN  `labels` ON
                    `invoice_countries`.`Name` = `labels`.`Label`
            WHERE
                `labels`.`Language` = 'bg'
            ORDER BY
                `Name` ASC
# [26-Feb-2026 10:46:27] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1772095595990 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` = '2631', `PostDate` = '2026-02-26', `LastUpdate` = '2026-02-26 10:46:27', `ParentID` = '', `Type` = '1', `Data` = 'fjmphlFS3KnfWFo19OXpRshf3sF79LxafkxcVH3kVyW4DdYg8b3Vh7LouH35vzrkSYTXdUYuzaM2RFaWdRWhNFPYJItpFgTvScgXtaXisz4iKRDyjQBSjfnXOPe2J1HAHRC-ESZE95d8dvSgXpFpMoSyZzYQ55OSBEqw1VcVgV10NHpy4GFU93laH9_10v952WyWFZJvCZOod36oYwMqdI0eHkI-fureAZRIOwchpIMagjK5-A9GuH6VwRmwONo8UR37jq5Ycru3lNi54wdr6T-sGnpYSMnMEOVTMupOqPJuAFW7ZRLm02hchL-vx_oTQH3AQY378uXL73XzJMy2kkt0kCAd3O7VE5ta_XH8rCHJF1vKuX_2U359XYBOh1tshYZRVFynX5ap-XtF2CnPYjwI8pbhD7V5eQnJasI0hfgPmNgX_I6S3NWPt02rzBtyGaR-zPB8X7k9ewF0HrCctkeF8D_9I1ynLZtwQWsbvlz-7UckWqC4RsnqIJQ4kohcjbEQX2j6h8noKp4DyFl1Ziwm1yatoSWI3TZMuuWfjM3krPSLoU7pgWv78yZ2q6OgbNsVArXKMG5THMqjMBLQcCerycxSBZDUIC7nqqqcXOLoIq16YxDN4uq-WSxtgZNlNrMWmyondsoxbu3yLEn2iLvOtcKyrQNGpQ0th7Kpb-2ZlXIi32CrsAtBOzIiQL39ieN2rpXhvQYFzda43kEoYSnhr4vVF6JOjlnN1rnL2kI9IubfWwRP6kYXZpdrhP1U_VRp7y7tbGPHE9LUKuAJ-gj-WQQWXVhiEToD3RDcifLeWB95DllbBxqwPO00r0HLWD7ELUmhaZypB9oF0GcH_bEUpIgw9kKfxdxfBt4aOwRmmhRmaVnCPRHDYe3Jsb8WXm8lsNtieH3NW2suaOt710YbyMuYWB_A_0GURpif--3g25Wk0lZCsNtKi96DF-HSDb8KFSDfHCLG9vCCK-zBLclOA4geWArZ-3-SIRN4RRwUDK5QgEcLkssWxLLgAY9NqUOYSYwoc9KJ1fClGn-o0DuKbB19rTCVC3Le-5jZiJmXZcgvzKckOFMzKB9OxznAx1Xg_QYZy-ypTBRuB47DI_FJin6Nc6qgClHcUHsI0NLqse-RL6oxNthrYs1XDeZtNM-Q2qGttczK6TcczbqyBjRKQfwEpDAATwIsuAc-yBzwGhnuhzR8FMWUNHcukgDwbc3EkBrCyFuigJWVit2dAfcNg-PuLYdXLsLCIc2IDBR2rJi5cvdtjxaZybMOVUGMV0xiO1jcCBKSDyF36kyC3D9HGAyWGEFc1csN6o9KaXOgteebzXE6kG3RizaG6Eaj06g5XeLbRXN_hmabtIhwla5_bZdsZ6BWO_XdxWtVesyr0mqtDDq6fQ0o18OrFQBxzaMNy-cPerV_m7Laex-E-34jpUTFzchs5u_0Bm3EW7jUVtZqhol_yK80rd4tL-oUGVSza3_PB5Alu09qoNIcNC5Hw5nKoSQ9uiczH73jwU3OjXqtdUnQOw2QJXAFbmEtYM9LeU9QCV-eXPz5TDc3xsH5Lw9iS_e5FMmHE_BvsRa_fCT5KsweyU7jGLtI67WrKcDadfO7FDvlTnbpAxB6vQSi5xg8juC241BqK--LZWvaDsiEBttU3rkOJuDtyKcC2GlqK0UPenRBYKKjv5rDHQbEDH6bY3Cypx1InGYY_E5zUzNvz3v9kxY15JL6-vJW30xQffu5-14xHXkNPWxvsFVmKPPsJyjFZtdYc6coWlk', `Keywords` = 'bmdvYmc0YTQvtC90LTQsNGG0LjRjw0L_RgNC-0LPRgNCw0LzQtdC90LDQvdCw0LvQuNGC0LjRh9C10L00YbQtdC90YLRitGA0LfQsA0LXQstGA0L7Qv9C10LnRgdC60L40L_RgNCw0LLQvg0LPQtdC-0YDQs9C40LPQtdC90YfQtdCyMTMwMzMwNDYw0YLQtdGF0L3QuNGH0LXRgdC60LA0L_QvtC00LTRgNGK0LbQutCw0LfQsA0L3QvtC10LzQstGA0Lg0LTQtdC60LXQvNCy0YDQuAMjAyNQ0Y_QvdGD0LDRgNC40YTQtdCy0YDRg9Cw0YDQuAMjAyNg0L3QsA0LjQvdGC0LXRgNC90LXRgg0YHQsNC50YIaHR0cHMbmdvYmcaW5mbw0L_Qvg0L_RgNC-0LXQutGCbmdvYmcaW5mbw0YHQstGK0YDQt9Cy0LDQvNC10L3Qv9C-0LDQutGC0LjQstC90LjQs9GA0LDQttC00LDQvdC40YHQvtGG0LjQsNC70L3QuA0L_RgNC10LTQv9GA0LjQtdC80LDRh9C40LjRgdC-0YbQuNCw0LvQvdC-0L7RgtCz0L7QstC-0YDQtdC90LHQuNC30L3QtdGB0YTQuNC90LDQvdGB0LjRgNCw0L00L7Rgg0YTQsNCx', `Client` = 'bmdvYmc0YTQvtC90LTQsNGG0LjRjw0L_RgNC-0LPRgNCw0LzQtdC90LDQvdCw0LvQuNGC0LjRh9C10L00YbQtdC90YLRitGA0LfQsA0LXQstGA0L7Qv9C10LnRgdC60L40L_RgNCw0LLQvg0LPQtdC-0YDQs9C40LPQtdC90YfQtdCyMTMwMzMwNDYw', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20.00', `Total` = 920
# [26-Feb-2026 10:46:27] /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
                `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
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10451 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Feb-2026 10:46:38] /fin/fN9v3p6D6/bg/ajax/invoices/form/clone/type_1/2577.html?_=1772095606272 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` = 2577 AND
                `Type` = 1
            LIMIT 1

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

SELECT
                `Code`,
                COALESCE(`labels`.`Value`, `NativeName`) AS `Name`
            FROM
                `invoice_countries`
                LEFT JOIN  `labels` ON
                    `invoice_countries`.`Name` = `labels`.`Label`
            WHERE
                `labels`.`Language` = 'bg'
            ORDER BY
                `Name` ASC
# [26-Feb-2026 10:47:48] /fin/fN9v3p6D6/bg/ajax/invoices/insert.html?_=1772095676404 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` = '2632', `PostDate` = '2026-02-26', `LastUpdate` = '2026-02-26 10:47:48', `ParentID` = '', `Type` = '1', `Data` = 'GPRRHZqGUQ9C_MvMlD1AR5uBxYloXiKIozGomG0Po31pATMYfgAGLRIXWXZTRa6dd9xrbeoXre76dsvtWZONuETejGJjKMFo8BD29xHeXb1Kh9tJi10YAoy3AadAQLKxuXEf_i5bpKBvlMPkFFa1WnHVUKOxuxb9oXjYQWI9XRloMj2Gdwo16dzmKPZERocCWS2HOzhkaxbcaDGEVEkZ_hKiJ4k-kVEGDPwztO0J480XmLEXHyq_xhI7DjD3V6HYncojubqPYQ4TqVeSu69PFiXxYubJliGTgnwwMrTppA9u7QDOqE1ALBNFOEE-sg0JmFwlYFr2iwXpStyD4SmNZZ_ZWrIEXRhgX8BxYSxFuoHZ5hflsDANsstXrV_b_ArCDd1BjSTd6cegD6mFxhV1P6mfOzayk3hqb41ElD-TC1A8qW-AV30EC7jGHFSMTF4c5flUZdtsy9dh4VnjWKpkHhAr4Nx-HR0Po_eleMag-3fU5eiiosfnUUPMsWsBZeSPjMLn0gyT71cclvR5zyZvxq17SkphsCW2Wxlcgp1k9vaePEtYdqpmNIxOv7A03p3r1wfiNE_3y2iXIyRwGDclI3ujFcxjbZtf8QKvDwm4WUOByuN_0FstWo05pk6J29Dr1Rf3CjcBEsH6GCeopaCZLS20mClT6HHcOLSkJzF1YMIa_jLYXyr8mlPMz6iL-HMzjZApuaCxaPVz4nd6y6MH1HCaxeben05CJjr6g5QZ-0ZOGKVkbwtx9R0Vo9In0Thu97vUjjlkeeAqcaXu3Xr1HkjyhgAgGtOBU2wxwrCF9SFz2tz7VBnnezmOGaWMFFxE3PLZ7IRRH-dtAYZzYhX4TVyD4DoJAYzNEtpo-M2REpZ_gcWjU0y84A42oFipQy8h00u_odYO-wmzdZgN5iP7_WRudydrIjkAHz6Ap3KvfCaZW-EAbJBYV0CU4XB8HD7xzysZU2IsUDFOV5oz3yUdn8rwOcpiwOhKSj4CSXql9NMObcXGQUHRGlebaOAcvX9-KF4LEu5Yu8iGOxtTCu3rDElgaz62zg4nAYG8Do8k_TEeqJn8-KJ9dGx0e-QeIfb1T1IBvTlXNHA2KVacnC23NvG2YvzYoXN1XTtUM5QEJGIXDuhzXTHli5fBAeRiC6g5OYSC_AcwbBJDFwhoqwMEq8LXSC60mu3dUO456FNlVI86BzpdrMJOmsH55JvziS377OsiiW1KtqKDTGCe-rO-x1RttaJYuKm5QDswBpH1oy0xzBQnOB6Ng3KFGLF1Wso76W4nM_6bHf5Z-zYUwN1rt6C7K2UHgatXNoQ7oXrJaq396eR452feM1XbMmU2VRtf-f8vvYllI6XlFyyGHfOkzEuhWkNVEzxfdXqcf93LtuVtSiL0K5DDPoQqhZWNAIzOYdkxC24xs_193b5LXC6vLDVVRmRh0itYbqzlMvtiogECeq9zfL7Wf23MT0wACcX1jY47P2VlO23LgpbxWc2MT0lJrP2RUMN436HyQFosbAr15H97guig2cAnuHU5bekqJ9PIG_e14VH2mzmQiNNPpx_dXno_su1M2X5Zxdf6KKEhC11hKh09vxEAX9Z1zxOmO1JOlKbKsV2_4RpLkSVLg7JXq1w9iCp8KHzTlc2pCg8_TVURb_mDwAQZnYzIJI8TP5xKmku9G9w2M_8NozAW7DuhLbPV-abI57UkoCiQs7byZ6b5mssfhkrTiU2Pc4feKdgtl-tjUcLW8vr_DzLxuy_CUYnQGB2Sdbm381wXZHY', `Keywords` = 'bmdvYmc0YTQvtC90LTQsNGG0LjRjw0L_RgNC-0LPRgNCw0LzQtdC90LDQvdCw0LvQuNGC0LjRh9C10L00YbQtdC90YLRitGA0LfQsA0LXQstGA0L7Qv9C10LnRgdC60L40L_RgNCw0LLQvg0LPQtdC-0YDQs9C40LPQtdC90YfQtdCyMTMwMzMwNDYw0LTQuNCz0LjRgtCw0LvQtdC90LzQsNGA0LrQtdGC0LjQvdCz0LfQsA0L3QvtC10LzQstGA0Lg0LTQtdC60LXQvNCy0YDQuAMjAyNQ0Y_QvdGD0LDRgNC40YTQtdCy0YDRg9Cw0YDQuAMjAyNg0L3QsA0LjQvdGC0LXRgNC90LXRgg0YHQsNC50YIaHR0cHMbmdvYmcaW5mbw0L_Qvg0L_RgNC-0LXQutGCbmdvYmcaW5mbw0YHQstGK0YDQt9Cy0LDQvNC10L3Qv9C-0LDQutGC0LjQstC90LjQs9GA0LDQttC00LDQvdC40YHQvtGG0LjQsNC70L3QuA0L_RgNC10LTQv9GA0LjQtdC80LDRh9C40LjRgdC-0YbQuNCw0LvQvdC-0L7RgtCz0L7QstC-0YDQtdC90LHQuNC30L3QtdGB0YTQuNC90LDQvdGB0LjRgNCw0L00L7Rgg0YTQsNCx', `Client` = 'bmdvYmc0YTQvtC90LTQsNGG0LjRjw0L_RgNC-0LPRgNCw0LzQtdC90LDQvdCw0LvQuNGC0LjRh9C10L00YbQtdC90YLRitGA0LfQsA0LXQstGA0L7Qv9C10LnRgdC60L40L_RgNCw0LLQvg0LPQtdC-0YDQs9C40LPQtdC90YfQtdCyMTMwMzMwNDYw', `Payment` = '0', `Currency` = 'EUR', `VAT` = '20.00', `Total` = 592
# [26-Feb-2026 10:47:48] /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
                `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
# [26-Feb-2026 10:47:57] /fin/fN9v3p6D6/bg/invoices/type_1/2631.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2631 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 ('Feb') 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
# [26-Feb-2026 10:48:23] /fin/fN9v3p6D6/bg/invoices/type_1/2632.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2632 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 ('Feb') 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
# [26-Feb-2026 10:49:41] /fin/fN9v3p6D6/bg/invoices/type_1/2631.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2631 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 ('Feb') 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
# [26-Feb-2026 10:49:46] /fin/fN9v3p6D6/bg/invoices/type_1/2632.html 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2632 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 ('Feb') 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
# [26-Feb-2026 12:13:18] /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
# [26-Feb-2026 12:13:18] /fin/bg/ajax/users/form/login.html?_=1772100807734 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
# [26-Feb-2026 12:13:26] /fin/fN9v3p6D6/bg/ajax/users/login.html?_=1772100815197 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
# [26-Feb-2026 12:13:26] /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
