# [03-Jan-2024 09:48: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
# [03-Jan-2024 09:48:40] /finance/root/bg/invoices.html?from=01.12.2023&to=31.12.2023&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2023-12-01 00:00:00' AND '2023-12-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Jan-2024 09:48:45] /finance/root/bg/invoices/2135.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` = 2135
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:48:50] /finance/root/bg/invoices/2135.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` = 2135
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:48:51] /finance/root/bg/invoices/2136.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` = 2136
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:48:52] /finance/root/bg/invoices/2137.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` = 2137
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:48:52] /finance/root/bg/invoices/2138.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` = 2138
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:48:53] /finance/root/bg/invoices/2139.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` = 2139
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:48:53] /finance/root/bg/invoices/2140.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` = 2140
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:48:54] /finance/root/bg/invoices/2141.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` = 2141
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:48:54] /finance/root/bg/invoices/2142.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` = 2142
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:48:55] /finance/root/bg/invoices/2143.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` = 2143
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:48:56] /finance/root/bg/invoices/2144.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` = 2144
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:48:56] /finance/root/bg/invoices/2145.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` = 2145
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:48:57] /finance/root/bg/invoices/2146.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` = 2146
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:48:57] /finance/root/bg/invoices/2147.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` = 2147
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:49:08] /finance/root/bg/invoices/2148.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` = 2148
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:49:09] /finance/root/bg/invoices/2149.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` = 2149
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:49:10] /finance/root/bg/invoices/2150.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` = 2150
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:52:38] /finance/root/bg/invoices.html?sort=00 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`ID`  ASC
# [03-Jan-2024 09:53:07] /finance/root/bg/invoices.html?sort=01 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`ID`  DESC
# [03-Jan-2024 09:53:13] /finance/root/bg/ajax/invoices/form.html?_=1704268394226 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
# [03-Jan-2024 09:53:25] /finance/root/bg/ajax/clients/select/type_0.html?keyword=аре&_=1704268406196 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCpMK0w4DCtMK6wqC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCpMK0w4DCtMK6wqC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [03-Jan-2024 09:53:33] /finance/root/bg/ajax/clients/select/type_0.html?keyword=але&_=1704268413882 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCpMK0wrDgsKlwqC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCpMK0wrDgsKlwqC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [03-Jan-2024 09:56:20] /finance/root/bg/ajax/invoices/insert.html?_=1704268580725 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 12 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` = '2161', `Language` = 'bg', `PostDate` = '2024-01-03 09:56:20', `LastUpdate` = '2024-01-03 09:56:20', `Type` = '1', `ParentID` = 0, `Data` = 'AqlbR_l6Me3lGRvql-fAyuzUFfLnpI_vdZLKOTOnT-Ad_Gh1AF10MnqoAG9z7nCz3qve1lqqSJ2d9BCXmmm43o12X6P21sla3_z5vWRCV3yIOVA4bh6frPXNwzII6JDXwopKeSjFXbo8AcSGjow_cYjP4cHUdJhTBZCzFOKDbB9yBBWOypY7GIY-6jYfho2-MzQ57mIxBEYbFujnY2-sEZJvGt6KvngDAw63vwDja9gAjnaAsJhSuX4Iqw1st4_2vce1a-3U-wBne_63cvh2mxBIurNN_WPHm7BobgZHUDkk-2DAwenMpONofxGFRakrqrVS93FYBe0ZJkKX_lDdAZZSDM2H7vdT9kb7Hfav3bdxA50ZbYhgqG700ZO7Osiv_prvgaw-rIF7CQ0AS2BbgDKFfE1CPioyXghP4xpoouy-klJDNX1c1Ry_zeAq4_Rk7bD8q57O0v8JZYsMItfVfZxcyYxjixwnBcRq-yTzkTLyauzqqkhqUqR64ULcrAuYowuqNS6ASxL2OOm0HUsNTyLL0IMIj6g1Fw1h65MiMrMzidlf4lSMwg0Sl5-qXFn_EEPmpkCJbnkcD2mzPYQbM4E_gKHAhPvIpGmmCMxf_otKqekv9-mGaggxbw4xl9ypobd4ki8uv53QbdZYVMkESwdkIgmpVugfbC2fCkCjITBlMD-C-z9ERASnjaj9YhBRw0uIuXjx8BkVixeQM2bqX6W9HlowH8J0WqqMkJueuX52Y4WlBdL_6NcznI51xWBa8FQcInISV-YHJ5UnnG9WmO3KT50vrp1EwbjQZQC0LwUrtXyWKU_Yo9H-RfXqUWxiETfguAg466B0lk8p79XKFVPveIfVahZiAFrrZppjOd1Nje2nlC7cIvBB7CW-TraMtxa-qTd3k9tC0xVnpC356IJac_Z2oWDnz8iSB8FL7Ztr4eLm4JkiMBKhc73Kuj3wkluJblcMqpcJnOuaCSzrkOzyGaz92uX2-QcpcjO-NYHRz0YzHAVI1a58fpWTpOb4HEkDIxshn0ssk8FAvoyFnw', `SearchKey` = 'wofCpMK0wrDgsKlwqCpcKDwqTDpsKrw5rCucKdwwofCpMOIwrDg8OgwqCocKDwqTCwrDCr8Oow5rCr8ODw5jDwofCpMOPwrDg8OgwqCpMKDwqTCn8Krw5vDn8Kdw6jChMKuwrHCvMOUw6TCiMOKwp3DgMKUwqPCu8wofCpMKjwrDgMwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOiw4DCtsOgwqCwofCscOAwrDgcO'
# [03-Jan-2024 09:56:20] /finance/root/bg/invoices.html?sort=01 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`ID`  DESC
# [03-Jan-2024 09:56:31] /finance/root/bg/invoices/2161.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` = 2161
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 09:57:31] /finance/root/bg/ajax/invoices/form/2161.html?_=1704268652220 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2161
            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
