# [13-Jul-2023 09:27:16] /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
# [13-Jul-2023 09:27:24] /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
# [13-Jul-2023 09:27:31] /finance/root/bg/ajax/invoices/form/clone/10369.html?pid=10369&_=1689229649795 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10369
            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
# [13-Jul-2023 09:27:41] /finance/root/bg/ajax/invoices/form/clone/10368.html?pid=10368&_=1689229660283 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10368
            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
# [13-Jul-2023 09:27:49] /finance/root/bg/ajax/invoices/insert.html?_=1689229667549 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` = '2048', `Language` = 'bg', `PostDate` = '2023-07-13 09:27:49', `LastUpdate` = '2023-07-13 09:27:49', `Type` = '1', `ParentID` = 10368, `Data` = 'JsMUXSgDl_rLHkzW2PBzoeCF-MATViPR4pBMjp7rcwjbWX15PaZjJp6rw4mF7ZNiJdY6990kzqpGH-6Up-oto2cWcbBYNnccun49msNSfClTTcSF6iw0bkKSsUVGrpWuYp9lDz_Te8aF2kFufjPagCc6BK8gcsYYlJcKDPt2pbzPqv03Atq31eyyTeYRBhn20peL7q6HRXr1zRA9G1CB72TLGWC6EKWcFqU7OeVmwFxZu0UQ5TKdbXMmGf6w518KQS2XUR2zfD1q3QrCWIhKRuOHDpj36v8ZABNH-XVMTP-Rk64j-moWJzwfzzGlHA-f3Q3_BW_OodUR8VpSRvsKf24-FiBxVs8GFkO4fT1cgntU4ka9eiUPBJu8IOzgg2duSE-Zebbjg0ntyJ8RMUykIxeN6XrfoFY37UCZwFktq1W5IuHDvG7zDRbf08iREPfJXNZiJq6d3DqnJCl5OXrll84VNiTfn2XkwPb8HQVl7AbDvxScBddEdMA3IhLPWNdJve3k4EJrNN2-jkwyN-P9zYQZB3j3Jqj0sao5HYXrHxAgesP4FRbZs7UDw3UxvLWBQ_FS4s86vnG9sqVBGIcOiooMlPyWMNPysuZDuVZQHa7TfnCtvRqcYDFJnJ087I7QddHsB89V5f2S-1trf4O7ya7dkCKP0AiadZQCo5Ez0GxMVQRN_2q50_Sndsy-GaB7qGYEZqYOSZvhV4tKvjyslmn9s8tBAbRIWBA4LY42vKKVhkb2jO2qaxmQgywwbGlpu8r2hb8lYTfQxFil7ny0FMAcZFD66Zc-il4IX-WdkSLovabYoMqpG0NIpIARXL0AatZ7MMYulY1qO3jZ9uFrDKiDEKP63T1pND8ROvUpa9Fsv20iDYWXW-dmd5Zm05WL9I4iU4wI6bo3SXlobILOV1HJiyvihXcoupq32Z0biQORrt-L30R5KrzSL8YnHLTDfD9Xdq-EXAB_KfTBnM5qI6PKqcLPfMB_tz8l2ZDLbQHpH_oZcOmwCCJGnjpR8YKxcGZVK9Kufz-adQBcoYq5PUMofVLh9gdp8BiFFS2FtX8', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwr'
# [13-Jul-2023 09:27:49] /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
# [13-Jul-2023 09:27:50] /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
# [13-Jul-2023 09:27:53] /finance/root/bg/invoices/2048.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2048
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Jul-2023 09:30:12] /finance/root/bg/ajax/invoices/form.html?_=1689229811355 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
# [13-Jul-2023 09:30:16] /finance/root/bg/invoices.html?from=01.07.2023&to=&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` >= '2023-07-01 00:00:00'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [13-Jul-2023 10:04:51] /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
# [13-Jul-2023 10:04:56] /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
