# [02-Jun-2023 01:31:08] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [02-Jun-2023 01:31:41] /finance/root/bg/invoices/2019.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Jun-2023 01:36:22] /finance/root/bg/invoices.html?from=01.05.2023&to=31.05.2023&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-05-01 00:00:00' AND '2023-05-31 23:59:59'  ORDER BY `ID` DESC
# [02-Jun-2023 01:37:21] /finance/root/bg/invoices.html?from=01.05.2023&to=31.05.2023&keyword=&sum 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-05-01 00:00:00' AND '2023-05-31 23:59:59'  ORDER BY `ID` DESC
# [02-Jun-2023 01:37:30] /finance/root/bg/invoices.html?from=01.05.2023&to=31.05.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-05-01 00:00:00' AND '2023-05-31 23:59:59'  ORDER BY `ID` DESC
# [02-Jun-2023 01:40:33] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [02-Jun-2023 01:40:34] /finance/root/bg/ajax/clients/form.html?_=1685659238288 167.99.142.201
# [02-Jun-2023 01:41:52] /finance/root/bg/ajax/clients/insert.html?_=1685659315628 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` = '31', `Language` = 'bg', `LastUpdate` = '2023-06-02 01:41:52', `Data` = 'QRdnMwLLuA97TARi9nNcou19coIBcq1EzZw1N-a_9D32VILQ1OUmcy86Lkc5DTk1AETkzjtvAZXEnCTxO2e0tM8s9QoQacWNAB7b2X1jaOLn0iN7YdkcKdCDtfpFZu2I2nL2InHg-EktIGI497S6R_4uIBeA9UOGYYOP4PH6huSCLEK0-uStD5U9jcrUK2-Go6H1JRNjhSIJYqdDSQjNED3PXFXqEkDJqI64s2JLL-F2YtrtHwTAkXIo1ft4frBUUgvmDCdZyNt_CdqFGc2vCuCmhbGtKxr40u13bjI-z8BVrsh9jOeGFSbgzRO_V9oRqZAPmNIo6imPrGVQzGG6kMjOoO3VPtHUNiOX-3Upo5k', `SearchKey` = 'wrHDhsK6w5rCp8OEwr7DpMK1wqDwofCpMOqwrDgcOQwqCpMKDwqTDlsKsw4DwofCpMOiwrDgcOQwqCwofCpMKnwrDg8OgwqCwofCpMOiwrDgcOQwrPCt8KDwqTDwofCpMK4wrDgsK6wqCrcKDwqTDnsKrw5vDn8Kdw6jChMKhwwqTCrMOBwqHCmsOAwrXDq8Kgw4LCsc', `Top` = 0, `Visible` = 1, `PostDate` = '2023-06-02 01:41:52'
# [02-Jun-2023 01:41:52] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [02-Jun-2023 01:41:58] /finance/root/bg/ajax/clients/form.html?_=1685659321609 167.99.142.201
# [02-Jun-2023 01:42:44] /finance/root/bg/ajax/clients/insert.html?_=1685659368051 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` = '32', `Language` = 'bg', `LastUpdate` = '2023-06-02 01:42:44', `Data` = 'MzyVxL4QQBcoxSgWLpqexdZNe2ULIQhTCbYtvtsEwDAzhAbDIl0GNASLT9Me_BAQ4qxVYCqCrmo9dGtDWD98CobnqsHAWqQbKDaoxer1U3E0aiLHN-5HO0KLQnyfrzRTQA8hTGDOsJtsTTHp-HlcNjmSS3yshTxiQ8KErxItfWot6kM1nJQdwh2DWnWl7Kis_xsY2W4NFd8ngnEsCrskVvfY-iNsTnWpI2fnAmX1upeSqlVZItWGwMARQADA5FgyXn4bHOedb0J1UoJ5ENdURmkxs455QlizSfTkkvDj-mgQPDghaNAlNxCMuKeAfAKGUS-ZbvLH7wkHff1D53Za7YO5hXVTZZOj3pkYgXU3eHEHmq2aUN2YFk27ElH1VnXCX8KnNJ0np2zB-eWPkY3Fsg', `SearchKey` = 'wrjCisOUw6jCpsKfwwofCpMOiwrDgMKlwrPCwofCpMOiwrDg8OgwqCrcKDwrHCtMKsw47Dn8KdwqbChMKuwp7CvMOWwr7CiMKMwp3DgMwofCscK4w4DCtsOgwrPCtcKDwqTCuMKrw5rCucKhwrHChMKhwrzCvcOIwwofCpMOIwrDg8OgwqCocKDwqTCwofCpMOiw4DCtMK6wqDq8KDwrHCtMKrw5rCucKdwqfChMKhwrzCvcOIwwofCscK4w4DCtMOgwqDq8KDwqTCn8Krw5nDj8KdwwqTDgsKxw6fCm8OWw5fCqMKiwqzCrc', `Top` = 0, `Visible` = 1, `PostDate` = '2023-06-02 01:42:44'
# [02-Jun-2023 01:42:44] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [02-Jun-2023 01:42:48] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [02-Jun-2023 01:42:50] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [02-Jun-2023 01:42:53] /finance/root/bg/ajax/invoices/form.html?_=1685659377136 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
# [02-Jun-2023 01:43:01] /finance/root/bg/ajax/clients/select/type_0.html?keyword=free&_=1685659384414 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrHDhsK6w5rCp8%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rHDhsK6w5rCp8%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [02-Jun-2023 01:43:27] /finance/root/bg/ajax/invoices/insert.html?_=1685659410676 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 31 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

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '10364', `Language` = 'bg', `PostDate` = '2023-06-02 01:43:27', `LastUpdate` = '2023-06-02 01:43:27', `Type` = '0', `Data` = '6uPiUr0tgcPbAF41W6FTgWejarddWV5WiTJnWADcQ5R4xcBSa7rIIZbHBFJxSqDPd6wT1JKHoCFKjmCGI3iQVSraJt-2St9MZlN9Ap88M9LR5j8r9rbA-adPKlLRagvxEkEuHbQhKzho-9ikrytLkf5wtKJT3DYJZ2Y457LzpbMABrC1QwCuBjwY9yH6mwWwlFx_oWZXc1mwPgmgnigz4flEopgg7ACOePTaKNWeaGrNph6D-LhUYsc-5qgSbllyLsWpeSiMrxIp9aCtecNU84mQUYXcmrvllVuTKHQ6k9ixxCQw7-bz-ITPh42RYKmSwVW02Rk2NPh4AQZ0VIVfhHhQlWCsh74nqxISCxVWm5eSOJpvBakwj-ngr68sD58PvtO2xyJQUL3_iCTtZgpzmdtxbsQ2ACIqnSP4ieiDunOEdV5XVlTDrqtPFZs-ynsv2ii_SufPCK0wWIH4QDQiKzogHRCo-ZJ88TFdyaABIR-c1iUjYA0Xk0ObaNdimG0c0fgJBbX8fF-dTiIlox0Mvu35eQCCdscIELC-ZYgQ5JF4LxZlGcWpLv7HFA3wEP3tVU-JzdZTZFaIvyeRPYUqS3KzGpRgl6GI-jC3kbAHXOLusqvD2WN5wwT2X8fuTd3Fw1FIPtW-ryY1BZJVNBEnCuzUfZw9dfJGRljLCvB1A1S2PTHGwi6fJ-oB2vtimQp2_Y5lrU6CLrRoimxZzDqxbd7mW1erS4xB1ttb4LSjsiBLiRx0gwMgNjIF67kYKUCr04MhhijxQ5CdA4uavzwUsUburyYa2GFxV52L3du0FuMvDwa9j1dzR8KapF34yFbTWrBCR_fBdeqZptADaifjUeA19OsKBCCeeUH8IOAGGriHudY20YkhKZKqqcVfQAKBFXDKxfX5h2fQcECVArPCtiMV2yc9u-693GCMSABF6cI8lBatSyb9CxS2tn16oGwVt2a-3iUockIcoj-trKfusHmSbAXBq6c4LvUgZxJroR-Gb8dObuG83mTInz9uyLKVcVVpQmrHVExuyQvtE_1ZbA', `SearchKey` = 'wofCpMOqwrDgcOQwqCpMKDwqTDlsKsw4DwofCpMOiwrDgcOQwqCwofCpMKnwrDg8OgwqCwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwrrChMKhwrTCvMOWw6TCiMwofCpMOiw4DCtsOgwqCwofCscOAwrDgcOQwqDwofCscK4wrDgMK6wqCqc'
# [02-Jun-2023 01:43:27] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [02-Jun-2023 01:43:31] /finance/root/bg/ajax/invoices/form.html?_=1685659414777 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
# [02-Jun-2023 01:43:40] /finance/root/bg/ajax/clients/select/type_0.html?keyword=kgc&_=1685659424134 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrjCisOUw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rjCisOUw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [02-Jun-2023 01:44:14] /finance/root/bg/ajax/invoices/insert.html?_=1685659457852 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 32 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

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '10365', `Language` = 'bg', `PostDate` = '2023-06-02 01:44:14', `LastUpdate` = '2023-06-02 01:44:14', `Type` = '0', `Data` = 'HUjokuwSaIHfdjR8qMzKQrAFkB84rl8gJjwLUdh7CRoxVNXth8V1lbGEKdl_5NEOlp5BG49mQgaq65X4toouhI_xIVJ-AVyIh1o3fUnvKwns3x9xTkB441kKLiodMk8yj7JzwO9opFr9si1JxWz4PmQJ5V8mq7syWLzVp2BhTDL2i6MiRpZiiAOgr7z5hb2qJdPFlgHpuFz6U2oqGfCYU3uaJyOqMI58-LJIyb0O2nB60ZxWA4eH3TFWoM0Opumq8VDQriDTn7vSze6QVE0i9fNYXU1WqaHFHvIM126HxUPJsvVKF3JGZU05fgcxR6Qokfbu_M5JSeK91NHL7gIcyTVw8aj3DSxWVagrOX3kcjExO80XSbFN9T-88BvHkU4_SzHBV-O0k0xMcCmbAzB1Y8ZceFuJvBgz7YekUGVs8I59TDsI3TNPDJ8qzTVuwoFPBaIuqKlOtcAkz6GkG6-xekc9jWZ7DMPHKqPbNmojoGWosi3NXplu6CFTlcj6nq4Cvx5DPvXL10NwwuY2KSS01stCjXlKc-ZOD8DIQNGGRO4KtnxTojaOozI_po7owKCJXECZSYKgNgnfOBKzdam1FFpm6nXSY1HoDgN5rI22Noe91oxtwGL5GSLeTqqVNIVpegykjj2JPgzPLtP4CIwC1eKk7LbgyflePj2t0hZ_vWRK1BM4IhEY_EAeTBC8mFw30GWmpgt6XCFndwwwrcuKoTptGWYrtFBz0Dl6RkncbVLcUgyDB135GKS-x1Y_Fi3nXFsjj6BR9otOoefnlmdN3rEiatxjena4IA_0CBky4V9WUA_2yC8aIQj-xOK8PbzdOps6z8WCtRKERmLBJAlsEFdmedwylBLKjOowBHgYBDKKuOGiPJhDIWBlOXxhdzaf3-wJyNfzOXE4Bn0orAF3YjwmQU6TQ3jab4uCk60APKUjyUpafo_3ZBTD32-FNpzSGmXxPvn3-LuIe3kMD7ePhAMVKkR7jX4YvGRAXMj3_OmD8N63Y-TOmiY_rwDNnwosfxKzk3m0t6z3esZEDDnXKwpmwD0de1S6e8gmH01uWbSD74pwek6WbSNMdWdfSdv2NhrNsLYas3fLz1RSR_ianQ', `SearchKey` = 'wofCpMOiwrDgMKlwrPCwofCpMOiwrDg8OgwqCrcKDwrHCtMKsw47Dn8KdwqbChMKuwp7CvMOWwr7CiMKMwp3DgMwofCscK4w4DCtsOgwrPCtcKDwqTCuMKrw5rCucKhwrHChMKhwrzCvcOIwwofCpMOIwrDg8OgwqCocKDwqTCwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8Ogw'
# [02-Jun-2023 01:44:14] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [02-Jun-2023 01:46:56] /finance/root/bg/invoices.html?from=01.05.2023&to=31.05.2023&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-05-01 00:00:00' AND '2023-05-31 23:59:59'  ORDER BY `ID` DESC
# [02-Jun-2023 02:00:38] /finance/root/bg/invoices.html?from=01.05.2023&to=31.05.2023&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-05-01 00:00:00' AND '2023-05-31 23:59:59'  ORDER BY `ID` DESC
# [02-Jun-2023 02:00:47] /finance/root/bg/invoices.html?from=01.06.2023&to=30.06.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-30 23:59:59'  ORDER BY `ID` DESC
# [02-Jun-2023 02:02:00] /finance/root/bg/invoices.html?from=01.06.2023&to=30.06.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-30 23:59:59'  ORDER BY `ID` DESC
# [02-Jun-2023 02:02:36] /finance/root/bg/invoices.html?from=01.06.2023&to=30.06.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-30 23:59:59'  ORDER BY `ID` DESC
# [02-Jun-2023 02:03:12] /finance/root/bg/invoices.html?from=01.06.2023&to=30.06.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-30 23:59:59'  ORDER BY `ID` DESC
# [02-Jun-2023 02:03:45] /finance/root/bg/invoices.html?from=01.06.2023&to=30.06.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-30 23:59:59'  ORDER BY `ID` DESC
# [02-Jun-2023 02:04:04] /finance/root/bg/invoices.html?from=01.06.2023&to=30.06.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-30 23:59:59'  ORDER BY `ID` DESC
# [02-Jun-2023 02:07:40] /finance/root/bg/invoices.html?from=01.06.2023&to=30.06.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-30 23:59:59'  ORDER BY `ID` DESC
# [02-Jun-2023 02:07:42] /finance/root/bg/invoices.html?from=01.06.2023&to=30.06.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-30 23:59:59'  ORDER BY `ID` DESC
# [02-Jun-2023 02:08:32] /finance/root/bg/invoices.html?from=01.06.2023&to=30.06.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-30 23:59:59'  ORDER BY `ID` DESC
# [02-Jun-2023 02:09:16] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [02-Jun-2023 02:09:18] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [02-Jun-2023 02:09:34] /finance/root/bg/invoices.html?from=&to=&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [02-Jun-2023 02:09:38] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [02-Jun-2023 09:52:05] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [02-Jun-2023 14:05:43] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [02-Jun-2023 14:05:44] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [02-Jun-2023 14:06:00] /finance/root/bg/invoices/10364.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Jun-2023 14:06:24] /finance/root/bg/invoices/10365.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Jun-2023 14:19:40] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [02-Jun-2023 14:19:43] /finance/root/bg/ajax/invoices/form/clone/2018.html?pid=2018&_=1685704783024 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2018
            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
