# [03-Dec-2025 10:21:28] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Dec-2025 10:21:31] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT
                    `Inv`.*,
                    `Original`.`ID` AS `OriginalID`
                FROM
                    `invoices` AS `Inv`
                    LEFT JOIN `invoices` AS `Original` ON `Inv`.`ID` = `Original`.`ParentID`
                WHERE
                    `Inv`.`Type` = 0
             ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Dec-2025 10:21:37] /finance/root/bg/invoices/10474.html 167.99.142.201

set names utf8

SELECT
                `Inv`.*,
                `Original`.`PostDate` AS `OriginalPostDate`
            FROM
                `invoices` AS `Inv`
                LEFT JOIN `invoices` AS `Original` ON `Inv`.`ParentID` = `Original`.`ID`
            WHERE
                `Inv`.`ID` = 10474
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Dec-2025 10:21:46] /finance/root/bg/ajax/invoices/form/10481.html?_=1764750106425 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10481
            LIMIT 1

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 1 AND 
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20
# [03-Dec-2025 10:22:18] /finance/root/bg/ajax/invoices/update/10481.html?_=1764750138854 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 81 AND
                `Visible` = 1
            LIMIT 1

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1 AND
                `Visible` = 1
            LIMIT 1

SELECT * FROM `invoices` WHERE 1  AND ID = '10481' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '10481bg', '7IyFLXIgLeSYXlzKfur6eTg35ufmsvFzJ3u98jQS4nFkBlxpvYzF1webw2C9YSvBtxmlkTxC9H2w-Wl8q3cJTlHLOh8RqVCwA4bEeVI6JDyKqYeN6HA1JhXduU_zxE7ye6E4TCWc4_k6IQXC-hajxCtNK38L7VfWZZQ969ETOiEEkX2AqfVxN0E8UgPsI-U51_fPA9MERxhsS-ZcDcX9_9ZcbqLcZ8nWY0LRzz_WJbhTKTnBW5x4-ZWLSEEv0jkBetcTSl2WPCsMwB7Cl5Vf6uHukGuul_jVFnt7TAuH35qs1-6lFxCE42-MG9x9Gcs3FHtz7u1jWamt0W_iseD_Gf41RBbLeoH8H8LEY1B86CugP77cekzvVjfZeLKacsV_aVQIQBsz1l6LCGYII9SqZk42Lf9vQ0fmvEOTdTh8b7Xcc1G_j2ZNjOcDcv2TqqcPGSAjEg1W1R0Gnqml0ktCZR94WDLRTO5sDt_JLeNGDDgJYX4vYPDehn6Ii91ma0ptg9qKdzH7zFwNozsuEE7dfqgF0N7QvzKg7t5RpAlli8ldPSaTSGrKufHDK77lq53TLvzy41Dn2SH0kMW6oBPfLtBzkgiJGAPddyxJC6BWM-H5_bKHdUVJTeeRf54iPlI62p-Od5njtvDef3vzdr3p8egy51qmd4vhdkXgHXfxlzV-J-0t60RjCRtSH93GJ7hOOU5BVq70yozKpx7nZdOBnt4-9GXTKIoeWVM7jLwyJ6ZxoeL-w8v3vuQ__rnGC7maYMqV7dYzakmhS86sUMLsCXn3qE5c7M9OCXXg4VWBMBEkTNKYJwpLOA3h6nsUM8nGmO3Ss96_HZrpeMfaUuUNAx9i3Ezm12_4U0lNyGYs64hJWhpuYSe8Ief8QQjI5x6IcIJ4ghoLCcMCHMuFfwBLs67CNmPiqkQi6pvFex0AuPB-TrEUBixB2EZtIFHASwCj2d7Kyg6e1iqkou9UqnCbNiQpucwaSYYTheHhauFWIqK6UfAEeljOIelM-m6AWvA9IgKheh-Kf5IHR5B5M4c61BX0ralm3dS5ulFcigVj8hD0UFdcuPwr-D9Ip7MHgH1Nh0cT8n63rKYwSqCo_yaZY7ABnghw8EtM8mGz5umLU-uJdfuHwxLs5LpbDfViW4hYca4wFGfWMa2vZE7_Gd27H1NwCO0rueI0AGtC9m80nFH21CfnnMXcCp4qqRKWTq-M3JUXGDt0bKxvNnxAyGx_jP9hShXCEnuKqk94OSoP-bETGi3aptIJo5hsSU43cnJ-4X6Td8CJEq3ozSN4X-QpEmYcKn6ogYx2Sovhzin6EVbmpoFAVbpNfegQk88wykhCfqhWhkl_grv-rVBs33shfPzipu8qejErb0iyXraPTqDwN1YZrDMzqThRPMcHO7kDApjdoRxQneEDYj538-3Z_O2Xwwxk3-dfE7Kpyn9KYndBFnYxmHkwu05wCPSHB4y4G9Cr77om7vp1lsFxcRvGWNKhN86s4eQEoB9Vk3LCDAfH8Q03Bb-vDz-evFSHGgHv0Uxvsq5WNK_sNRC_OoOlLSLKAaC-Wph181awM_nS6RXrcJri73x6B4-PqDUgL8phya1b3k3fB6GZiWoaKFVtyP9_3BtZUwE1jZ1GZ0_x-HmvpqO_a5yBXNuGn313uDFdk63d-rf0sJp7GrzNJlmtiqOJN7K2qrGkyN7h0Re5-vFoqjVbbygCpraLY1e0ZbEl6qD6KvN-92JIp0BKR4MKlJN8X7VIPpH7UJielZwQ98BphzYYDsVdxjwxrDXF4OUaquUPvl4qQSUzFgBAPaNZbntpPLOjBXLAW_DReOsqwtCZYsRxdSeEqpQcM0c0ZKr7xQJDyt_SmAAPZ5qydAqxHz1CNQZVERpp-DJMHUAo9XPUHTJ8fZ9CKPd1tKp9vFBPQ7Q2Cll2n_dwc-uHkXAMOQ')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '10481', `Language` = 'bg', `PostDate` = '2025-12-01', `LastUpdate` = '2025-12-03 10:22:18', `Type` = '0', `ParentID` = 0, `Data` = 'NpA3oqzJmR3Qh-TSg0FTksV_Zb78-4SOP-PhD2iEsHHCymlhXuxJiZI9wiZW92SB9sggpy41ZY193eegIkavM4-Z0eV2kqJcLCY2FZk_OZQAQXBcJy-K-fWlCnDYUFYRPoV5vAMmbD5a9U3CF7pFg2ElL7J57V8JhxyEQuQnJGerjhq8YAwfkRbmh0EIdDVkweprHSqkT0YdR5L62vdzLhS5O3CtH8tZ0RWSO6cOgVHpznDYwLMg0Zhz26EQjTspkRaGA3TB-a3dp0vKhPkVuodu__H3YjkFfQ0qaXYpPitbtZ-SDJ2dO7bQJUrXqBxTMLUdepVn_Sutllp5R3Ue-vWUaQ9z2ykBOXZSANGGjJJRYQ_r449NjDHvvJKSA5KoiGDqfkLetP66D2nrPtAD8LuCmri6azINeD0wGVTxyoX-2_zwzYiKA6ErhGEEUk_nnFuEt4Mk00xqAIISfnRAi5UcW8JKCle9Gvpc-xs7oZEt9UZ3zBdZwNnZiDbaxo9iLrQ-8yaljL_Q6ezNL4zZB_SQtrm6r43ytDSgpTWputsINujQTfNGRxaY7QIbKLV19cyjIOHPk_F43FupcxXzsQJAqC3JOikVO3C1YtHQu_kOrHLQoERpMrNkwfm5qXXUZtefb2RWLQetiOG0OpKfGL7JUs91xvSZxsl6_KKlHTNcVWS19KZ7NOmjJ4HkHu40Z8k6I9tXwAK7wXTqFXqwr3V7d9ula50SDJOeOzBfZ3fULdmwU36rggjbI20XUM-i0ZmREI2H4IIkZ2ONg_4ALCZrUe-SeOwvRySloe7R5WKij4jdlHDS36fJsMousNgrwDgpbCjh5QZsWmMilS4HFThY8lvO4g9FQXadqILEqGvA5iwk0h_uPe2bHUg53RmtXRTJppGX3zScKNh7NBgpZwmL-Ikj_4K3sB1XNrM-zXOzZqpfPVpWQngMmL6XI15hGysaKcNPevKnltN9e9jc9IxxGi4_u_NvzKiI_1Am_cVjDD_5rtFPYQSsPuX394E3tq1mZijt4jytxP9-B9J1MkxocY7gcST2NIDTfZp9t1RzVAtm8tnBVsKNB9GSiQkEzW9qTCpEvmiHlTRDW1kOzX6aKg82J_X2iIZedd_8OHwZLy0KTqxLy7hEOx9GTcnD-vzLc8C0sFc0kKlXBJoUrs0RLs9dEsyoPrgAUvNGD3s', `SearchKey` = 'wofCpMOPwrDgcOQwrPCt8KDwqTDnsKrw5vDwofCpMK0wrDg8OQwqDrsKDwqTDhMKrw5rCpMKdwpzChMKhwwofCpMK4wrDgMwofCpMOIwrDg8OgwqCocKDwqTCwrrCn8OGwp7CrsKewqXDnMK1w4XDkMOGw4fCssKTwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrD' WHERE `ID` = '10481'
# [03-Dec-2025 10:22:18] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT
                    `Inv`.*,
                    `Original`.`ID` AS `OriginalID`
                FROM
                    `invoices` AS `Inv`
                    LEFT JOIN `invoices` AS `Original` ON `Inv`.`ID` = `Original`.`ParentID`
                WHERE
                    `Inv`.`Type` = 0
             ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Dec-2025 10:22:26] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Dec-2025 10:22:33] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT
                    `Inv`.*,
                    `Original`.`ID` AS `OriginalID`
                FROM
                    `invoices` AS `Inv`
                    LEFT JOIN `invoices` AS `Original` ON `Inv`.`ID` = `Original`.`ParentID`
                WHERE
                    `Inv`.`Type` = 0
             ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Dec-2025 10:22:36] /finance/root/bg/ajax/invoices/form/clone/10482.html?pid=10482&_=1764750156998 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10482
            LIMIT 1

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 1 AND 
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20
# [03-Dec-2025 10:23:50] /finance/root/bg/ajax/invoices/insert.html?_=1764750230991 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 83 AND
                `Visible` = 1
            LIMIT 1

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1 AND
                `Visible` = 1
            LIMIT 1

