# [04-Nov-2024 11:12: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
# [04-Nov-2024 11:12:42] /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
# [04-Nov-2024 11:12:45] /finance/root/bg/invoices/2332.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` = 2332
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:12:54] /finance/root/bg/invoices/2333.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` = 2333
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:12:55] /finance/root/bg/invoices/2334.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` = 2334
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:12:55] /finance/root/bg/invoices/2335.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` = 2335
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:13:03] /finance/root/bg/invoices/2336.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` = 2336
            LIMIT 1

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:13:07] /finance/root/bg/invoices/2341.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` = 2341
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:13:07] /finance/root/bg/invoices/2342.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` = 2342
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:13:09] /finance/root/bg/invoices/2343.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` = 2343
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:13:09] /finance/root/bg/invoices/2344.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` = 2344
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:13:10] /finance/root/bg/invoices/2345.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` = 2345
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:13:16] /finance/root/bg/invoices/2348.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` = 2348
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:13:19] /finance/root/bg/invoices/2350.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` = 2350
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:13:19] /finance/root/bg/invoices/2351.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` = 2351
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:13:20] /finance/root/bg/invoices/2352.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` = 2352
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:13:20] /finance/root/bg/invoices/2353.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` = 2353
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:13:21] /finance/root/bg/invoices/2354.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` = 2354
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:13:29] /finance/root/bg/invoices/2355.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` = 2355
            LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:13:32] /finance/root/bg/invoices/2358.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` = 2358
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:13:33] /finance/root/bg/invoices/2359.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` = 2359
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:20:47] /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
# [04-Nov-2024 11:20:54] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [04-Nov-2024 11:21:13] /finance/root/bg/ajax/clients/form/55.html?_=1730712073350 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 55
            LIMIT 1
# [04-Nov-2024 11:21:31] /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
# [04-Nov-2024 11:21:34] /finance/root/bg/ajax/invoices/form.html?_=1730712094438 167.99.142.201

set names utf8

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
# [04-Nov-2024 11:21:37] /finance/root/bg/ajax/clients/select/type_0.html?keyword=fregata&_=1730712098172 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrHDhsK6w5rCp8KewrLCpMKsw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rHDhsK6w5rCp8KewrLCpMKsw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [04-Nov-2024 11:22:22] /finance/root/bg/ajax/invoices/insert.html?_=1730712142289 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 55 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` = '10436', `Language` = 'bg', `PostDate` = '2024-11-04', `LastUpdate` = '2024-11-04 11:22:22', `Type` = '0', `ParentID` = 0, `Data` = 'oXEkH53sDYSBU8S7kjuMN_1VPt6Od82gjwEcCXQ-VICJWGpQGFvlRsMCzNE-CFUg9LhnX8JKmJFLq5sxIQE_2JhUnaxlf6lMHHSmQVhy7oPwskPVY0u0LbK_EUfihDp7Do7MYq6X1O50BeZkF1v3KwKNfkEXR3jhKqWyHGSrvBkDdxbOjRlj73V6JEVLwGzFzKVRRU6dFT5936NfjDZdCNfzSOU9GMR5vmlKhQy5uGVOQKTmUFTQjs3AXH4beptmwh_OXxZDlNd3EnObsq2YSCHnmHr_TYD74wgBVJLuC-pnhKN2jYUSJ3-Q6E1XqzezMwzz9nt-unFWPvc-nJhYeG24LzGMpHG2RBVzBpcARjeeJ_jIu8m9b0JYLnq_CF7MDzZtec6_fgw7_QNPbrltgwzaAqwcn12uINCI7wbijZMNh4xeAnnzFuMBhm-uDYHXvrPKFwaV4HPlW5ljERnuv0ZrJol-lL2KxtC5yefjSbOuLk8UTnKEw2CUe8KnVLKf47-FE0JjIOUCdRdHGox-99XGPPwGeJ1v7zJAqFOEUc4K849TcO-8BjE5AF6cla4Ptw8ni8Cz9vS9_s6pKMU8kV8oMoJ6I2VvdcvHzFX57BRFr1MI1iB7G6NOTyH25W8avlqGt-2hXC4X0yt5xGRTYM8gItSENr6ta-vfx7rHQTx7VVSU1Uo8vG9CBuaWc3GcS5q20NfVP-Q6SLWDrM419Q2Ghp80zlAbaf-Z3g26I5205J-VTxqZnkXi8RL-dsW0B3Znu4u85hBu5PGbmlM1U2KA5EBLsEU_bs09GhFXTInBiTySj6BvzGZKkjI_-AD0lEnu56WsWUB-Y3NDMX7zHhipN0oUJNJ1UErgVqU1qAlx_TLKLGhveL7FqbVXVPrcCc6AIDoA6kje6KbVAhUEsse-crToxFa0N1LpSI1IaBsHaboyzpxa4QcfBdso1I33oIPkrPSERBjYR1MvukyhXHYQ9dazBog4jBaV5kVEQYExUSmfF1idl7aibvwYhUcINhk66roBs34DuVGAeLtIBsWs5o4FezhGblti8W3wVuHHmCFqwtYrd14QEmxPfjJF', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwqTCvMKrw5jCucKhwrLChMKhwwqTDgsKxw6XCmswofCpMKnwrDg8OgwqCwrHDhsK6w5rCp8KewrLCpMKswwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrDgMwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCu'
# [04-Nov-2024 11:22:22] /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
# [04-Nov-2024 11:22:25] /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
# [04-Nov-2024 11:22:28] /finance/root/bg/invoices/10436.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` = 10436
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 11:23:58] /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
# [04-Nov-2024 11:24:24] /finance/root/bg/ajax/invoices/form/2367.html?_=1730712265238 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2367
            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