# [03-Jan-2024 09:57:56] /finance/root/bg/ajax/invoices/update/2161.html?_=1704268677106 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 12 AND
                `Visible` = 1
            LIMIT 1

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1 AND
                `Visible` = 1
            LIMIT 1

SELECT * FROM `invoices` WHERE 1  AND ID = '2161' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2161bg', 'cT0dww69gHRlHxcseB4WTUmt-32nElpk4DIuqG-AKjhVqRs5OrGivGp6xIhoQlenzwrGIso0fgIYseOPutzUA6vdv9nsGEfGyFacTmWkG6UCUIdDAjNN_cWAm5pDC_U7bSGeGzxuqMZHxHkO8SwphDXj8ag6qhyGgWLdPpSCpMrqwcObZb5jVKWfi1QPdHlDsBlt8v_2wq22FVdvRPwgLPethUYRYG_wkD0aNqOjNKsGPoBU4L3Risi2PaV1MSn_k7EHRwowWWnSVmEen86MfgonpolFUF_DULRPwj38neot-akL-MZNQo32zFZdew6A8RaNkzOROhL-L2NOCp_r08uuvggoHObkorezyCtUc-DLIx2I4IbnQ-WUifOikGKGCkBC45cGxBQyyeCPODO-RdU9er6i-d0nOQgBkiUccUmn_uJINqfYxUsd_n_n-CelvkWuoe6G_dVDESmeOM_hSLiLzIdc6BsJ2Q_6nZuW_jaPGJ-Jw-Jtda7kPGFGzJw95RnolxpMCj-i1h_3bygtJ6A37SLKzXAhfDXJud5hzLnlJK57b9yVwG2cRBVbvJww8DPbBbnCp9EFFRtJ561rjjM63h3Y0W8c66jEYz7nsUgJSO6pzhHy3XW0Bl-W-nelgZoslFi_YyiNSnVMSNvpXiQQgeRej-DCglunU7LfdLTzt2-GCCw9lORgKx9EoLa2ImJIqWNsrFpTWWZwo0v4QMczpimkSvZ-4pihq78fH7cjV00W2X1cJ673yFqAA6V-AMq51CCQw6Ff80ZTtwzSxnrCht6tLNIyE5Crp3hrj8FKXUwQECUB5p0nNibrfhXBsInNXaMhc54-WG06IFGfo79fcZFk2p9pCfXwR8tuAVDya1-QmyROIPBQB9i73m4qy-j05r-WHpCavS0Pzol4iEiodBFgmTE8R6TVKnyvSsPDo5p-xAFzbfHGkLgFPi0LvZ11q4O4PzgkSoN8FUXsFjuc6B1iitrckqIVj7vDSaraL388wahUOEa10Educ0XJbHOC4y9Wu58jgvr8r4x_K_63x7-S5JaD5z7kSKrYo0qQktByyfjIGmTiwM_LWKW5HgjLncEHlYyscYMG8-BFeqlNGlk4F6XYp-DPinhN6pBfpg0NVQQYjBwBm2r7-8YRQwf5LcFZB72AW3DEAZq8qvXCltNLYeil-LCD-zy0kAYwFUaiFeHNvKgimrpSZB4HYbVXGUd_k4vlEbL99Q8Q7kRud4VwT4oJSfstCK2KOPP2t2WhXNGqB5LBKDvClok-_Diwnsmmo4IsG8NeRwxnWSvv8itHRXUNvysrwEdOmjMq2OS7HOLWd7wvjxoRpbe1sSt-y6omK65uvt8ESKBG7zyk_WEy5ZI3tV2Mm4dYuWeWTR4VgwSm8S2nxMA1JgxIaQg34cK2_7Fb-RKpeZ3EpVWtdX1ENDKJWNlY496Q3eNQCwWGgPUgk5H8O3q_DOSSVq0XXECib-djTgtuwuKHIzIdpaJGs4CkYyH1cBXKJhHA1vsXTg5SFvpOkw91TDCr1lGf2W2-SHluSFGWtJgO0tV2wjQ0Ls6FM0nM1Q9KUtPiUQtsO0njjZhLPyZF4xinmxXWfnfhiSkwcy-_iLpSV3R6YaXbKnH_wfkKkgVg4LoY07u0fzdgVaQLQxT-XrMdHEIQmsNHYue2e0mPg3shVthR8l9_yVVvLH7s_1DMlospm6DQWtFluymxrk_nGDs-2IN74Yd4qvWMPRZffeWbEEbmrsOaQY-nUi220AwYZSmj8pDbG-WPhteos5JnvC1WCPXMkToXJIEKJDPveqtAvSoITETyaZzO1V83388LB2QW5X3ouLnnoQDgCFxA_RekfraQwiietw0faMZUbSjzx2h5HStCpk2U-OftgDGvrmbRIzuMMMRdXi-NkE7e2Rubu4fji5t9wJsA-pRuvsBt1c0VfEk5GITdzasyFX-kSFSkKrCwraIkz_3MDVY8bv1QwTih8XGMCbR8Fa4iplOZ1Q')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2161', `Language` = 'bg', `PostDate` = '2023-12-28 09:57:56', `LastUpdate` = '2024-01-03 09:57:56', `Type` = '1', `ParentID` = 0, `Data` = 'tkQXjhzJr5yhGkDG7Ye30O994pTb2K2Dtr9Oyf3-WLJJulKVHSo06QrtokvEa-74lvPaM5widoABZaaWLq_D-j9yD97B-SXtq7j_2WoJn-j6wUltBUMNprD0wiWGcqS4J_MHoRnXRnFEhJZNThI6R88l5kISSmsy8pqohy0LHkFE3nA9mnuRMKO7gbu8xh0eJhgbTfWzixoWjrSdTZE0yAF8zUGaT8wg1DbVoXyQBSg9dUFeZzV19eBs75GYPPxP9AgGVSOmv1SW8OWmu2ZckL8zJ06jwPToXaJWOEqHWqd_FBDidH8c4II9b-oQHwqVeUlLV_VRf1ghLpq8IQOiP-ahaiaQqZ4msg3lDHjbU-b5ABvRgY65FF_xnIYknQ5zy6MrjVPcu092jP8-GPJxFCcPKICaSrrTwTpE0SU4fsdqwWLu4yUSqYNKKKTeWQHw9Yo1E8mKggjlZjaEOVaHHP-4J25-DiR8w6NoKv8u9N_Xxyh36q2tOts3-6FPB9RwESezLtKtP65QCC42m-BQxga2F9nz1Rw8Fgr2tt7WiyheIzjjdKL0yk3KH3AkqQN7LzkznhDm8IQYnEDZSAxzDJKCqVEVMazA2wDM4VFoglOGKtXzw2xZGZrwIb_3c1k6MDTKSK62GtEg_6VOhanT7fnmP76kXlYSkmkVj8dxqJeG5mPbnhF0MUG0Yu_uqHSvZjJVxcqi5z8nh_kvIsVCqFEDH33FVLYkuabHWPz6V1oiTZvrBooPBW6o3ySHaHML5ugKfvgXCSMkSnRzDw9-wIG5ajlaQeVJIniIZeCoQ9CUCGD3aj90NGyJannLQKXrK_0AIUxwOwJvox7ClPZH0ezBOrsH9A2S9vy3_BLR-H5NRzIpLvI1otX4KWQ380dIu3Oui1kAj5TyWQUmoc-TYFUa2eiFLsWxEbmubLRi0yiLsfVVjSdrny57l4xc0NnoOtNJxnwFg9GqIHE5X34J5JJMTyxxKoz8VdClYxZStrZkExmVMNdH2NHRtY5Oig3pVW09PYvcx_O1A3oPOILilA', `SearchKey` = 'wofCpMK0wrDgsKlwqCpcKDwqTDpsKrw5rCucKdwwofCpMOIwrDg8OgwqCocKDwqTCwrDCr8Oow5rCr8ODw5jDwofCpMOPwrDg8OgwqCpMKDwqTCn8Krw5vDn8Kdw6jChMKuwrHCvMOUw6TCiMOKwp3DgMKUwqPCu8wofCpMKjwrDgMwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOiw4DCtsOgwqCwofCscOAwrDgcO' WHERE `ID` = '2161'
# [03-Jan-2024 09:57:56] /finance/root/bg/invoices.html?sort=01 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`ID`  DESC
# [03-Jan-2024 10:03:15] /finance/root/bg/invoices.html?sort=01 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`ID`  DESC
# [03-Jan-2024 10:03:28] /finance/root/bg/invoices/1000000064.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` = 1000000064
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 10:03:49] /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
# [03-Jan-2024 10:04:05] /finance/root/bg/invoices/1000000064.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` = 1000000064
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 10:18: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
# [03-Jan-2024 10:18:30] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [03-Jan-2024 10:18:40] /finance/root/bg/clients.html?from=&to=&keyword=бул 167.99.142.201

