# [03-Sep-2025 14:37:32] /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
# [03-Sep-2025 14:37:34] /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
# [03-Sep-2025 14:37:41] /finance/root/bg/ajax/invoices/form/clone/10461.html?pid=10461&_=1756899460318 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10461
            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
# [03-Sep-2025 14:37:45] /finance/root/bg/ajax/invoices/insert.html?_=1756899465134 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 47 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` = '2546', `Language` = 'bg', `PostDate` = '2025-09-03', `LastUpdate` = '2025-09-03 14:37:45', `Type` = '1', `ParentID` = 10461, `Data` = 'oioqdim_UL7bGvtAedaB3xiPhbL3OxDtTYmC7x3MMqAbIbyWR6K_Aonlz_mrO4Aa4LSUokQBDqEYYTMg91pPfxvwkI2want79uiuAojpnrjZaZgloE-1bDmeIjE4IL4oaoKsl3AnxkhHyQnKFtnP-yYfjj__svJx3AzgZX52RDupE36E3NyHd-2yxVc0vVjjH3saksTVhRbdrmcuIdQxNJjPKIG9UhraKbu62KSeRQpyYdXLNLk3NOqvo4SfieaFbm4cH4cSROmd5l2mUgSGLk8XzdEsmtPE4JL6vFDr3ng1vuETjsNbPS94nR0gzfx0j1a3cNU8nhIHy0_0XAs3lGNsfRkuo9fWZT3GSx471mcaTkLn0h1OryioPZnHfGUUm_jBME5zZyQiFUi0hnhX_QblyXPFllpyEuSWVk_hp6COLGlpkd58--vbuxh7uxS2X28NQ2nKJO7xnvFaGPiLUy2PIlE3bnab2zK1LNUJLc9C7oTE4y5IYAcX1Q5lj6j6RHABeTGWEbMn9eIbcX650GheBX8sAkZkoc0wbi9zY9xXu-9YSXcoywnJnUpei7fsFYmmgodTvKXUOMxuVpwB512DMvCGE09eh8aEj1jpBHbRA9mdd_U8K1QxYLFc2K-0OUN9f6FPQ8EXdfpWSa57JRhCeuO8vRbMjFGcHaxWbTtgoiRIE5MataLT-OHEh-twS6dGvxJLNCbZrv7kp84-iIvByI_q7IaGN4f9qL4UAohtGPWpG3OqyfOr3SzI2ozZ8kVqLLbbmXUAk1P1ju0bHGv8btleaxAHmS_iNa__SEljjZZWOpVgA_1Keh9X6GEwxJ3fBeTRG_arRqZoUi6Uk7rEClPVDtPYigqLNnrX00Gi1Y1Ko49WLOPFoiABJcrxXx6aEmWWJvG-efstYhiJzmO5bTF2KqbE3G35bHmvTFZKlssQOb1dusKxjS4MsfA9UFPcAKO-H4Nnrjrhn-zXjydl0FzGZ4k9y2WFpgzG8TAWrKmZsH7Eane6mBhmilYUKMdnlEEgkZnxtzm6FQwfOZzGzYlkJnGDKuR3CbbX-6eU6q5ItoMDAjh8vFiAVfVT', `SearchKey` = 'wofCscK8w4DCtMK6wqDq8KDwqTDnsKsw4zDn8KdwpzChMKuwwofCpMKnwrDg8OgwqCwrvCoMK6w5bCrsKfwr7DqsK2wwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwrrChMKhwrTCvMOWw6TCiMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofC'
# [03-Sep-2025 14:37:46] /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