SELECT MAX(`ID`) + 1 FROM `invoices` WHERE `Type` > 0 AND `ID` < 1000000000

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '2602', `Language` = 'bg', `PostDate` = '2025-12-01', `LastUpdate` = '2025-12-03 10:23:50', `Type` = '1', `ParentID` = 10482, `Data` = 'OAK_X4ABXw3PDqEanAGBybS9wpFGsUP-sku3eu_2qa8PBGQGM7rMSb5N1guLnNqGfBNibu0ZpAwmOz6PihL2vyzbRSCkSz2mCKCKXG3ycLL03803MyoCdlwxyKbKstK-D-j7Mlk46hbsClDtnhw-IkullvLqBResaD2y5abkai8ZSswidyfh0gtBeIsaJlDPgpGKadAanfqTWgZdaz8gu9qeuq66Doa7C9lKjj-YzwwfHNxzwUjlXgI6Ed7NP8YHtZ2-6QyXD4roAdvcHvjzKPZ2LCGnKWo6ZVR1ByVZ5Kx7cTWjEDhv4k_Ap7ImEFcViCg3-OosjwWKdkcwY8-TsQObYPYf9TT0J2amHZ_bY8U8zw5dfKzApT1Om00yU5TkZbINRD68GVAlRmzCJBCS1U8dz39daxKb-KMm9YLYWYf6ztEn36YEwGwYZf-Xdr8k9minMGsES6lsTGnCh14NpwzbGf-fSpLMoIfCA1LjoHa8EgPiP508hiLndlE9K9-bXHb-oq9vnPf4KbtLcI2fANDyFRm4cnHEtmw1qskqJw94LI-Zew79_QwcgpnKeB52yjX_zDJNj43qsxr2K1Dixxv2Pv6AboBjEqVEmjRwRTtzWVhzlif0-6tqiWz2OJ2VDURqpNwYOfi6_uq2jiNU5d26C80MuSHYSQBGOoxKTmMgAZ8SgFwdaCBmp6gHcCxzr6JWqwz3mCpZSvATTsz8F2NtTsZxjoHgAzUqa_rDeD1fACMC_KYZw1CnJgOgfbwmdjyo5LxXwFMsyb1OveV33cjND0CcPCTGibxi1I32QGKRrnQ1Laan4higUnX3qPQg5K2bgnHE03h-ciq4MkVoEczAyPowYkFiG7sVrvHZcCkzY8qUMfWq0i5hlbzRcq6NWZoVXubFIL2LIalFtklBgMUdaUuwiFsSDSJyjGKt5DX9pv1rFbHTstUN0LYpI62VRVAZggSX48W6BCfJRa-Mqg', `SearchKey` = 'wofCscK4wrDgsOgwqDq8KDwqTDmsKrw5jCpMKdwqDChMKhw4DCvMOXwr7CjMwofCpMOIwrDg8OgwqCocKDwqTCwrrCisOkwqPCp8KewrLDqMKtwrDCwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8KhwwofCpMOWwrDgMwrHCisKpw6TCp8Kew6TDwrDCr8OCwwofC'
# [03-Dec-2025 10:23:50] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT
                    `Inv`.*,
                    `Original`.`ID` AS `OriginalID`
                FROM
                    `invoices` AS `Inv`
                    LEFT JOIN `invoices` AS `Original` ON `Inv`.`ID` = `Original`.`ParentID`
                WHERE
                    `Inv`.`Type` = 0
             ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Dec-2025 10:24:03] /finance/root/bg/ajax/invoices/form/clone/10481.html?pid=10481&_=1764750243794 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10481
            LIMIT 1

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 1 AND 
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20
# [03-Dec-2025 10:24:11] /finance/root/bg/ajax/invoices/insert.html?_=1764750251389 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 81 AND
                `Visible` = 1
            LIMIT 1

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1 AND
                `Visible` = 1
            LIMIT 1

