# [31-Jul-2025 07:29:55] /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
# [31-Jul-2025 07:29:58] /finance/root/bg/ajax/invoices/form/2517.html?_=1753936196013 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2517
            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
# [31-Jul-2025 07:30:17] /finance/root/bg/ajax/invoices/update/2517.html?_=1753936214298 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2517bg', 'uIKvMllNMzO28pg9DxnZdw8Z64S2sWUch__oZV_Ppe1RMCIz1vXqWGeddx-iBXGcLr_ixZuWmNvhkUUnl_wWaqRDgaYUeN-DKVnbDyBSR6EFngaOD8tq6-k5Cu7aenTbNzYvayD7e9O6j3C_FlOLZvDjT7hLV_5zVxnuimw5GhaubGkKCDPwXYR9THT1JCc5bXIpc-z9BG76KrGuHnVZhT8pGWRIY9DsRqpyXnuaGliDggv7FMAXEEMj5Pgn94ywzEf5Ea5c3QZRjgd4L3qluzChr7idCIfgky8vB6bZZPrN9EHjmq2Ygl6BwaABF9xIHJ5ApJcl0IirW0Fp7xp0FZtHbotB0cvT5LT0Bi3VOLmPsHwiLuJVi0vlIpl0j3deRs4wKVS1daLPx3m7fw2rN2OkqEprnsxzRboBOSqcssg5Opu9sb9l3Nz0XW9XbUsVv_Bf_DfTX21hERrTDy4RwIiDTVekNWZxpbrGwq-MrGNaYYnLm7nAs5E1b2edvUP7TwDAL7fxoPD9vmzp-jXuyBQrZ8L0-lTUPQ4ktp8DaYM7lpltMoV5Zc4IOEK-a6t-0A6ezrEQQ1g9veO7UJIzcoE8ByBSO9EOVQxR4gkKvq_yLawVRSGs_d7b2-IjKmV2BCkRMc6P4Xw-G10UTzTAsr1paVxensxBk2eXh2NOAsU_L_1hAkklk9D7bNpnaXfLVamf5wkqfjZcADT7BMhu4NOMVd6D_I9b_bTDw4sWEobERtPSiVoFe-V6si70uA1SRNfB62panL0s5a03cBGfB5Oe81f6XQmsG4qxW5vZhKUTGumiWU1kG41N3XMDKtUU3XygftudqpqbrCOwEr3tXaSgKJm66NsfP-bomlD087WmU_v1Ze0YyB8Eam4HPa9UqMLyNzBOkq8myD_M7mSQmiVY8QLfNxSKmqZZ8Blm_X6OCn_UluXvkK7GK69AOHDvShyIT-lkeUxQ75eCjU139EaAQrBrZvO7_JA7jUDW-MWRzZe4MnfNV0pK4Fs8uKE5l4UJKwVlmXFgN1PlTRGpp8E_tLjJcZfbG_TJjtly4wcUrw5ZXfwrhIAhhaBy_vMXmJ4xUsFzW3Bqazm0c9bWsXK8zIAfAirTobfiYR5iwe8Det49N_7ng88i7OjsyNkrimWWCG31ClxF_DkkMPKONrzNsQbnQXwlPIC-2zMcx1-73CLzPZkp86qJmjEvZHvzMIdn3BTs6-dw0OnjQ1_3WS1XjT8_QYMHGxaSr__9GTrrPcNU1KsnwNLjTgOl-vWbbM5y_pRLqD3JWtBGtYuBOfDgx3r719S6CZUs9B8sahY_KEm8Diwo9ofXX8baxvdt0JuwQ2XYYtXbw48FR20-pu7phGw7EZJVxC-H8KXwQqchksehYNwG4kQLyG-jIFkaftqzbq32SkeA7FeUvHpJTa8jm1bL_DF1Mxw4g18u2WJyS4_7ri6uLHug3inQtX99-bfJ88JiS_zChPyT5EQmtg2RphyI1ATVjJDeq7gf5wj0WFC1zh1ivKa0EPIEP6vb5RoMw53HNF66uE1w0kzZ5hzjOOE3dt-eJxEpXmbvttxkkFEDQGsjtIjuTb_Hc45Wj2tcGk91rR0GD-Cs2M0RMOX-g11uJwQMfDD6TpdmMI0eTeqhYJlBoN2jwU0caNhYtE2ru4nIa-zi-Vpr6NOIuSDrmwUROhnX0HezPc4LllaZNKjRqtyilhSeXs9J-bZgBVjbws4ujV5doNYNjs7ULv_LCmNoE73n00spzCZ_MmjJKnlAHonaANOSD7mOyT8geOLSOnz82kQdCXAIcotlylNsmXDDAkqqsnEzaWChLw6RiSWb8B9vxomsxQw-FnuAIEfWCmGItpjO6wBa5on31QkpcJqBJhYmvDQ1ICPbd6VvRgyJOHpX1loN9IystUmWcrifWCJnS1NgM4lJLNDT1PnbV-lUGJSK7IFmZtfPQR3NweJmJKJa4IDz-ejMeCFB-H25y7cgCflGAFYSZV6NYmxgcIo5EtPFutH9iQ9UqJf-H5YR9Hcsw-skL9kxZuQdNbWNfXnXVRG6i_GyUPISvrb18W-JVnCsQ0QLHSH4z2NpNDnqkDPlc5VhXvUdhmP-86v9yZWt1fxygpRN67gKEST7uNKUVYh77a0THbB_zlqLVUkbl-ke2dlZz5S_a9OHLG-GPBXfQ6af3Pg77FyF8epMf9WVqPCUU4VaD716Ql6Sr-L1Kwg8A9WIJM70jOdGGrZI-Cem2VYWh7nlL_sW4w')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2517', `Language` = 'bg', `PostDate` = '2025-07-30', `LastUpdate` = '2025-07-31 07:30:17', `Type` = '1', `ParentID` = 0, `Data` = 'CxEyNzZCjqKpMr8WmO7ddIkmxTCKq6nXBVr1MtHfsmmWT0eKxS8PuVeZEB_UzXBkLanR9KPiqfMmLHpU0P-KGSKzjHDFu_-V96fVrHIUSKKq5NJ-Za3C90yt8ZJb5bHo3iqM-SufzDnfyh7MqpEYVwTS0zH8ItWxnpi07k8CuuteKb-eehxgdpWBYCMik6NjE2vDXomXUg_ytBoiiquAjemb98DnnuJZLmc8Kvkl-Yj_yJHDxpA0mqBivppBESPpHqP-7gxN5hnG4Jo4CQIOWT_laHufQP1Z5XbZ9Wz6VXh39Zpa9hkzuBp9pL2GwLuIkVkMTLnTC4WbeQhz64imYQZ615wbDZb4tkiOuWKqhA8w7TVahlO6PW_Fu6vRFzEiQQ2QdHrZrU4K4WWcvIcgqBrw8M_gJMi0x9w7yifA9tHYcUs6rlqRff_QLfYig7ssCTWQBVoJHmJJ3RyHM8Iav7wCcOVSVYpsg8IjsqQEuijeJvVl7WyfkQXCp1EncrNEeFfYyxWE7SJBb71kd11N3-ZOqnsOmHrYD8NJYZhjIKqkh-hRdjpErgiVUlasqCrEhxnIJt87_tsQs6gkhNIkToBZ14--lIbruj9ytJljP58hJXxTsruOc-p6DKJk6hzD_943Sa_dwjo15kQbu6hBfknrGut2P5sT8U1iAkgQ4zI3nt9N_dcCe4FWfqEhcwyLZTBrZsox6DOCiMhIZpaE6uRS-b5VsQfJL3trfig6V4byeQAlKzvEsIQtA71tk2-RQwX1IN15sxrYdflwiR1QEvniLlyXNvZ3PgQjN5KCjMZWdWyLrbD7Ht5G0j7OQ1jvgNc6O4hJwtFPXzMSQRUDJFpm3O49Mu_xNVA55L0SBHbNPBzTPDPFgvVdpYW0JOQEoIj4Hz_3qLLHl9fcZG10QU7_qLou7Dqi3jB18WmcHGJkBWM0nSBd23CsRKAOz1hEmTzatdO5o5H3NfpkOiDytljQ-L_O3eEmsZuTbfZd5vQYVPEt5dSSN55kHord0spQh9r1NaGBq-yUSbAyAiWTvsBuvZPlR6i-tNgh8YN1_0lfC-PBMv4JnYiRrRuiFN1FeKTb56580pG3JsXsoPA6hiUTMqB6WWKMEEU_prULFVuqIz_F2QrZjZY-7seF1WnLsRuhHe5Uyn4jY-olAQHXRwvoWc7en3lSPXidTvXJ7-xt-8GBYbuZFn9GUapLn3VHm23e4TJAw7hSFH-IP0w9eaUqFZuEU7S_Bmocq7GguE8', `SearchKey` = 'wofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLwwofCpMK0w4DCtMOQwqCocKDwrHDjsKrw5rCucKdw6bChMKuwrTCvMOWwr7CjMwofCpMK0wrDg8OQwqCqMKDwqTDpsKsw4zCpMKhwwrDCr8Klw57Cr8OEw4LDwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrH' WHERE `ID` = '2517'
# [31-Jul-2025 07:30:17] /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
# [31-Jul-2025 07:30:20] /finance/root/bg/invoices/2517.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` = 2517
            LIMIT 1

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