# [02-Feb-2024 08:12: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
# [02-Feb-2024 08:12: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
# [02-Feb-2024 08:12:27] /finance/root/bg/invoices/10391.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` = 10391
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Feb-2024 08:12:46] /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
# [02-Feb-2024 08:13:21] /finance/root/bg/ajax/invoices/form.html?_=1706854403330 167.99.142.201

set names utf8

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
# [02-Feb-2024 08:13:24] /finance/root/bg/invoices.html?from=01.02.2024&to=02.02.2024&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-02-01 00:00:00' AND '2024-02-02 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [02-Feb-2024 08:13:46] /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
# [02-Feb-2024 08:14:02] /finance/root/bg/proforma.html?from=01.02.2024&to=02.02.2024&keyword=&sum=1 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
             AND `Inv`.`PostDate` BETWEEN '2024-02-01 00:00:00' AND '2024-02-02 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [02-Feb-2024 08:14: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
# [02-Feb-2024 08:15:54] /finance/root/bg/invoices.html?from=01.01.2023&to=31.12.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2023-01-01 00:00:00' AND '2023-12-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [02-Feb-2024 08:16:46] /finance/root/bg/flow.html 167.99.142.201

set names utf8

SELECT * FROM `flow` ORDER BY `PostDate` ASC
# [02-Feb-2024 08:16:52] /finance/root/bg/ajax/flow/form.html?_=1706854614673 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
        
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20
# [02-Feb-2024 08:17:20] /finance/root/bg/contacts.html 167.99.142.201

set names utf8

SELECT * FROM `contacts` ORDER BY `PostDate` ASC
# [02-Feb-2024 08:17:23] /finance/root/bg/ajax/contacts/form/1.html?_=1706854646018 167.99.142.201

set names utf8

SELECT
                `contacts`.`ClientID`,
                `contacts`.`Data` AS `Contact`,
                `clients`.`Data` AS `Client`
            FROM
                `contacts`
                INNER JOIN `clients` ON
                    `contacts`.`ClientID` = `clients`.`ID` AND
                    `clients`.`Type` = 0
            WHERE
                `contacts`.`ID` = 1
            LIMIT 1

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20
# [02-Feb-2024 08:17:35] /finance/root/bg/receipts.html 167.99.142.201

set names utf8

SELECT * FROM `receipts` WHERE 1 ORDER BY `ID` ASC
# [02-Feb-2024 09:29:09] /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
# [02-Feb-2024 09:29: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
# [02-Feb-2024 09:29:17] /finance/root/bg/ajax/invoices/form/clone/10391.html?pid=10391&_=1706858957205 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10391
            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
# [02-Feb-2024 09:29:23] /finance/root/bg/ajax/invoices/insert.html?_=1706858962799 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 2 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` = '2182', `Language` = 'bg', `PostDate` = '2024-02-02 09:29:23', `LastUpdate` = '2024-02-02 09:29:23', `Type` = '1', `ParentID` = 10391, `Data` = 'wV2btAUFHpg9XovNrCEdXXF6BMWAXl1KkqPyGUJPNB-7HqncxvWGziTFredgLBhl15mnk0uwIm0nfiFwECIsN4tfYtISli_OZdPSrhp3umZU743xXI2oIW2WsKoUzmz1V0q_3WkAQgZNjKN7W5dlq10bKMGBK7xU9uGzyj35hiIXoZAUkdymUREDeWqmzpv3uUDos5hVA_lWY70JSGJVY6luYW9Lzvamhssm_hQBMTsZkP2VE9PRTn32LfgIQysYZmmJ8Zu-d533fpgfvKkud4UEPEmwW0fuIfi3QwtASmpX4MNl0Zy1NPoWuDDKQgd51mxX0tEAslL9gzQmNQkGIOmSBRsJ7Pfk_lLvSaIyitdJWp95rdKIyJnK0WU-4VCPWbpQjUHfy5z6Dtwc-RFTJ9p1FGqRFY8aYt_QpeLaZ2A4UtDuP4x352SYifMlB7a7GJE9GJymSaZFAO2LA7EUYp8eJ7UpkkjSe9QMp1K8TrAaY2aGQNfLlMpNIHK_06ky4BznyUAr5nwYEoE18QCt3qEL4JhvSd0yro9dWLdKpkzXvLqMo61QXL32Vgrqw-3cfNCWtE0KW7MSOxDsGURdF3rs0ZqL5OGbFS4ohkY8SdThFRXegP8VIJjnGJBwahBNK62B19tKunXSOO-tsESUViIddNATiEKU6S-J9KK_JE620_H9KwvNqf7y3XTjlkVmRwF3Ai9e44ci17K5thGoBjNALoN7T39qWuyvlz3cFEhJIon3uq1K1epDsjZYbqQrAcpVFTO3NUakpzoPweA4UnHdJCAKud0sIE_I9CVhLnKhiF-xnyVQuAiWOM143E-kM6g0sbYRh2g6FGkBi0L_77KS3mDrSlR5OeCa9AKr-YU_J6XVXzF3reBh-JC9EMgEEYz5yls7Yqw_kBTw200ik-2mS_LYilsHVZ1tdVumWPDcf3GEszr7ydk5NnI_kqKiq04wK8sTjUFIp5SvZXh4Af1_Duig75OLAK9FsJdlDXWwOMlZKHWlRGFn8DzhJzcemNcV3QHXopsf6tA8SmE_ylxb0nWfrsFxiNAL3KgqPNYRx_Onjxjmkr0cloRA5Yos', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwr'
# [02-Feb-2024 09:29:23] /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
# [02-Feb-2024 09:29:30] /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
# [02-Feb-2024 09:29:32] /finance/root/bg/invoices/2182.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` = 2182
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Feb-2024 14:39:18] /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
