# [27-Jan-2023 08:27:11] /finance/root/bg/ajax/receipts/form/clone/3.html?pid=3&_=1674800834938 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `receipts`
            WHERE
                `ID` = 3
            LIMIT 1

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 1 AND 
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20
# [27-Jan-2023 08:27:17] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` ASC
# [27-Jan-2023 08:27:58] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` ASC
# [27-Jan-2023 08:28:00] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` ASC
# [27-Jan-2023 08:28:51] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` ASC
# [27-Jan-2023 08:28:53] /finance/root/bg/ajax/invoices/form.html?_=1674800936516 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
# [27-Jan-2023 08:29:14] /finance/root/bg/ajax/invoices/insert.html?_=1674800957855 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 2 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` = 1, `Language` = 'bg', `PostDate` = '2023-01-27 08:29:14', `LastUpdate` = '2023-01-27 08:29:14', `Type` = '0', `Data` = 'w84KA4iUFrVRUVvDIgvHIXFvyY2xPvjWqfTSxnAF4jpBLcENJSQ7ScwUqZqEyXNPSUotJVEH8EAZgqThtc9Z5Nznd7oP_C3q5dxJ_xdLS4rmiVkJcj5NocEliVNRVPKaVTpSAd9meexKcSRSBxbBLAWma2NLqPAUyOyrLwNYzJ6u6JS9c0Aas2W5bruOpZcUpNMK2Rmw4x9p_euPNxlud4jxOd66yb7bm4BCAxK6lUAHAzEXDtxUIijfDbJIHAZH5ooFSyWrZK0FXrXTBaXE5Gm7epTt3sQbEf34GKtylfWqb6mru0rVzglEUe_lt-wYUE-soNvt_9BZUrkGJRSKzUycpZHVMb7-T_q5YCmwGXvIlIcIudJAIRNhCvtCGg6M1XAq1UHg7BNhdS7MDv58tdqHr0V3QShx5UqhPPCI0ZgVIsJFraE83cfsEiqDgwJ4am1M-L0zBmtpVLepur7uk0_1MUg6b_A_AEjxZ-axgDOKZVawh_b8JLHgYhIF5XdVqiwW8vSVo1s4McFt7vNWEbBDMO76Bp-cOGgd3XSXkc8TTDpLCFVIUmmN8d5as39MSTCZ4qXAQ7HwD5dxuDnGwaO8IbaEJMTey5HooY7MP9PqiPMv3u1gcq_ms9I0GgrgrCdNS3zctkzHcGAqhnVcZv6QmLc4kbnK1yzUQgGL-n_vSkFLDdEPXtxSEzfzAmZQQzOKY0PhQjfpiz7WCw9sNL4fJMc8hbLwbwD8sFcOR_khTZR3iFwmkOp5Q5IFoab4RdK4M6U6yXylEYsXxmEGNfEpn4JsReXT0EnJqgHppEn41_U5ijm5NtC6q5T-d1HvY4c0uiYIN-JAmxfZqsUruaRz6YdE0gMoxTIaSUVrhP2B_vb_tIDpjXc0gOTyjlw9epWDxKEWxo0ObJOuJmVBVnHMHPhTUc8VDsbU1FDZUSs', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrvCn8OGw6jCsc'
# [27-Jan-2023 08:29:14] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` ASC
# [27-Jan-2023 08:29:22] /finance/root/bg/ajax/invoices/form/clone/1.html?pid=1&_=1674800966188 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 1
            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
# [27-Jan-2023 08:29:31] /finance/root/bg/ajax/invoices/insert.html?_=1674800975084 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 2 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` = '1935', `Language` = 'bg', `PostDate` = '2023-01-27 08:29:31', `LastUpdate` = '2023-01-27 08:29:31', `Type` = '1', `Data` = '3eh7FeWsWf0H2CEQ33V0zaaNI7vdScHPfQ7Bh31cUL4ouE7ZK7NxReaQ-APdOC7xBoE8gxLQJ13L8tkkf0w-2CnBJs9cvVdrvxOOEEwwLbDpS7FUP7415Kt7JsL_FbGZbWHpPu9P2wBGip8zjOCEYqZqE8Orw3dB41lB_WYj6PmzWzMJ19UO4UCZxueptSOt0HRDZWuSC7twyAddT4MgTxb3nWWM-y0w3MhLDUSU38RocfWXMPj7CNDNapG54wifGdKZfsZyudZtg28aDNN6Qk0chxsY2wnA5BNlawkoZ40swd77oMdFXgmzM7Nlf5C_-2SoDIxGfJq5pCOuSlo3rRvuPaHAd6u2srPXuYBOSleK5g2MI0yRc8SRvH8Hmpb0Jgxgg9dnlTXdDKRmkSXtLZOE_c3RmFmFMku0nYv6MPkGRQSOwlRsBzT69EKXFNINuTwBiP2GC4YZe3R7h7XBXlVnNfcde2aUoOEQhHljXwiDDuO4cVQ5H-DgSxy03zc3e9zlxOyDv2X0kRmFtniHy0q6t_zYLGy8vbBCefsIYfYTpnGDEbdrfPvxiDGN8FQI79Wn-pFwVtwXnrpSrI6Dpv9ZmhPU5jxb0NCgu30sCumh4tEAULwN7aNr9PESuDRP3cEr4zqRtYGHT4K29KJOVBpLE3H07hd69L8u3K7gMEF44t1KYtUyALhuRJtH4rnxCqdc89JUa903ORGSXVbtwouMWWfonQbXNm7Wt3S1sTYBFfF48PkRzuffD1gcWB1hj6b2qMmjUja-3TuDY_eTK69fSYOjtxhoapi-sahGcoVTnQXVNUE-I6eNdZUec7SmJbPh7QmUsysPx83uRDJIiWu0FBP_kQyEtHYZ2mRpVbC6UPfsyd5Rcn2Z370Kxt40ss4j9i_azW78_agDxGVT-0JhZ07xAbQtwevsbabYV3g', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrvCn8OGw6jCsc'
# [27-Jan-2023 08:29:31] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` ASC
# [27-Jan-2023 08:29:38] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` ASC
# [27-Jan-2023 08:29:51] /finance/root/bg/ajax/invoices/form/1935.html?_=1674800995091 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 1935
            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
# [27-Jan-2023 08:30:17] /finance/root/bg/ajax/invoices/delete/1935.html?_=1674801020976 167.99.142.201

set names utf8

DELETE FROM `invoices` WHERE `ID` = '1935'
# [27-Jan-2023 08:30:17] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` ASC
# [27-Jan-2023 08:30:21] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` ASC
# [27-Jan-2023 08:30:26] /finance/root/bg/ajax/invoices/delete/1.html?_=1674801030080 167.99.142.201

set names utf8

DELETE FROM `invoices` WHERE `ID` = '1'
# [27-Jan-2023 08:30:26] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` ASC
# [27-Jan-2023 08:30:28] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` ASC
# [27-Jan-2023 08:30:48] /finance/root/bg/invoices.html?from=16.01.2023&to=31.01.2023&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-01-16 00:00:00' AND '2023-01-31 23:59:59'  ORDER BY `ID` ASC
# [27-Jan-2023 08:31:25] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` ASC
