# [28-May-2025 14:08:12] /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
# [28-May-2025 14:08:14] /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
# [28-May-2025 14:08: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
# [28-May-2025 14:08:31] /finance/root/bg/invoices.html?from=01.05.2024&to=31.05.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-05-01 00:00:00' AND '2024-05-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [28-May-2025 14:08:47] /finance/root/bg/invoices/2244.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` = 2244
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-May-2025 14:08:53] /finance/root/bg/ajax/invoices/form/clone/2244.html?pid=2244&_=1748430532855 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2244
            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
# [28-May-2025 14:09:29] /finance/root/bg/ajax/invoices/insert.html?_=1748430569324 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 28 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` = '2481', `Language` = 'bg', `PostDate` = '2025-05-28', `LastUpdate` = '2025-05-28 14:09:29', `Type` = '1', `ParentID` = 0, `Data` = 'U49lXzuf7tM47JPkOkP3qwR_mhX-sl_wKxG7haj56goM754mTPFmlGO3x9seUbAfEh9OwVnewVasDh738m04ximL5uASoVMcZalqlRbqK-KtRmx64XjHjyWKaZwEzfW-ndTZnPsUW6MbeJ0ZME1nQIUIF9TbCFDAnZ8lKu78YKq-pe9NN4fUOV54a8cLt0DrmZeMMmgI5N_c4SNZAC3HAOGouJggXgKwPRJ0wM8Ac8T70IhM7zDPp5NMvJjO2BLMOcGmubXueCQ4KoE4fLUjxMIl0pTW1q9FSeA1J_PyQ5fBEo-RfM_7GZeutKC7kalP-BrRJXzJ88aw80k-nospNjqWVcSvUSgR3xABYHObqBppqRB4estIEDpkzU9LSNxWzsp41m5YCJhYUQduvwVcTLFR5IqBMnH14hsl3JC50oj5hc3APZ52U72pS7WziyXuqdYv671GcQpn9ch9kRF4WIV3yvSvg6scACPWFW2y7MhcJicsXgZiL8vAJ8GCOunZUI9bfkFIjlibJ9l9k743O7m7fMny7yuJKotnyULbBdMZTsuOrHRjQE0VTQbjIzXUASBr1Bt0L3WYgHtILg7YzK_AQ7yAQyb48REB0RYc1KER5WKv7IFeSA0IcVVy-sC5cx8jr4wL-T2blAg1hgl_RZqtaoahjfqf6QF9YGScghytiZP67gcPz8wrdP9XezStHHxWpAb-y9FTP0Bq2Z1sunpJpJKumobRx1inX4he8X3yiuJoBLB2TqEIVkpe12quqWlC0v7EyaxSK4CTITLLndPrTZiLeRMgfFgZ08VPrgsftI0r_IDVz6ufd3icJAdkca7ly5eo6pYeLRR5IAxogkoS0It_XKYmNmjJzsHX0CqYNAMLcDAAxQe6Qc2YiqXSXNbPjRTfBsnSVKTfGEjDDoaa3DpCjU9TTzGI8Jlxbf-VUv6JMClfFx8NJfXkn7pS-1J18sc_MMkc7ls2V_zOVVToW2KIV-gRtvRKqmcHPmM', `SearchKey` = 'wofCpMOawrDgMOgwqDq8KDwrHCtMKrw5rCwofCpMKnwrDg8OgwqCwrrCi8Ocw6HCscOZw5jDnMK0wpCpcKKwrDgswofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rDj8KdwqjChMKhwwrrCi8Ocw6HCscOZw5jDnMK0wpCpcKKwrDgsOSw5jCrswrDCisKpwwrrCi8Ocw6HCscOZw5jDnMK0wpCpcOUw4nCssKww6LCrcOCwwrDCisKpwwofCpMOWwr'
# [28-May-2025 14:09:29] /finance/root/bg/invoices.html?from=01.05.2024&to=31.05.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-05-01 00:00:00' AND '2024-05-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [28-May-2025 14:09:35] /finance/root/bg/invoices.html?from=&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [28-May-2025 14:09:37] /finance/root/bg/invoices/2481.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` = 2481
            LIMIT 1

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