# [06-Oct-2025 09: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
# [06-Oct-2025 09:30:34] /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
# [06-Oct-2025 09:30:48] /finance/root/bg/ajax/invoices/form/clone/10472.html?pid=10472&_=1759732248568 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10472
            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
# [06-Oct-2025 09:30:54] /finance/root/bg/ajax/invoices/form/clone/10468.html?pid=10468&_=1759732254648 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10468
            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
# [06-Oct-2025 09:30:59] /finance/root/bg/ajax/invoices/insert.html?_=1759732259551 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 9 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` = '2566', `Language` = 'bg', `PostDate` = '2025-10-06', `LastUpdate` = '2025-10-06 09:30:59', `Type` = '1', `ParentID` = 10468, `Data` = 'MgHvj7fd3oVfuqNgdh3Js7-zj5SL6Xg4-2dcUJnJQmAWNvxIdkicqxWt_Ib5cvbC6alhaBGyvDtah6jCPLTT_XZnlQS7_-Lcu_eGRYx1qc2Xfe91KMCfFWvFBDjVfCKbplYqjr3zPf5Pt6ghyfP6bsUm8mtBGsoMV1kLdCV7u_synSbz6R3jG7wQI4Qdr6c_AuQlGgD1WwLUEcSNFQOv0MQWu-b0YLbDTpUfNHn-MwId9HUdcnMYDR8HKO4igDweLTU_xCBQIz6-WEhEYxxlyBuQWV50akiXrSm3ag61uCUEOIhODfjJyfThs0EAHLfnrb96Zxe6IYKdxZ6aCn7qjsvjBB5BdJVUiGOMjGyRvUvUcZm_TOIBEtzZYKNQt2SJvp2yJVfwdUx_X9Qud4fq_IiN0lvJpq18jI0x8qvtIO1nDttkrGA989cxotqM6qwxGKq9uagn3c5v7Ht_lRIULhVpuWeveaSh0Gg42S-KgKlz-LWON8ZiMu_rvtsRcI_AfIXLaqt7bzX40_O94irF7sWMkc9QyrhrQpF6CCHCtz3VQ_Sn38zLaMYauaA3xmN9r9INuiDSGI6DSyBg5-xejI5PHqEk3NOjYLlYTuY3XhIGkTSqy-A6moSSzrDrLVN28u6oV47AmKNw-mDHbn1eDkBboU-jOkhwU2WvsXYoSqXznOdYixo7OIPfuuTUH1mBDmwd4DZOPX_ZiMfoBTUtAGhE-57AZuESEp3tDRn0MpNse-h4lLGjIRlBXysrcOVRjU-SbgdO0WTIYA5fA5CIPJY64IFuokyWp-Bh5ynPpbkzL5cvtCAZMMLE8mADDFs3FIB_xlkej6rVmTXf_Ti4aIQYjT1szupFv5QM769F8xYC886wDwWG3z7lxdApVZ8ie7VX9MDe5X7I87SWvXMgjx9EvNiQhxw-fpUGt7QgyeVw6vDakdg_m0rmlv2WiKcncn1OMG7CuJ_h0b4lycAh8nW5vl1dG_vaL-Yv1b_FHWl2Vz8p0VW-unnmWkgBdvYs', `SearchKey` = 'wofCpMK4wrDgsKlwqDrcKDwqTCwofCpMKnwrDg8OgwqCwrrCisOGw6PCsMKew4LDo8K1wovCvsOGw4fCwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwrrChMKhwrTCvMOWw6TCiMwofCpMKjwrDgMwofCscOAwrDgcOQwqDrMKDwrHCtMKrw5jCucKdwqTChMKuwwrvCi8OUwwrrCisOGw6PCsMKew4LDo8K1wovCvsOGw4fCwrDCisKpww'
# [06-Oct-2025 09:30:59] /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
# [06-Oct-2025 09:31:10] /finance/root/bg/ajax/invoices/form/10469.html?_=1759732270248 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10469
            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
