# [11-Sep-2024 13:27:45] /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
# [11-Sep-2024 13:27:48] /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
# [11-Sep-2024 13:27:52] /finance/root/bg/ajax/invoices/form/clone/10430.html?pid=10430&_=1726050472295 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10430
            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
# [11-Sep-2024 13:28:05] /finance/root/bg/ajax/invoices/insert.html?_=1726050485115 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 65 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` = '2328', `Language` = 'bg', `PostDate` = '2024-09-11', `LastUpdate` = '2024-09-11 13:28:05', `Type` = '1', `ParentID` = 10430, `Data` = 'c3FGP4nc76w9WFswM-rDPSkWaORpdvBNAH7GSEbEJ0_rpM9loKLGH5F50lZTIqKMAX5AuIbPNPu96_0yFev7p5Hnp6un1sXwsoZlF487HhlrtUgD-LV8-0mPmxKCJ5TG8GmcIIZe5cMvBT2y1kZt8mkBU5_1cksyL9Zst8Jp8QCKt0HtEP7bEpqfI6eSeyWazxnvHReibX1kRhr9fgtkQICfvvTVmhD3v-OZHaOBoMCBVpHEWMKAagtscV8S9d7yi-na9_PB4payuxC0_Pl9D4eSG8wApUuLtyNAfNSwAl6ERususz08vvKvvDOFUIFj3NqtestAV3j01m00p-19SshE_W-6UZLl1ti4tb70guvwx1FB9EfEOCuJThuIdWR2ZjKRFy46smCPquUu2MQkxOjU99a8xNpeCw8hblyEuqkz7rYEUAmpjX1J9Hz-07HZN3K_Dntcm1sZLhkkCwmjp3HAj1kNJ3RSq64nTdoAjsWmfP8WaIg9TpM0hs-Xn_IHwmWKzwRNeNk8mpnG5kIcM1zKv5Y0lRpkiWJC6DXGqvZRmLa1b18QeeQ5a_505Rl0kIlXiFFF_Zm9Ca2GtGslv2PqFued6i8rqWXFZEMeiDUbh6u_gfRNebSIgcBuO3aFWBuu-BL_ndOTTWvtpUOuCO4C1ko-XT0otPeF2pz3f4e61pwIr6CYwRKJ9bF4tpz5l5Yy_ZbkDOzABH46tPjphhQj2WkMVc4yotC0Y6emAaXhZbvVtCiTGI7bEfUT39kcTBz3_py-J6WWvXyMldmPVY6HanElUxr9ZMC4p9Ao-pyO65-Y1rdtsagXUKrn3qYL6x2ubFUa2FGc8RNZ0RxgXtq23k4kJcBX1Nr72GlRGI6PqPiR_YJZ2v6JK6XEuyy7aMFofmErC8WojSMGM8sjbOKiv75jiqs-6Bzd2slrvDgQ5X8X7bIWoxMU5-w82Rr7MUwnEZ8oZinS1-reg7TllMmQ7pornljtFHNwVrScTkOPrT6HxpI-zLi-qNrQKx6nw9fzyEeOMhldMuwC3Hgg6II9j1GWbwdKKZ5MxNsEfQw_CXxTRQScVttAMLLEpKRrmpypzR3-TdFPg-2dYj-6lvZGkYSpnHdLQgFkDDiDRVnTaOX7jRK_6i37yagVv3xB5uPpzIZNGF0m5IJwvSwy4A', `SearchKey` = 'wofCscOAwrDgcKlwrPCuMKDwqTCn8Krw5nCucKdwqHChMKhwonCvMOUw6TCjMKVwp3DgMOTwqPCuswqTDgsKxw6fCm8wofCpMKnwrDg8OgwqCwrDCsMK6w57CpswofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4wrDgMK6wqCqcKDwrHCwofCscK'
# [11-Sep-2024 13:28:05] /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
# [11-Sep-2024 13:28:07] /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
# [11-Sep-2024 13:28:11] /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
# [11-Sep-2024 13:28:46] /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
# [11-Sep-2024 13:29:17] /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
# [11-Sep-2024 13:29:27] /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
# [11-Sep-2024 13:29:34] /finance/root/bg/invoices/2328.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` = 2328
            LIMIT 1

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