# [12-Nov-2025 16:59:34] /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
# [12-Nov-2025 16:59:46] /finance/root/bg/ajax/invoices/form/2567.html?_=1762959586582 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2567
            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
# [12-Nov-2025 16:59:51] /finance/root/bg/ajax/invoices/update/2567.html?_=1762959591401 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 74 AND
                `Visible` = 1
            LIMIT 1

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1 AND
                `Visible` = 1
            LIMIT 1

SELECT * FROM `invoices` WHERE 1  AND ID = '2567' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2567bg', 'ADlxYN1B_jKLqLJiKxUOcDWPXrUBkaG5WEpxZQ8FHc_c8jPMXvGudFtXDg5mKYjvWnRSRkfv1SodalAaTuE6j4gczJ-N3yoPivARko0VrBZk2hQ3FwwZy3gBZUvJ4mZ4uSUVvXZxXvaju8vaNlxpzp9-oYOYCJTWD1F5fMguZ5Ocf2-zPFhMXzdBB6XpQB0xsGFnYJFIwlTEjpdv3zwmumZ9fzWUc0TSG4KKLm5zyJziXX6KMMGRe09a9XTdH7D8BQcRP8Hz2PkDwq1TerR8ahdlja4gVSW1M3mzk-_LAxm_0j3EH0ZYRjs2x9_0lcYtxa6k61-cJ4WSFfOWukHRFuy-GDjhBjT4fGIMFQfyeyzP2oI4oL4bjFsgoe3Aes4x6NrV2dhG-dQf3sxQCDXrdOAwGU7jVxAQrDRPiNzVx33OqDWTV1mlZo4SM1YaeSwX-lCu3hTFSQ8jv_t9BnV38t1uQCRzpn2Pcwc7-_ZAHSS1fVbON0ycR5F7-7q-637JminuBmTctJ2HceaKAStqtkLute4rlcGOG3EJDOmwiGnC9zYM87fiKKuuocr9JeQQyC0PIZZ5PIeMEds7bjyX-pcfioh9Ycz4dFt7PIXbeyiX9Anm80T_s-vz_PM3wJaHv2A45C9oPgeO1hWutirI4_2gdE794ejrVIwmSaBPHuPulA_RgxrZ51V0xUoOnJaoU7lhuiI3xhi7cO4IzN9ylXEqZ7JFnNFkIzN8ZHYtw0IvzRstNmIf-k80C5T3XDld-IUEeRuZU6ZQHzkaEag021E3Y95rxeVRx6f2Uu3b54Xxfl7RYqiXouo1UTDYNVUBp_dP_mxjAbulBt0gbPuaLRM7isI7iD6vWyTtHuwLtcYTxqJcp2nF-6CTQf9XkrDMnrKLWri9JzFyV6gooPbuByhvFVN6bwnghc8fSqWRzZ9xl-7YEUS73eL5uqzD_gOZJqCYmG1DKtoZ3W0s4xNWAwRc5mYJDpSL9jxkxzhxHn8oFEJmGjer2IvCKsn77x2uiNgzyrJRt1iVmkVrCQ4O06ki8oOg2SCHa6EddfHArHLKAnqg1KhlVp76tr-AgNx6GCI4rWyDYM8Dd5-rKnu4BtFXbE4wON2qWpEs0KxLWZaLm01dDuR6DtiJnYfEfmM-jYuyDCLkdbHqYauMX86lfe9IYNAnX0iyAlnVFohHIbRvQ3kGdLQuIFaqNFJMaALDLjgbJO8Gj4yPN5wKW7EpLAChctwUbzz9QnTXy2gc9iCMMsk_wo32wK1xbVshL1-fhhbMJKIR0QtnYOaTdaSAludgF5jsJMCuktJwWLSo47L9Pq6iU_mjJeoV3nKUHQrmnMKuIUEn3dSaBGqrt67DocdD7XWy8lq0NHbYS8xxnuZMJFknqg2qhlJLVPXkACnVKXh1QoqyGg9MyR085ikwfSSA9-ehU1suYjehcv8CtHaZAxLwW-jPokD9I8vWjRO7iYRJuPPPwFXy1QFTnuSA1VqIe5j7F9V13e0e1TEk83ca5Zx-7Rt6K8L-hr48_rLjsaIcyAbOqoLiMzS--53l45PcFWXPzF62jkWqdVCGBbZ1XWx2sxREaTX6Y6HLFlrOsISUGvuxgV3FIpIVXchNjK9Ln8xBfd9L1nphU7hPNxwu0k-oXy7ayctZkdkJGpv2sAWHb0VVuqrrKJDvj6wKzbagh1r7BaJ40BLqPXpY5hPcMw11EMClJcd1-Ct65Ecnogl-NTANnfDgtfFZlPEt6mY59b-6M1oiApCM8TKk35TLb8RgV9PbClhwMVm6ed4iK7l7PuGxCQ1uyjBhed-lZQ')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2567', `Language` = 'bg', `PostDate` = '2025-10-06', `LastUpdate` = '2025-11-12 16:59:51', `Type` = '99', `ParentID` = 0, `Data` = 'cfSA61CaH6SXEAEkLkYFQnKpxXmTY-pBP9Zlm_GHE0T1TNRp5JDx4NYoub60FhXFqNxvjr8AguGu1yNyaFMFk-5-gfb5Pt4qwSmDvjr-rdZrvMTDqYSOuiMryEDl2Fc4bGv5cFwXzi1fXIWv1vEeOsGTib0nB-bQbaYN9oGr0H7U9O8KQp7LRLbAmFbX7Ui6KagYIGud-_KkF2i25GRA1jDyxiR-NJaxxfAmUasnG-s4quJzqvfOieHJk3qXdN69ulV4fN_ctu_6HRVbqgUV7xGqhnx9E5NdBqgHHOKUI5biO-Pf4Jxf-ZemOi9KG1xxHleXnZ2KQxFvPbXcHKbY9EH2MFnaENeCubqB1AgmTABhTdY5pnBTCBAnD7YVLqLfxebmSOjwvmLnnsS5NfiXbzPwIOwn2LvVHDNEF5coNrWgGUvIeMFC60vMcsRQKUoNRvDQU3TuRLFxtTaFeyp09PBbYd6JqjXirpY5tGYldy4x5dx7IddSMivCG2VsR6MbnIB2YEZMtAxln1pY-WWQ39Q9-0Q-5QcGsoWU0TNAQ0Wy4p7jxY7YDYlRPC36sxDMMnNcgm6903I2A1kHbEWN-XA7u1oQTmBjwaDkPxW3PLzZrZxj6crwxKnpPUKrYCjt5HQRDwShp6sgL6_8I5hchsT3PbMCc7Ut2I0FciK-yBC653x1TDvu-ko-HUamuCBzTbFGPV8jKNijyh-xJoliJtmj6lAoGlgR-_Toqmqi0QmSQDgfTP1plaVhI7wvEhaavr28Z_Q8Xih4lQEMTTvgxPyULJU13w0bV4gDmIF2P966IYZ5TIleWB8H3GtLVvc7VOuzI_vThVtDArd74lnqU9V5OMkrXem21XwzzVZwriGxRFyLBnlgMYEB9j6nwpXV4LB1dkR3j8KJikg1Ilq16n2sp5ouM4FUmXr5Qd7FKHw', `SearchKey` = 'wofCscK0wrDgcOQwqCrMKDwqTDhMKrw5nCwofCpMKnwrDg8OgwqCwrrCi8OCw5rCsMOZw5jDqMKswrDCwofCpMOEwrDgsK6wqDrsKDwqTDlsKsw4zDn8Kdw6bChMKhw4jCvMOVw5TCiMwofCpMOqwrDgMK6wrPCtcKDwqTDnsKrw5nDj8KhwrLChMKhwrzCvMOXw5TCiMwrrCi8OCw5rCsMOZw5jDqMKswrDC' WHERE `ID` = '2567'
# [12-Nov-2025 16:59:51] /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
# [12-Nov-2025 16:59:53] /finance/root/bg/invoices/2567.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` = 2567
            LIMIT 1

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