# [27-May-2024 10:51: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
# [27-May-2024 10:51:37] /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
# [27-May-2024 10:51:43] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [27-May-2024 10:51:44] /finance/root/bg/ajax/clients/form.html?_=1716796305369 167.99.142.201
# [27-May-2024 10:52:57] /finance/root/bg/ajax/clients/insert.html?_=1716796378365 167.99.142.201

set names utf8

SELECT MAX(`ID`) + 1 FROM `clients`

SELECT * FROM `clients` LIMIT 1

SHOW COLUMNS FROM `clients`

INSERT INTO `clients` SET `ID` = '65', `Language` = 'bg', `LastUpdate` = '2024-05-27 10:52:57', `Data` = 'U-TISsVARvDkY2OLDcITPxeJkKJMSLe882xMBWXiGs7CE1Pfqc6BRx6Q7DZdyyJT0nF-AfS25xARu3fhL1Wt5GIDbMMOZOyRC0-DZXPfzFef6RK0A4QgsSc4Sva55ZWcXgfQLlaW2ws2VTebI87HcY5nRQEWj25jJijGXswrjHoZ39asQ5L0FsGL0iyFjOw2npEGToACK-cd3QH9wK_NoEjwX59Rik__sAHL78f1Z0JHE0eoF-VPG08aoGBJh7NsLkh12G90_xadBBH7SrSY74o8J--_luRjDhtrVAjdEbbdhnODjnrWsc7WGFJBSyLxsTB01-dX392MzE3WGMxu-m18EWYCQ7Xxt79g0MUpzBQ', `SearchKey` = 'wrDCsMK6w57CpswofCscOAwrDgcKlwrPCuMKDwqTCn8Krw5nCucKdwqHChMKhwonCvMOUw6TCjMKVwp3DgMOTwqPCuswqTDgsKxw6fCm8wofCpMKnwrDg8OgwqCwofCpMOqwrDgsK6wrPCt8KDwqTDnsKrw5vDwofCpMK0w4DCtMOgwqDq8KDwqTCn8Krw5jCucKhwrHChMKhwonCvMOUwwqTDgsKxwqHCm8Omwq3CqcKgwqzDl8', `Top` = 0, `Visible` = 1, `PostDate` = '2024-05-27 10:52:57'
# [27-May-2024 10:52:57] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [27-May-2024 10:53:01] /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
# [27-May-2024 10:53:04] /finance/root/bg/ajax/invoices/form.html?_=1716796385003 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
# [27-May-2024 10:53:08] /finance/root/bg/ajax/clients/select/type_0.html?keyword=aria&_=1716796388647 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrDCsMK6w57Cps%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rDCsMK6w57Cps%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [27-May-2024 10:54:06] /finance/root/bg/ajax/invoices/insert.html?_=1716796446766 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 65 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` = '10404', `Language` = 'bg', `PostDate` = '2024-05-27', `LastUpdate` = '2024-05-27 10:54:06', `Type` = '0', `ParentID` = 0, `Data` = 'MPwWAKJ_ff2LQUTpkjc-NlJ0ugD6COUWP0D_oNXn02Y4pZh__wUKOKygA-ejHds_nuSNpqq6YSaOMewqosBeNNQvSjp6lKHdnRJVSOdCeyRSE7ezUBuXJSc5lBfKkLrM72ejiFjNLvUjFUl5Nyr2ju4MXFxZQsh_9h4JfBSPOUHqq2Lv_jS_Nf1dCqa1gltxzoYSgigdz-0Nc-XoIvaZ9zs-BCo1POF9qk_T98p2O0OG5aFl_cW-nWZ47MNFV-VXv5vLfO2aeEns82WtFSzo-_4b4zPtrraomu2OUpm3fPrIYvm2aJIaqxzVOqdSLJTR9U8eXh0u9-khctkeFkxpNNBWWrKbwZr6a3l6g87wpC82fr1Kws7ZbjcjOwiI4ikcyyw4N5McL2QkViXX9yPwiyJdmcsn88YME44JeS7FAv66oux1VqbMnMhykXcVH8hb0T90p1k-RHlvO27R4K03HM7R672haeK2kTDIELaysNi4srA9oJSEIKNbDYL5GYp2080Xwk1CtKB9JR5v_8sKFQL_yuzrzYPJ4jafRaKuAZUO59-R0ko0Sh1QIfToZ8STT8shvT27Yq81cFV33GP5MjZGQ9rylbCsOp4gICAdEZQrkDBrebR7v-WhmOtxANVaSwDyv13EOwBOHoLe1HgOtVZijrtC9EL2MWG9GVV9ErkXC6EKZ43ESUR1UpX0wAwWFLivvAahLsM7T8ojSy_blgZows2IUUOj1eoVUu6Z5CRdY7bbMp3oXHOLWgHOhXmGnXy7N-f-UBazAmEEcfEiJgEoEQv_s2Lsdsp8_DcXtJmV5uoeXq8y0M_VqT42It_8_FTi0jYD7rS9F31QDbry6eItEsLxgbtn4gAuaDGWuqcRUO7V_4S_aPcEsh9o-Kp7VOfcO1gr9lzBoMhvYQgUzbiEL9zPIWXgLTeip21XwnHzNxDRXNfsNxM3aPy-82XAQMXGx2sC5vl5-aa2WDs4Ntq7c0UPNf4BXIc_4Txvf9d7NlH-8Nar2LhZuzjUo2B9MaGg8QBfJLTOIVyBtm3HiA', `SearchKey` = 'wofCscOAwrDgcKlwrPCuMKDwqTCn8Krw5nCucKdwqHChMKhwonCvMOUw6TCjMKVwp3DgMOTwqPCuswqTDgsKxw6fCm8wofCpMKnwrDg8OgwqCwrDCsMK6w57CpswofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrDgMwofCscK0wrDgMK6wq'
# [27-May-2024 10:54:06] /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
# [27-May-2024 10:54:11] /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
# [27-May-2024 10:54:39] /finance/root/bg/invoices/10404.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` = 10404
            LIMIT 1

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