# [06-Jun-2023 09:58:58] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

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

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [06-Jun-2023 09:59:07] /finance/root/bg/ajax/invoices/form/clone/10366.html?pid=10366&_=1686034746174 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10366
            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
# [06-Jun-2023 09:59:13] /finance/root/bg/ajax/invoices/insert.html?_=1686034752080 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 27 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` = '2025', `Language` = 'bg', `PostDate` = '2023-06-06 09:59:13', `LastUpdate` = '2023-06-06 09:59:13', `Type` = '1', `Data` = 'He3SOCTLKLFj8jkIL6q2KlNQi7EC6YhQWngZJjoeCLPEia0ztykVNdgVOrusZktgvJuSS-0_4jVwWdYIHZuGF7aBFDgRPUzx4ODh52bDG-Fdq_Xo0lHboSLcZ68cq55x5vtkO7ei-D1kawcg01iTV_3rLbDFVC4mTHfwHDj7brKko8d1qRO4p9FBYXqkfquVjqTrflWoS8O3VMi1U_kGbNndE1mLr8tuUqVacrDHb2Zi4ipAt0IhYdQ1dylzfwUfTbynWa3aHgcD3Asg38vGRcIIRJB7dcm1KsNw0fuYYlXuN0P-JqQowlVnw5NbH5EusE714H0p8adVybnJcdnU0uATV8j2XtK7-I750Rfe9lhdzlKqQBsw9TNRmunKT_IEKj2K3XT8ofZeou8XyhWhrqD4Y9Kiz-bwWX7ts2SuBObXlkoyQgHBV3jKnI4z-YJVJjyv4pWQH-R4h8BQLLcP0mFfUYZVsZpz4CmEOFixPxMciSY7JnZnPdiOEQwGqQnOlhNMOHj4eIIpi_uuKHyDHihUQ0R-kNWvC-UZJ4cD5CERH56G7FNwQsntVpCx5wAOZGzRBnuU5c03R0wu6FP2_Y4qA071VCgT9OXDQ_34CAEctEj30tecee2KKUyzZZn_G5tuxXIX9IY81F--3JLvlPoFfGuKXHc8TqpkQkr20ajG9hKV_SNOAH6Unp71qWXP-1Ujmt4XXDJ0QO0dZcSaK1wW2jklVhtQz-AKimbD6jshOuOBb2tUWRUi0WZrCuc4UBEjY5m2MBu3QTWsPZ3qzAyLZvwbisHR6qs47-byc3EaOBSSLTG7qaj3-_kWnMRczyu0Y_F5MWCDsWYgyvCHlhm-KMBLkfcav8hFDiA1cvuyg548RvZyW6D4lamSfiwWcOuPQMbGfp6rf3zyMdWezQJbV1Etqf_s3Zs5bW64R7JriqlJCPlsFknmcsGLYJdVtJbyMsyYvyepqlzlP9TUiyo7T-3MXc1OXj9wZQL7au3vhD-QTdtgix7WJ1zTjeIvkxObvErtimqo2WlZnjfJLuM8H8MUG80RtsvtLtUBvtY', `SearchKey` = 'wofCpMOWwrDgMK6wrPCusKDwqTCsMKsw4zCucKdwqPChMKhwqrCvMOUw6TCiMwofCpMOIwrDg8OgwqCocKDwqTCwofCpMOIwrDgsOgwrPCtsKDwqTDi8Krw5vDn8KhwrDChMKuwwofCpMKjwrDgMwofCpMK0wrDg8OQwqCqMKDwqTDpsKrw5rCucKhwrDChMKhwpbCvMOXwwofCpMK4wrDgMK6wqCrcKDwqTDhMKsw4zCwofCpMK8w4DCtsOgwq'
# [06-Jun-2023 09:59:13] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

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

set names utf8

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

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jun-2023 10:00:27] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

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

set names utf8

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

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [06-Jun-2023 12:59:44] /finance/root/bg/ajax/invoices/form/clone/2025.html?pid=2025&_=1686045584816 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2025
            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
# [06-Jun-2023 13:00:15] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

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

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [06-Jun-2023 13:00:44] /finance/root/bg/invoices.html?from=&to=&keyword=photon 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `SearchKey` LIKE '%wrrCn8OYw6TCscKzwqXD%' ORDER BY `ID` DESC
# [06-Jun-2023 13:00:53] /finance/root/bg/invoices.html?from=&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [06-Jun-2023 13:01:01] /finance/root/bg/invoices.html?from=01.06.2023&to=03.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-03 23:59:59'  ORDER BY `ID` DESC
# [06-Jun-2023 13:06:48] /finance/root/bg/invoices.html?from=01.06.2023&to=03.06.2023&keyword=Елдомремонт&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `SearchKey` LIKE '%wofCpMOIwrDgsKlwqCpMKDwqTCo8Krw5vCucKhwrDChMKhwqrCvMOXwr7CiMKAwp3DgMKUwqTCrs%' AND `PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-03 23:59:59'  ORDER BY `ID` DESC
# [06-Jun-2023 13:07:02] /finance/root/bg/invoices.html?from=&to=&keyword=Елдомремонт&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `SearchKey` LIKE '%wofCpMOIwrDgsKlwqCpMKDwqTCo8Krw5vCucKhwrDChMKhwqrCvMOXwr7CiMKAwp3DgMKUwqTCrs%' ORDER BY `ID` DESC
# [06-Jun-2023 14:15:32] /finance/root/bg/invoices.html?from=&to=&keyword= 167.99.142.201

