# [09-Oct-2025 09:56: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
# [09-Oct-2025 09:58:34] /finance/root/bg/invoices.html?from=&to=&keyword=remed 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrDhcOGw6LCp8ODw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [09-Oct-2025 09:58:36] /finance/root/bg/invoices.html?from=&to=&keyword=rem 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrDhcOGw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [09-Oct-2025 09:58:42] /finance/root/bg/invoices.html?from=&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [09-Oct-2025 09:59:00] /finance/root/bg/ajax/invoices/form/clone/2464.html?pid=2464&_=1759993140044 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2464
            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
# [09-Oct-2025 09:59:14] /finance/root/bg/ajax/invoices/insert.html?_=1759993154497 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 74 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` = '2567', `Language` = 'bg', `PostDate` = '2025-10-06', `LastUpdate` = '2025-10-09 09:59:14', `Type` = '1', `ParentID` = 0, `Data` = 'hIvkPDOHh3XvNZY3HTFo6h9Rc_qySg06zAN9rDuQtpz5DBdu6s5L4ydymw2HXe1ZR-IXsEA7HbZ88hcZyeKkWUM5jMNG6rXfoG3WKEhjcqr00NDZHextWLaw8lN3I0su571KPS_5KB8RGfPWM_NGbIZSfiHSfNeyEE-g-1CIliTUYL9c7IlHRDYxl7NymaIVsKgD-qcE3y61pD-BCILaDIerDbzMey7w5OIzlnQO2bs5Ua01HzFh57w6aPY-r-jTrrT0Af27V401nL3BdfMDUVih0ANv-h-rXQtg7obo3fb7bLp0NzldP1_cAO2Fda4OTgCUJXoGeW9gtWYlMiSdpMs151iIXp6kW1_znGobFfFSN36qQ4P3PBbX54nZkXhKdmBM1gvP8yFg1ee5RFUCG14sA-8CC0bO5e9ElzbIYWkYuxFID76IIsdSwCN6k_rudLDfE2r_spbZ81oVnztU_GhuF79jeblV8_Pg1RcSpda56YReCPzlrmazdOyig5_nATKzHg3tcl-LSgGLicbZ4dq2Vnp4HaIJtvyH1UfnecY5MtQDA3hsQtaxBk8T62iLqhdgXdAMEyFOZyDvFBQn4IIQexCvxyADHJbQCR_C8G_4x7nochF2UcxqWv1-vLLnRdZirrYhAv7g2yqD6vq_-REZBbj1k7vHJIkzA2obeQ-QvPSLJo_SSAHGdW9jGQyrC0OVr-YzvxVmaGZnQNPdOqEvBR8PuRHo7GflMDoN40tRTdGZSb4Z3DlklfOki_5-8mfpo7QfNtVEA1DRnO-ZzkfJxwm6LjzIoeI0qA7bV03pAkLbcBjzCNG3MXMvxY2I7Or0SN39FdDYtxaq8pM57jCfhVgThsVlBsyv5T_nQ8lMbsxQXxuzm9f2WqNua8nVu0NW2uShtSupYVb2vHoUW3vbWTOijmkGdLCUU_W3UZ0', `SearchKey` = 'wofCscK0wrDgcOQwqCrMKDwqTDhMKrw5nCwofCpMKnwrDg8OgwqCwrrCi8OCw5rCsMOZw5jDqMKswrDCwofCpMOEwrDgsK6wqDrsKDwqTDlsKsw4zDn8Kdw6bChMKhw4jCvMOVw5TCiMwofCpMOqwrDgMK6wrPCtcKDwqTDnsKrw5nDj8KhwrLChMKhwrzCvMOXw5TCiMwrrCi8OCw5rCsMOZw5jDqMKswrDC'
# [09-Oct-2025 09:59:14] /finance/root/bg/invoices.html?from=&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [09-Oct-2025 09:59:19] /finance/root/bg/invoices/2567.html 167.99.142.201

set names utf8

