# [27-Jul-2023 11:34:25] /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
# [27-Jul-2023 11:34:31] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [27-Jul-2023 11:34:32] /finance/root/bg/ajax/clients/form.html?_=1690446872694 167.99.142.201
# [27-Jul-2023 11:35:19] /finance/root/bg/ajax/clients/insert.html?_=1690446919056 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` = '39', `Language` = 'bg', `LastUpdate` = '2023-07-27 11:35:19', `Data` = 'T34UsOcnpIM3wX2uSDi4GpyXFQwWtuQy68eiGsK6P2TjqN2c0q22q8U-umyUoUARPv2fFRsxeav9nW6rsi8_Cj38Gdf2vdHdPgX8_JQaW19vzyBoFKu0yDcgqFX832_9EeLyzbl4bbKKhaIEDSij6Z08FElVLoDnd94hqZVphtoENs_XP5Umb38iGcddOhe97Kh2rSUsSgAZK7BunnaCWxFhewDBKkuThD76PWjHElXVUDa9OxkRp1xCqQ0wuh4tRCR3I0AiBOpzmpVIjO8Ajj4Exs99ejYBc234Z8sPYupdTeRkXHLeIrfWEmqFDXjCWqUNoLA6M85BDb-XkdlkacbHhoR2cgWDsvp0Y4uRF4PENzr515_ugs7TJd2atqDc', `SearchKey` = 'wrDCr8K6w57Cp8KzwqXDwofCpMK0wrDgMOQwqCqMKDwqTDgMKrw5vDn8KhwwofCpMOAw4DCtMK6wrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwofCpMOewrDg8OgwqDq8KDwqTCn8Krw5vDj8KdwwofCscK4w4DCtMOgwqCocKDwrHDi8Krw5vDj8KdwpzChMKhwp7CvMOUwwqTDgsKxwp7CmsOmw4CpcKgw4LCtc', `Top` = 0, `Visible` = 1, `PostDate` = '2023-07-27 11:35:19'
# [27-Jul-2023 11:35:19] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [27-Jul-2023 11:35: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
# [27-Jul-2023 11:35:24] /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
# [27-Jul-2023 11:35:27] /finance/root/bg/ajax/invoices/form.html?_=1690446927149 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
# [27-Jul-2023 11:35:30] /finance/root/bg/ajax/clients/select/type_0.html?keyword=abi&_=1690446930309 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrDCr8K6w%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rDCr8K6w%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [27-Jul-2023 11:36:36] /finance/root/bg/ajax/invoices/insert.html?_=1690446996824 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 39 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` = '10371', `Language` = 'bg', `PostDate` = '2023-07-27 11:36:36', `LastUpdate` = '2023-07-27 11:36:36', `Type` = '0', `ParentID` = 0, `Data` = '7jfrIPModZT2VfOLUK3J-ituxcoQBum51JPrVKuj32hfEtZ7LF46U1N5dTw7X2SgSwUK2FNgwcUdDbMb6lmHuCgBvQ7NWVv7NX4aswKCFVAPEoS9Xsu89fjscYuQtr9HFmI43V0X7TwzOGymJ_qemZNWPXh3GJE2AxnKeU72n6NF3sZtIAU3lEliEmK5Cz-oOFyMbxn1xmG0TnOJGLCAiLgJtqTZHWQ-FNvAM4QcMXjzprUhQhduwdiRAuXjqYDfAr7U5nzYqXP3FHxhby7aeqxM8i014vIScDjY2zB3u4hGaDoogRWsZXeDFrnp1luCZUJi7S5083i9ZbOqJu2kcs_YKjxdX9iLRCE0JhawDjawMSgdtnMASwr_nHzBOiOJv8Kda2SDnYAJbWwhTnATuKODabItOrv0X5mY4BDSqPCS5ZI1upQNScEnSljKFFv3MyUT6tNNiQhfzjh7SQSZdHIMs7Ey1Shv9pEAQ59ku_VskfYWbMDQbf5_xPNmg-hwM7FIkz2YmsgbSSvV3f1aoiI3--1PBA0WbCrndSXGLsoK-52UZeLjLS6opUDiecaPtKeYB8NTIf6g1qQDiS1u_AOmuzFXBiwMKh6BsTKU49fxqC1I8YzIohrhs8na110PHLsFS2PKj_-YDULo16IRy_SMtuRHked_yF-9SRRSZE-lkWAH2urQHBRi2hOvw-wZnNtsL2WusuQclKPPeO9b7vK6xrCcEdPJ7kEDpB86JQQz-UVyPWH98izOwYsgSWJJX95gPGhBPQVwGJ-WMvXHmolFjC5kN1HmbzwclzN1rQ2HXKkviRykWHwac62XsKqmKDPBHpLANDYhu-8R9eVr5CX2CWJDUwrRy4r4EDb-3Ara-kPCsaOLs4MT9Vy60HkpK6C-8T1uvOj7D-RUsPtZDQ0WhG0FhxDkViYdZMQCanL5tw1xDxIs6yBjEGRfH60PlaRj68-Ta-j9UMX5OEgCeDayXfc989YDUBudZZwO2AY', `SearchKey` = 'wofCpMK0wrDgMOQwqCqMKDwqTDgMKrw5vDn8KhwwofCpMOAw4DCtMK6wrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwrDCr8K6w57Cp8KzwqXDwofCscK4w4DCtsOgwqCp8KDwqTDgMKrw5jCucKdw6jChMKhwpbCvMOXw5TCiMwofCpMKjwrDgMwrHCisKpw6TCp8Kew6TDwrDDhsOGw6jCrsODwqHDoMK2wovCwofCpMOPw4DCtMK6wqCo'
# [27-Jul-2023 11:36:36] /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
# [27-Jul-2023 11:36:40] /finance/root/bg/invoices/10371.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [27-Jul-2023 12:05:03] /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
# [27-Jul-2023 12:05:05] /finance/root/bg/invoices/2048.html 167.99.142.201

set names utf8

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

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