# [31-Jul-2023 10:54:54] /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
# [31-Jul-2023 10:54:57] /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
# [31-Jul-2023 10:55:04] /finance/root/bg/ajax/invoices/form/clone/10371.html?pid=10371&_=1690790105210 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10371
            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
# [31-Jul-2023 10:55:30] /finance/root/bg/ajax/invoices/insert.html?_=1690790130476 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 39 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` = '2050', `Language` = 'bg', `PostDate` = '2023-07-27 10:55:30', `LastUpdate` = '2023-07-31 10:55:30', `Type` = '1', `ParentID` = 10371, `Data` = 'nmF9R1jxDmAOOglPNLRZyKkRjPy3R_sXrO-7X9EQg3qIP7YcXHdcujvBS_OkeAb36kqOK_VRoUbfyN7DkFYUwD9b-gqFPor-pMPjINMPrNYZYvIXbjW6TPR4BFyHA6UwUnfAL5ev2ba7g-wkIS8weHZNKu6992l_rmhen4wdQxKcP8EIcuh_Htvf8hpj8MQc-d8mvRMF7lji19yM5cTaVZpdypND16StQNyME1HO3xzmcEPinAVKXklmNUeyhCH3BjOpdKtC_b-BZmrD2VYp3LZACRltddyeTdeFRxACId35DJk3lA64arE10JrOM0iDDG9qF5Rbia11EqWNVXBmlyvo8xSIMEfz2SZxvcoz11JOZQ9UcRQGxTep7Pp2-Nu6rl71eTMl1IkHQlivunccl-m4r6z-a97wSdCccX-OB2DcYq9bYZfd9RHeucoh19GaU4cQEQXloFgXbneOKUkR4g3SaYPSrYASKfixpgzWS-rqTtbe28pKJVcSpNcxuQTV1PCQS_VX2ZgYmkfMCXOzWk_nFLmAZlM38lJTC9upVaunF3LKW294hWEzVmIGWeRKQAmmnAM-5VthVlvLv-S047d163_xAjEGZFd29n_01G2i16QRpQgZoGxj2-ptI0Yitp2ngrsRYPly9S1iiPbtwpcPx3SPmVjIP3PNgd0spR0CfAHDL-WBWn9xfrwlNmWpPBdIcckE4qLdzZckEPa4cR5EsCaoTgu--mQrLNYKXzF0eVOZPv72I1AEqURAXQfwrJA4D2zxyY3uee2iAVG8GbwZb7kxk3pw4Bg3QEf7MAhoOO8d9Cz-_jb9rNFXtmKl5j2yR2LPhXIWTRBu17mxKk1dkaqN9ylb3N0p1x9V4Y9jLcBWoEVPwKryZcXLr_R2RGmHdGxDbXmwscRvP6v3JRB7UzyVm2e_4KCMx1KRJo-kWwkfQA-B18Ua5WlbOuvjaH6PKLppBCkA_93s5asPYbg3_HO6I3qix6VqSAJ7Z7A', `SearchKey` = 'wofCpMK0wrDgMOQwqCqMKDwqTDgMKrw5vDn8KhwwofCpMOAw4DCtMK6wrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwrDCr8K6w57Cp8KzwqXDwofCscK4w4DCtsOgwqCp8KDwqTDgMKrw5jCucKdw6jChMKhwpbCvMOXw5TCiMwofCpMKjwrDgMwrHCisKpw6TCp8Kew6TDwrDDhsOGw6jCrsODwqHDoMK2wovCwofCpMOPw4DCtMK6wqCo'
# [31-Jul-2023 10:55:30] /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
# [31-Jul-2023 10:55:31] /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
# [31-Jul-2023 10:55:36] /finance/root/bg/invoices/2050.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2050
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [31-Jul-2023 10:56:53] /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
# [31-Jul-2023 11:22:44] /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
# [31-Jul-2023 11:23:07] /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
# [31-Jul-2023 11:23:20] /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
# [31-Jul-2023 11:23:28] /finance/root/bg/invoices/2047.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2047
            LIMIT 1

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