# [04-Aug-2023 10:15:54] /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
# [04-Aug-2023 10:16:00] /finance/root/bg/invoices/2068.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Aug-2023 16:39:58] /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
# [04-Aug-2023 16:40:01] /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
# [04-Aug-2023 16:40:05] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [04-Aug-2023 16:40:07] /finance/root/bg/ajax/clients/form.html?_=1691156407339 167.99.142.201
# [04-Aug-2023 16:41:04] /finance/root/bg/ajax/clients/insert.html?_=1691156463932 167.99.142.201

set names utf8

SELECT MAX(`ID`) + 1 FROM `clients`

SELECT * FROM `clients` LIMIT 1

SHOW COLUMNS FROM `clients`

INSERT INTO `clients` SET `ID` = '43', `Language` = 'bg', `LastUpdate` = '2023-08-04 16:41:04', `Data` = 'N39Re5gOQMqx4tSZ_QV31mdpui92hQCERdGjtxF-E6GPA25rIA8o4crNiQe6YD1HxoTPFTjIUDx3FuyHbhfnzbrWjf4yayYuHUS5_-xVMY7lbbKiXnWE3TGlKz4NkGqsPcVcD-agXzdumcgdqFk77LhNSpXNS5T_r_qE08oBalU-MLK6a6tPvldlILlta_o66NrnGJtaNmXEYP8trqhhBuXagB5qeBSxYbwH0VMT4xL5ijyVXPAf90-0GLFnQsFrgTBD751bhExMjQ3Rgp24sUeiHkqv3ry9XM0LWXU1VHQKEtjNAOIjUPAxdZwDxjbVQq7NZmIJoBPib5l6nQeOFA', `SearchKey` = 'wrrCn8Kpw6DCsMOZw5jCpsK0wwofCpMOAwrDgcOQwqCocKDwrHCsMKrw5jCpMKdwwofCpMOPwrDgcOQwrPCt8KDwrHCsMKrw5vDn8KdwwofCpMOAwrDgcOQwqCocKDwrHCsMKrw5jCpMKdwwofCpMOPwrDgcOQwrPCt8KDwrHCsMKrw5vDn8KdwwqTCnMKxw6XCmsKwwq3Dq8KgwpzCrcORwrLC', `Top` = 0, `Visible` = 1, `PostDate` = '2023-08-04 16:41:04'
# [04-Aug-2023 16:41:04] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [04-Aug-2023 16:53:30] /finance/root/bg/ajax/clients/form.html?_=1691157210402 167.99.142.201
# [04-Aug-2023 16:53:38] /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
# [04-Aug-2023 16:53:39] /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
# [04-Aug-2023 16:53:41] /finance/root/bg/ajax/invoices/form.html?_=1691157221602 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
# [04-Aug-2023 16:53:47] /finance/root/bg/ajax/clients/select/type_0.html?keyword=пок&_=1691157226919 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCpMOPwrDg8OgwqC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCpMOPwrDg8OgwqC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [04-Aug-2023 16:53:50] /finance/root/bg/ajax/clients/select/type_0.html?keyword=pok&_=1691157230239 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCn8Kpw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCn8Kpw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [04-Aug-2023 16:54:50] /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
# [04-Aug-2023 16:55: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
# [04-Aug-2023 16:55:15] /finance/root/bg/invoices/2060.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Aug-2023 16:57:23] /finance/root/bg/ajax/invoices/insert.html?_=1691157442996 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 43 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` = '10373', `Language` = 'bg', `PostDate` = '2023-08-04 16:57:23', `LastUpdate` = '2023-08-04 16:57:23', `Type` = '0', `ParentID` = 0, `Data` = 'W486vCJKl1anZK9Cp4_I2T0tNZva0RlWg-dOdhsojU2hw_nmRGZsfpBk1UaQTPYlU__7H2M7oDTZMp2d2ZAf6kH0Vq7BqR9R6dGityMvoS-uipg6VA1ZhbV9qTM84w96gEGRBq_uJejXtqevSHk4WDhlvjM9GDlmwcOTaasBu_jJdK1kD2W7X1uVLrqdFCeWZetIwhz9085x-fWtX2aYg4cyNY9tO0KpWcpwq8gqqz9hsxRG9bW-f_hPKPnuy0PlXA1UV7tZDCMwziYugMlqmNui7arclRZ9lf6QSi9brFht6m6X5GENJ1v6KOhYmwNFNTrw1TOdGgjIiXGO2mX8Ia6QXvwo4gmGs85tg5K7rMj8foqtCFyHoW5OPUo-OKgUD-s33Bo8Cp631yEw88cgd4ZnJdhywl4qfq2NkU_GzPZOrge1RqKKUHXOBjv3vh_S9DAEuWnRjYGU9tQMNqT8vnXs69vBdIWxuSLtkn-f8hT85wu2RQD-JOlRHw2GDM6uknITBXi7S3IbktXDQIZI0U_zfywTwCapD4xjpoqrkS1jwRrAWxN7WkNE2D-bgK5GnIsX5dALtAx3a4l4RpKosSMitjo2GiFe030EjtzCJgwwOtFX1_mH-SOGpHDEYAhyjk7bdybykgUeK-qtsF2BLA3idX0KUxDZFQddRLp6dvDfsvfgXcMB1FKUEMH4DuArw-swLpep5UoYRuKV9Xkl5NWLptji0MbflrfsZGP-DoD5Evi_GogxcbRxJ608t9t-dQRY0EWDCplnjEKITcla5c-wGnMNBCu0z6AyGalaaB3rX6CyEnqojei3lcQW7w1-JX1RcZScGZSfIrcz_y6NrNuTxvZTWrjgS4oPV3XDL_bN0YMH-8vtgNeqLM0Q5DVq1o-4h1vdfk7bg5t9-ZIMlD0ovcSq9r19piL_6ljQnFEZKxVrwhCIMSZWMdih9Nt01cUvBfLzHHYdHYWM2xFw5O7JSm8STBXg7_BgSKBEiRR1fz2eu_Uaz6q3O2wXyD2iIvdpXoXl4HqGn58tOE50UBRlSTvmrfcmWt3BWo-Jy0qS_rx2H-OljmIc7UcAL3Bzj_7NmtK6v69sy3zTzwM8o4juzlBLzfQCm_EXJSvcKx-uFExuWQko1UUSM0zcqS4D3sJna_UsfYLfxQC6vPBSXWZTOPEhoT_svxbMm8mjOOgmG1ANGv6srkVxe06-FBII', `SearchKey` = 'wofCpMOAwrDgcOQwqCocKDwrHCsMKrw5jCpMKdwwofCpMOPwrDgcOQwrPCt8KDwrHCsMKrw5vDn8KdwwrrCn8Kpw6DCsMOZw5jCpsK0wwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK'
# [04-Aug-2023 16:57: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
# [04-Aug-2023 16:57:28] /finance/root/bg/invoices/10373.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