SELECT MAX(`ID`) + 1 FROM `invoices` WHERE `Type` > 0 AND `ID` < 1000000000

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '2603', `Language` = 'bg', `PostDate` = '2025-12-03', `LastUpdate` = '2025-12-03 10:24:11', `Type` = '1', `ParentID` = 10481, `Data` = 'ARY76tMVUcGAhTgbOPAsEF4Ls9s1y18LR77CRbVsm1XHtNoma40WVSjwvRPFjD52mKPlRsv0aroP8PolF_3hj2iweD3Lp-U2KZ6UULNIHYfL5cI2XUTXu1C7rgso8Y947DBU0yRTLi4fQ0224lP2Fake5BMNToEXI23gzssi_O3BIWb39kgd26YBuk1fzrqbRofFma7YDlRrb6Xkbj0t9zVyJi684CoZAE7im8GXucltXPyRD-Yx9-lOOQicfPyv7cVzfs_V-uhuhPG5Bsi-3KBWixaqIujq3s-CYBDQycNNCJQEVh7dJ3ScDULjsx3xVol46jX1hHjdpAeP6AxLcJ21Uibf8IENf7Lma3W1GYC4z11R8fb2qCv452u9YVFSnuv-9qUT-4zGmPPSqRGUhr5kTrBDwwwXvfiAquUlN2lczSi8P23iYiDRDMex37pOKirSiQLesyH2VVKjxVvrRmOC7ag2BG37lbC_CRT_Ct2Ell86XM7zuaZm2TodmK0c9_VTqR60H6vIwWYqXkvmKsLeNGSCkN4z29kGUnR6nvM9SJaeZgnGRMb1WtOjRZuUPIx2OZ6B2b3A6E28tTixN8Rq3nZ3lq6MkZSZbDmChA2JWhxoTHCs6_CEp2LLk0aJ8SGyNUvC8TareGrYYkkDHTgSTGYGIu0UGxB1PwLmBfpCg2sPIJESurn-F01daBXbdrgu32toXtiMHiA5jVGX1niJrvnqH8CNIeCWDm4PLwmok3utsFQeu9qzJZbEbBA3TUROcQSR1M1XkRdZrjPv3uL4GVFTeVy2UeFGwG1k4-371KQ0fMfycjji0I9BKogTR6vXb_N0YxViyFO2naUcR1ZqNfnWPTr3jV9TWCdbQw-U5UeLa0RYy8JilDeeCdhsxYg8PPgeJoMq923at6Lu1SIcjUyS90CsVYSipydRz-zoUU3jlLMht_1KWEZUntA0VNsyn7nFrIjvl5KPimjxyzgHT73EkXrP8iVZyhBIKku-pkn21r7RXeHiQLBDQSn1Yu4PmGDmH2WZMdD0IRd8izec-2hzUkAgXm7TeIw3ewwNrgwCDcnwEle4_XqZbyC_Lh7OatpBpMWKppjMEtCF5Zyp2dMY7tOdc6rmTiCogUDpy353wbaZNEHxKCUWebqZxNH4lSPlrFqz5ng-NHrlq2GZlNDv05Bl8QLYn0wk7pI', `SearchKey` = 'wofCpMOPwrDgcOQwrPCt8KDwqTDnsKrw5vDwofCpMK0wrDg8OQwqDrsKDwqTDhMKrw5rCpMKdwpzChMKhwwofCpMK4wrDgMwofCpMOIwrDg8OgwqCocKDwqTCwrrCn8OGwp7CrsKewqXDnMK1w4XDkMOGw4fCssKTwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrD'
# [03-Dec-2025 10:24:11] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT
                    `Inv`.*,
                    `Original`.`ID` AS `OriginalID`
                FROM
                    `invoices` AS `Inv`
                    LEFT JOIN `invoices` AS `Original` ON `Inv`.`ID` = `Original`.`ParentID`
                WHERE
                    `Inv`.`Type` = 0
             ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Dec-2025 10:24:12] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Dec-2025 10:24:16] /finance/root/bg/invoices/2602.html 167.99.142.201