set names utf8

SELECT * FROM `clients` WHERE `SearchKey` LIKE '%wofCpMK4w4DCtMKlwqC%' ORDER BY `PostDate` ASC
# [03-Jan-2024 10:18:44] /finance/root/bg/ajax/clients/form.html?_=1704269924819 167.99.142.201
# [03-Jan-2024 10:19:51] /finance/root/bg/ajax/clients/insert.html?_=1704269992505 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` = '56', `Language` = 'bg', `LastUpdate` = '2024-01-03 10:19:51', `Data` = 'j9a52GViES4dcjDeCrqplScihdyWDuIB_wzfoz1Bzg2DGRtL9scV98Qsv1dliHMbfClYH0l48BsGS_cMzi2OblH3nXn2y7Ns995mlIJhUuSKmdMWdPIvd6Hr7F6mkuVgezr5iREdHE6dto-agtC-zJPKAp628MUpvgv6NPTdsQEL7er9npILv3Wa-oFOAjpf3qXML7ERk-5hj-3jwmWvbjd8I25QFmbxoDHYSeZzVg8cEjXbFzx05YoDj9JzjAYUqpxJ7GAtLHUaLPGwVCaD67I8M2iL7SyChkXBGGhczg9a-ghhFYDAIAtpoUfXGCVtrVvZ3BzIvDVNInTzYVItptCL7Ha7U-jaU_n5KsQWQOk', `SearchKey` = 'wrDDhsOGw6HCrsODwqHDocK1wwofCpMK4w4DCtMKlwqCq8KDwqTDlsKrw5vDj8KhwrTChMKhwwofCpMOIwrDg8OgwqCocKDwqTCwofCpMKjwrDgsK6wqCqsKDwqTCo8Krw5rCpMKdw6bChMKhwwofCpMKjwrDgcOQwqCpMKDwrHDi8Krw5rCpMKdwqXChMKhwonCvMOUwwqTCrMK5w6bCm8OAw4CpsKhwqzCsc', `Top` = 0, `Visible` = 1, `PostDate` = '2024-01-03 10:19:51'
# [03-Jan-2024 10:19:52] /finance/root/bg/clients.html?from=&to=&keyword=бул 167.99.142.201

