# [10-Dec-2025 06:08: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
# [10-Dec-2025 06:08:31] /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
# [10-Dec-2025 06:08:37] /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
# [10-Dec-2025 06:23:30] /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
# [10-Dec-2025 06:23:42] /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
# [10-Dec-2025 06:23:45] /finance/root/bg/ajax/invoices/form/clone/10455.html?pid=10455&_=1765340625217 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10455
            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
# [10-Dec-2025 06:24:01] /finance/root/bg/ajax/invoices/insert.html?_=1765340640869 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 5 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` = '2606', `Language` = 'bg', `PostDate` = '2025-12-10', `LastUpdate` = '2025-12-10 06:24:01', `Type` = '1', `ParentID` = 10455, `Data` = '8o1fIcxFGSE5e4HZcmGyCgHOuJ-m-JMnzrHBlkYXDQjKVuoqojLwj0ApLuarA99h1KzKRqUAP_1xdlDIITXjYEp5-Ox18xpVPUmQGyZCkejn8CZDeXvqcoPEvR86UB4yJUD3Bj62X_4UehnxA1UJ2WTZY0gPsD6fSJtm__EzsDSGSEFSdBbTbgR7kez--rBW6DtxeQuwCSiAI12ehan6wQD5iN-LRp3zVAGVSZ-QzJTy1JyTls0xvzO_aT6JggXZOOO5HZ2yMlViGSlXS0kFY3bKmrBr_HuyfZJGo-4Dde-FWi6kiGcn2Z9pE_Kn4YM2pVrnhB29EWxOCdhElYdbyrjJfN1e3ZGjnJk1ahQa1qpfVGrxe8Nc20FcINDhcALpVw9g7yoyZ-ZwlQsbeACr7u4QQN37yQd7qvHbLPj5CovNBZvPuDRtfpz-rVfed7QGlfrjczvtS--FjbGaBDUc-5fpU9a1gdUtDpnbwMpUqQRDgMXcSuTGMdlEgugRkT79yz7myg-5y4ec10fa9x80wbpuxsouElIC7P-eM7dcryoaGgeNUE_jBZ3WZ257tPV0Vl8S9zVpsHIdxrn3DVdGjVVVEWAbvcZVtkNNg-hjr7PUFFPp62ztVIap6cYbFgjw8kC6gb6yjeIey2RQYkvIJUZxs-rLuxKXDRN0sc4kVjC1Ymxn9KxDKzItZEJ5JkD0vOasXSIqxl314_SWZxnmL0eO5jdUbXnYWLZS_OIG4EWdAMrxrU5AHbnwCNTrbb6wDSds_uoZz8T4cOPMhz1Fdno_lbZWhKIv1QRNkPSfznUX0NOhH3dv8DnammcdX5nkBUpWce9qOO6V9Y_dwWMCj9ab7nDjA42C5B_rkHxMsU7a3_lqcF3yOdyJ4FFeQvZqe5_69HyJH1cy9-nntYyQjHoI3ndU15baD34eBkuqcYZHj3ETM8H64TpQPZaoFyV4SCTUjDWSsqleRnBgomrAFuKq2gNfy9kaqb8EfGtFJZgAxGEEiEJ9_rwDx7O1atzuW2BnwHuCCBYfR26BKaCspGxTkpEve3fYPu-rZL9iBnU', `SearchKey` = 'wofCpMOiwrDgsKlwrPCuMKDwqTCwofCpMKnwrDg8OgwqCwrrCi8Kyw57CsMKewrLDqcK0wqDgcwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwrrChMKhwrTCvMOWw6TCiMwofCpMOWwrDgMwofCpMOqwrDgcOQwrPCtsKDwqTDhMKsw43DwofC'
# [10-Dec-2025 06:24:01] /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
# [10-Dec-2025 06:24:09] /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
# [10-Dec-2025 06:31:09] /finance/root/bg/invoices.html?from=01.09.2025&to=30.09.2025&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-09-01 00:00:00' AND '2025-09-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [10-Dec-2025 06:32:04] /finance/root/bg/invoices.html?from=01.08.2025&to=01.09.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-09-01 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [10-Dec-2025 10:09:28] /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
# [10-Dec-2025 10:09:31] /finance/root/bg/invoices/2605.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` = 2605
            LIMIT 1

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

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