# [04-Apr-2024 16:05:13] /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
# [04-Apr-2024 16:05:16] /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
# [04-Apr-2024 16:05:30] /finance/root/bg/ajax/invoices/form/clone/10400.html?pid=10400&_=1712235929852 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10400
            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
# [04-Apr-2024 16:05:56] /finance/root/bg/ajax/invoices/insert.html?_=1712235955221 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 58 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` = '2224', `Language` = 'bg', `PostDate` = '2024-04-04 16:05:56', `LastUpdate` = '2024-04-04 16:05:56', `Type` = '1', `ParentID` = 10400, `Data` = 'j8uRVj7TcJLajWvv_pH6y9EzzyWrj4wXcwOgBDUhLu0wijaA9kkidxU0kXlR0FtmjcwccGDqo9H-fJQmjdN8kqKpqC_N-qOIhvWzwq148JCzxtluvlH7qgRJPI_eeOIp1GdxS-MnSbw0mIz8V24fseRbmKjHaK-sK7xldjQmFOtCInWmomC48Y4Xn9VLfJqtMgm3Mvj_58Of0FJEnri4mdLleEf5bzg7dWpZKSAqJTX2zPVTtaEP_yM81AL7zv60MsETv9VbEyTemwEon9TU8N8aNOalOZWBmgQWUnmsSE3VODKLDorYKQAS2a7aaPcRIP1AGDRe1SeGi3aRm0KEi1fVFp9-a8abHsgskSKULdOCZSExoDLNF_e18BlNGRysIEE4u5UudqPQmPdD8fRFvsDfLvujIW1qV6efbjOJJ5Fj-NB-ZPLIvGWhQPSOmKrgcEdNfgK9hLAfylxa-0yFARX67HW33Y7nTMedLdbyIsbtouLbz-MxH6c83yvgD1WumZXty7g0tRfzp4jN2EGagt5woqxDC4vofVasnHO5qZLfSxOS96sTacz183ym964mF1ZjPBm0ku9oX3kZRfuAKtUZ1IfLyPgXWTQGyK1EY0YcfIjWUZ1Hr_YuFOLiSVW3-LjmaWGs_9LQTv40PbwlD_ZCazKaDp3UVbNctKz95D4omkg0sPXMMmBCgq2d-Jo2MIh1D9AfeY8woM2DLziGl8rOxkrx28--X3blx2o6qyMaSIz3ZBwD4uggetSxZDVYsJoPCz3GNtQhzHoqBsLnsPcnxBqnMVhIUxBONxRIn-d_wxwENbe09XXPTwt17tTFMIIZRpQo0Gg1TSYDy33ccM4l_nhqsgFsXMfDq2ZelpiOs3LFI1bZotBntJObVo9ymmzQ-Lihd2h3X1vjwmOUcApzlxmkCR8jzNklq59iXuLoF_L1RraX4-VO8Z-WpOqHXzf1DHew0PnKPQqj7x_D9AX-0umklMnAlGW6YHYswhuuKgpGmXNttIubLnMaAwR3yNfAGvtluXSMT5DL_ZlGwp_6sOkYjETInPCW-b98OBQ', `SearchKey` = 'wofCscK4wrDgsK6wqCq8KDwqTCuMKsw47Dn8KhwwofCpMOqwrDgMK6wrPCtcKDwqTDlsKsw4DwofCpMOIwrDg8OgwqCocKDwqTCwrrCisOcw6HCscOZw4LDwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOU'
# [04-Apr-2024 16:05:56] /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
# [04-Apr-2024 16:05:57] /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
# [04-Apr-2024 16:06:04] /finance/root/bg/invoices/2224.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` = 2224
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Apr-2024 16:07: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
# [04-Apr-2024 16:07: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
