# [13-Oct-2023 15:54: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
# [13-Oct-2023 15:54:20] /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-Oct-2023 15:54:27] /finance/root/bg/ajax/invoices/form/clone/10378.html?pid=10378&_=1697201667161 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10378
            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-Oct-2023 15:54:33] /finance/root/bg/ajax/invoices/insert.html?_=1697201672659 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 50 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` = '2114', `Language` = 'bg', `PostDate` = '2023-10-13 15:54:33', `LastUpdate` = '2023-10-13 15:54:33', `Type` = '1', `ParentID` = 10378, `Data` = 'dqmHPHtJ_V-GfV_vG9OSEfFJ8X8exjKDYukCSZxgCKUxh1JQj2ohNdPxzMdbGDD4n68e9u81cus7Fk3y6vaFtX0C6dR7hTRvDmTngN7j-gryoLNGR9DfZ9MfmwgmopGq8TOCLBhHbjiqEHVjKc7_AX2469zt7GX0zE3txBGj0cigtEfyklnVA8Jbk6bfhDaDFhHEQRFhk2qhq7bUxx3Vx7cyNykEmP605QFu_886AnXl0D4P7i3qYHb-WQg_Ds9PCjw8Det2sGagX4xlsUgadlKGIqD0bkEwr7DS00aqU3OJLB_0h7KVJR_ahcoGVZvxuTLUwn3aSPBLWpq4erT00Rv27IqtUHcytVRsgHQ-drJk0EuHjLW2DZNlfzFGK0ELjHeud0lprnhoZOr1yLfk8RPVWMn7fc3tHTwUtIusk75mSeEQ2orT3ufHjkpKI_EP3WrKG9pOo-u39TJ0GGuMW2OsaBGEcJpn3lpiqFfo0ChRsu1_mEJ5F0NgBTWaZL4qnw7iGz5UL9h0bZklkgpqpbtBS2GMFRiJLUE6dI4PnvQ2XY6nXaST1djNYjihqLHvpGg0i-jn6XzgwtkLNHzDSlbHS6nzkavLKpbVgSpDv9lxKWKHSyNra_kAb_vp9auMbngHBP0YpKlLfPbrKrUwkVR3VdYlMro4Go6VKJCj-fQsEeCTFLlddvVpBcJcxTZghgcW4O9LSZQTm5C28vzxhWRzNg_6mY4c2e04Xwn97YT1sf088FjoboGckNhzKV-cr-Bg1s8zOOm3xLgQwigLhv4tYMjLAArYLeqGCnQ1YQVFFQIfYdyUTSCXXK9daIKnj3O1XmAcYS6GvQZ4qrLPTMIU1AdcT-4xxmBjbeETdcFvnWm612aqMDcYqF43CuQicQZSQPuhEDtq_9-qzmrl1hTP16sJ6MEPD4MjmtPaK9KfGzF5kbebuTruB_7_NK3Q2cEAyzT6yI9NNpYjpJ5JY338KayBmWHuFajXb4VV3PBJm4uHI0Uis2rm-yicxVCAKBfTsMxsp0GcM-HaNyi6SRLWt0urtWX02aoKCD3KOJ6rQF_Gd3ZZ0w9b8grfT3UV', `SearchKey` = 'wofCscK4wrDg8K6wqDq8KDwrHCsMKsw4zDn8KhwwofCpMKnwrDg8OgwqCwrrCisKhw5bCsMOawr7DwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rDj8KdwwrrCi8KwwofCscK4wrDgcOQwrPCtcKDwrHCuMKrw5rCucKhwrTChMKhwrzCvMOWw6TCiMOKwp3DjcwofCscK8wrDgcO'
# [13-Oct-2023 15:54:33] /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-Oct-2023 15:54:35] /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-Oct-2023 15:54:57] /finance/root/bg/ajax/invoices/form.html?_=1697201696513 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-Oct-2023 15:55:00] /finance/root/bg/invoices.html?from=01.10.2023&to=14.10.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2023-10-01 00:00:00' AND '2023-10-14 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [13-Oct-2023 15:56:01] /finance/root/bg/invoices.html?from=01.10.2023&to=14.10.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2023-10-01 00:00:00' AND '2023-10-14 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [13-Oct-2023 16:19:33] /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-Oct-2023 16:19:39] /finance/root/bg/invoices/2100.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` = 2100
            LIMIT 1

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