# [04-Nov-2024 11:26:52] /finance/root/bg/ajax/invoices/form/2367.html?_=1730712412324 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2367
            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
# [04-Nov-2024 11:27:32] /finance/root/bg/ajax/invoices/update/2367.html?_=1730712452553 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 14 AND
                `Visible` = 1
            LIMIT 1

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1 AND
                `Visible` = 1
            LIMIT 1

SELECT * FROM `invoices` WHERE 1  AND ID = '2367' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2367bg', 'RLSokRF4Q0dz9Ixe3D2idjtsobAbIp4V7U22MLfsM8kiEAcSpsia60oEpeS5WAd0xoj75ZaWJcPCpSbjyvqLcgA1tu99_TXeYcdCBVCXd1Tf3tMHJsOAteCg7_EGWq1tnwLYTeVagtlwc07xu-NTzEqNFvW1XVTSlsnYSSi7xKI1S7Tq-jAT2wrscDXvlTjfilPtsyMlZdkHZ4IOh_D8C5Un1CeIOheagu6XEx1j8QXafqI9BLpbI6D5WbhGprklYKEHd9Lzn5_d2OyBvddjifXBrqafXdY3faa4D07VmcvuF0U6qnBv6QhmvTitBWiU_stRSx7MrZ5qmBX-DIEbmpaCzzeLSUz8c_dUxwQo510CcCXsNLvYRvJFSBnd8u_DJIRNaq0ibfAL3trZoD6Ee6mev1y3ndWC54GmvXH7OZLNoX_O1b_qhOZfiy7xe_0lx-M6yCqwATp7HVZowoqrhXakwSNq4rL_3YdrOTfygv8iLpx9HLajWU1sDaE2LJ4J8Rq2pfTl1GtP8QnnM2zHuRFVKZrBIz3QCMMQ7z7J5-97iglgqovgL3XWXbibZSsTWe5eeOUKOOYlC9qZ9bdWlH262KkZgC9xKvr0t7WM_5vN7wFAUwkgZDoWjStR30nt3VGI9iyl-pRQNry8H4jCQT_nq_hL84PGIqz8hZMACUGU3_DlO-iuAY-OE8jFUT1Ic0VbY6pUESDV8uO-8wE_jIZSM5kh5JIL8ZFoN0d3DdzOOY2z60lZK7Qu_H-fXod12WMLT1huKiPLmld1eFDU2MFuCrLlVNE-Gky52mGQiGUE6XhMdI00giRfyiupObTnbfEFyyY_cBF94T6agWxnfg6rEhhoLA2VIvWQPv78-SUUau2cUz1W6SLAYZbicVu4y1WXeg_LILl4ZomvEnUYVWIEWDhVQJKFwZTrRgrOeEB6_AzN5X4cRlHhM0VCNvXbrhVFMlW9K_LwFFV-WfXsOrIaOf2hwaiF5vHcdTpwEZvPDwI2XQ-Pgz16u6wVtyR93XAj-sLB1UXDtDOddHANNyw8ExLX5Ba5QaWJBbPubE8MoSa_4bh6HjtqbAB7g1yxtutuwZRTXw9x5oEe8yHHuOCpbgn5k8pHb5izY3wgqIRTRQBXtvumM-oZU4bzpQC-flvsZWPTGxWBhGoWHbaFKWH-Wo0mfchdkUKpJCG7BHbTcuHfgXJWoUawaP3ioiXPNI6NRbgtb6UgfnYKSrPdTaxyw2Jy55hMZD8HDOUy4ZixJ3hUEgf-cr23qli2V6Yu5Dl237qYSNykA9GssE8OROV600qb5l9DH-HW_P5nOLI9GcEHKgJ90I7sqvDZRMJc2sknsEXj6Zpbir4Em45bPiag8mj_ApgE2rr96dSrL3kI4Ll6PRLu9FvlMBZwGruRGA5brAdCJXk65TEEGnVUxbDiD_5bvxIjdyr6IZO0p-hm1Njm_0yHbsOwJqkIAy3A7eXd1lh3O5N0iUbTHd8w1eZtBArHpFPb11RHYsPlehKiL2nxSp59fxvUPUjpC6tmGcSeHarirZLDyM0IUkMnrrYmLtQ0TvzuIq5VC_Uz2af0AeKAc7b_2mxyiTQ7dnSTPpRGlplYjx-7A9LwXLB5KETfuB_J01mrTa1_yTZSEHrE7eNUW2NXJBRlgJLW3PgJPG-qHsR16xctExiW-2wtJirx_C2DfojEHHg5jfKua-CyOecmJIp1sQEj_OoN8eq4mNghEnTFPoXoKIhbR-9EiYuMgg2xgd24PRrUeBW_Hhid87u_oSPxzsEeeSlqdlHweJ1WK6EgUUMhOggseUwQJ0-urEQYKI3DtGAX3Fy8PqEgegKo5Hw5_4LLdYS8NBuein2994_hUNBmpMoHvQOmhQECq5OOfx1sUJw7NgcRX42gUyuYAiHtI8AnDYK-lE9w8MRnXC_pudVRd7ntTK8X1IZzeH-AX4qb5dyWNyhfU4bO5md9GiVM2PnflYjEliNNXCL8KflJEWV9BFILDaTLHSItkeNni0zK6rYmmO6K1IxdfgGYpm2KpAmhWgMARh_2GnV00cAV3yNNuNR4RY9Cq25EQxdOOv9_JnEG0n-UXWEseZzikR_-negIina9p6l-IkUgi_nWdVKHe01erSnd5CWh4WEvjzz7cq94GCBBpFdEDxWCMtUpVJGJxuLWYT6dvbvI6f3GI8jw0nMuCELbLEIZ6yCHxt-goyUm4RUXuDKjMhS_BxVy57vo7BmFlyp0iKbJCeGBQ-nXuzEc5ZFi_R2ZWvDE0rboGLeXYPwpmvVXNB1JNKQZkncoxjmfGJFU')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2367', `Language` = 'bg', `PostDate` = '2024-11-01', `LastUpdate` = '2024-11-04 11:27:32', `Type` = '1', `ParentID` = 0, `Data` = 'On6WVgg7pZc0zZtiGHBC0HXaLqQgGW39VTxOU3GwVG1mFxbnnWlSAuJhce-Oxue3Y4paISZWpxW1L0v5_9PqmWMb4MY6RulKBrQHYztq5gnjK0mVffIgP8KxlCrrPRcWJ8dGzAVOtdIZmD4kBiJ2kghb5Q5oyIBVa-7Kk_b8aLr8-ucwDMsOemolIolarch_ImFJlSkTWTpH2LmgZwVlz8WOY6cVkXaj0zC7MZLug1TsqzMTeAoDYzAWRWUtNx9XstMpMOYGj0hTf4i4M6rJaHPwGxJzld791IwvJDSo1Ifl8_EmpmeYpDci65AoX0Nt_oCq59Op07CgyoK-m-4yp-vEw6EPHW4RDjxmacry1s7_CFFDaWUMrN1isTrlZgeNsK16rlac1PogLIkO3Ilp5Uvck0SGAU_zgJ4HDs6YrgTcqRuutY8NRzvNxiDAVGFMpyljovCc5kpwaiwBjWiaJKFa65Axs0pwvbZdwNMju2JtYo15pNbaUZG_bjv5B8y6vc6nHyT7m35PYKxAPtvoQLTF3NXZ8kQoCSOroZkist3dzfq0ooSX-bmHn9olyg2jpHbLzTcosHbLP2qcSwSvSKsq7V4BXFZpiM9zEA0LYuX6hDMvOAZWwpMV9-tb2KQZoovabgULUBkUjj0cfGCvZZpA9n1tzwdzyK0Q5iITsAu5jZwV1I9IpbCHIaKbUx-tREj2SI-AZvan_-7oGMDN1-lEo6n6YA2DB9ggHpVW7np4SlPLWeTS4lF-UcZyfuYmzbwxif_-7sbGs2OWX5OHBGInKn0R6Q6ztC8AVT89g1waCgFIVtXaDnqb_HVGgMn6uAKix06S5PI_GU4U9LAWhdZbAw2trSz0Rafp0f9A64Q_WetM_abNG4oGzZ5s5WRE9gIOje9pobpS-gp_8_tO_xoVGm0uNu4zljF5-JMJtCb1qor8mUcL9SkmLUF-qhUBqXSABCU9vRg-j8b-ckI0RB0gz95uhZ7IqBLvksK7QxRcfVJInO_XezSqjNFtk23mStn0w1PytKH9b8kpnDEBE5LigrN84xzFYsarfoGoAPm95KlvvgzEQ0MrKVT9WGF3mqFx0qVDb53yeyBEXSdW3tSjKv_EvxaO33InSdj3TFsTf9wPZy7nicJflqnUY2CrIaKjAetpUZxInHzXok1lhDa7JuDfYyfez50HI7yDlExhVL0Mt8pt-xHI88Qu3_Bq', `SearchKey` = 'wofCpMKjw4DCt8wofCpMOqwrDgcOQwqCpMKDwqTDlsKsw4DwofCpMOIwrDgMOgwrPCtcKDwqTCo8Krw5vCpMKdwwofCpMKnwrDg8OgwqCwrvDhcOcwqTCrsOEwr7DpsKswwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfCh' WHERE `ID` = '2367'
# [04-Nov-2024 11:27: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
# [04-Nov-2024 11:27:35] /finance/root/bg/invoices/2367.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` = 2367
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 13:04: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
# [04-Nov-2024 13:04:37] /finance/root/bg/ajax/invoices/form/clone/2351.html?pid=2351&_=1730718277280 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2351
            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