SELECT
                `Inv`.*,
                `Original`.`PostDate` AS `OriginalPostDate`
            FROM
                `invoices` AS `Inv`
                LEFT JOIN `invoices` AS `Original` ON `Inv`.`ParentID` = `Original`.`ID`
            WHERE
                `Inv`.`ID` = 2567
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [09-Oct-2025 17:27:05] /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
# [09-Oct-2025 17:27: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
# [09-Oct-2025 17:27:12] /finance/root/bg/ajax/invoices/form/clone/10469.html?pid=10469&_=1760020031116 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10469
            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
# [09-Oct-2025 17:27:15] /finance/root/bg/ajax/invoices/insert.html?_=1760020034313 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 81 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` = '2568', `Language` = 'bg', `PostDate` = '2025-10-09', `LastUpdate` = '2025-10-09 17:27:15', `Type` = '1', `ParentID` = 10469, `Data` = 'D4j2gpXBJJC9RTeZkv7okKkXW7gYZUUlJmNa3r_7xzEfY9W193StVYrVrM_MmzTfIcl4suQstGtPbmDXNfYkqAaIMK28blY-dOEVbE7KQksJtEhvn6HRCSDFRBZfHHV2FW0WgeqZnjmFABfpxEIL4q4niTTwobzk93rVaNInfXj52RbA0jVp24yEE8k50P_Hs44ZlbyaQp48bhohq8sOwJlnsosvwLdf4jpbtHYmTf38uZtKYAROtAt-Vmjqks_T-GOKXg90JKhdASeMM78E2NR20QhQg8LBQv2AiG4jfchRM3oVepgLjqFjJzF1zZEANPyVs2Wb4XAELzve0F6s7FSC8VnpwCykLKYw3biogJbpJBPwMeN63o0hkbILxRjwZYV36gmqUkmyEOlI73Vkbvyv233YuWL16IorkUEYWVmF-k6OusmO--omjN_ZfL_tDFb7-NPBZWIBh_Q2hJ5S6hNePVacy94mdF7Ib4n3oIrNy6xxCLEYnF_KAFT6u61oYajrn82Zla4xWZ0E4AroFY9Ochdv-ApKL308wUNLFKG8l4uWLUOWYx4nMwjLGvuU62OWqqgcXffr8AImqCkieAps3uf7KWZFLarjAtOPHczrR-rBWscA613VeNqX43_G7pRAbaYI0b5DWA0erpGi0LMojf54DIIczlHJ8OVX9Ay4qMk0xreu-CWQJFBJGCv2NBZzgp7e7y7SfdB8r7TG7c7R2kdWg8DVzeZd4bDiFA145TXNXvb8jT53E-rG5fvnhAEKEF6Nfvlu4Xyv08fhWIJYVUMtzeV6ImBuiF_86SOdPKT2DZ6rpH62LRjwIZnqWcnTljOKFNFZITh_IzLDb7YIS0hPTRNsHKjfOiA4n7K_W0jQGt9wNzlGa5SsPH7ga5M6-HKVH_GugBjPPmRIUycYwadpyzGj5mcPH3ldhUAOh8ngsVfMff1R0l-Yjg1CXU1RZ9K19u9aRxNg5IC25qM1nJNyWKFuh8T48Qh8bsoKMrkZLAv6u0ARbzQ60fTUgvd9BjDuZ1eT5d1ncYI0hwW59TRtCh6NKmGkRLxsfMfFXHMgDPtPrmNzVw65yE1cVvaZ6Az1fYTsyA-jzfMYMHwwnAA4f9Xe-k51QiYniEbZlPE7Y0iYD-0PR5lJuo2tAvVm4RQDMcdFmceBIzkVtsTI4QTT7KrzeQmCyNW1HuM', `SearchKey` = 'wofCpMOPwrDgcOQwrPCt8KDwqTDnsKrw5vDwofCpMK0wrDg8OQwqDrsKDwqTDhMKrw5rCpMKdwpzChMKhwwofCpMK4wrDgMwofCpMOIwrDg8OgwqCocKDwqTCwrrCn8OGwp7CrsKewqXDnMK1w4XDkMOGw4fCssKTwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrD'
# [09-Oct-2025 17:27:15] /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