# [06-Oct-2025 09:38:29] /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
# [06-Oct-2025 09:45:37] /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
# [06-Oct-2025 09:45:43] /finance/root/bg/invoices/10469.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` = 10469
            LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Oct-2025 11:37: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
# [06-Oct-2025 11:37:43] /finance/root/bg/invoices.html?from=01.10.2024&to=31.10.2024&keyword= 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2349
            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
# [06-Oct-2025 11:38:05] /finance/root/bg/ajax/invoices/insert.html?_=1759739885097 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 4 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` = '10473', `Language` = 'bg', `PostDate` = '2025-10-06', `LastUpdate` = '2025-10-06 11:38:05', `Type` = '0', `ParentID` = 0, `Data` = '3AxHUjx6d8kfyy6WQNYKJMQLo9mDA8a63DeAZ8lMaR2PLYOiveJQTjKdlo4mHAKlLEWZBi6OFakQ2JfzjQqGrh2os5u5tBK-AgEZmD7Sh5v5o8tt-ZeXZdOj1rKAkK4V1NNvHrM35aW1QTly-NkaJ8OpAwxLw4_owNHTIgfVtiMOgvfti_ettx-eP-u-2ArqXhRyN4C5sq1meiZqzpFfb_Ogg1OAmgr9XKJwSefTcnsqWncMQjhOxxio7FNAgR29eBxz6AlBnA6Yv71mgQ1qnQmTObZxB9NoWmXQ4U3Eec5FlPlJBuedqT9x1SU3N5BOqN0j1jECGWzAfx6kBbZxG5KrI9rv05tjtV2abF5rr6Bm98gSnBiKq3-vzHktdouR9TLFA4BkXgcg0c9XM5xu5UPY7Y0r7xahYJ-bRrQIvtZRbzSrKNx02A9U2n-rUP5IvClk-xCvEot8FmnR6rhH0nb67PNyN8KO_0-_5ng3bB-42okHh4q7LTL_VmZBd5GZotyPvXdCEWqPlOGAO0kppize1dXb1ds7CPqNxYCJ-KvwsJP_CbQ0Auy6oYFNeDMbmnZWHMMO0n14saPH8aG6avBG1K9DX2d2wAd9UTeVj0JeVbdNjIfvOzzBLdNiyGFnGgLylUXBrPQRo8kfplM6IBU6tHnBB05mH0TpMKkWgeU-2gau43B6V_WjXDV3IbKg2zL7AK4qHz47xsHtiq7YRBVtxRtP95zCuor4jUtaN7IwagfvGKZoo4s4yP2nUNYsYBCRJ8W0YVLtEVhWDLwSsnDwmsCaeon6i7NlZdfjZxdo1D559AOJJtP7dgzaS76JYCrtgJno3EmC3oelrubh__RzRminOJTYEHVwTaRtSIeQEMXD4RP4UJcn17me0cB5TQeLTPk7GZercdEEm75ckVBxBFcwQ3u3p9ay8yrVuUkKASHhe8X_4XW1gS_fETWYVUAKkb3LZS94gy_uf2P3wt9W2HgXLHc7wCzw9Y8qmup5FLQb0z_xIExMTAk8lvQr9vX0yUqsIY3Mr55cCpvCqF8RUcbv6zqh_qL7FB5qpfzwNOyafHVDaddkfcuvdtPo', `SearchKey` = 'wofCpMOqwrDg8OgwqCrcKDwqTDhMKrw5jCwofCpMOqwrDgMK6wqCrcKDwqTDlsKsw43CucKdwqDChMKhw4TCvcOJwqnCjMKewp3DjcKlwqPCvMOCwpfCpcKCwoCwofCpMKnwrDg8OgwqCwrnCr8Kpw6PCp8ODwwofCpMOPwrDg8OgwqCpMKDwqTCn8Krw5vDn8Kdw6jChMKuwrHCvMOUw6TCiMOKwp3DgMKUwqPCu8wofCpMKjwrDgMwofCpMOE'
# [06-Oct-2025 11:38:05] /finance/root/bg/invoices.html?from=01.10.2024&to=31.10.2024&keyword= 167.99.142.201

set names utf8

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

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

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