# [03-Oct-2023 08:41:07] /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-Oct-2023 08:41:52] /finance/root/bg/invoices.html?from=01.10.2023&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` >= '2023-10-01 00:00:00'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Oct-2023 08:41:55] /finance/root/bg/invoices.html?from=01.10.2023&to=&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` >= '2023-10-01 00:00:00'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Oct-2023 08:42:30] /finance/root/bg/receipts.html 167.99.142.201

set names utf8

SELECT * FROM `receipts` WHERE 1 ORDER BY `ID` ASC
# [03-Oct-2023 08:42:34] /finance/root/bg/receipts/3.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `receipts`
            WHERE
                `ID` = 3
            LIMIT 1
# [03-Oct-2023 08:43:06] /finance/root/bg/flow.html 167.99.142.201

set names utf8

SELECT * FROM `flow` ORDER BY `PostDate` ASC
# [03-Oct-2023 08:43:08] /finance/root/bg/ajax/flow/form.html?_=1696311787452 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
        
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20
# [03-Oct-2023 08:43:44] /finance/root/bg/ajax/flow/insert.html?_=1696311823782 167.99.142.201

set names utf8

SELECT * FROM `flow` LIMIT 1

SHOW COLUMNS FROM `flow`

INSERT INTO `flow` SET `PostDate` = '2023-10-03 08:43:44', `LastUpdate` = '2023-10-03 08:43:44', `ClientID` = 2, `ParentID` = 0, `InvoiceID` = 0, `Tag` = 'office', `Sum` = '123', `Direction` = '-1', `Data` = 'h0xw1ADFfk-3Y2-Mltnf8n32GgHtq8cub_uCxFROAmHS7GdUH6wXk4b_lgq_wahbLTg9rfW75hsUQRbBxd5YBXDvkZBKACBsuuclRHt7kVm6gcpQNfBxSQZ8hFHq2wfvWrB6ItfT5ssw7jjQQ8lPoCp3EoMAqrhdfEauH1C6Ac8', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwrnCisOKw5vCrsODwrrD', `Vat` = '23'
# [03-Oct-2023 08:43:44] /finance/root/bg/flow.html 167.99.142.201

set names utf8

SELECT * FROM `flow` ORDER BY `PostDate` ASC
# [03-Oct-2023 08:43:48] /finance/root/bg/ajax/flow/form/5.html?_=1696311827868 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `flow`
            WHERE
                `ID` = 5
            LIMIT 1

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