# [14-Mar-2025 10:25:15] /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
# [14-Mar-2025 10:25:20] /finance/root/bg/invoices/2430.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` = 2430
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Mar-2025 15:57: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
# [14-Mar-2025 15:57:17] /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
# [14-Mar-2025 15:57:21] /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
# [14-Mar-2025 15:57:25] /finance/root/bg/ajax/invoices/form/clone/2425.html?pid=2425&_=1741960644971 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2425
            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
# [14-Mar-2025 15:57:36] /finance/root/bg/ajax/invoices/insert.html?_=1741960656693 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 62 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` = '10443', `Language` = 'bg', `PostDate` = '2025-03-14', `LastUpdate` = '2025-03-14 15:57:36', `Type` = '0', `ParentID` = 0, `Data` = '_tJ1kSQYAlXAk51kRiNWortf7t3rPAQ1mc8llohbaKUc9-YSwD4BwiY1eN_2ZjNAjVUO8Ynnso6OQY7hW7TFS1pQLHilxLUGlJs9KhN_fZ4k7gN_0g3RUVQaDkNvpBHFA_kOTjeyGc9RYwRIBvyja2p5nRIPB7lDohf6rcN3nsH1PO8YYXQCY52A2ooAPzuopbhCCmYT3yjThB-ZG0imEIolX4GQt15WdQe6efJqg0djXTP2vuYqjKz2Z0vGSvi_Tnqw2k-W6pTTAuR1rM42C_WHkC4zGOxtfEkcsf2FLMRff8vbc2P9LLk-UQ75mU-QNQhuK2QYWchdYUtnvyyuo6ZWb8Ge70k4X_EabgLEaL6STrh5M4nR5gReq_4KX-hOJT_-8h_evDeyCjS_-Nk0HjJsN9Jn6ITnPzXw1HGZi1n23ySE71Q7F_TS4fo8MnbHmMxAB2Gm5cqAy4CG83LuVQB8qwWS2kh3k5zigi361yD43__xVVrWUYkrqrHkmMv8nhG2EDU0NYmMwM0mIsYc_oSwPYCOHjmrJVJA443aCD34ZuQJcwSLjjWtlS-tRIYDLKMcs79h80DBank_SnuaDULSAe1B1mYIggXxwTgDYMbKvVISwTVRNNkPTW35JQZ55O6si-2M_ROpVfy3pY63zOEiFhH4c4wpqBzEb5iSx1LDBQwhvux_BzeBnWs4QKQS2ae8jF-tjiPlhTi5rY5DwX_sFw_71d8wPBsKX1w5pfUYYJ_Ul8TV2MLm2iamxD1JowivQa44ZHTnwRf0CtnoI8nF-kPXuG525Zv3eiTgVUxDcDmQxKKwzhtHdHs6k3q0MeRPXZhItwY6EAnNakv1xV3iQPBtca-GR6kXnZ_ufiBzg5Ix0tW1mRzuDW3odj8ApUUa21068rs63CKuEwuMlmTHDy6jCHno7TS-zxPFWJAVq0j6FtK9S49Zgh_QCyoB-WO-HEx8--O6_CI0NzTUEjoBqdpEcz0E8L6xUndIJQbAl5xW9mKQMnFI7pFbXvndl-DM6Yq_ikQeZ6tDZxY3lUe3rb7hevd1kuGMUB6-N71wJnSfKW7VGPi6dlTiYuIznP5nQuhQDX6ZyZqySxhxc9h9bdezzP9jEJWNLsOQsavGy7Zn76vSmEX6LOkr9M9tHuOxitDGalKTUfytxDl-kr1Sd492qfCcVTvZeGLriacoMwplf21VE8UMxYcmXSnCmw-7FYs3E4Av55k_t1OmlHaIYqg4OobgA60YZcekpvPF1hgzgRmvxqbqsyh1NeNai1NiH1SVAFSb7C7a92Qqh0iVcKU0hR3hKrIwlIObLXHUURq9U545qwAb7i__VI3w', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwrnCisKpwqPCp8OEwwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4wrDgMK6wqCqcKDwrHCwrnCisKpwqPCp8OEwwofCpMK0wrD'
# [14-Mar-2025 15:57:36] /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
# [14-Mar-2025 15:57:38] /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
# [14-Mar-2025 15:57:41] /finance/root/bg/invoices/10443.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` = 10443
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Mar-2025 16:28:40] /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
# [14-Mar-2025 16:28:43] /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
# [14-Mar-2025 16:28:47] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [14-Mar-2025 16:28:49] /finance/root/bg/ajax/clients/form.html?_=1741962529345 167.99.142.201
# [14-Mar-2025 16:30:26] /finance/root/bg/ajax/clients/insert.html?_=1741962626721 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` = '78', `Language` = 'bg', `LastUpdate` = '2025-03-14 16:30:26', `Data` = 'zpo3SQ_8yBf67s_ai9beoo-3gwB2CSPJCGxBnSZhnRYcpW5QnTQ8qCOh1vugO-qCzJhCYdeXN4qrSvFcucIzu6J6tfnce_syhlyYlxmUUz-5L2Mg4MD8-8boYStGOfQsjn_s5AN_sRyZUn_5y9ZbFBfJK06QgQyDOuuFWDKqXrXO9fI3qusluimuZ_3xoC1jP1OMjZfs7HhX6qCvb3XSxnOcD_6kdF9lNw_7gjhSeTK81b37VYoBbkogoE0JwYIkqSmFpq9F9y6pTFx84hzi2LHL9xXPc7XHZh31Bw-fJGNJrXZ5k_fOM_K3ZJ1GPX5tVe1Xf_ljIC3Mshxy0EI-zWt0zJ72iVmLREd7nuiS8GO4PxrANPG2uCMeohrglySH', `SearchKey` = 'wrrCn8K2w6PCp8KzwqXDrcKswwofCpMKnwrDgMOQwrPCuMKDwrHDksKrw5nDj8KdwqjChMKhwrzCvMOVwwofCpMOiwrDg8OgwqCrcKDwrHCtMKsw4zCpMKdwqbChMKuwp7CvMOWwr7CjMKUwp3DgMKlwqPCvcOYwpfCwofCpMOIwrDg8OgwqCocKDwqTCwofCpMOqwrDgMK6wrPCtcKDwqTDlsKsw4DwofCscOWwrDg8OgwqCrMKDwqTCsMKsw4zCucKdwpzChMKhwp7CvMOUwwqTCrMOTwpCmsOmwq3Dq8KgwpzDl8', `Top` = 0, `Visible` = 1, `PostDate` = '2025-03-14 16:30:26'
# [14-Mar-2025 16:30:27] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [14-Mar-2025 16:30:32] /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
# [14-Mar-2025 16:30:34] /finance/root/bg/ajax/invoices/form.html?_=1741962634281 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
# [14-Mar-2025 16:30:38] /finance/root/bg/ajax/clients/select/type_0.html?keyword=pan&_=1741962638039 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCn8K2w%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCn8K2w%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [14-Mar-2025 16:32:13] /finance/root/bg/ajax/invoices/insert.html?_=1741962733647 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 78 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` = '10444', `Language` = 'bg', `PostDate` = '2025-03-14', `LastUpdate` = '2025-03-14 16:32:13', `Type` = '0', `ParentID` = 0, `Data` = 'IjGTLuiGpoNVjG55oM_2QDBnZF68fGJ6s9vSQblOZMHdHgHiOXGqJCX1fgrQdTqK8BPr0GUghk2RcPRCvcZeCHJtOkcp9IEJ3j7DL41c89lIjDg1aOEi9_UtgXQ-KqWvw-qmngw5UxXhAGpRZ_jT1aBPOox1dNIQCc1LVbdRvM0qsmYyomjCDmoXNLUDvokMdgOnfdcJL8QDSUV73MnnvVxS_fQsdKsvQwqijT3CIhdTFSHxke7StsdtI-0cs4W-bgz-XvM2KE0jCOlBP4Kk0nNIhpNmSAYNf652fLxPYdqfhLfPkj0nKIisTqsPyr5cEL4C-uj3sEY8skGZtiqWIkVnqJcSZvplVjRp-bf0hRwyISuCuR71MLQFqxci3JOVlk6JbjDyuZrbpmmOoQ34qEKe6D96ptZShFyLbNPImRgboXqmGzWDMVhdVIonjQZE6aXjhWywSpBWqg8CBDSgA8CiJ0E9zVIjYnKfv1UopMMaK2sRjkPAyItkuV4ul96Ml-s_FCFCYHSADspzeBy3JFaZcNP7dorrgnPx1LL4FwBSZ2hnW4D8L6_FSUJHAVA7rSdRtJLi8yIr6lpFoeSLWzhE9qQla_Yzb9pWukR0FATcE9_72HOMXrdlj54CRzPGNg-MpHQ85jmucFGdDQu9Q6f6Cdbz2n0tHxCocaRUqJuyFP_B1WNkj9Yo9jsvdv_5-kht07kHA_QmzXhJR148D_hM3Jq2VHedsaSkKI6vhQ3xeUUpDIos3jEEh_d8RvLGVDdnIdZNb1B6YhQ7Y77T4M4uHTyyKJwDuW_ZEwo7SBi8NzmuKFJJATbKLxqy9lpOK14zBlEnmPWAb-5MJ-rMOA5NcCQJPs2M0KrpUqJ0w4xFMXtwx7WANaFwvADI7yII4LIqdKn4WaspcyhciTLpOSkAhF7b5a67Y-GyyOq6kV1qrcgyQd4foWIHw0OJilG4Qaz072nT4ad7GQrKc6lorT5VlkBqTHSfK-wL36oLWZdkfQahACyKRL3jXZsL4IscZ2nTXj9hk1Hje-KYOQ4N4fgOVuoQPS8FBwLmEwMGdERJCk27yY5Qv1Bx3LJM0muu9SaGB2J_tPNzZVHzXnw-cQ', `SearchKey` = 'wofCpMKnwrDgMOQwrPCuMKDwrHDksKrw5nDj8KdwqjChMKhwrzCvMOVwwofCpMOiwrDg8OgwqCrcKDwrHCtMKsw4zCpMKdwqbChMKuwp7CvMOWwr7CjMKUwp3DgMKlwqPCvcOYwpfCwofCpMOIwrDg8OgwqCocKDwqTCwrrCn8K2w6PCp8KzwqXDrcKswwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrD'
# [14-Mar-2025 16:32:13] /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
# [14-Mar-2025 16:32:18] /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
# [14-Mar-2025 16:32:23] /finance/root/bg/invoices/10444.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` = 10444
            LIMIT 1

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