# [02-Jun-2023 14:20:10] /finance/root/bg/ajax/invoices/insert.html?_=1685704810098 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 14 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

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '2023', `Language` = 'bg', `PostDate` = '2023-06-02 14:20:10', `LastUpdate` = '2023-06-02 14:20:10', `Type` = '1', `Data` = 'v653aE433a8wlebycGgncBP1SVvSSHT2Gv-7JtTMi523RDcJS8bxG3hNJ9tylH0J_kpLFaE3cujdB3-3_zRnUOlfExFy1cIzn8l8yLI4V61J3G7UMjymOx0QamXapXpng4bF1iZLSIUBepP2XjgbSDZEWjXQTRT2jG_Yvd8dYN-AQ8TX6HGW9cbsH52cfZ2DzFvjjdSljpzmThgrcbsTumM3eHtjDOvebsQCmsTh1DV-4p7qgj74I6odLWcYUxpbEztEUVNK41o4norGo7Zlje9anim1aJYv4Z6BgVYmuvWQyz_maoh0wHXoZCjcLU1Hc94xU6l9wOjVO_Y5Q8yV6xELL24CKXgynmpU1ZLuA6HXirYQ_yqERocJgzREVr0hE4r-kMkPaz721gDMFymQqyx6zXnBNgoIv7txWt5O6aGSUC8mt71vZTyPReSVwr8MmCD4WqibZnky5wXuU8TFgMtfpIeEe68R_sxlIRSdZRGSHcVH3iUwVsHiTwlWTG0DS2AcQEX2sMnlLfFUIBMcBgrdtLZHipNnlJ0QIDGOCr8ZoEm7pT-X_8ZNamMGrHAtU4PkaYaHMfH3YHXiuDVaadRVZlQApkqhLJSodKB23xYdM1rROvBFKbmzu2p-DG2AY9xKl2SNAOAeChY3uML28OWAU-MkqW5NE6x1OhmyVK0G4hcHH3duPWBoxgZ_8XXha2QDe95F0AJGq7OyTQDliQmlvPt9SrjhTDDqxx1ChxB6h9fnbM6eE5KY9Fo5cmsULs7bX2BtUUMOoTImqJEMcWtrZzl9hx3at86hYsqdJOrgAictmdPd1Ouz_oGEi3_WKGVbw3uI29QtShbKVc1NJLK0sqJ1zdjtvlIfUGfXtHXZGbmKtwF7g1rPxsxjsdqvr-cbE0kYUuI1uwBQFY5G2fQu3-jPwl0E2PT-8zmdwhu735kd4A_RJYNt7UQzbesCtg4IDDkbfAZAuVZK4QvB4jKrJxVoHyEVRdCqVTTysZxiov_oqAydjoUkXvQls_ag5zreQwLuM-NTTyFpCfglzz4y6vg81LWgyc2BIdg19bqgY2rKr_Bcf0oxgbZmYJPbFghbk_QH_YhCb01AgPZnAOs68RSDPjWUo61Mkd4g78ux_rgGZRqFjB__OZvdA0WwKnxXfagSIBWYSitRWhBVNWhJ5s8enCn6YBMk-n28HFrmFBJPWZ8Mveaozf-3Bxy1lmScbbTYvPKSiZjtD1gBkZtVaMIVNYoCI6D34l2q8Zg', `SearchKey` = 'wofCpMKjw4DCt8wofCpMOqwrDgcOQwqCpMKDwqTDlsKsw4DwofCpMOIwrDgMOgwrPCtcKDwqTCo8Krw5vCpMKdwwofCpMKnwrDg8OgwqCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgM'
# [02-Jun-2023 14:20:10] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [02-Jun-2023 14:20:12] /finance/root/bg/invoices/2023.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Jun-2023 14:23:02] /finance/root/bg/invoices/2023.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Jun-2023 14:23:12] /finance/root/bg/ajax/invoices/form/2023.html?_=1685704991503 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2023
            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
