# [02-Dec-2025 06:39:18] /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-Dec-2025 06:39:21] /finance/root/bg/invoices/2601.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` = 2601
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Dec-2025 09:07:07] /finance/root/bg/ajax/invoices/form/10481.html?_=1764659227061 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10481
            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-Dec-2025 09:07:11] /finance/root/bg/ajax/invoices/update/10481.html?_=1764659231673 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '10481bg', '8p781PJ2V6Psd9pFpTmti2IOIL9v-6WcR_UUZoZ14UwNiMd1FGfRGrNtaeYgGzi1I1TioOfwcZW2if__sklyHlRU_8p6iDjFpntXpWdRzsNkvPEaQwbz9lLsgOjn6g-sDpG1xDbqZJrQMm356GdNXZGjHQPV8ayn0AN1rFS5nGoknzDiZni34lD0JqzPpxGm5qbJb1mdEzr2eOsZW8Qy9JZN4jsSruupjN0CBuqZYvN4MrowJxOUBAgIXhKe81g16RB4O_H063qaGmmBx3zOI0WMK-eUJPBokODsPpBe47Bgncy-ABEdlYqnBGiRiS3-REqmB1q3oss7UvpUkF14Om2bJ6LwG7ClUitezIDDCB-kI55AX2QpC8eWSdKS0IAq4c4DTdrkN3vaN9F6HwQZvcehWpOMKcNKkzdygxgcb76vveTejOmAzNl87pYcpnyGkTFPxR7WRbQ1YB0poXlHhr8_tPrgecN0l7wCbg7XsZfP_0Z8-Zedj4-VaLTX1e-_3NrUUlbpF45y18Jh0_0Uft33vkoaS_b1G5q_IpLbH4dTEkp2Eb_sCmRUNdqbn--1taqrmNqLrABtG8OciMXY1UN5BXYxKjxRTPVzrD1v8zyJTVciVnKhM5BfHHvOUERdkVQqX-RImvXgY_VHlYMg1Mkoj1AZjE6DLXK17iIlfMAMCNiWgBURRXMy4dbC8QqwPSuQKJAPgkKBUHZmQ7cscJAwg1AgylQxy63ZcQ3zsQr03g4fjheubCEUJhXMQjGrElUe_J31bFnVjXQ2YCGR0qtRvK0AuXGXOQoPxvoA_kW-p8ERSXtbKfzrMXMd-dFGMPiw91DGOSA-JoDh6F9yBrCYFlCUnlMPPZclBn60yNY0r41WqI8Jfry0YYHD8EDoXV_W-3mQzszG2Hpv0-PSAr5NqpWDME9k7WeNvwJcuRcvuCmWfqxfXLVeZhYvfT9ITbwR10nYY4a7_LogGMhJMlFUJ4jaOFJfpaY4OjhKqAHR4DH_g-IfBHeX5GkG5Hs7ekTKGUUcGVLYyT7-ERhXKETcTe6-aDH7FgEbxnxfkHlARk5EIPc8_2fLvgPFoXRaonMcxlgV7pMMwGdyWWz04oko32o4x3LZc47otOcZHqy9ja19yoHdxbX82WaTD6jiyZd4Yv4sPgv-YNLXsEeDac3hg5bs8VjkrRIVI6b3t22urFBrueolRqaaJBalxUjHHkrqj_DMsYkrFyTrX0ueZqgP4D0rbl6rGKhHNdAl2mA9KFWTrMuyU96MG0L4oozdDjhPMGywm6zSUxYlh5T3ZQjxOLDaALNB0AXcfq5-ISip-9nX7aXBWadHXuttBEOMOCU3GWPDGN4OxlfZQhvJwgYLdGg5IFK06Umx6waone1pBC7ZhBf5memD_8-8C8JBm4OU724asgGurhq5axD7e-uBdZqEinpCtrK4WufANF88o-p6O9q6fmj4qInLQCYsgi1hh7MUrQI-EqiZ7hQzZfm6YLSfUuM31iCFSI-Q2tEQpN5WUH4G7ooNwyVg8NxjLGUapuCdzNzSRND4BmA3RIw3i92B1CY7HAML1FbRfiWssdppMRB4lV1IHGb_T6elSN7pYPypOwf5OgqRnfyd37x7XLxLaf8aX5TSf8pukqQw87HxQLUa21InI2bUrSDuvrQgisVTEeD8FzbX5MGn-vAPq7O_Dz09i4ovUs1dFm_5_P9n5xGlDkfPUV09pq2KOpDhX5M4MiTichdKJuXqaURYjauTMnHXCoov_BpP_WNuVoKAt0-HDfRjsREOqDTQFCtk_TDFosiiGC7AU-BQZ57g-BSaqS8ZfuoibVOX3vAQ72HzJmufPXzLi15CyvYqy_ksrgwc5LuaAobJpLqyhBxhMw6r43eIDbcAIaZAJoLCnxH8CUwEdntn8Qpb7nDKxpnrVXeo-Pa_uSufPxKVv4CceRa5BJnCFeOKR78VaocPATqbN1l-Wt6StdZms20VccTdwUfTnzScCe9lU6kqgxLuCzMbbhTiV1u6nYV7BX4aAkxWWirB8ruTQsk7IUjvB7ZtJYJEO43osv7WP1MlwMwZQaKVpRAoa-oAAxCfSrByT2DffyhLglDpITovMmRfk43F_NHmtSiHUWFTd-OsqJVGdgQWJR0jpP3MVclQjRjBx8mdhkqCvxZdkEK4HRitnLtf07aK_g0IzxHLKykxAw')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '10481', `Language` = 'bg', `PostDate` = '2025-12-01', `LastUpdate` = '2025-12-02 09:07:11', `Type` = '0', `ParentID` = 0, `Data` = 'bBJCd6Gy5TDoqp543ZjXQlTQMYp3TvCZMX0BoUXcOpZPA5mf8-khRJanHLn0YoaI2syYd2qLzXqXZe_yCIFlqq2TFHFTLblwiX_4MfaMpK-Gp27-RWokiUM1PGnJA3boMmx495Omk4_7-dAMzYq4vCNnHYiRZPU_e0dw3g5zG3VH7PyvGYyEMDbg3Ocxq3t6eiqY3aXIoqs9Kbrt-338BZuT9sWpby3XH0t20J5VXIvBlzm6CNc97dItkugg8MSZVngsricjr87hHT6gikew44HYd99oARjejDe3dcNQ8UBzLSxv8SoXpRUGkvOgleONzMV86Zslw9DDCbqtKnzGCqoyy0XB2KLnn8p2IGimZDV5SKx1uk0OuDHrJ_-Ht8dcil9OCD8kOjn0dXM9ik92gd5rercJRRcptONwDRqD9uaXqrKKAgiI2ziqiDug1TGILXr_rXlSWzj4mpyJbkxCdqI9ntXr17EmguaH7JZFRc0WPfUf-Nb9xyrGGk_Og-JTzoGhNecCc8a-_hwKQlOcZonn0WxLXjnZRc3UwYqPtoyCQWwBf5qrPfpZKIfll6iBIFxIIQ5hhccBhywn1qmXkh7Djx5ZWSaiRZ_hf3JCXISz0wW-8AHLeV_aX_R-1VDBXDfXdLDxlAOAVenND_98wZ27pbSWV2R_IyGTdhTX-hShbmu8Sv8QjQOISw9mhlFri02qf_OfAfQ3anoUTsquSAhDNuabBdd6ZcS9Tc6ptSvreqHdCPCsmbm-p-pvWBiaivtuzKu8cz7GfyHMdDGcokPBR-DO2VoVZbgkuIye_os7WVfghJq0wAeFiw7gjTCHBXj4JUtCXzMPk0y1zNIJzTyrnsPhQH5bAOfVdbau4QudTo0fe3eqUm_-N8qJ3css9FqeVC6iDw0U24GaTIX-HZA8ciWzcOUww41frUAOySJ4QM-XlT0gyOCCCum6_exLmP-KQOMEs3ivlb0HZhgR1ImicEJWVb9UTOhZhVOL8RU', `SearchKey` = 'wofCpMOPwrDgcOQwrPCt8KDwqTDnsKrw5vDwofCpMK0wrDg8OQwqDrsKDwqTDhMKrw5rCpMKdwpzChMKhwwofCpMK4wrDgMwofCpMOIwrDg8OgwqCocKDwqTCwrrCn8OGwp7CrsKewqXDnMK1w4XDkMOGw4fCssKTwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrD' WHERE `ID` = '10481'
# [02-Dec-2025 09:07:11] /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-Dec-2025 09:07:14] /finance/root/bg/invoices/10481.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` = 10481
            LIMIT 1

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

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