# [10-Jul-2025 13:31:48] /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-Jul-2025 13:31:59] /finance/root/bg/invoices.html?from=01.07.2024&to=31.07.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-07-01 00:00:00' AND '2024-07-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [10-Jul-2025 13:32:03] /finance/root/bg/invoices/2285.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` = 2285
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Jul-2025 13:32:16] /finance/root/bg/ajax/invoices/form/clone/2281.html?pid=2281&_=1752143536011 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2281
            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-Jul-2025 13:32:27] /finance/root/bg/ajax/invoices/insert.html?_=1752143547264 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 2 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` = '2513', `Language` = 'bg', `PostDate` = '2025-07-10', `LastUpdate` = '2025-07-10 13:32:27', `Type` = '1', `ParentID` = 0, `Data` = '5mEXDknyhE2THSSfFCfa5XgEaJTdCVGRAiQNck9Du0_7xwNcoZjI9SCE7UGhjGPEo-6mJ4hg-aktugVXuXsRw_-a-FKbn0RQIO-oUtSJjzy6eXfDlqoxATfEZb-_JHDfI6jX4_ZWP3eekfAPnMJGa2Vuk7Qaof4g5rnh_xLEbGfRCnexgIU6KWACnB7sDGyv4Tctcb8zC_mftN-n0SV5up1S7hElak2P_r0LJypNOI62vykCBLPWvT9A-etQ_cvwxIGZvSxYBNMizL5cpg7LaEuBlp8FI3hlpgYmPs6GutuA0F6Lu7dqJjMEcnYreUnQTAuScKTvgAL6UcFxtBAsPJDwRAWrhcVh8fB0zFzUztXanH99W_n47DtEh3v6nuXzlbbhq2u1n8Zuw4i0TE60RVoBLOh5yEfs62-KzG6rMIaq8WpNvd0c6hZiE_oLYFqNP4Hb90z1i9kl_eCe4beQwyWUCK5OzTaa4Vm6LFCn_F9GYHs8IfzBqvGy7D57E-3ZvppUKNfxWiKknqTrq56EGBdWmTcmvhxEjLovBeqGQelqgWSlW_ni8LA1BQydnPYV6qCfzTc7QirQPiRGRX9_dtUc6-M6lWwDFBT1HtlfwwTa_wb39ROaM4eGArWCcTvZgQv-8KH3e3v1OFCSIAwqF4N9vt0eO96D0PyqkhMvwgfXU3_k4bUY-SWSXHD2cemlusOkEFFyx5z6TnQrspsz4QRc6qEfnu8zYjnaB6-E0Jict7h1c6rIkRpUwyz2DwGn9wYnPcljLP0caCeMna3IY9Uf-hzW8CSzjwOY6_Dqkk9ZnLDR57fr073g9jDvtDbCrnDVG8fS8qwRoSONXyMQ_1sDQKqZpZiPa3ZuL62DUE965bdnhpaq10tT9ahNKDFrRDVqKjA8vsOGZYOhjzl1sWLpTS8bx9TeGllu2cg3tjxrju0zUZJPGsAG-w7up0e-3yNp0jS6eol7di7V4_hEQ5MLeG2hZU-BFOCOZX_3hINTOj0Av7XS_3joyEbzVSvYBqs8i6PPfQYSlGMVhqHlXw0Qi_3yY86zfSxRsVBUWNE', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwr'
# [10-Jul-2025 13:32:27] /finance/root/bg/invoices.html?from=01.07.2024&to=31.07.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-07-01 00:00:00' AND '2024-07-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [10-Jul-2025 13:32:32] /finance/root/bg/invoices.html?from=&to=&keyword= 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-Jul-2025 13:32:35] /finance/root/bg/invoices/2513.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` = 2513
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Jul-2025 13:44:57] /finance/root/bg/invoices.html?from=01.07.2025&to=31.07.2025&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-07-01 00:00:00' AND '2025-07-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [10-Jul-2025 13:44:58] /finance/root/bg/invoices.html?from=01.07.2025&to=31.07.2025&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-07-01 00:00:00' AND '2025-07-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