# [02-Jun-2023 14:23:21] /finance/root/bg/ajax/invoices/update/2023.html?_=1685705000249 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2023bg', 'OMKqGqdnbS9l-zjjsy-QNqqNJktjAdAM09LLvLfgValyNJ3TD4H2ieq6KgPEhmcWD6z80RjBfkwte-okc29oyWkPlpus_xDVGhRpDMwjAS0MhgSbh-DnzIxGQFH-C5ZhvSK2WweR0ryQYTXbAIZs6FgHsF1mILAudi9XJxaLzld2y00KsjGFq7UfufngCVMC_uLb7kqlhdSZjZnOBB_nZuzpYLmD1tWZUtwcRF25xRxrsyrMO6zMcQhr4blS-mPNuX5pvnnARM4rhOKqxX6tt_IdjSEnZsDzH5kGFo8ZRgL3IdGZze99WgC9G8Dk7bBeWkXviXCQSA05f9BAfF4hfuJMY5pfo3lRCfwlOSkkQv-LCh0Zsipczy6H98xQo6TTpvpWBKVmHAGYGnWndfBcRUoZ-0O5yE2cVJGhHJ7RIjq7MK5SYVoCfqZ-sQ1S6GetIGPvhMdtfYRGJI5zaMxbEHzEwDQ0-5BKEgeHxIkgg4PyZZZ8aHvoURS_q1KiPYEr8qKhcnQEaHAYZX_pHpAyH3uiPZ7pE5cc8PdLODMm1f_h3F-J-_oaSRZxAJVmy0tOg5obe7tgD3kWPuKsM43ofDfMWYxxsLp811XCcaAG5cHTg1G4yqcsINL8IOdnO8lknCWxvzkR9iNz5cRBgVboamhs0_n9h1uYsKfpWBm1FIPOCs8-8RM_bOeQB7pMO3MipCDccmulb04hgA6dn81vk9_KwYrkTxb4wVDg_XE3B5WNdLn0OVy_f1g7BwCdSO8vptTO9PDb14StX_OFXex1kZZdOZQcVNwKqvi2lEVRDZU1zCZz1UDJx4Ek2ElMYeoWmMql9EpXEd_vIOC-_IexjxWa9e27_HHnx7gB6SvivCT8CGJX2vIsmKI3m_WGksTwnVSt8RK9KWfDfcvbykgWRGu17T_Hw6De4dKVqLm7JvfcTtU8tr9rHP1w26o03giC5DPaRUAMoI0X7rA2RVePDlqfUNqU_Oso1JdIvcAEgEm7SwgoaCd4HM9CdCfhOb-ZKaDxWsiAVxKR7kCuxCh1lK0SB_-e4hWAVhQi9t_nv95U6K-XIOZv-v0sI1Hqi3uzZwxeZCiR4-uqSIN8CC0fxOidBk0rCRszY_JW8-JHZ-HnAApzA2osDBw53-Iuphf_0mEsiqSbJELnscliZMv8tz6E9nTeQuMqWXHWF2TZ0xcxSMWx5oBbKAbgWuBHSuTAeM8AiNC6KidD-hxqwtw6BV7C5LWz0fZKCVxgmLgDyEiY9lGAUWzRckscKItsvjKcFXKLGSqmEog9use8EOL9Usau2eJXzpKSRSAG6nrv3R4AEGCVvdkiwuN1By3tYNxOHeXsFk51Kp97VFpPWQsLP4z4FMnCJHjQQyMHNzvkaX5jxlSnRC3qL6U3xGtzH9l_zge9VfITBxcqsyqU_gPeJbkFOShowZ2-qbu3jeIqDmW5OrDfUm_HvLIMH6SRzIL4_w2Lg7nlZ3l2tdYkFTf19K7b0tUGNmq9XKxs7JTZMKJuv3tTY-y4fWadg8C-MznimYYFFlYPVG1_CA9G6j5vt3kh_qubdX1m0q1EfpIc5eTqCqfzFks5qyY8FW1bv6aGYUP9fQ_trij4AMkELv4tvROoOHj7AgLE2e87MvoPdtWY8y91ILpAyxzkYDkTVi5LLw0Pp02vlBU_LQzFGvBX26kTOcoWEkItWlo_dLs6bXSTy9mpI7wLOtIG85OIhU2cEDT-WFr4IBuQoBqg_aB86RsU3LzeySUg7peJ2VDEaYScHQP8Vbp_b77oqpVf3VzrqDnGjkXls19NW1aLupmASskUrjn9PoZo0HOWq-opq320-lN3Hap3fePX6flPGxheKyPHe-jZySFngSnKHB22CizOaltCxaM_YkYeMAutd80rLSx6ys8O0cZzocgkQ2Vt1vC8u46YXy1mfRDaZBJHAP-q8lZarmdjA5Rg_3jfoLTj_VRp_fMmtOAgKBD4GYSUiPjYYzQiSz82Cf0vJObliLR95YGFoTClH8fK1uagx208pfCT9E_9iPAZXp8a2ZSHW1T7CHsI3Xdejy4Ntfn9gfXiHIEnfaxSy2r0nQ0s2MVyiFCx2S8baPkBXOw1LavAaYT9AG0rwSAa-1JEVNP-g73FHz1WJVyGUndCHmeimmI88VjM5iXeK7cEpiflAoZ8wtRNsUovd59pmUBqynMa-9dPQJfo66dDjW1CxyRdbOGRfp2bCqJ-t9sURcIdY2t9nlKTTGXTCSkHBsoWQosfdG-HG45e47P6wLWUhpX1w6Q')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2023', `Language` = 'bg', `PostDate` = '2023-06-02 14:23:21', `LastUpdate` = '2023-06-02 14:23:21', `Type` = '1', `Data` = 'z0a9ujdym7fzZeLiwQI7y_L0jLHVm8ie68BB0TUMETYSAIS5lvYjmfMRLiGThJht4okFPDeCT-O3iTqHPqv0iwUxq8RK5D9hMZ7Pu-zHZ_AoCIpbp90tXEcuPyvFOvxA5lvQ1XuZ4gqeWwDdLA01lbgcuRWj-5uzY3535l0KHzgI9ekrIuwGJh9BxXD-_Qt1BfGirHTEX5WbazrkTvyTeB-ej0xK8Bl95E8rjZ_EDNV08CzWRXuJALBTpMGpJ30xqGvqAyN6RcW9sofY_leWJLx9NnfAOxc5V8SB3Zpl-dO9JYf1DH82g5E6csPPmmfNUdFlIiIhyAQCEtlcelQyGLv7o2TxMgregODW4IxhjDLKuBovw8EeweMZzszhDX2YItoXhIdrzTUqU6jPCn0nwAyXwYZ6R7zWEATcz6liaNBJZ6GXVJDuQM2AQOGCaQiWNyU_oCdLXq034gAlMmpTIiN-cLb-iCGXjtuBNiB6-bix-s5Nn3Su53Mtj8bTjaW76i1_QPRyzHe5pSxMTxL7qIDJNyCyA-APqdTsaT3E55XCQsqWPX6o6jtwT96D31JmXrvvAG78kYFmG1x1UMOd4DEJ5wdOa9tY5kiy2m2zyXMwnHIUeaNP90zVcPNKyWuMQcIRY9the372vBxNzMmNo1nbYT7FPWUvCBDlllYao0luZIuK953a4e3PHs66mKYubDmYrRn6t1KBiBibP5_14kn25VwM5zsowZUS4UbqeKgC5-Gh65R3KTurXOItTXJdlLyG5rrYO7DjKpU4nV17cu4Dag_YdGYOuE0QMu5BmHWUV_jAkKMcxYJpn1PXThfOY5PiaezhBSAQIqXGuUwoktX0Rl5YYI9Sj4FLUcRDmrrTCPqd0vM7rqYwyYrHaAniQl-Hd_ugHme26xyEC4b3wMxCerpx9GgpiHHgbMHcT1SPp_PU99QLstJkhzU1XwZE8IdZWIX_PQxE-bGb5RW6DLuiz638cx3_Lc6R7YrC1ic0LLcdFzJCD7WpmCBuLkTD0ITcoJVAs2r2TfedB993sai_ql-lqdqI6PLowAgtsx0GLaJiNpcElWcFei0abnkOkocMYRIlCMvAlBn9lz3tZbPAKY46bGjwNF6hIFGBcumSihCKSe0OSGmB2KGXt_AJkyYDMNPHt2M0R433VBbUe5KtLmTXXUy_gjSUAgOXUww4gAZ6qyXQhVhLW3cEwMR2sSzPmrhB6o6rkuIjBFGDMG2fPpeq0gWtxjYa_URpxjE', `SearchKey` = 'wofCpMKjw4DCt8wofCpMOqwrDgcOQwqCpMKDwqTDlsKsw4DwofCpMOIwrDgMOgwrPCtcKDwqTCo8Krw5vCpMKdwwofCpMKnwrDg8OgwqCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgM' WHERE `ID` = '2023'
# [02-Jun-2023 14:23:21] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [02-Jun-2023 14:23:24] /finance/root/bg/invoices/2023.html 167.99.142.201

set names utf8

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

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