# [16-Oct-2025 08:09: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
# [16-Oct-2025 08:09: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
# [16-Oct-2025 08:10:25] /finance/root/bg/ajax/invoices/form/clone/10473.html?pid=10473&_=1760591425467 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10473
            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
# [16-Oct-2025 08:10:33] /finance/root/bg/ajax/invoices/insert.html?_=1760591433766 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` = '2570', `Language` = 'bg', `PostDate` = '2025-10-14', `LastUpdate` = '2025-10-16 08:10:33', `Type` = '1', `ParentID` = 10473, `Data` = 'RPf4iqoH8yway5-ptJ1ErtG9csVhjf_wIxLSXtGviNqTKfdhlbV41h1-Zcd63SchpvUlcLMgwrFimjpPzrRmv0ae1Zg2qXT8D4NCtAH74WutY0sIhrw9Z7ygBeIbhF4lalaoI9jxKi4eHM0TyxyhEE5XMfdaSCHdbtZf6kHFEmC0TcsheIqsYz97w-Y0o6dSXbG_RXMw1hTTE_mX7rrZxi05xiHMc0VC0nQmOEGJgpDAC-MHxZCbneijHb2JVQSWFXZhmOv6_THH8m-knxy0LhT8w-WZP1Tf03kvzmFRwP5yJhC7lTmiOX2kDkfh6-0ZmOd2XpagaRohvWyunMK4ekI6EDZfePEa8N384d8NiwbKkPVEvMgTU-5GNITKcpbI-jnBMoDBvBYxWGUumaF4zFGeOBllYs8MRTWhehAbPpvrlcOO-I_dxKnYvwM2nToCOzpxgHAotYnZnZuufkG88EK5zWybudpikMs0oOhrvW34YadOdB5sDDKLZ6qzAsAOQhOZBRgiArv2S0vmaRfadMlTR3Rzxc0EhA5XuRz85jkSbUj8Y95GRSnF59r6yhFsXxUpLPYc9HI3HNr-pM0Tpl6_o-lGq8R6tsWNCeIxAtvkg0_iCX2YoScPC4UULVOJYGe9HGiqIcxcqIs8Sc3tuEvOxQYyZCfV2SsuvWmoTah3mMEuXot22ySOndFSndF34hywSyJXK6_P41rMP3Jmflkv4QQo_fJi9OJGPnH3guO_-MXokd9d7tWNuZvB8IzXZoR7LKKXbysq2PEPCtUddg45W0w2XrHUKuVWsNDerSj7oEVxYkRnC-MdAW6q8pfnNtN7jARj2GwxwrOaySghG4o8UdVglDGrpVXNx8iMBQdqPW2b6OsQixjrnHQf8UqERRz0qp0OMbhqib3o51rC0cwk2t8GmSCzR6Oy70PQtJUz7CFKydU5LPOGU0jW_hno9O5300ppB5jop_Q4ZE7xpqeo7vUN557S8Ivi2U2fPblmImTXslpoeKARfq49QmjDS2r6_hoW59aoSMOm1KJpkFkV-xyTdlAD7f-A5bHne-8YHeZy5AhMmahJc-LsU1BE', `SearchKey` = 'wofCpMOqwrDg8OgwqCrcKDwqTDhMKrw5jCwofCpMOqwrDgMK6wqCrcKDwqTDlsKsw43CucKdwqDChMKhw4TCvcOJwqnCjMKewp3DjcKlwqPCvMOCwpfCpcKCwoCwofCpMKnwrDg8OgwqCwrnCr8Kpw6PCp8ODwwofCpMOPwrDg8OgwqCpMKDwqTCn8Krw5vDn8Kdw6jChMKuwrHCvMOUw6TCiMOKwp3DgMKUwqPCu8wofCpMKjwrDgMwofCpMOE'
# [16-Oct-2025 08:10: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
# [16-Oct-2025 08:14:08] /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
# [16-Oct-2025 08:14:12] /finance/root/bg/invoices/2570.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` = 2570
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [16-Oct-2025 08:14: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