set names utf8

SELECT * FROM `clients` WHERE `SearchKey` LIKE '%wofCpMK4w4DCtMKlwqC%' ORDER BY `PostDate` ASC
# [03-Jan-2024 10:19:56] /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
# [03-Jan-2024 10:20:00] /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
# [03-Jan-2024 10:20:08] /finance/root/bg/ajax/invoices/form/10385.html?_=1704270009418 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10385
            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
# [03-Jan-2024 10:20:13] /finance/root/bg/ajax/clients/select/type_0.html?keyword=bul&_=1704270013852 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrDDhsOGw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rDDhsOGw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [03-Jan-2024 10:20:18] /finance/root/bg/ajax/invoices/update/10385.html?_=1704270019411 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 56 AND
                `Visible` = 1
            LIMIT 1

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1 AND
                `Visible` = 1
            LIMIT 1

SELECT * FROM `invoices` WHERE 1  AND ID = '10385' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '10385bg', 'KuJI1Px8Hy4pKlUXX9WWB65KwaTfasvkP2xInqGWfKZT4JDeOpZYOnIhiHZ0xrrYsFh0SoJYVW8DsYX_nT6KDqwxmbcMgS2px-b44h0Zav8KhsOJRKOIDlJJjeMv-DAa53e7kxH0WhBIy2wFfHai3Hm2Dw__ZVMnHdI-T5RnuMpnL0qYKslIs83-pDAtG-lMunFfQ_KJhjTHxEj4aXEZ4ZTZKmGaS8UResy0i-P65f_LSrDcwBtabXNZBjW2jpBAckabvIClhK_auZt0JrqNihvn00TnELhpx0ieDQT-rnlF-Z1IrHH99YaBTB9OuhY_Zh98sbgfFvDHdpZJNxcBqHEajyXtVC-X1qt6VPezBrzE9LUDDfzXL5Rk9wlPO_-XkQsNMvv1Ky35ao8IeZE1Pe6ulzSBVLHsm7jTIecS2pzRUDSXlMlmCK1pJ7BS7T3Y6UXXZqT4Prm23gyzruUsdolBcTph6ZYDbN8r8RNDdbmqpS9dr_wcExTXMNu-FWt4J9IQebSLuUbfGtoiWn8DXNTJvmMy8L2sJVPyqbPyZV9q50O3Wx59_AJqoWjrwLuhkATACGn-M6wKyyheLXcx4aBvekfr34o-95H-6DjI_3ZfdIAH2fr4_GZpjGRMfDH0lOLR8-mxpcsoiPFzeI9U-UViIp5Fsf2zIFrS6TxxL0X66JXB1RtUSDrQhJ_-0N_zSjpyP1r3sNlVsJeQSt47wX3RthDkSYowww8A4e0Q8AKtINsZ78a0OuJvbrt-ksT6MPfUD36CsNODJZulrHTTpf85TcDPqK9Evns9kiPG7qg6_F__4Co4ka7t1xtBJTr6WZIZqG78pQTZeYoaENerbHl7x0mNghNy00UZGkEtUpoQYORuHYllZopTvFQBXraA0MNdW7EbhPKT-1W67EEZDmzMnL-tbGB_Hz0zp1AWEsBMfLFf5gRInv8EuP8iAKjog_4mTFLQWi4rN_ZNVyDm18vzLaPaxbmo9ukC1HLMrc_djihWy2-kKA85Hm6O5dQs9uNlhQMXEJj4m_9d4VuNgUbAvcsbJTM0semI-iEo_TVLbSEUBqtooZZwpOouAd0pNVRdxfw7fkYPlRYnQnbr-UPQcny53Sl8jEbA2_zuT6MLuZIBd5ztbpQ-v_aemrl5Imx2WtT0h_zlhoAWHWiIAbeHeQIjI544rfjY08HJPTf2soTTP1PYQ121rznfTCwu0u28hU9eeEPV3Y_UvmvVzSkHxCDAvutgTrZxY-d0f5YR_NyBFXdPR-SEjBUcY9oh-Ojqwnf_vza1YGJzGMTbVFFLuYPnVuNxezqFDNrFuM73TjgDukZAP6YlRUTLbz2nFg0PELfjJv6-M29ev79BvF_9cLZhH75tosSl-EzTcFV0atYKzz25y26iv6BvGUVguK1PfswaM9OOU1CERm3KjKKHsJTRbXo_pA8RPr8VBJdup3DcQD7X9QXKP1RedzBBUOAFWEcf6iHXqHuh8g3BH3h4ACBnWGlJgjP41pW4t879F-4SuJU_ioSd2P1tcs_qeJWQrvCAhCKckiYEYwokrnyF1L9aamnDOFU_jrsJtuUXF4-aTShDjwystUGJT7gP9IhI6GEb1httUUuYuducX0kkCTHITrY9WMCfZjkGh1w-wjIybCKEHWP4MhC67zk5yc7EbGkZaQEHkQrkTT--vzkn5gZJOtTACM4xFIFfV25vpjiwGccBxp3QDgTGn7IDUd075rhANRtkcuRJW1RkxnvWkvnu9ybhfeyHGoWaCeepmViSxrOta7GM2e7cqS4mLse7wGPoY3O9jhVqt1l3wr3wYrCdnXTltiHlfAthuaQdOnjV4KqX4EKZ6FKBqh0_wO75HXWYbaAN77nbJrRccv77xNX3_2VzjWVapnZQa_eRbxkFA4jYZwgrxR5jM6h67J9R9cT2bcpTZ5OOcOXqPtu9izUYbiBX_9fqHWOilaZKZCaUa_as4NtbgtKROyCe')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '10385', `Language` = 'bg', `PostDate` = '2024-01-03 10:20:18', `LastUpdate` = '2024-01-03 10:20:18', `Type` = '0', `ParentID` = 0, `Data` = 'Lhi5nHeMX0MpeB-X7APf_xK7E_-lduNAUpufLryESOYd7l00psZiRSc_Tq2HiR4PJ-QrbV1CjudkvDODVlEowl_FOwe4a2bpi--JNYx6ac5apbZvG4DOweugAd9j2MqlJ0lYZ_5mGg70YIMGQrrXl5xJ-wfeK2D5JoffN95HeHZ9Ri5rkvaHD2UxO97WBew0bMJMCxxnY5mwJM4uIFeq2JWhkwH165qXg-oOw6v-uuNMTWt7rTgESvXUvuJsSmYKYoDwmh7JcTf0lxbP4IkkoSa8oIxNU9BRWrt2kDgHO3J3D0TsOS8ZEbjLg_BpOd4Haqh3TUZI5qS9u2ofxhvcGhwoZnusTQSV7KOjWx_ZsylPGxjeLr5zADbbmSYDoJf_UFYPGpw9UQaj2Jsrot0DHsCQQf9BbwaE5t4_ho6AdofD9zSzKJF_AFLhmT1DaL7_6LfAgBaZ-5H5gJ4bWWUi77AcP8wbibfjtLtIhcNfK1RYz-whMuftw_Wz4JHwsYcKYCck8Nk7T-EuEvV6PXWzrGB24GjVDx2dEh0c7OSUAOgP7s1-SUAD1CONH5W4eaVdHnn-fTjI-0ZFfR0jSq9pQkBkMioxGrRips9sPgJaCiQ0wyVe9gBT9Q51V8tnkpv7JO80GU2q-Xtx5MgAjXp3bjJauu6_tTsQWbY2g1hX6k5mcz86i2VvievWStAOtBsIdzR_0CtpGUN0Gnc3e6ERlkIMPsZ0TH8FrAM_5sEvTOboOlFYeVVsxnknGR3Jmzu4B4Pt7Wq0YMqRy86lSO1wsfg5OzX_TfzM7D0is7QJdXVHd3OB5QeLQsolpV4D1JvwvwwW4mGCKXPGi1yTm5TBnVk-VLStNswFLbmAdZTue0iSYVWxZmqle0l0PV8qKyFfERcLHHEsBFqaCzBnw8ZdiJ6jtlEDjOtQgSzr21Wk2yKxGRWzhU_lUH0n9WeQ1GRC8S2_dxXvDuigYcARhjmJeb_MqnHz4YjpKAiuBpqgrzRRhbgg029MaRpcRjAqiKjZSIiz9L6IGY9qiGYe2t9XGA', `SearchKey` = 'wofCpMK4w4DCtMKlwqCq8KDwqTDlsKrw5vDj8KhwrTChMKhwwofCpMOIwrDg8OgwqCocKDwqTCwrDDhsOGw6HCrsODwqHDocK1wwofCpMOPwrDg8OgwqCpMKDwqTCn8Krw5vDn8Kdw6jChMKuwrHCvMOUw6TCiMOKwp3DgMKUwqPCu8wofCpMKjwrDgMwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3D' WHERE `ID` = '10385'
# [03-Jan-2024 10:20:18] /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
# [03-Jan-2024 10:20:34] /finance/root/bg/invoices/10385.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` = 10385
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 16:22:49] /finance/root/bg/ajax/invoices/form/clone/10385.html?pid=10385&_=1704291769606 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10385
            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
