# [19-May-2025 10:46:31] /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
# [19-May-2025 10:46:37] /finance/root/bg/invoices.html?from=&to=&keyword=arapyasunresort 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrDCsMK6w5bCsMK0w5jDnMK2wovDgsOPw4jDmMKww6nCtsKIwpzC%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [19-May-2025 10:46: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
# [19-May-2025 10:46:52] /finance/root/bg/invoices.html?from=&to=&keyword=tropicana 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvCoMK6w6TCsMKzw5jDnsKswqCoc%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [19-May-2025 10:46:55] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [19-May-2025 10:47:17] /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
# [19-May-2025 10:49:01] /finance/root/bg/invoices.html?from=01.01.2025&to=31.01.2025&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [19-May-2025 10:49:06] /finance/root/bg/ajax/invoices/form/clone/2408.html?pid=2408&_=1747640945958 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2408
            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
# [19-May-2025 10:51:14] /finance/root/bg/ajax/invoices/form/clone/2408.html?pid=2408&_=1747641073908 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2408
            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
# [19-May-2025 10:51:21] /finance/root/bg/ajax/invoices/form/clone/2408.html?pid=2408&_=1747641081868 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2408
            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
# [19-May-2025 10:53:02] /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
# [19-May-2025 10:53:19] /finance/root/bg/invoices.html?from=&to=&keyword=sterimar 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCi8OCw5rCsMOZw5jDqMKswrDC%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [19-May-2025 10:53:23] /finance/root/bg/invoices/2391.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` = 2391
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-May-2025 10:53:40] /finance/root/bg/invoices/2462.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` = 2462
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-May-2025 10:54:07] /finance/root/bg/invoices/2408.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` = 2408
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-May-2025 10:54:44] /finance/root/bg/ajax/invoices/insert.html?_=1747641284874 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 75 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` = '2479', `Language` = 'bg', `PostDate` = '2025-05-19', `LastUpdate` = '2025-05-19 10:54:44', `Type` = '1', `ParentID` = 2408, `Data` = 'Ja29sU_pPEQEnN48s1nFrRCgZ5NdCIxsaDvhuwyVjdsWHvrU77DrpM0pP1t8bL5I6M9DCQNAyapj0gv-rESZ7-O3Hj7W-_0gI0mjoZfXp17mqPIy1KrGUnNNuJSocTzMScTfqp0isHEgNchmMzyruJucIiK_jif8YEcHrdWdC0ZTHMN5KQ6U5ZIQvQnE6PPxQWV6-IQwxl320U8uikPnzNqvST8g-r6xOqAomqCy7rtlY-2LdLrriYTnvWrSvLrwQaepnyq-E1uDqbSQM0ch1Jrvbt7afgdXuyQF6WxCyPfjeNbK2K6Hgp691vkMzfVprCs9hl16XxCKren7YegqQ0lAEfBXGcxHajpvjgwTGPaVLD4uTw0iOLERa4rn7455Fq0O48XUwugO4IX0pal02tPansKGitHevUE3vzf-RsGs5isBSLytNegz6jbEnQqbqO8vZ43iRfUNmHbKuUQ6ZHKJcCsGpGg6iOP5j94-c-xrcG9uCq5puK0OEqkao3SdcqS_T7tR_ngmQj9gJ9Fv6LMjQdn3Rf1eifhFpYAO6fq2DjX14ZRzGpYXDHyku8yYow0a5-UXUVdAfO02Gw82r6KA8i_Blhkbzqgt-Zpnl9FdtbPxy3KHpof4Pn2nr8DjnbVleT9QNKj8Cx-UZWVqEhrBj_nIFJLnhNo2D3t5jNZP9KmS4I9Zn1c0GX1IhcVFqbqBWO0KVCqwePfYs7QfZC6gOlVsEI3ZWYGzIsEV3ZlCmKYHWnw59RnY6t2RMEdqaudD5P3O8SFF0evSwQtVZhjvmDWlEMKahYYkYfjzg9ghZDZE-9v_N5w7A8V5sGXRTAiFWLTfKywjuI2YwV_rta4kU9BngEipoRNnZGv-WL22aEDfK5qDAGHLcxr76oS-NnrA6u6sVJy64PtOVDv7HxYf8xgwBeeoaW8rMYzxi1T5qwavEzQXo1TxVvQMyMCCVP2CvXpx33fKOSJoN6TuuqtlEHy6PtHYJgvsHEag9BzM5IH-gWNDTUDbU89oNMOMb65JRp-r3XcliJa3oVHpc9OTFsoc5tHVxaN0ZYXSC8h3OBYH3RwTb3Ela0iCr4rROYmWmgcfAZ24dS3LZYtBeBIu8FACNf_gTaO-v8yOtLPYBGDeiVSq7srbpTZGjUASmpmp_1NdLHzrRLR2LT5Mm3vO-aFOjKwLw-NG7bJbAxtwiWIa_myOg0d6rbXDYajQ', `SearchKey` = 'wofCpMOiwrDg8OgwrPCtcKDwqTDi8Krw5vDn8KhwrDChMKhwpbCvcOJw6TCiMKHwp3DjcwofCscK8wrDg8OgwqDk8KDwqTDosKrw5rCucKdw6jChMKhwwofCpMK0wrDgcwrvCn8Kpw6XCr8Kzw5jCpsK1wwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwo'
# [19-May-2025 10:54:45] /finance/root/bg/invoices.html?from=01.01.2025&to=31.01.2025&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [19-May-2025 10:54:48] /finance/root/bg/invoices/2408.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` = 2408
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-May-2025 10:55:10] /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
# [19-May-2025 10:55:14] /finance/root/bg/invoices/2479.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` = 2479
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-May-2025 10:55:28] /finance/root/bg/invoices/2479.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` = 2479
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-May-2025 10:56:13] /finance/root/bg/invoices.html?from=&to=&keyword=spisanie8 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCi8Kyw57CsMKewrLDqcK0wqDgc%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [19-May-2025 10:56:18] /finance/root/bg/invoices/2344.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` = 2344
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-May-2025 10:56:53] /finance/root/bg/ajax/invoices/form/clone/2344.html?pid=2344&_=1747641413428 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2344
            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
