# [02-Sep-2025 10:01:28] /finance/root/bg/ajax/invoices/form/clone/10456.html?pid=10456&_=1756796488540 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10456
            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
# [02-Sep-2025 10:01:33] /finance/root/bg/ajax/invoices/insert.html?_=1756796493107 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 83 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` = '2545', `Language` = 'bg', `PostDate` = '2025-09-02', `LastUpdate` = '2025-09-02 10:01:33', `Type` = '1', `ParentID` = 10456, `Data` = 'q9Yio4NlW3Tkfi8VnM8yqViaU2Ka4OZAi8cv5rpsWgf0Psug2Kal8fercC0O68rzmH3RV8t8H01p2NIt7xPv3nbPo73V_37CHIAsYTnRmNemGtcRlu6A3UvE0GIkwpwFhtXFX0em6ej87tmit9gHwHZEOsvK3Oj3PVuweinyhG9qN5HmEWEY6HLIot8OcddWASHZqXRwu6xvhfplnHq3gkUfq5l5dY9CMIlaYIBkAwg6v-nkTenCIG8dDJBRcaGijpAB7Ldw4cpp3A6rFEst6dXHlekuTbBir7lMbxGwvEibhj4UNMh7xSNeZDH-AMKtP_40lqBWzJZGg0HM-F1DMbaBqS90j97eaFsAkDBkr7J5JG0sdb-srIxiNMpKY96-RRrfZihKWakha2nW0IfLnX5tKo5w6UjaC8Ci2uUsnDWuL1Yf152ZBUMeWrENBoc8x9gfUQbt0QpIv0DZCDvEtSVxlU4rf35cid130Bg5-m1qolTfQNGqteJ-ex9ziwXyI26U9DQ9_zh--BPpe51SmwAUeT01JOPhLlr1-PEGUsdNVOQ9upbmk0IkxitHS29MXtjKgj4LmstKKzdbo9PGJGVd6t2Vx6vtfw6UDAixt5Xv_bupT5i7ogTeDqGKF0fQ0V_uyn1QUD0foedligccYkQgEdgmKZbgrkhyifeXd7oiCtVTt-sirC8gCSO6z2Y1t26nsPedb2vwstXl-KcU9EIHpS6kp6Q7jBE5C38yXFxzHJCvSsvFBwn_1b-Ztl9fDU0Gg20D93ojznujN7TDAs_ffqAb1qbq0YXRJFv-i4eJ_u0RoUOmPDBLPCkkdP_ry4qVnHrA5BGJyZyL1EdWFPIh7ro5Fjfqht8jBxVhld1nJYy6P6RUt2EGdQ-VQe82K4duKTxKjhLX5kIyt37qXNNMsFByj1qIqxG9hJhfyRdfdFKXY3kofl_PFfmZrgN3iT5P2GWlqjqo651xwhTKUw', `SearchKey` = 'wofCscK4wrDgsOgwqDq8KDwqTDmsKrw5jCpMKdwqDChMKhw4DCvMOXwr7CjMwofCpMOIwrDg8OgwqCocKDwqTCwrrCisOkwqPCp8KewrLDqMKtwrDCwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8KhwwofCpMOWwrDgMwrHCisKpw6TCp8Kew6TDwrDCr8OCwwofC'
# [02-Sep-2025 10:01: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
# [02-Sep-2025 10:01:35] /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
# [02-Sep-2025 10:01:42] /finance/root/bg/invoices/2545.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` = 2545
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Sep-2025 10:08:21] /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
# [02-Sep-2025 11:09:50] /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
# [02-Sep-2025 11:09:56] /finance/root/bg/invoices.html?from=01.08.2025&to=31.08.2025&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-08-01 00:00:00' AND '2025-08-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [02-Sep-2025 11:11:40] /finance/root/bg/invoices/2529.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` = 2529
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Sep-2025 11:11:41] /finance/root/bg/invoices/2530.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` = 2530
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Sep-2025 12:06: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
# [02-Sep-2025 12:06:27] /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
# [02-Sep-2025 12:06:43] /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
# [02-Sep-2025 12:06:53] /finance/root/bg/ajax/invoices/form/clone/2528.html?pid=2528&_=1756804012756 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2528
            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
# [02-Sep-2025 12:07:07] /finance/root/bg/ajax/invoices/insert.html?_=1756804027247 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 82 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` = '10463', `Language` = 'bg', `PostDate` = '2025-09-02', `LastUpdate` = '2025-09-02 12:07:07', `Type` = '0', `ParentID` = 0, `Data` = 'PfsULQ1TSDVTnpQy85Nn5XmFh8F_l9Uc4V8UvK4hUVSY_RCEWttsWZU6YwX6aBop6P474WJ675Z3EudAHGusCUcAh7GUpaQXhf1NZpCCyXt0__nSuuLNs8OGjzepHpu65bAe4bNNhaO3J-yLX3CwoaOD11od0f-PHFQ5OdKSCrqWia4yMjlEI_UvuOlK0XzAei0y4KwsX_4kTzejLFYLjvNSE0uNruXpfMv0I3vyoYdopHkTj6-M4WqursOsaq3gyMyiMYX8lM_GPp_S3B0d1pUB9uC9gjVyaDIOUYg_W0DOJJZrTLnNBQjHl_wEoCW-8v774EguKuDTmfK-WIGzw6NxOPlewR6Fswkq3FTCqQPnBFlUue2WgI-f0fj1zU7IeEf9dRy1cDI-3QGkghr5rDHCXKnbcSq-SPFHNlPXUvWqDP9lUsaY2A4t_WTvrWYZ1g1yP5nLlTqIP_0MDT35odguNinb_4HEMPah_Vf7ROnzV6fhDSOEMpDKgi2CEFBTMZ_FoY-qdcs4u7lBYKyHrDbkgZKgvqQDAo5l3rvfoZ-4bDxGsV1p_bWMaOlIWJCg-f_wY8KjggOk2icPUUkvcKZbb9wE-jY012EFZvsqBIK1xIJP54yQ898v_uRflwIwQLxzLVTg_FTBqbrEp4v0a8hW0pzuh-JZ5uY-_1A5Ka2ylFJbIZG8sC42AwerKBNYpbrvMmqNAsF55InVLmCH8iZj9clIdiDK6hljrI-fyNApXFkBmu6O4hCoBwfudAWZiYVWdx30QkQwy2jJ3h0l8-LC81PwyEDN7cNnhyCNozh0QjyV35tmNzoy7Ey_fO3NM1OT6Z23-aNb0L4ScM5VgJeohs7Bvt02p_D8Ql8KYthDNiOyuodXASlKKje-mYqnV6X0HzN9ci9mCo8XtDF-rBM16rGINwMeEAS7MPfOaP55oJMm8S-pEOtVLRcbdapYlLGRGTZRA1MqlJokb5PLQ-quN4KhulKz1n4HRV05toTpyfbQdVMeUd8sxkIUaghM', `SearchKey` = 'wofCpMOPw4DCtsOgwrPCt8KDwqTDlsKrw5vDj8KdwqHChMKhwqrCvMOXw5TCiMKEwp3DjcKlwqPCvMOCwpfCpcKCwoCwofCpMKnwrDg8OgwqCwrrCn8K2wp7Cp8ODwqHDwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8KhwwofCpMOWwrDgMwrHCisKpw6TCp8Kew6'
# [02-Sep-2025 12:07:07] /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
# [02-Sep-2025 12:07:09] /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
# [02-Sep-2025 12:07:12] /finance/root/bg/invoices/10463.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` = 10463
            LIMIT 1

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