# [22-Oct-2025 06:12:41] /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
# [22-Oct-2025 06:12: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
# [22-Oct-2025 06:12:49] /finance/root/bg/ajax/invoices/form/clone/10467.html?pid=10467&_=1761102769079 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10467
            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
# [22-Oct-2025 06:12:54] /finance/root/bg/ajax/invoices/insert.html?_=1761102774404 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 51 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` = '2571', `Language` = 'bg', `PostDate` = '2025-10-22', `LastUpdate` = '2025-10-22 06:12:54', `Type` = '1', `ParentID` = 10467, `Data` = 'rM7t7dDiZl7IU7gF2zFtixOxKJI3G2wBJkWebteCHHMfGu1y2aaDCG8BpoPBZn8cbiKfBnBt9SjaJOWRIOiG-T_-TD9-rhuOtN4k2o_QGxhcC7DsEjblLK9PjXFtIaF3S1oIAvrXZnd1WK4lcAwrho4Fs0xjFUDUImSCq0PI0ypziEh7xdt3cV-4Xl7HRHhjSouw1m156TPSMVRGhYytzlKNYXaRe5BuGJ0BKLo6aBX4sX-RajrIae9I0xI0MkApAGElmFuH30E72_4-5QJr43XKAnvhotxLGe6Ra_YQFYynhQSJeHfcKVY7iEmQaEZTAsP28Y6fc8bsSIe7gj9KxPeYaZGo7Wkbs-r0kqFA3mlX0f6z2H98zPHcHWzV76bskgtrY_J6VoxpNzUVtNwaC0ZiWm310fjxQu0dcfkqp_bitZzXHHCpxz_WTTC9_xG9GizFKb7gWoMcSM-As96lBP2t_j0XLolEMhwecVD_vjGYgIZGwuYQuqH5ynmM1x-er_TH0nEhIWsNvemZtXNU4_ZTdJDL1nP7uBXHD2b-O_oz6qyoq8sT044ZOY0pDjvtQ1p8ec3jsMdht7FIuuC9U2qzmPuhCbGR4ObB8v8eZuXq6wYQ5aXQ5z5xwA-7yRJ37_Dcyd2geo1SOElDyLoWsqzKqDhTZ5qR-lo683sk9EyidxVGuoBVuAY9h1YkquMxMWh3I6sSWcnljz9zexi8mUGfuvaF0zEynEKwCvyaqnhqNNXjpVtchA4ApWNNd4c5Zzsme-pvDd2bEA3oAk8RJQTmzpWGq_PdKRQeG6ZtGG7-kibHQiHVgnzqTAyOFZm9YsHCsY55gpK1XW9ConTU5Ax7PU_T4YdUAeZUDWFP4_VWxL5UgIhBNK2HX5alB7LeiMtybx2kFdld-egWBnI3R3qsWwWtzUe3-EH4-SK8ejYRuilWvfM_QU5d1NVosZpKltGUiKhyyB-6m_o_hfpYVDOeLH7-ad7uI5_NYWXTrO5wogbbuXb3mojkEHskrS0DxzgNCEpGFKUbQAt0ocqxvXOozQPOeKq265IU4AuIt2k', `SearchKey` = 'wofCscOSwrDgcOQwrPCtcKDwrHCuMKsw4zCpMKhwwofCpMOIwrDg8OgwqCocKDwqTCwrDCisOGw6fCscK0w4LDwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwrrChMKhwrTCvMOWw6TCiMwofCpMOiw4DCtsOgwqCwofCscOAwrDgcOQwqDrMK'
# [22-Oct-2025 06:12:54] /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
# [22-Oct-2025 06:13: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
# [22-Oct-2025 06:13:48] /finance/root/bg/invoices.html?from=01.11.2024&to=30.11.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-11-01 00:00:00' AND '2024-11-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [22-Oct-2025 06:13:53] /finance/root/bg/invoices/2371.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` = 2371
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [22-Oct-2025 06:17:31] /finance/root/bg/invoices/2370.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` = 2370
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [22-Oct-2025 10:16:25] /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
# [22-Oct-2025 10:16:26] /finance/root/bg/invoices/2571.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` = 2571
            LIMIT 1

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