# [05-Sep-2025 08:28:34] /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
# [05-Sep-2025 08:28:36] /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
# [05-Sep-2025 08:28:38] /finance/root/bg/ajax/invoices/form/clone/10463.html?pid=10463&_=1757050118250 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10463
            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
# [05-Sep-2025 08:28:42] /finance/root/bg/ajax/invoices/insert.html?_=1757050122757 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 82 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` = '2547', `Language` = 'bg', `PostDate` = '2025-09-05', `LastUpdate` = '2025-09-05 08:28:42', `Type` = '1', `ParentID` = 10463, `Data` = 'bmC4pMJ6b41igrWYyjk2a3ReLPR1Baq5kTvfUes33JAYuwbtSw1Vf2sqCKklnD80HeN_zLDzb7Q7B6FsxepFOSezkxLFvJhTpLdygLI_JvWfszWu7U-zURYVfUGZHy4aV51D7CaNUEqJS-iFh3_4aahpmdGgWAnSokAic0lEjgy4PAC_J91odIfVD971-osnTBvx6roooY2MUKjdi4YAfoFty_jp8Xaq4udMyEh9GTxVmE1hEEs_32dVDbkhTRH2CFHmdbIeKT4IqHLRgjZZ0WW3SXCUHbnRmTKc8W9n3ulcKKhqYO8Z5Nz05qITpY_rAkdR2u95Z1eKH2iIoTxiImRPjiZvJ5Zaoxunv9Cbfz9fhALjCvI-IPT_288vT4ehwymABFwb9PjZ98psdDo-GCZV3f6fLANyfiGr35oGhc2sr184tqvUDr5R68xnoH_oqT7UNYzXO3YdOX0WIZRX-eQWdVFODllzwKiqVYxQFle_vpCVUM9QZaRfmV8TV5kCGo0Ith9g9pdfvB2IkMAMcyRm16BCEvYjvnemge-fxmaZ5aQxA-LkbfDIspZzvYoXDiqiyNmwWhGW1tYELsmmtrRkNrBptCpgtmgfmFjrPCLeAUtPJ1VvUWBGQnn5l1jdZ-ZSaUnZLTdWp1Zxo1vhSK4yxWJ9Vv1Z5LgLTLWZFvThSQ4Qw7ITqjLLEthTcAoVXqhruW4iAgjfkBtR4LB6PrQ_41ZZPp7aJdSEqTZtHWgC6-ArT-VrmEvGaJxC7O72vLkeeLO9UcsybFvRHG9OO6s9Y2OUv4nPMKUv72rvatROx75AWMLAbaeVjT8WA5NjjKBMNJZ5CXwdwdN6635cqruOum0vbAlQVXTSr2vqPMMKjO8tOzt-ZeO9LnsCoozU7nlPPM0rmO9yrUYX3jMEZI4AnuN6bfK0o220FJFZ53Dpi3dOKu7jI8dbBqMc_6RB-joiZDyrYQIn9sbfNZfdOn83_e9nLPJ0ao5LV7Tah51NJMupLzf10Qma4xAnyEpc', `SearchKey` = 'wofCpMOPw4DCtsOgwrPCt8KDwqTDlsKrw5vDj8KdwqHChMKhwqrCvMOXw5TCiMKEwp3DjcKlwqPCvMOCwpfCpcKCwoCwofCpMKnwrDg8OgwqCwrrCn8K2wp7Cp8ODwqHDwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8KhwwofCpMOWwrDgMwrHCisKpw6TCp8Kew6'
# [05-Sep-2025 08:28:42] /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
# [05-Sep-2025 08:28:44] /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
# [05-Sep-2025 15:32: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
# [05-Sep-2025 15:32:11] /finance/root/bg/invoices/2540.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` = 2540
            LIMIT 1

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