# [05-Mar-2026 10:16:58] /fin/fN9v3p6D6/ 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('MGURL','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Mar-2026 10:16:59] /fin/bg/ajax/users/form/login.html?_=1772698627419 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
# [05-Mar-2026 10:17:05] /fin/fN9v3p6D6/bg/ajax/users/login.html?_=1772698634127 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
# [05-Mar-2026 10:17:05] /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
                `Parent`.`Type`, 
                `invoices`.`ParentID`
            FROM
                `invoices`
                INNER JOIN `invoices` AS `Parent` ON 
                    `invoices`.`ParentID` = `Parent`.`ID` AND 
                    `Parent`.`Type` = 1
            WHERE
                `invoices`.`ID` = 10488 AND
                `invoices`.`ParentID` > 0
            LIMIT 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT 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
# [05-Mar-2026 10:17:09] /fin/fN9v3p6D6/bg/invoices/list.html?type=1&from=01.02.2026&to=28.02.2026&keyword= 108.61.209.243

set names utf8

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

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

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

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

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

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

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

SELECT 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`.`PostDate` >= '2026-02-01' AND `invoices`.`PostDate` <= '2026-02-28' 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
# [05-Mar-2026 10:17:37] /fin/fN9v3p6D6/bg/invoices/type_1/2626.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` = 2626 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
# [05-Mar-2026 10:17:42] /fin/fN9v3p6D6/bg/invoices/type_1/2627.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` = 2627 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
# [05-Mar-2026 10:17:45] /fin/fN9v3p6D6/bg/invoices/type_1/2628.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` = 2628 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
# [05-Mar-2026 10:17:49] /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
# [05-Mar-2026 10:17:56] /fin/fN9v3p6D6/bg/invoices/type_1/2633.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` = 2633 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
# [05-Mar-2026 16:09:39] /fin/fN9v3p6D6/ 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT 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
# [05-Mar-2026 16:09:43] /fin/fN9v3p6D6/bg/invoices/list.html?type=1&from=01.01.2026&to=30.01.2026&keyword= 108.61.209.243

set names utf8

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

SELECT
                    `invoices`.*,
                    `Parent`.`Type` AS `ParentType`
                FROM
                    `invoices`
                    LEFT JOIN `invoices` AS `Parent` ON 
                        `invoices`.`ParentID` = `Parent`.`ID`
                WHERE
                    1
             AND `invoices`.`PostDate` >= '2026-01-01' AND `invoices`.`PostDate` <= '2026-01-30' 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` = 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('CurrencyEUR') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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`.`PostDate` >= '2026-01-01' AND `invoices`.`PostDate` <= '2026-01-30' 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
