# [30-Aug-2023 12:43:59] /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
# [30-Aug-2023 12:44: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
# [30-Aug-2023 12:44:15] /finance/root/bg/ajax/invoices/form/clone/10372.html?pid=10372&_=1693388653736 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10372
            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
# [30-Aug-2023 12:44:22] /finance/root/bg/ajax/invoices/insert.html?_=1693388661226 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 42 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` = '2075', `Language` = 'bg', `PostDate` = '2023-08-30 12:44:22', `LastUpdate` = '2023-08-30 12:44:22', `Type` = '1', `ParentID` = 10372, `Data` = 'eWWEh2lzx_ewKNMhDIlmYSFAjrp75WFWq1LqYN5EqIVmpBykqm9v0D1PIVLSyavNtlsadMwIv0a1u0pUwDY1L6Pp1-6PPPw2Y3zgYCo7-d2cQs_8rvBe7j1hOPjyHr1R55ECGw_0puaDQDd5xUZCexVw4gUpWTkIEqz0Ey2tDAtJ6Gb89t428DH6oS7ndseXQP3zXOJTE3sOqBihbg1U825IQD6nWN6ldIkuijwLzTMDVrGC_q6lN5Qn__LAg3cJDrSmDqtGGMciWmXxZM7Eo7m2a0R9rhq7ayIiizpmtH1pxV7SpwqZFtnhhkQ0mMpev_WH-RmQGRb1I1R6A5sAFQl8C3atCXl4IPhqeusQdY2PL_OZAhRKKO2hhwKUsGJe-nqu1LEOE2rYrwlix1lWG2asW69wyLuSnSrYCqmwWOxNm0gD_nG9r7eV6mgTqHCdz3aBjaMZd77y14h1FHZmvBVAr8tLJL8JtTbTLINnT4p8sK1A39_w5B1RXKKVOJDegT6j_1md6HVRu9IWENg3PDx16ENfQxxxjKHVzuLAjK1FUvONKDpTk8WZ_alW1Yg1jxwm1d7mhnY7LeDY_yg8nVbfxshjvwqQFhgriwxs1cD3CiUIyywnx49v-HQOJ2oYhMZd8yDRgN73IqxJtXRdxXTM_SOQVuFS2uR-uzlvE1dFtpsAKEkXjzng1L1_1chslMg4yywIxLdiEoKZzaj12-rXyP-72rpOIRbbWUg0XwzpBhlm3ooP3dSfhVQRLXblqARyaqzY9iPUQNFZz0WdXERokZBKoMqMEumAdVKrgB5NYCuiy2Et46ZygV2_PS46y6hFpXiENJEN6fOUlEGWCk1ShwJTckzRuu_y0GL2NV-aUqmeU8IQ8KfjBLLwTuHsY4KsBtKyK-jm0Pt5J3H0L7YsU9VMB_njS40zk2QZgdCUH9TvRAqUD6XgTdp4sw-QNdF-Nzc8QOnrdrtfJdNn2uun9l87WuUnclL4pQsruIWEONA2y8fQwAvKRJMQ0mRZvejAcf4Y-Rb-Gjeub3x8gUGNSkGtgd_7_wR-CXSKgIqK9uNcYqYMpqPr-MzcVNeXNk4LdYXwong2vi3-4Rt8aon4sdQjJ0y0bjUCcyfdNzOOnZOu_ocY8XHdagflZPW5TxWsmHrkDcdPnigem_TRnaUKqtthorCUIptyBe97xWtJri_x4kAcX1a3WtejzZGP', `SearchKey` = 'wofCpMKnwrDgMOQwrPCvsKDwqTDlsKrw5vDj8KhwrHChMKhw4TCvMOWwwofCpMOaw4DCtMOQwrPCt8KDwqTCo8Ksw4zCucKdwqPChMKuwrjCvMOVw5TCjMKVwp3DgMOTwqPCvMwofCpMOqw4DCtMKlwqCp8KDwqTDhMKrw5rCwofCpMOAwrDg8OgwrPCu8KDwqTDwofCpMOEwrDgcOQwqCq8KDwrHDksKrw5nDj8KdwwrHCisKpwp7CsMKew4LD'
# [30-Aug-2023 12:44:22] /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
# [30-Aug-2023 12:44:24] /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
# [30-Aug-2023 12:44:29] /finance/root/bg/invoices/2075.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [30-Aug-2023 12:45:09] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [30-Aug-2023 12:45:11] /finance/root/bg/flow.html 167.99.142.201

set names utf8

SELECT * FROM `flow` ORDER BY `PostDate` ASC
# [30-Aug-2023 12:45:14] /finance/root/bg/ajax/flow/form.html?_=1693388713344 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
        
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20
# [30-Aug-2023 12:45:39] /finance/root/bg/receipts.html 167.99.142.201

set names utf8

SELECT * FROM `receipts` WHERE 1 ORDER BY `ID` ASC
# [30-Aug-2023 12:45:44] /finance/root/bg/receipts/3.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `receipts`
            WHERE
                `ID` = 3
            LIMIT 1
