# [19-Apr-2024 09:06:50] /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
# [19-Apr-2024 09:06:55] /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
# [19-Apr-2024 09:06:58] /finance/root/bg/ajax/invoices/form/clone/10401.html?pid=10401&_=1713506818685 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10401
            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
# [19-Apr-2024 09:07:04] /finance/root/bg/ajax/invoices/insert.html?_=1713506824597 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 62 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` = '2227', `Language` = 'bg', `PostDate` = '2024-04-19 09:07:04', `LastUpdate` = '2024-04-19 09:07:04', `Type` = '1', `ParentID` = 10401, `Data` = 'tdruED6r-mX9f1CFYQcPd42BA_dQ6x9yJcEjR4GS2KUeXCjl5q9uBcNF7WwPReQz-rqlsKnQLE_dxzF_JERswu6Rh49X_IpnmO7NGNTKcUXOCtRcLqzfIrvCWzXsWU9MNJ4_g31bQEpJqLm1SZXDue5O7IXhbGg6r-uKy3BfU2sf66aKqFecilFRPhd1oamL78XoZMBhSjO157IKADytaIYgj8oifPkIm60z29l9rb3fJZWbTg5MxTyPbmiE3LH03K7qZnZ-_6g-eT6E0RhS982-4iRjxfhQLgl1FexokWnT2xIiHq29rfQUhM77FSVuh4PJJR5sU5sNVagoCX4MQk9sALFejdzMieWTqOr1uh0UvNK8kXIZd1GsaZC4wNeSwwHmAQkJW13XQPVF-8r2-G73Tgl-onvUO21NeCg76PNhjUakoRb7E3QYB8Le_YUEvqIBuamFXhgHrgZHoviygPvOF0zQZ6wxD7U-Vtlk7oAM5VYAmxCeUtNy4NJaCv1kxW9kgnQUQ1Ewl_rZYc62WHZBaxCSWMFCmBJpb7mfvmmCaS3l9efC5F3f9w81DBGbDEWmASez0EHeDsosZRdB2DW3hNp3esXKcrJp0rYeZIxUBvYdHtaF8F0qnHwnYKzFRTt9N6HNjjOFVIcWMJvT-4xRS9F1cdzFcICMomSSu9-GDDclq0bE0Sy1sP3_XHhLMqpk6hbLTpOAH_npyypblMShOyUOhmuCJrVhjeMbLxqFbZ0hvd08g4nN5jqw3F5rmMv3HHzX1YD3BJD8rwtqlPCLCt-cCxgXSpFizHsBTDczya-XGWD8MaH504TcEnp4XThe-sWczOOmXJYFavFpil-hGpPh7RL3YKbDRCEr7WmYdmQB6IfD2_5a5Y6NLxnhizfZ-dGPtf7vVVVACVYdXFdxcmGhacSwjeS8IBWPrdB9d3_lAByhRCJrzddtNVAvovavsLmo5annfVRjAW9fwE-_9_KHLi3XI2kBsqB9WL5LpZcHNoy5wNMu7WCRF49j', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwrnCisKpwqPCp8OEwwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrDgMwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKd'
# [19-Apr-2024 09:07:04] /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
# [19-Apr-2024 09:07:05] /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
# [19-Apr-2024 09:07:08] /finance/root/bg/invoices/2227.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` = 2227
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-Apr-2024 11:47:42] /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
# [19-Apr-2024 11:47:44] /finance/root/bg/invoices/2227.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` = 2227
            LIMIT 1

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