# [26-Feb-2024 10:25: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
# [26-Feb-2024 10:25:09] /finance/root/bg/invoices/2188.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` = 2188
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Feb-2024 11:04: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
# [26-Feb-2024 11:05:30] /finance/root/bg/ajax/invoices/form/clone/2166.html?pid=2166&_=1708938330664 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2166
            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
# [26-Feb-2024 11:05:52] /finance/root/bg/ajax/invoices/insert.html?_=1708938352293 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 9 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` = '2190', `Language` = 'bg', `PostDate` = '2024-02-26 11:05:52', `LastUpdate` = '2024-02-26 11:05:52', `Type` = '1', `ParentID` = 0, `Data` = 'WRByy4UFdOjtGLatB8el8IMOs_YLmq8_uLbqlpdyixs2LDCR63Cjh9QYYJJVAQcLtILI9Y9rrz15P5BUyg_XwjI7h2tiTJ57gI7Dvw9rE6dDvFLbRdEicG-CIA91cTAI7B21j2aeIeTx8Az1A2KJWEnoZBXppDP-w2_XVWFKQ4q_TChmmKVR0NTg5AE8pTK_GafxFkwDVV7oF6SHxYVnlaSAhfRnkyN9LX0p-H1AV0GBZeZQbN3EnchUVSIE1HVavtyt9DMogcvfkwXNuTKTP5V5Yiwo-sIRooyDFp-gY5jW1U_KEgbOzzN6Y19hiEzJmhUTIBPS1g87cjWN32nk_tXmZYVzhWCkEm6PbAb3gQyl0k19kjclGD7VtlOxDcB6URmHB7Vf8P51aZYXWYvpCMrFXpLNjXu-lpPOVl_jQy4IRignB0-mR2YX2iuj2bIZaJ5CaqSRseOMUyiGlWQRX-fQhRpZxbqzsSGVHM2DeS-aPi0_1V32xy7dCQks9o_sUfxImei_FRzrg8v1CsNiN81jeWS6Jg0pSqlZpbRQ9El_W5usroXGF9JVMyaIiPv3f4i6Ef1CEQKWjcpNfJl3VarIdjI7jhJpW2pE5yMHc6fnmzqJQOUeVCGpjYwM-EHnJVsXFJCCzm_pPtG3ZhQ7v6Y81KUcfY0sq2Wuwy43CQgPzFFO-xJ3pkFQTT4Cth42nji9_Jxs0a11HSxEBpLvkHXhMExhGG0fkflVkcAW0jEFSAI40FEzXiqChpijUDJ0zVT_s_p-s-W5KPqcyVk_yvZCKcvOOELOBVQV5yIMudmgQyIe9krtI-o_4refiCNXxwbizojwvbaxuQNDGhfKqErfIe1dRuUnWHSt2rWyAHCZ7mFGrRYRGHvVd8GCMc9EdCFAszEmiS6UdTcw5BZbYiW9XxnTxAIjd-hWw9MhYNEO74uES1JN1UiIlLwvYecTwwjoQuhWMglBotI0ZXuGG08mmeN-0w8Y4AFGwr83vRgINHAmObVjjRN9HAuIZDTVCxUMfD0a1IUcRBWvCmk4vx0kY6LAlgy9yG-Th36oSAz6B2AncqCGLe4_CEmpwz3Sv_H5qbamYKmTz6OExjCir1aDVa0IUul8JiNGdOajZPtjiOc4T80n2eJMMdluBM12Pz4AlanXI6MoysGjRYDeV4FUYQhbhJ-y4uyosaXEpQxy9351n5r_ocNckjWVb1ZWcxzh7jmu8-SjLMone4q6pk8ll7LWChASgCrhuTih3T5a28aTAAfEQgdckwTEEJ1RJ7nPEXfefcSH3TIlh1NdIUz3pFMgL_67i5p5gvJBBvdG0K3cAItCESfWsWGKOyvvX-2xOGolLuqIV28aful1h0u1pykupST-U7xSiL3tVGQCEBDO0T6lU0C2FB9Ag5C1q6VJ0uTvbR8AxiV6HAzcQ7pDNnygSMCI4bgPXgytykKuCtI_F7I7GuvDpm_EFy8c8NrHCrueZGxXuES1FXbsFuAUFSh-CTlshUTqOrVQeD0D-p1CtwL0p5x1aNNzfCS55oBDPWhxWz-BF3c_2O_jii9cI_iPNjlu0NSYxBdIfwRfC4fgUVwwsW-APTS3pdx8N2CjQhCQf6KD3gvtmyEa9HSFuY7J-WamrGpgySQs84FeLLxbgICGAJBCcjuTrKENS1J5W0z66PKVT15dhKT4H17JUVX0Rp-NcjUhDTWzSJhc626i8P8Yam9pHDk1BLT1dn4a0NhkRhp69Wr0vSMxoSxDJXx1Wt_GxdaNu5z0C07fk0Rns4vafyG9Y4-XEnX2Devvywrtb9muWkiY7849Ow', `SearchKey` = 'wofCpMK4wrDgsKlwqDrcKDwqTCwofCpMKnwrDg8OgwqCwrrCisOGw6PCsMKew4LDo8K1wovCvsOGw4fCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw5jCucKd'
# [26-Feb-2024 11:05:52] /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
# [26-Feb-2024 11:05:54] /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
# [26-Feb-2024 11:05:58] /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
# [26-Feb-2024 11:06:01] /finance/root/bg/invoices/2190.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` = 2190
            LIMIT 1

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