set names utf8

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

set names utf8

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

set names utf8

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

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [06-Jun-2023 15:13:06] /finance/root/bg/ajax/invoices/form/clone/10363.html?pid=10363&_=1686053587249 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10363
            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
# [06-Jun-2023 15:13:13] /finance/root/bg/ajax/invoices/insert.html?_=1686053593995 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 30 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` = '2026', `Language` = 'bg', `PostDate` = '2023-06-06 15:13:13', `LastUpdate` = '2023-06-06 15:13:13', `Type` = '1', `Data` = 'W8ujPhtlyhECzUQgFdzE-jtBjD-5Hm6VCOZJGesZiKYsif1tsBKKCFcfNnOY4-4BhB_2IIiy_QAO9qp1W14uqIfZOkwWmxfzAQyzCC2mU3aq_yFpaiJg2G_KWjEs80W-rCr9FpX_F9jiP3aI3hb9ZnmoZWHNSaKOgak5Y2ZKj4Ce8mpC62G_sLoMKtwDBA0uCQ-88x6yQQwXMZuqiLGAiioMsF2Lk0gsJfi8-EGGouE0B2X0xNWKryzu_ydpCwgG-XPyozL041_5wXhLKwkavnp4mRUr4oIW7Mb_QlAofgcsmsMPaJXPIQp_tGbOquNa6U4EpS0MPzRzIZSn7WLbjZoqUPgdby1UbuV-GHAXra1ZnTi7d4cdbq9M5UuM8sEZ-B1JcFHZb-8d-_dUiW3zCi_9GkIdASOHqh-3vnKCBcjdGyUEJJbQcss3tsvmSljN7XPkosK6aY7FN5NglO6Alrnx8Anawjg0OiQe7tALwNgoleamoHzXX_ziv0ktDmAgo2GQlr5QcT7ZpuDkxZ6RJXS8lIQSCk8-v-BjzkGkmOPh1SZ1vlq5rYP6XE3AG4NSAkoR8mUM7H_KHoC4WflFtyYBCJ83X0C9-bYgWpt_FzhZ8ufa42eGlOEfNPbapPqd5oJumMwzosEPnoYuBFzIQfn67rh8QFbSjBDuSLPay_b1lXyI-cP6_k5csXLxq44lvZB1e3WdiCKsChPTmqUjtolRmYg8HLTBcGRGC-jw7zvAVDlt_iKl63FtcmBlhaY5wYKEeolet0mqYgxL2vbgNYpsFNnntN_1W4TM2HRElx1vHjb0tyQJpRmd_tpCCbOR-US5QzD3vm5YNTrzIv8nZXQXABjkW-3ILB8QCC3Jxzg6q6itC5pEsXsXSaOFw9VtkSsBRaEIpjHwDX66mzhS1ddlWHIV3pAW4QtoEFZfMHEKwcYgmqCfC61SlErUVLUZkMTUhNUw1Tct71mzW5eUa1caxBRTWLOg8uK52GFY4D6UUo2wCFeSU4In-DWT1UJJZSVhNxa_OFaZBeY5RkdygDeaucloYiOLOg1PflF8J-_G2N_4CFmyvwq-vTmp2g1U', `SearchKey` = 'wofCpMKnwrDg8OgwqCwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwrrChMKhwrTCvMOWw6TCiMwrrCi8KwwofCscK4wrDgcOQwrPCtcKDwrHCuMKrw5rCucKhwrTChMKhwrzCvMOWw6TCiMOKwp3DjcwofCpMOiw4DCtsOgwqCwofCscOAwrDg'
# [06-Jun-2023 15:13:13] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

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

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [06-Jun-2023 16:07:35] /finance/root/bg/invoices.html?from=01.06.2023&to=07.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-07 23:59:59'  ORDER BY `ID` DESC
# [06-Jun-2023 16:07:57] /finance/root/bg/ajax/invoices/form/clone/2026.html?pid=2026&_=1686056877491 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2026
            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
# [06-Jun-2023 16:08:24] /finance/root/bg/invoices/2026.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jun-2023 16:10:09] /finance/root/bg/ajax/invoices/form.html?_=1686057009546 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