# [19-May-2025 10:57:04] /finance/root/bg/ajax/invoices/insert.html?_=1747641424831 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 5 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` = '2480', `Language` = 'bg', `PostDate` = '2025-05-19', `LastUpdate` = '2025-05-19 10:57:04', `Type` = '1', `ParentID` = 0, `Data` = '38AtXv-9FwUuzscZA9_zJwKPMNkxYb-W6bgRcA_g3XQmyJQ0OtGE62epy-6BYFLzLiEdIKyIJbYLMQ6sJVpHhVs8YsR4xLw0mWLE-GYgVjRnQ0FZlSrNk4VExsX85y0K9rKQ1Hp4w7qc8sG_HGefb3DISgK6PVnZPMtNqBoBWjiqcW_4rxSCZfV-NllRy_lMPGxtFLzgN2wjmhR3OB6Y5AlcO8V43td1nk9wR5xtdE8lyZqLriTqVKITnzN8yipFxmrX06p4n8NIXHa_FahgmibcetOEMMGkPZaWSjr9BsGkyLY1HLozREwXFek-IHgLb93h6-XNmr91irZ9MUVboEzUU7Bj8Jpu8I4EiKSIimnGMxw4FENIHgDzVQCDekl1ZWxkyhe9LA864SFi4vlJ00IlcZGKY8yosmgo-_yXfFKOBm2GPHBE55K80tOe0yqYlGrJNgr-VQr1swrKwlv4Xb7zkZNd3yA8qDJw6LwoWo6UgTfI2106A3JQ248NW97ewpImdtsgKQRQ8nG3p_JBY4LZM9ulonQnovzCikEaNT9ScWv3bm5UUu4dWRy7YBkpZQ25Pm5t_P44m5G8hbrZ1aI-XLn7CWuk2PWjoz97Wr2MBBnKt6as33CPaAbdGcYZ3vY7yAjuVtsSj5yJGJ22PDb5DDDAbAlBs2GvMNG1OA0mbn1bBxbKlmP8F-iOpNmDMlbB1PNZa4b1btAPoAFfH-uXGcsevi_t-csQWf6FRfys6JFv4YeR7zBkORqk2PKd2ACychTx_vdKbWBaarXlJ2-3QHS_pvFdi9SauQfpp3U1r9ZdMtSQlynDi20E0rBqwfsJQ4SyAfnJx3358dVcbVWVQt_5-IvuSxSfgAuYRQDbFSadxLdpCfhcFXsdjz8959vGLs6YXL0wCe4YozULBZnMFQrKoDKpEvnPYjFKfsSwSYX9o9gtiBLMOGJucupKZLSm52iuF2F1c1qPVqa_2tIBIpP-IX_IzXJ-DXLwAVmyHTsy1U9UKMPBrZENz6H5pmkJT3iRLA5diHOirZmSlfF3BBG1WSmns75KeyUUiaQ', `SearchKey` = 'wofCpMOiwrDgsKlwrPCuMKDwqTCwofCpMKnwrDg8OgwqCwrrCi8Kyw57CsMKewrLDqcK0wqDgcwofCpMKnwrDgMOQwqCrcKDwqTCo8Krw5jDn8KhwrChMKhwp7CvMOUwr7CiMKMwp3DgMwofCpMKjwrDgMwofCpMOPwrDg8OgwrPCt8KDwrHCsMKrw5nDj8Kdw6fChMKhwrzCvcOIw6TCiMKEwp3DgMOXwqTCrsOYwpfCosKCwoDi8Kow5rDwof'
# [19-May-2025 10:57:04] /finance/root/bg/invoices.html?from=&to=&keyword=spisanie8 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCi8Kyw57CsMKewrLDqcK0wqDgc%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [19-May-2025 10:57:07] /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
# [19-May-2025 10:57:08] /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
# [19-May-2025 10:57:21] /finance/root/bg/invoices/2480.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` = 2480
            LIMIT 1

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