# [06-Sep-2023 09:38: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
# [06-Sep-2023 09:38:30] /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
# [06-Sep-2023 09:38:34] /finance/root/bg/ajax/invoices/form/clone/10374.html?pid=10374&_=1693982315155 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10374
            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
# [06-Sep-2023 09:38:46] /finance/root/bg/ajax/invoices/insert.html?_=1693982327364 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 46 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` = '2091', `Language` = 'bg', `PostDate` = '2023-09-05 09:38:46', `LastUpdate` = '2023-09-06 09:38:46', `Type` = '1', `ParentID` = 10374, `Data` = 'dWdMLzICqTdn5naCxP_aF8ec1yNNYwPaBnBnK5SrhUEidLpAKRT9Q6uJaLOfQKKQFBjBuFKImjZWxTj7df1vtzABTTsOK4MzWBABWnCcX9mdfpuh5kfdNe9HauxtWx-HPxqXSJtdC_hRWFtFfZvt0SOvBMShq9EjC6jpLUv7w5ntT5iaqbMYUaPDHY_vVoEHCQ4UmPy12gP-L1Tpjbb0DsxvQwYSzpCO_xt6hw9y7bLDOVoCJ31sXstUXoXpSAexQuRvmq0NRXUf_lL4eOspgc25bMS5JhUbcS_nrs49Yt42x_bzrjeuH9fmbAyVXXMTSdMcNsNwkeQbr5u2qKozMdJ-GPga9xlbjDt0fldBcWgGpBVaWe3fz1QKZL7ziQ2uH1rQuuUDBAYQfgvxJHQm2tN-DXxVO7a7PS47n2xDKiiJ7GbL3nvrqHR_CDmTuPAZDpTJxJgyIS8Dw6JTprZOqxD29FTSXKrVPhsB_VbCUF6w8dTK3UC1cwKgvJEybK3uOG3C4Y6glFhzWdCbvQrtKCmb-G_nm_wxd-FJxPqiMUhtRG4f5eer72eoRKqSB-fGLwfLoozb4dT-m2X8EvUYtS31VmWbotWaxSI6_tEmpuwtoQNwNuJdfIbTPCeuHwNDTqIRw-_EUSl6ohLj36UiwBQf4_5Tc3qqIRBTiot4jtdE_d8R0tacvI4802VPRHkbXMK5bErlBOhqRCKU_dXnjjMXvOzxPNmMYtKUaBZ73nQ8B9WBllcYJVRpRcSpHgUvxcyilfl_Q9R0TkLzNWjP3B1e2L9GXLyd398UrGq7rWiHeEavoCBGkjjJNdXmtQp3o5hgIs9cNbY8pDdwIqN02bJ3okG4b15Be0UUtBnybpc7b72U1EnWnO7UWPHMAvUU6hpINKDdT07Bt8_Py0fRvum5QM4bgnhKo1bvRx7FOKBhBdJVYySBnFq83gAwgoa8jBL0-WFK09XgaDziA5xC0gNsxWl0ZZURDGNvgpuBFYzYgsSrwAIuY8PZ0XJsyjRYrewFxwTyXsl_y0VsCXHbXB4DGK-KaQV5bmj_SbSvjL0FQdOYwp2NRwjiqsskUlhTLkxPg-jNFKktqrGm3S7eRfGb0tjHuKQwpJcQh6jbSBG9WZ58iMo8nIru8fv5LovTCeHV2c97Nt3fzrYdNP-A0A', `SearchKey` = 'wofCpMKjwrDgMK6wrPCtcKDwqTCo8Krw5nCucKdwqjChMKhwwofCscOWwrDgsK6wrPCt8KDwqTCsMKrw5rCpMKdwqPChMKuw4DCvMOVwwofCpMOPwrDgcOQwqCrcKDwrHDksKrw5vDwofCscK4wrDgsKlwqDq8KDwqTCuMKrw5nDj8KdwqTChMKhw4TCvMOXw6TCiMwqTCrMObw6fCmswrnDhcKw6jCr8KzwrLCpsKtwqDmMOMw4fCnswofCscO'
# [06-Sep-2023 09:38: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
# [06-Sep-2023 09:38:48] /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
# [06-Sep-2023 09:38:54] /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
# [06-Sep-2023 09:39:02] /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
# [06-Sep-2023 09:40:22] /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
# [06-Sep-2023 09:40:27] /finance/root/bg/flow.html 167.99.142.201

set names utf8

SELECT * FROM `flow` ORDER BY `PostDate` ASC
# [06-Sep-2023 09:40:35] /finance/root/bg/receipts.html 167.99.142.201

set names utf8

SELECT * FROM `receipts` WHERE 1 ORDER BY `ID` ASC
# [06-Sep-2023 09:40:39] /finance/root/bg/receipts/3.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `receipts`
            WHERE
                `ID` = 3
            LIMIT 1
# [06-Sep-2023 09:41:23] /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
