# [09-Jul-2024 10:08:19] /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
# [09-Jul-2024 17:26: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
# [09-Jul-2024 17:26:08] /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
# [09-Jul-2024 17:26:24] /finance/root/bg/ajax/invoices/form/clone/10414.html?pid=10414&_=1720535185544 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10414
            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
# [09-Jul-2024 17:26:31] /finance/root/bg/ajax/invoices/insert.html?_=1720535192481 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 13 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` = '2284', `Language` = 'bg', `PostDate` = '2024-07-09', `LastUpdate` = '2024-07-09 17:26:31', `Type` = '1', `ParentID` = 10414, `Data` = '4RpJnihoFRAjv886HoZIeZhfiaOTnXNImQYg7BRKlhsFKfKRD_PnpWlD-W0o7f0vzkjG_ddFzspi3pgYsRsqUU6xwl3yMuvNNu3EpWQwr3nb3Sklzu1eR0kxc5zi_O6xWdVT86lcox2yFa0wdvA5vJ6K4qZtxaGeP-5jrbbmSu82aOjadNfeAudqHg98sTb7doYfidl0DLTyHJGUJstr_GuKIvathME8dSnO8YSfp60RJYDTi02qsjfRvAox5EskUvZRjbeHLmQF99wzx5RMrk2OOqjE4S5GIqkSBkPMpqZhJD5wj--NCEg4IYRm9tj-DEspn20h9BiUAZr7wyqQrzkq14HOTEXpUo41qyHIfG9OVOwyXNwR0Ypefjcvk98PVViJHYsqeKSCmv5CXpO1dl4n9adNYbK3dQf2d8T-PvZpnAZOlKNZCHprwcK6qonIlnKujTTxIA5Ie1GIPCL3_9aFRxiRwhNI-ddiQpGWf0JtkJQ5i1UD5pV1GYug04xCtGWQdhCMVJIFUcpSwsNSv4IWrWFr8ZjMRVKEeBng6IC2owBPh9VubqxNNCNLRVBELpYXwJpgx46_p0_oXEFQwRxV1FWBsUNIotIzdWizWTDRAF-brpH3mkSzLd2lWGgkJm7DfAHN0ggRddrs6W_bFkRc-SOCZrzbLDVD3MD6bGttQ6nkpzktebocJ9OQpt9Tk6Dh7YYnZC6zGqRBCajc63QC6eBdNFxHT5LRTNas4BmbaJkUlM9gd_tF2X85mMpBFJR-o1_FksPyiJGA2GJ7S16Wd8NGLdDgkX0J3tf7V6hFmY5wTMTGr3gyEja9AvoDztxqjaxu7X-dWOO7DlHvEREmOvGFKj10pmbDCuZo5mgnUAI_CYnc9HYNm48aUyngHpQCwwfeYMeI-XDaXPnfcTvzFAetHjcsk0KXMqP4SSE0_0oEKj5nv9mSneyhnpY3BmwkSwfADWEwLFUNMIMtd4TrrgtYdSNF_JrxYAPTbyqgxpKLEyNcZAVEfB13_MQAikzeg3XBrDBLCMyV1qmjyzMxt3F1ilv_8ORNoxnuCJ7X0FX6FXaJK7hkK4zwsp7v9tZEEIp7172KDWigL8yLN_Bcot9KoEJP8ZDSie6He7A', `SearchKey` = 'wrjCn8K2w6PCsMKewqXDwrDCsMKw6jCp8OEwwrnCr8K2w6PCpsODw5DDoMK1wqDgsOPw4nCwrnCoMOCwwrjCn8K2w6PCsMKewqXDwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4wrDgMK6wqCqcKDwrHCwrjCn8K2w6PCsMKewqXDqcKswqCwrD'
# [09-Jul-2024 17:26:31] /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
# [09-Jul-2024 17:26: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
# [09-Jul-2024 17:26:54] /finance/root/bg/invoices/2265.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` = 2265
            LIMIT 1

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