# [09-Dec-2025 07:31: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
# [09-Dec-2025 07:31: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
# [09-Dec-2025 07:31:21] /finance/root/bg/ajax/invoices/form/clone/10479.html?pid=10479&_=1765258281924 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10479
            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-Dec-2025 07:31:33] /finance/root/bg/ajax/invoices/insert.html?_=1765258293640 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 16 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` = '2605', `Language` = 'bg', `PostDate` = '2025-12-09', `LastUpdate` = '2025-12-09 07:31:33', `Type` = '1', `ParentID` = 10479, `Data` = 'kP4NgfQjW0o8a0KRGswMpmIJvvq8oKgUYU3EfrfYRAkvwzpY4fQ7tJ7jiMWpptdDF7mJ2LbZfZ8pPVy1hQ2KNdkdNopibKSVLdmPjL1SE2vWflK1jFDDrG6bUsNcbPp9IEwANcqcG92S46Xs9F3LayhXdZBeUU8P--nZODPGPJDwX3pSl9xqhhwL5jRYgLTPSBZCJA7qOx8bB5aoXke7UwkhXNS2aw8mp04FPOU2VJTy0UvltigL70yrj5eGV6RLWxFszgqlr9mvaYPH_VBAqy5gDp-cn614Sjuvx2uxBa6TlXPSHTQcV1QaYfCWlyzlASpUbfVeXuD1lveIdzIQ1zOFg_1KyqUT5ClSm6t9lrsGpDhqfVtP5yoCrsv6isnM_m2T_oflP1bFraTZL40NpSklO0KPBH7eIm9cvub_4T4g5BImiHJ4LEAvrHZC7iSOpI7Ew5UDZn9zJQCrr9nGzFWO2iCI3dS5Vm227lo78DO23CzsM86o8vC4powqnjHMULtCkdwnGfheaO-OVzENDSOcCr8DjFCuULDWzZkhpX3cPvFSKHuqBUeYMgWb6-2W79IPZ3QIwgQmQIGPt6tKKfOPr1_P8Kjgj4tLWQOlL99DSoRYBrfLqJZG6yiR9SV-xJ7Yld7E-qcsDtVskDW2qqOc5EKeyHtLCPdmG2dVcrHDaVzdAmDixrYnE14nixYSkJayyQ05JR_KvAFhKl8kL0dEt9LtxTaer3FjdPLzC9iQ4WP2BSIDttgMsGNHagUrLiebYIh9ZHC-yK74jyyYe7TLtdkqrx9WACK6AjnpP9D7ekVFL4Mre3QY6C88GpwsNw-lsiv2cetmrmiElQTGw8yWk6dDHMFs1L5djFamMgihFzf7-UyEuXPLEh3Erzc7oerNGIxhKytzP0_ZIDJtcTm2HmjcEJiC5fJWpoWpBgJN8gIhTvfVktLCGCy-X8osiZLch677Vs_2oeFqttUwiQJDYrOQ0E0sWTfT2xEMvqmkdoEx_JHdb6yjgAnbPnhQ2KfxG21O4wGlVVBltPpPmGPicIbf8YheqxG5xzudP7UnheFDvU0ZE9zaxLuZzkdycyJXFZ7HiI86Lf1A94gTfLkrnaQFg4XJ0RPMgf8kCpdYXQfyFA8o5M9ET2kQa2ZEwXs6G7pQC7fG3NTLh_jF-6odq_Ab5Ts7BvBP0IDJMjFRmJhI1ielklvRCZwkuO2qKpkWjOei4ZzP83CwZzY_VBAZ7Sq4KV7E7qqkf6TKBkvuzC4XE89fnh46x4Uz_VLE91ZOCgcIjMwhWCTwLwRRfwEbZ93oj3z_V-Ek_4hmq5NWnx7Vb3jnA04-VRnr_LNdYe4VboPta-J0q547rm4RsmyYdaIlp0ACgT5zJbKL2aX4hox4khKE8YSIbRVBv4GWdYr2WBxWkjhfWSwbZQJXS8WGIbBhQbaTNgGAU-D1WCK-6DC3if5O--XADkekN9emlyq-dlXmlTtfF0jamkm72oIV71RXo5h3RG_bpZZbZZpN6E-4KXcAztMBKMJMinUrECDeL3vKfbVcLvka_fkwJq2rrnRx_gIkn8FEicLgjqjFKtKZ9f_4N_39T1pimGcEIr0c5AwQqRXtMzd88t1kzTgaXPQHzhSEve0lUqPt862-Q0Oc0v6gRjd5mTmVb8qOmwZXcoAXGfpJCEWbwwX_dbtjDRE1xs2f--4ekxGddo8LkGQP2qvHBlbXFuUZuGV1nTAmtIJ5-U5e_EeMoYeDJRHIZLXzrVes3MUe6Tf1lzrBEQHmTEsmk8GGillytfxkWZfi37HlI15gFfm-bsxUjxcEoQ2et2GXCnV9Y2K5nsc', `SearchKey` = 'wofCscK4w4DCtsOgwrPCtcKDwqTCuMKrw5rCucKdwwofCpMOmwrDg8OgwqDrsKDwqTDlsKsw4zDj8KhwrLChMKhwrzCvMOWwwofCpMKnwrDg8OgwqCwrrCisOGw6fCscOZw5jDnsKtwqDpMOQwrCncOGw6nCuMKcwr7DwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0w'
# [09-Dec-2025 07:31:33] /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-Dec-2025 07:31:45] /finance/root/bg/proforma.html?from=&to=&keyword=spisanie8 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
             AND `Inv`.`SearchKey` LIKE '%wrrCi8Kyw57CsMKewrLDqcK0wqDgc%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [09-Dec-2025 07:32:14] /finance/root/bg/proforma.html?from=&to=&keyword= 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-Dec-2025 07:32: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
