# [28-Sep-2023 15:24:33] /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
# [28-Sep-2023 15:24:35] /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
# [28-Sep-2023 15:24:36] /finance/root/bg/ajax/invoices/form.html?_=1695903877472 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
# [28-Sep-2023 15:26:00] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [28-Sep-2023 15:26:02] /finance/root/bg/ajax/clients/form.html?_=1695903963505 167.99.142.201
# [28-Sep-2023 15:28:23] /finance/root/bg/ajax/clients/insert.html?_=1695904104419 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` = '49', `Language` = 'bg', `LastUpdate` = '2023-09-28 15:28:23', `Data` = 'X5HJBxUXQffh1AQ7RGcPtm_trQ1KDGldbUCIoo8LyS_b4p3lg1vpmqxRXHIjk1r3wK9jjYQ_1UHaHPAL5rHgZJvX1mwIdLXf8VRge2_2aaIDIzeUP5xkNF7uEakqNpECDG7snqF_0daYjCSQsiMh9cHWswuY_NGpw6Xw3j0BIaj2iFNirfNG4bvV16IeU7Bz918ErLaHer9r224vUihMV--iZognrYASyrpJNP3qWYvL-eXx_bo90cDqtz19Bv7HOK7CwrIvnFkdjkJx6eb_3YbJRZ15S2mnU_Qzx0gTG6j9CqPWlrOappk6K-0nwPEvhk8v1bkHV64h4Eas4Kbytf3dtB3KTk0bmIK553shI0rfAW6VYdKJ8-9Gf4JbtmwTosfhFQGgmWDtClIAKmRimFSM16G0k5PUevyfbhN1RDQ', `SearchKey` = 'wrjCn8Ocw5zCrsODwwofCscOIwrDgsK6wqDrsKDwqTDlsKsw4DwofCpMOPw4DCtMK6wqCocKDwrHDgMKrw5nDj8KhwrHChMKhwrzCvMOXw6TCiMKMwp3DgMKlwqPCvMwofCpMOEwrDgMK6wrPCtcKDwqTDlsKrw5vDj8KdwwofCpMOawrDgsKlwqCqMKDwqTDhMKrw5jDn8KdwwqTDgsKxwpCmsOAw5fCpMKhwpzDgc', `Top` = 0, `Visible` = 1, `PostDate` = '2023-09-28 15:28:23'
# [28-Sep-2023 15:28:23] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [28-Sep-2023 15:28:28] /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
# [28-Sep-2023 15:28:29] /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
# [28-Sep-2023 15:28:30] /finance/root/bg/ajax/invoices/form.html?_=1695904111282 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
# [28-Sep-2023 15:28:35] /finance/root/bg/ajax/clients/select/type_0.html?keyword=хиг&_=1695904115929 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCscOIwrDgsK6wqD%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCscOIwrDgsK6wqD%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [28-Sep-2023 15:28:45] /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
# [28-Sep-2023 15:28:47] /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
# [28-Sep-2023 15:29:00] /finance/root/bg/invoices/2086.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Sep-2023 15:34:06] /finance/root/bg/ajax/invoices/insert.html?_=1695904447460 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 49 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` = '10377', `Language` = 'bg', `PostDate` = '2023-09-28 15:34:06', `LastUpdate` = '2023-09-28 15:34:06', `Type` = '0', `ParentID` = 0, `Data` = 'sIzZX0xiEb8-7NsdQbXuTcOaxjGdaPddb3HtgmQpgOIAaR3Ryjca10YOCm6OLho9SlnyFgSxgpfP_S_n3CeNXsZBAadln77JDlMM_qe5cat7bG_29dDXYLE5pJm6uhGHhY2kVhDiIVd_qUYNfo1Ga6n8KQ2-xL62tR2mF554_P8agT90WNdSRREpqwfzGXMaCnWXTAlEAb5GBLpPTbiJQkwVCEHea-_srFdF4CGqAkYu8JHu70TURbPAKbbqo5KPjpgbd390w0h1IL0EpfNKFLl8p7T9ZRxSoCFdM5seSi1C1iP8oIx7WKVe-QbHJpFMaW4mdYsXn39ifJwvpWJO4ekwCJsWWCORzJQrCaLStFtv3Rl6E5jAmQkOze-jhem4tE7XCQr3wy8MP5xEe__-zk7pv856IOKVidrOjHF25YLw2DLetpevpTzS8b95qseIV-JDCfDcwAspcWtmSricSxhj56hP_Rhhn0qI0dvlhTUYRAnUUzOg_f1vloGVas6vWNWga71N96Ii_vXcAML91zLBev6Ty4nW9G-MJhgaJ4nOR6wlyamSLKbrrMOwJPUKvvWmAWHbB-oH8BR09b_Jm0ANMUmOdFJG2n0CZgSEU5LdW49hezSwsF1GidQBGQoGTIKFXqvIj7LBzEYIKqGnXVWodNRMbTR72KfPqLa9hWuOe4gbNjMuyPLQlL6xC8Rs21WFkhnHsXOQM2LO4cVQg5gYj1V_AeSr1EJJHujrDO6fcDiRQJ3dwOHUoPVzZg_GKJXYSvyh8Wx7HsLGadYuAm0cI_ThZpYaQomrrRqhSAgrHRPjCv3UOyfkPzJyFvHD5hQbiLWxiV1Ge8iRe7I_5H_u2egr5WQWnshtPREJeHKtj439oXdKkxqgrnOzE9S48yCb7l094FJYM6aLzLztkq1SD6A0t_rWv4sB772UR01YzWmxP80Dfo1LxynRMgWaH0B7hm-oLW_g4B6G1c5uZIxRQIO6bLlHua0NleDOSsEsnOllnoo3sbTiOoKUk8wsWTsBs0PMML51WEz1nOZ6Nq-HSD1vVvl02lo8iXRx-0QvdS78AqD_xMIsvsQceP_eJhwWBCohQ71NT7b172oQhlFwX6HV4ZK1JWLPH5FctEDJB9yRrSVUPlla95R1qVEpRQucrzQ1uI0h5_I9YKpb93iJAx85JST2VbhpcPKJq9JjPRmTmV6wra1p3fman8aEFEn8zSkhABumgcFE8ddrvCFGVAxqBdctSuCUIZLfGc6PtgdD_hvQBZm25-uObkMNLq4yr-9iJkepjrqSs-IuMhoz78O9yQv-jOr5yAVATuyNtt-7Y9qVBENB992eHMkeGiEhRXAGHFCbVm_iqcpyquEWtME1l0sjHtgizomshs6JITyx0Lu2URegAcXNPb1SJ2ujNcDIAZNTU-VCbW0ZvoBY7NBbnHVPE9ssud6Im5m698uJMOOrq2j1e_Yar5ai3UZyFUUizvu75h5wIrh_IXLzvp6t-OwBmKpm0Jsrkcb3jIa9q2ec3FI2puCpqeBV', `SearchKey` = 'wofCscOIwrDgsK6wqDrsKDwqTDlsKsw4DwofCpMOPw4DCtMK6wqCocKDwrHDgMKrw5nDj8KhwrHChMKhwrzCvMOXw6TCiMKMwp3DgMKlwqPCvMwrjCn8Ocw5zCrsODwwofCscK4w4DCtsOgwqCp8KDwqTDgMKrw5jCucKdw6jChMKhwpbCvMOXw5TCiMwofCpMKjwrDgMwofCpMK4wrDgsK6wqCp8KDwqTCn8Krw5nDj8KhwwofCpMOPw4DCtMK'
# [28-Sep-2023 15:34:07] /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
# [28-Sep-2023 15:34:09] /finance/root/bg/invoices/10377.html 167.99.142.201

set names utf8

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

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