# [02-Jul-2024 09:23:29] /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
# [02-Jul-2024 15:36:08] /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
# [02-Jul-2024 15:36:10] /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
# [02-Jul-2024 15:36:16] /finance/root/bg/ajax/invoices/form/clone/10416.html?pid=10416&_=1719923776130 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10416
            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
# [02-Jul-2024 15:36:21] /finance/root/bg/ajax/invoices/insert.html?_=1719923780997 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` = '2281', `Language` = 'bg', `PostDate` = '2024-07-02', `LastUpdate` = '2024-07-02 15:36:21', `Type` = '1', `ParentID` = 10416, `Data` = 'LWXaZ5G4x2NSxrnjmYgRi7jC9hq31mRkOSoAkqrbs7WwNokQfh0wWUJwGfIyE2wrn4NsR9s2F6A443YJXY5lgUqzwxNvFxESIwWi6EBh3GIFNqxaHyU36G8IUzHpF2pW9hFe7EBjGXdvt2_Fd5DtnaGMoPLgnQWaC16_IoUjrjt5psDJNOhtiF9abgAWaIdd3rq105OOxQ4t9QxXpFaERrzFFFrLgHiH6IdfZqCocyUEmi6RaDq9QimRMek44Ui1kU4zAkOYNcqBU953apYf1yxIE0naEvAaMdaGHIvAoQWDQhuma9zHIuvzLUqZGFn39E1FhfJsR8VShMnGFM-BTi8iOjBlwzhjr02mbMufvzOReCz0-bC4fFKyX-Z1euT5uZa1f6pef5cLst3scbE6ifOLZ20MLY4CWv-wSlCQEPQ9QAO62fsBIeEqrMQoAnHPVD7vBQWB1v_aDhKXt1qE4y_HYZOo_sr4jFuQ8EgO8xSufeiQ6ZqRss-2AAOgfJRGAtzPQXZI-f49pzA9073M8imrgA6bAqh5mSpgxJ8lJvT6yItiSxptpaYasJ2a8m1_q7OHOLG2APDPVb2gW2i9Oh-uYqQwc9FOwx3Q9qF02xBVj-QybthLFJ3uSAQQ8VgLysGq3AWU8KUojhaDKvHL4i1xtRtaR1PR8HnxFq36tXx5qFooO8hACmKBsb3W0fwFlmqtyEdbFYUSGadXDIBEd3sNpe7tF5dQ3rvklchr-zpXmUBI43UW_InxjL8KUXY4CbcBoy2qEtQtztSBUy7Km-bZ_PR3yvo_JvCuZytFvLMjAzCmyXH7TcHTyx020hJ1EBWVjf4pRjuCHhsXDnYJ30cwPr_AJe98-VAjjBKhYmoFmOdJvMx3sEOzyFeVbHszYMNmFYd-1-hyt7Qbpx9sqqCQCB_zr9DhBe8msZdJO10nWJSF_73jYOIvkFwdyK2umts3A-PoJAPa45ibnOPMiQkiXGlVvqpDhUWT6UlpRilsYVrvU9XQBZnl-we6aLQ5efc13XPyAywm7GPypJ15E_L_iiudxCUyskVYlbN6vVg', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwr'
# [02-Jul-2024 15:36:21] /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
# [02-Jul-2024 15:36:23] /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
# [02-Jul-2024 15:36:33] /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
