# [06-May-2025 09:19: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
# [06-May-2025 09:19: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
# [06-May-2025 09:20:17] /finance/root/bg/ajax/invoices/form/clone/10446.html?pid=10446&_=1746512417391 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10446
            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
# [06-May-2025 09:20:26] /finance/root/bg/ajax/invoices/insert.html?_=1746512426771 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 79 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` = '2478', `Language` = 'bg', `PostDate` = '2025-05-06', `LastUpdate` = '2025-05-06 09:20:26', `Type` = '1', `ParentID` = 10446, `Data` = 'MvzoXlraZviqi2kAetwJ-HpQbhHFIS5PcVYlTA0UjTry4QGRNc6QT5mayvhSMxJn7bwRHVHwHNnotgEOm1gLDHPML94y33arLa23f-JKTjLQAyadj9aQN1SU7ybppNvSY91PgrwurdwfMX06ReaiTskhAZym5K5xeSbP573eRwkUTigO8hM0U33vhwQ8ypzzci1LqS0BmKNgR2KY8IqlPSpcvEfHFOWVT1SJqASL1FHpUoSE8iN6tbbFXeed_SA7AIQvQw7vz7CIjPPtZ37tM6hkIoh92HPrTST-QA29so8Je5LGq_szUZijBg6tPlFO0rBYl_8mQOY9jSUX4PtbyEgKu4xQmh2XKXzX2n2KKn7nMLJTS77zN6w93wz05-wBrdhXY_2uU-ghpp0kDVc_usedU8yGxpSpAJJ7L6y4evsBerHvWr_S2jy6HwcPsKhg__ce6E9mu0Hwo5ygZ81NZ_tUCvcdtJ3ReGXUSHe3XIzS1mqYQXtGFnDx0cmU7SThrpQo73AgpkUsQdSrHZA_e-OdWZvQKFTAOWsQj3Iyt68G5zEUifldqinczYf4dARsl7vW1gKN0BhcLnXDxShpYGrh1JCAUL5wBjr_uxHQgDx4iyQfmm3JLi-ZBrjqCaFoR_tCmxnfwBDottlBXj8l4QOhqiGNPWxI0_rBpy1JTOfOswvbetoRzyactH7C3F8yncQ9SrLhv5Fz9d9GQpC7hLU1ONYCkzFICyeJa7ZsxcR93Ulojyb8hgVDM3ybKbC2XxQ4qg-F5XfEEuzMFjzLh2mY9CLxnyD8vHrEIgSR0NwyGXIeIT-lGsSYjHzkksKXPQyjueYD-bYKkGL8gjA5vmO7zRJSHkTvAWBvl_s-j1pMF8_wQwpQuuEt15LmlzIlevLn4eGSMvHqWZQzSE0lnN8PcXn7JjTyCpIfpnyzHE3BRODLEBJdswxRRLwTA5z7VTE7Qv8eJoQjLEGDqCjpm9hcc-F6ANBqqZGX1ILIq_QiY-gMiQ23S-rQs_fusQgnhJ9e7LjuSkWxpWyA-YLD3RCnn5ITKyKetLbif0YTH7rnxqDCq1XSxNp6QHhcXmmsZKVw3rTm5sreRpBzgEaN7UWK-5pL0ekEg0QK0DOyH1ei0GBf-_FefrEhM4Lbt1fszff6I43wZC2D2Cp7HZ-BZrsWRaX1nTc7HExB5HkrTrEFQ-5yPQB9fKxbwC3Eo-ORL7Es0iqUKN7Z_j2vhjYnl1ayf0VBHSGW0t6TrCssGaCKnMhMFWCy8BxtDDmFbJKbSt0fst-gz09OzCL12Xij6CbxrvTOKJ2FNDiPPhHdlOzSGwud86vS7vzmhhXskmOGbRLKo2L0c-YCtqpI9a3XmPVbIDJ5YoMxRAQBYAdLYWYW-wk2OZGpLtvpwlCwm_wfLfYIszVIllu5iPg5935jX6GleeeikImH4GTmCz24dXakn8QuTHh20C0tCdaj3b6CK2dkS2v_eBpJm3s1oX7CAYBNJt_UVj88X5404DAEIz35_QwwR42wTEl_E5BTMsgw', `SearchKey` = 'wofCscK8wrDg8OgwqCpMKDwqTCo8Ksw4zCwofCpMOqwrDgsK6wrPCusKDwqTCsMKrw5rDj8KdwqbChMKhwonCvMOUwwofCpMOiwrDgMK6wrPCtcKDwqTCsMKrw5jCpMKhwrChMKuwqLCvcOIwr7CiMKAwp3DgMwrvCn8Kpw5nCr8KfwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrD'
# [06-May-2025 09:20:27] /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
# [06-May-2025 09:20:29] /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
# [06-May-2025 09:21:11] /finance/root/bg/invoices/2478.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` = 2478
            LIMIT 1

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