set names utf8

SELECT
                `Inv`.*,
                `Original`.`PostDate` AS `OriginalPostDate`
            FROM
                `invoices` AS `Inv`
                LEFT JOIN `invoices` AS `Original` ON `Inv`.`ParentID` = `Original`.`ID`
            WHERE
                `Inv`.`ID` = 2602
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Dec-2025 10:24:31] /finance/root/bg/invoices/2603.html 167.99.142.201

set names utf8

SELECT
                `Inv`.*,
                `Original`.`PostDate` AS `OriginalPostDate`
            FROM
                `invoices` AS `Inv`
                LEFT JOIN `invoices` AS `Original` ON `Inv`.`ParentID` = `Original`.`ID`
            WHERE
                `Inv`.`ID` = 2603
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Dec-2025 10:33:19] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Dec-2025 10:33:36] /finance/root/bg/invoices/2586.html 167.99.142.201

set names utf8

SELECT
                `Inv`.*,
                `Original`.`PostDate` AS `OriginalPostDate`
            FROM
                `invoices` AS `Inv`
                LEFT JOIN `invoices` AS `Original` ON `Inv`.`ParentID` = `Original`.`ID`
            WHERE
                `Inv`.`ID` = 2586
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Dec-2025 10:34:32] /finance/root/bg/invoices.html?from=01.11.2025&to=30.11.2025&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-11-01 00:00:00' AND '2025-11-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Dec-2025 10:34:44] /finance/root/bg/invoices/2592.html 167.99.142.201

set names utf8

SELECT
                `Inv`.*,
                `Original`.`PostDate` AS `OriginalPostDate`
            FROM
                `invoices` AS `Inv`
                LEFT JOIN `invoices` AS `Original` ON `Inv`.`ParentID` = `Original`.`ID`
            WHERE
                `Inv`.`ID` = 2592
            LIMIT 1

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