# [08-Nov-2025 08:31:04] /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
# [08-Nov-2025 08:31:06] /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
# [08-Nov-2025 08:31:13] /finance/root/bg/ajax/invoices/form/clone/10454.html?pid=10454&_=1762583471355 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10454
            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
# [08-Nov-2025 08:31:21] /finance/root/bg/ajax/invoices/insert.html?_=1762583479529 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 5 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` = '2589', `Language` = 'bg', `PostDate` = '2025-11-08', `LastUpdate` = '2025-11-08 08:31:21', `Type` = '1', `ParentID` = 10454, `Data` = 'a8jNbWPloNSlLab16U_FxK7DFO2R5C4PdSf8CoJpT92EX3kxLwSEhLKdwRGJ3Q8VMWvSiC1KX1zFCy9XyuqM5grsjbc9DgKcWjtf84voejGwwjY97QHdqrsojQhzlqckUn8VO3ZwsVN-vBZnAi9PCfDjvx0sCpEhZw4oWxJQgD--HpBEYK4f8DCLwFXeTORQYzFABwCmcYL20AV5I_RXBFotieL0omI60Mo6z2Wi_tZ9h7srpG87xXU4pN4PJx86HVWzyg3-uw22szjTvZr2jle_aCVClgdQscekIeGKLP3RmLHKFQgF34c5j3_IOn4XWXiufTjOw3KReH0Z_tpADJGESJNVc1NHZIf8EuF4yfRbjeOj1O-6o56LQZ35OG6UHnhzT4eBqyUMwkLagEYxZDC4H3NC95TQ4gB2z4TIx5okbNSPss-5VTDjM3GE5pQKK2CFITSP_zP2iH0w1IZODoqJUBYCG75QQZKdG-sMDAdai6JlyxOZHhCrv843pDW7cFwuk3CL8iJcWyMg9FxCIta0Fxwp3qGJ9t5bfrUmjaeZFD6TwwfjBJbdHXPrajLnZtmoJSHJCUgmaakvU2_sgNC7osUpFHQaT5Ol-iNSmretTkLOqr00PRHmFuRaF8ODmkt1gW_PXm6SOwPjOS1hnrT8Cpae4Gxk_1KUAknE1xjCjDk7fyxM3IlTtbFwqVs6KczSxTcTsNlBwA3xdy4VeDO5-iwUjoSvGXx4PoY3gf8pD9Z1awuWmENDE24epiWCUbyRwx6e8NQjdvFunaHwlUGB3uK8jDB22R3MigiwqegzQ34LC_aCGxSVn_Q86gc-q27sQqoNt7nmuUqVH6upViixDiILPJlV_NHjQ5-1CJhQ5rBonrIuYWFyG2jCkI27-iDtVQujfK7Nf3qCbPjjNyFdJ5cHypY4KwP76fSdBcEI3XaNl70fuybW6OHIXfjC2srmWM9C6Nt8VnTsgH0Nf_uTPTZZR-XBdNgMePd__Ext4dejc51ASCXGm2qYvd5C0lCX3C89r0_k258RpfSDoaACwxobzUpUtRz-APX7swGZJ5CI7VBJ98FaCiZGO70f', `SearchKey` = 'wofCpMOiwrDgsKlwrPCuMKDwqTCwofCpMKnwrDg8OgwqCwrrCi8Kyw57CsMKewrLDqcK0wqDgcwofCpMOPw4DCtMK6wqCocKDwqTCvMKsw4zCucKdw6bChMKhw4zCvMOWwr7CjMKUwp3DgMKlwqPCvcOYwpfCwofCpMKjwrDgMwofCpMOqwrDg8OgwqCpMKDwrHCvMKrw5rDwofCpMOWwrDgMwofCpMOEwrDg8OgwrPCtsKDwrHCuMKrw5jCucK'
# [08-Nov-2025 08:31:21] /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
# [08-Nov-2025 08:31: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
# [08-Nov-2025 08:32:08] /finance/root/bg/invoices.html?from=01.10.2025&to=31.10.2025&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-10-01 00:00:00' AND '2025-10-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