# [03-Jan-2024 16:22:56] /finance/root/bg/ajax/invoices/insert.html?_=1704291776804 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 56 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` = '2161', `Language` = 'bg', `PostDate` = '2024-01-03 16:22:56', `LastUpdate` = '2024-01-03 16:22:56', `Type` = '1', `ParentID` = 10385, `Data` = '3D_QBWPyGS1RTuEXD4MrjEgMBLtRIKr0_NU02NNbMIx1tY52lioet8yOPKSzeWk1ldFYZTC3JSsEG2pjz0H9MDRA9h6MSOkF2k5N7pH_SyJA2_RVgpc4CwIoiEdWQdTaIFM3smUr-GDqTKITuxDrDnG6zTTvUNZJ1qaJZk-VHxRH6eZfedM5ZsweakYRHEcXchjxP-Lj265cIIon9piZdT32tpBpKt1jYk1AC0DSwC5018chE5gpABDkqr9Nnpohr-Uj92cFYwdUj-DahrG_1aO5QMnBBtF6GGqTYG_3i_UrhQRLjnMBBMqA6BXeAsrzTWSZQPvJX1vv_xKZg6D-JTf8k88sPKts2Ky9RHHY3_ITAgpgIJw8UFvS6TIRSz-u7jXnnF8_UhtZvPKA2_keQaFmcpCl7ag34VeUKqOAVzwIT3DxG7-To9FlUyf5M7MVYOXm0LFELvMC_3Q9xc6q0TIzbrs-jIJiD0-yZFWC6xRrGCdKQmbjs2Gk4mrVXto6RA5-Aapp_TFDrmB4hqKCTmvo8Vxsq0AWbUCWnBd9l-BnANQzWhIDm3dVmIszDVY50gLjx00dpPe4FiHw7QlFz00Nf39ZdXZcc2IQIFxparpSC_7xV0Z4NlF7gpsjCyAY-DEWos4o3tdbEVDbUXUp4f4nu6uK1tFAgBRvziEkZgvVcppT4kBVkx3LKLhn7ovtdEp_5kLpsKjjmxiwaOLz-pFV70UJyNkKD2Jq86MJrGUGfRTV-TBIEYVWFpS30voiAqxDfgmrbsXfGcCAvGJGn12EvovwAp3kMfpTFJUV46Gd6MsQAFqCWnFzDJIhepSzxn-dq-ZrDqZFrXdSEwLur3zRZWTjGurab9JNBxSRHfepgRLA8fwtLeFhJ714kd2cSMRO4_pMf-tzryLFOscDLvnb48ztviaFqPC7UjJpXN67T2Q-LsiAGK-fznivOr_BBEIgI3w9mJSUs2TrPej1qUq8wZtssAzqmS53tXGUAVF484UGmPxliruBBSCT-V3hMYEZfY7fZQNqXIXXTI0isw', `SearchKey` = 'wofCpMK4w4DCtMKlwqCq8KDwqTDlsKrw5vDj8KhwrTChMKhwwofCpMOIwrDg8OgwqCocKDwqTCwrDDhsOGw6HCrsODwqHDocK1wwofCpMOPwrDg8OgwqCpMKDwqTCn8Krw5vDn8Kdw6jChMKuwrHCvMOUw6TCiMOKwp3DgMKUwqPCu8wofCpMKjwrDgMwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3D'
# [03-Jan-2024 16:22:56] /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
# [03-Jan-2024 16:22: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
# [03-Jan-2024 16:23:01] /finance/root/bg/invoices/2161.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` = 2161
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2024 16:27:22] /finance/root/bg/invoices/2160.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` = 2160
            LIMIT 1

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