# [10-Jul-2023 12:47:24] /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
# [10-Jul-2023 12:47:27] /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
# [10-Jul-2023 12:47:29] /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
# [10-Jul-2023 12:51:08] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [10-Jul-2023 12:51:13] /finance/root/bg/ajax/clients/form.html?_=1688982673755 167.99.142.201
# [10-Jul-2023 12:52:33] /finance/root/bg/ajax/clients/insert.html?_=1688982753678 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` = '37', `Language` = 'bg', `LastUpdate` = '2023-07-10 12:52:34', `Data` = 'BSDbEZRPkBEnq3MMpMbXmZAHc8f4GoRdaGpeYKqyLQMhiRrNtgzM2Skfbd51NT7c72st8SJW2QzFNKPJJstOANo250yGhJfTgmt2PNpzYkEOryFGSlaLN3NzT69CpVh3oFD-xf61gc-ogJh95cl2MelSFEvXsZ9BhI_ZzLfsUfiaWfGoDfZsvnXLPAdL06WHVtx8mSH6WHfUCJ7OOobQc0f0KfszRPzmKuAqPnnfk80uKzGMuCdzCA9E572k8LQGJr2UnPfAW_A7IktFNxJSiUNvbRYbNfGTQdPiq1o50DT2LJwry4K6KxuzNslkg1Um49XxkfL3FDhS23TzIv-7Qyl6XhMqh_dCyC-6jom7LI12RWM4XSnX-W0OzNlG4OG9', `SearchKey` = 'wrrCsMKyw5bCsMOawrLCpcKtwrDCwofCpMOiw4DCt8wofCpMOPwrDgMK6wrPCtcKDwqTDnsKrw5nDj8KhwwofCpMOIwrDg8OgwqCocKDwqTCwofCpMOqwrDgMK6wrPCtcKDwrHCuMKrw5rCucKdwwofCscK4wrDgsK6wqCrMKDwqTDhMKrw5vDn8KdwqjChMKhwonCvMOUwwofCpMOiw4DCtMK6wqDq8KDwqTDosKrw5nDj8KdwwqTDgsKxwqDCnMOAw5fDq8KgwpzCsc', `Top` = 0, `Visible` = 1, `PostDate` = '2023-07-10 12:52:34'
# [10-Jul-2023 12:52:34] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [10-Jul-2023 12:52:40] /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
# [10-Jul-2023 12:52:44] /finance/root/bg/ajax/invoices/form.html?_=1688982764387 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
# [10-Jul-2023 12:52:47] /finance/root/bg/ajax/clients/select/type_0.html?keyword=qparquet&_=1688982766814 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCsMKyw5bCsMOawrLCpcKtwrDC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCsMKyw5bCsMOawrLCpcKtwrDC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [10-Jul-2023 12:53:24] /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
# [10-Jul-2023 12:53:31] /finance/root/bg/invoices/2036.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Jul-2023 12:57:11] /finance/root/bg/invoices/2040.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Jul-2023 12:58:09] /finance/root/bg/invoices/2042.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Jul-2023 12:59:32] /finance/root/bg/ajax/invoices/insert.html?_=1688983172279 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 37 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` = '2047', `Language` = 'bg', `PostDate` = '2023-07-10 12:59:32', `LastUpdate` = '2023-07-10 12:59:32', `Type` = '1', `ParentID` = 0, `Data` = '_2UPQV6_xYo1n4eWqZmWTdX826uz0G5THuvLeDs4jyr5qN4jfTafZp7mXKRxIYdRn8ibbsrZiqX-NgQDvl8bH8nD1w8rnPQTd1eNNR_VU4970zNmy1IXTb44v9aif50RWOEMqX-E_xtrph2j7FRbLl_mk6CX6dpBdb92gcg3thurPwYloOXZ7H_xsve0lpdCjsNcctXli4eADjYfIl3tHIjEu8c7Zu3IIxhF_IOhZSU7rL3UXajSh8CgATw0GQ3HTpjxrRnC7Mm7y3pczseR2l1BZrGsjKtPKNQBsUXE9ofBW1Xlf7svjBnubeCzgawUc6OK7VMQ0KjoqiUnOQW1OLgMhnpUbo5uRseTjqHYM4DOQw3tIVYqTTyUFTTATOm9aWXb9NThs1SyKflRn-OuphU7y4Gwmh1_4SVMtfhkzt4FcCBH4umSNJQBN2Kp5wDph3V2vomgpzO9ZQ-3fp6UoNboR1qH4ww6U06-JhiPwP7A1Mr_0EUvsUZZQBzW9B55mGiQsLf82lqN0gaLlZxWklkM2n_LE7RjN3rhfYNd29-LR6w-x2owwf64mSdPO95-ACfhIigV0BVbhis_fsAdbOsN5-f0HVJHL9MqYiWla97jVEsi5qCIbUXdJBxxzkv1iDkcMlrL37LR-4V3EXaCijFkVc6TDWdqLQv9QmnLOl6mUe8ff_6mTjvf05NsAsmS24GkSMzPJaea7CGC4tXpRlBRRK5R3UDWzE9NAhWAzXkdyUwPsQ46ifMHrx1aJKzyqCG99IeFuUZXHbofSjTJTLbLkN5va78erkCvM5fUrYDqgERzjVIH70jWvnv_O1EMj8Jeh_Ea7a9WxelK6PcvQ-fVsEY2AOskypeik-EeSs1f-bmZKSKwhs4n_I22Kxl2sRIOVMRa9I2cXV18DcFG3Wly3nSFCh041w9Q3rW0Mrb9Q_MSuvHQCCL0QlGja2fjBwTU8XuFpgX3WMo9Oi7m0VJtkHof96r-kv9L5abtoqpqIyzLBX0pGaxzL4cKtTARPsP0roxXcnMaP0mQlRzNFUBEsQ1I6cyc0ffNcSYP9BDv-SXGuo921TT3C3Q5Q03aUepPhPldQYbY8HHlfMl2lNlP767jqb039niV3vc4eT5A7BcMeT7xK-2nADRDoMmsOTO1dkh5GNOq3lnMx_6KVgDzPS6sZQx9tMUIhzKoOoBesVa2j9OlfsboKvg-m0Qf9uYbC1IFEKNNn9lt-1HNvqYfmgMaEl1aisM4QCIXPJI02n8ENLg-I_pJayvGZg-MSJJM5Ub6CD4Ih2OJT2tLuvwKUMtTGSZpTri3-twSflUnswtassppk8ibFQNsFq7YyMjonvQxdbwpVw87nJAQ6gx_WX-__ef8lziegNB_StsrmtMI8v-Uku1iCtsZnDvrN5xlrfnzZ6efleU-tZML192cJOrkz1rSBG9DJdWNokLMshEul8slB_9t5dgCdVgNDjGWbMUrHfPdD2cxgoenw_uL_Bj7JE_UHbKabjDo1xggpvEm9Wq9pAQNR3-8pIt6TPTNv7Ubv-0IpcUn7_HqeN_74lcjtrcEJqGk4ZLQVDAKQ4RdE8_1FN86_roJP6wV8NU50PlgiCYNyEPLPddC3WD04GU_KKXJcDJ7kt3SLlt4edmh1t9yy2LCZv7xCqGM4C4T-sveRPwxgMDjRAQJ1_5XQyxlXZKI_i9Wc6tMj0KNKafruSmkegjKpAxhhvMQwVK4EggzWBl6fGHL81irpVhM-uoyh00TipmwDLihZlefaBUPBLhuWhjg27BywLQxQ3V2RNkfK-0n0NEqFti_YopoZjeriyS9qZqRQuoiXa1X65lK91DDt7-gi4Ve4bQxwkJzCDXBS8X-e8VtiA0JbANzsGz2IEDCtWenMA6ShpgyWDTbzV-c6XHu0tGW9TRs', `SearchKey` = 'wofCpMOiw4DCt8wofCpMOPwrDgMK6wrPCtcKDwqTDnsKrw5nDj8KhwwofCpMOIwrDg8OgwqCocKDwqTCwrrCsMKyw5bCsMOawrLCpcKtwrDCwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwrrChMKhwrTCvMOWw6TCiMwofCpMOWwrDgMwofCp'
# [10-Jul-2023 12:59:32] /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
# [10-Jul-2023 12:59:42] /finance/root/bg/invoices/2047.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Jul-2023 14:08:39] /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