# [04-Nov-2024 13:04:46] /finance/root/bg/ajax/invoices/insert.html?_=1730718286803 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 68 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` = '2369', `Language` = 'bg', `PostDate` = '2024-11-04', `LastUpdate` = '2024-11-04 13:04:46', `Type` = '1', `ParentID` = 0, `Data` = 'GeQJJAskTXF8Xms1BVKg7QmV5fhK14_MlxRgUQjhEtGoZDxF6vt69hrBV63OusX1ih7Tm5SpAI3zIi8zfPzbuXp0a5s3tADnmOg6d_W6A6ZAzTjs2tpIF_Zqh-1KpXQh80doKQ-UDz-hB2G8tDVb2CFDtavMHk6w06tyW6dpop0Afi-IJebPTxeyFH5Kof_e2VCAuaMgWpBdbZmm6luxyAK6Z0L0uiGAieUOJ5uVWPN9b4gbmbbV3D362dNKb-ckKWfxPVXcGBKUZGh4gyfwIWko7DVzpGPa169tLMNvh1b9WaVoWgfCgvCTZwVHq7BEyvKy7m1evpA4-_cMxQ50TyxadFzPhRXA77IHLQtmhTg4lu8FkPn6a72iz5nSNiBHJFXtck7ln402tuGn2Q6rPA1f8rD8NanuaQhhKLaKW9HeN1QY_ajyi96EgQGGcMp_ZU22LIrW6XLDszo6S43p1F0Pxub7Vkn-tdUzGutQPphe-gsPgCSBLymP6TXRBFcYeZQyThLt6VhsiBHlvC7AlwUvHNwelF-ff_lH5UFJArHlI-uDWfVFa4HrLrBd5zoQFnTkveXe_ymaMHyOJNCac0IXiZn3Nikd_AgouJ1sULyLmqAzSsv6KN2JB7VcfS3-Qu5mrCdzMjR8ZPHA2aWyN3fEDBszYWCpJ7qfW3IeY_juIMGlKx84KaIJjeup3minqkJBsYNYyo8Q42f1cqG0_pffoYGgNLs8ivPktcoQzcA23U0A51IXdtFa34lZBSP2Mze52-jg9rfSv0oaSCa_ugWwdp6uInGCrAk3KvFelPiyTVeRdb25M8vSlVbXDznAZvIsYT0ojPC6buigaS7F7U3OjuCcQalFCo57p54DqcWBq3rcdM5RotkPo0SH25utKDu53oGfkQCt0hc0loPB2JOVNuOfGoiheS0tHBk9niLR2kUZuzl01UpmbgiEz1dvtpXoED1Dpft6Bq9gZ3cWNM5I2Vr2TS7mg0CrM-L1k5o', `SearchKey` = 'wofCscK8w4DCtMK6wqCqMKDwqTDnsKrw5vDn8KdwwofCpMOAw4DCtMwofCpMOIwrDg8OgwqCocKDwqTCwrvCoMK6w57CpsKewqXDwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8KhwwofCpMOWwrDgMwrHDhcK2w5jCp8ODwrbDqsK1worDwofCpMOWwrDgMwofCpM'
# [04-Nov-2024 13:04:46] /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
# [04-Nov-2024 13:04:49] /finance/root/bg/invoices/2369.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` = 2369
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Nov-2024 13:05:38] /finance/root/bg/invoices.html?from=&to=&keyword=tricom 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvCoMK6w57CpsKewqXD%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [04-Nov-2024 13:08:56] /finance/root/bg/invoices/2367.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` = 2367
            LIMIT 1

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