# [03-Oct-2025 09:41: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
# [03-Oct-2025 09:41:55] /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-Oct-2025 09:42:11] /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-Oct-2025 09:42:29] /finance/root/bg/ajax/invoices/form/clone/2517.html?pid=2517&_=1759473749526 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
# [03-Oct-2025 09:45:00] /finance/root/bg/ajax/invoices/insert.html?_=1759473900089 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 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` = '10472', `Language` = 'bg', `PostDate` = '2025-10-03', `LastUpdate` = '2025-10-03 09:45:00', `Type` = '0', `ParentID` = 0, `Data` = '6mjEtFN2Smd3hLrthoJoLMYxw3Kv1lNgFYBGW2QM5fIAtbVkfcEHf3nXBqL2qOS_va8V8m8jo1Hg0lvnBfC8nA2CWZnZBCnl9EkwmdVEmDeWf0h9hNKN2J01uIqTYqw3eLl1MKVB7O_sekH-285wHfXKQv-e-x3vQcGD2A7Ur30D8PGwJde29RZUJqUpJ07a08rlpnVfOzGLUJKxtlbpEMYcrpD6NT1fqc0Gl59zEYoKM3MRWsdpPdW8trpu92gGMe86wjNDFNWjXtHuK-hBSm7WFZurXwJnQJGdbNDfTp_7bt4y8RATTt16W0G7-J1yTfqHQfo22_Cqv5-Hd3MhITq66fGR8w3AQWh3KZBHfGyWXeWxvBfMLAl77AVLREe_cwtd-7YxD4Qkb8YI0XulbtUbRKHwELOOkBASerPiGCvwXgzxEFWekO84_R83On5_ZHAKny9WDEooOqft84TYdyKT0Xwm1Mun7PhSTcMyco-BeTsOrgCPLtU7FKb5Ghfq7zB_NlX0qVzXg0cmbi1p90zmtzkQVE7gi_OeDylxeK9u4dzq2zKxw-smBioO-jN4yrUaQ5G0eT8_0KGiXrzKj1DbGXhQOfmtbBr4_7QBNik2rW69_sVzJpwcqltECTE3tfDl_Axovh5twQthZKYt5RMeQPMdoL7Ahi4mXZcmoiiyAegrmcRVbHAiaOR6N_0AENtBKnTQ98O0oC-4Rchub5ZCDghowbjnqBOe_dkrxEV0IRloJToP0XUb93dJh9OfnE925kNtXWkwO7n2-DJ2c9uIebCVcmmWhpv3YXhVC-UFbXF8UwNmjEpenvdiCuvNKP6lpWJj4LJEUSvTB5o60b-WtL-eKwMpdmHkFjleFEdvwmk0f9-v6l_1m4Ok4lzFYXrlWGEv1GuV-9ko60g-SOIHcTvqyTEZm0WV3Mj4GC55eDEmM8O7SrJ8UaxN9hRdx_A8qarGhrZ6oY49hbXP-uhR5r8OkcKCLtHXi3rjKjttC7LnbHeDos4_M9xeVj52p_Ie4yaxbUr8Ct8MGR589VCTB7fLl9LpWsxG7cxl29BNFSuDaCpKVo1sY-n8CbS2-AaH3AmF0IYST_HYWpYnQlMVi21vwPVGi7hR-YSvczHZ0y7XAKLCWzpk5fezcs6L3JmGNlsS_Y6vMK896cUZ_J0HFP7RrS4Hyk_sJDRqUCASXNfjA0lss3xavnzmqMyxPQNgQ61Hag2kW_zqCVhBBA-kRN5poO6-4HEpPXeTfd0lS0PEXk0VRVFUC5zFbDIWX0nJyhNbDmmptxlZk19CrQ', `SearchKey` = 'wofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLwwofCpMK0w4DCtMOQwqCocKDwrHDjsKrw5rCucKdw6bChMKuwrTCvMOWwr7CjMwofCpMK0wrDg8OQwqCqMKDwqTDpsKsw4zCpMKhwwrDCr8Klw57Cr8OEw4LDwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrH'
# [03-Oct-2025 09:45:00] /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-Oct-2025 09:45:03] /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-Oct-2025 09:45:25] /finance/root/bg/ajax/invoices/delete/10470.html?_=1759473924912 167.99.142.201

set names utf8

DELETE FROM `invoices` WHERE `ID` = '10470'
# [03-Oct-2025 09:45:25] /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-Oct-2025 09:45:37] /finance/root/bg/ajax/invoices/form/clone/10471.html?pid=10471&_=1759473937755 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10471
            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-Oct-2025 09:45:44] /finance/root/bg/ajax/invoices/insert.html?_=1759473943942 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 83 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` = '2563', `Language` = 'bg', `PostDate` = '2025-10-03', `LastUpdate` = '2025-10-03 09:45:44', `Type` = '1', `ParentID` = 10471, `Data` = 'YVBnEDMcMv9PjbydJHDNeHpfw1vsFp3q2lfDwhPhLOBMftPgNR15uou8ZnwNeGxaH-hChSH4Siykf_OOqIEDKnJ7lDsRtoz91A1wuDElw96nKsmb_cAGXYaVi6He523NBwHiV2LTvbxCPm3wsOpG32Vok_BtkGV5q48R0DZojigq8PKiBv6Fjhj6Ca1U6VsgnU2knBtREeU1b2h2VOaBCHffVkItwxAL31NSqCWr3hvh_tR9zifu3CUB5wquKnqtdXhrrcOjHjScWMk6ZVVfvOXqLcUbZ1IykSfKIWU-ReirVocxjEWX27x4_SJti2d73KvLpsU-N6f4S03Q2ipFp8qgwsGrCasHjHH6PCxpIbsf0dY0IA-YzXjR7SseKS88etUgxw0_Fgcf3zgQ_LgX3_ZHiOfmOPKzfXQNmTdjjBOtKyIdW0Wdg4kJxc0M8cTahNVSxBkYQcCezW6gMf-o01lRfsEwN06z6G4Qbe5RKtb67aqpu1Q0fyHUEo4evi8UbKMvXjHohfFYU-nhVWhS1lt4_AJLxjJ8V4YDlhx21Mmxbvy3MMxRCRR8F0EdVkeLHKXEzo1RAww_lB8mSlsYIlmQ4k5J_pX16_s5hj2xjINOleHE0BSPAE-A-aLGFw6KlDbvbgmAdB2OFhREuzHt8sE8JKe-P0BkVAsonSTLP_JzbC9D73uk-U5-Dq8SNbPMkqh9PiKN9g-eKyQjTjB0EI6oRo5JWSpCgUGuZkpASoa7Wy11309U3JOvND6VWurwD8nHL70CjKC26oXsShoof8xWq3KyQ63QNHdXWcPFaXTLeZOk2VMBktFnCDfxu_MNybNJwaW4VeKH3F9AiIc0JUdWQ_ZRlDliV143-XFyKPwJOTp-5t2FhHfEwHcBHD6Kdvweoe-9O5cdAax6Uny34KPB3vM7QEMfHu3SGx9V6sQplXczfJsgTqiuqCoWMp9hmgpCci1TjvjvMYi5alriUg', `SearchKey` = 'wofCscK4wrDgsOgwqDq8KDwqTDmsKrw5jCpMKdwqDChMKhw4DCvMOXwr7CjMwofCpMOIwrDg8OgwqCocKDwqTCwrrCisOkwqPCp8KewrLDqMKtwrDCwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8KhwwofCpMOWwrDgMwrHCisKpw6TCp8Kew6TDwrDCr8OCwwofC'
# [03-Oct-2025 09:45:44] /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-Oct-2025 09:45:48] /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-Oct-2025 09:45:52] /finance/root/bg/ajax/invoices/form/2563.html?_=1759473952483 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2563
            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-Oct-2025 09:46:28] /finance/root/bg/ajax/invoices/update/2563.html?_=1759473987912 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2563bg', 'FXTdtmwl-uFcw3oaKSMalesp8biICRL1xkL113jYRfHyFatdJZyVq_aYth7iVys06UdQf7rLzquHsE7BFJnbVgd9erDK92NlGe23IOG3UAZ2K3l0ItNAedCRnJ2nEtuAh17E9KvgmZ4-RBigwDMHcZaSp2MBc9iid3TOdSVV2Kp3NhSfEOPoKjSU8yzf6m3hurO3JgyPjFfM-UhLLUTYGxYm1_HW27U9CX1qmj7Eis1FRogRqkzXutRovWcae6t5ZTq2U-r3kWdb3bMwPJXMQ2kFpMI0GVC5i0mXeCdDfpP2QE-2iPsPsp82tQabkw8iBBGskQEWNn-8_MtBa4IfzkqKasQB0a2e806UoKsvFb3XkFwaksQriYuMTMqMsTQ-KNrRvscK8iRZpVGZNt3Pko3PVF4L2WxMKWkChkuu38eqAiplAhVXeh3fRb9NrSAYVqQq-AbY5K_s4vTCfFbo79KKcH_Zv2_4m_PnFrMxdFKuUlnXvkWuos77QP-HCK2ZnMNuU2HPvFsjseRbT6sRYitV3vMgcFh-xgroQ2VYWfYHJXdkzv9yhdGXANkKJW0JVv0YkarMfZsF6do8n5bJUhS_vx9w50HXxadC0hi1shBLJfi86U9he0ks1IwQCnME-bsGmYIOA3j0XKDk-SV3Se51OAR2SD9faLzzNhU2SMRepEZ2L11zS6OZYQTTs9C102R0JueFMt5xsr2IquJib_Y26sMpg9UuRBZAsS2P2b7dmoV8LFPZhd15G1tQmTGfFE8fodw6bP2wkPO4CSY_Hi2FdOYwDwI7W0MSZne8AwtUnO00hWMN1gai4Y-mtEjXOBiXRKTB7mL16a0g7qySS1tlyYR2UwnB-tHgB9isE-apRSsdVVter1as8rS5zHuf2opf4xfWj-TKcBOwom-6SWER6tlH-80QgauAtdLAqZ6TSj5Ew5uXeXtaR9ALK66j_AAYDf74Fvwi3A7sWpHbRJ1cHGGp5EtHMkRTNnG3YoHiBBBMLj5VBz2kfS2sEK2g-6F_IOLLhjfyTNM5UJOjEFszxBe8QKocewnvik7jxjV6RmxSM8XZZ7YNZwwpWH-UOVsYB8aJh5dYM_SAHO916oJCiIrijk7GQZSNBjeBD3dwV8p2mcyUXHVvNJGnu55g5GdfgUYXjjWdUQj4xixZJqzvoDUD6Gt_5Y6FKR5Pfw4R9E-i6F_Jg1NYUySxUYTFXJjbg8IjW2rz_DhYSu2MSp4V7BdTQZ3YOVJAlPS5T4JVke6h5j-7sL4mUvw_-uzVLZjbGvC14L87CO3PtagZXG9SNNhtLmU7F8AewE6JJDcT5gsnfABH3XLLURPs7ID9F8PzA3jcPQoj1A39i07JsWb_WmX8omR2uZVKejnmZ2aF8ZKKrywWyI53m7bUhtIlyl35ONrxc66YuRk6M9hgKW7AYCBD-E6yw4bei9sTwhzm1l9sKAYDAeSvDkQW52VsvObDH9HQP8dPln1zjqIy-0TOqrTDmUiPkf7-x0PjyFRR0S-8LRPwyS-zRZhw31D_Bs6zOL2VtVt52uTwq1c6H2J3JLNniPraFCJabN5lu3mVYX8D-fDLfA2MmfgXkvy9KT9RY-QRlQKMM-lDT9mNDN8iLgFTrSfLmaxxoTmDsXaMSpI3s5E_MpBIfRqnQJ6I2SCbtV6EeR6RPFADQsPbfkomnYb2YLGyK-XCIhnAkFPDXV6TO87qUvHlqplO-HqFh2NdQ0ocyBWU2KNyEbqnIhqfHAW2PmA1onAT7YVdBDN3V-QI2ttLHhX97mfOOfHP5eh_dkTlOWvMGIFQyT0J--wPWiQnyBLutw4XpNiwBRRcQqPKuiXkw9KEMCnVfVz878xivVldBafyh2zCm7wliGOoF2PfglUtujQLafbrDIejKPiPmBr81Qf82p_qbvbH')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2563', `Language` = 'bg', `PostDate` = '2025-10-01', `LastUpdate` = '2025-10-03 09:46:28', `Type` = '1', `ParentID` = 10471, `Data` = '3Wrd_RjSetifHODYf6CfM8i_V7XR0PkK_GfpuLEWpnti6z709cLxGerGUU7oIugEDVyUaTReZRFyDfOTLJKQTfDqoe3MluZbSg46vqW3VgV2hCvlciFALO_JU7l6pEfWXr-ysL8q8ywwQ107r3O5_cpArn8y1i70gsmo_uXUqLKvqo9_qBhBtcMaDxb2_yDMvp2eFYf149mVv0MaX8NY0Dh7a67PiCdo0vGhGDW7S4ykBHkAgMgIQtaZiLC4oHI5ODjWScN0jOCwGYrIGfaEtboLEMB9a8_B_7YRGhEuaIrJVyzJv2B8jq_H1zRIU1AirinQtwO0QEhRRmwXZbOkLtITXvImsNExnd6Ua67bYpcZWLgbbw_082baZFcMqul7731HoGIqW1RNFDMVIJ3o_Z4qH5yAMYY1DmaifQO_pIJooD2csHSsExhcy6uyaaCaMyirSZOKMvhqkNmag8c907WwhBcWz9NFG41gLm-2CZ6OFoYnuZ9dt5x_L7ohCueeUzKpUFRyUCUcWAO7scZHdcL5g_YFrooGjKsuEf1ok63oNbf6ooXNy9jzhvcUKO0zXKS_UC6GPRPqqywfEQ1kHBwZn3VC1kGzUmqSZPiOiL-zjRlSdJi_CMA2PiexC_yooMvIHV0hdZ1IJWB9QaHircIK8SzVyAds18g4RoE66UtW0qXYW1nFE5AOQnEszQMoOfLhriKWNn8bzkhyoFiz7zL7yG-V0kdanIwsM5AhAvYg1-4w0h4eHTpg48cuEeuaNDZcXgPQ_AzCsBu8LgMQL-kGlgYWwAf9rcIFXomMI2kwDqgf_fC7IwKQy7fqDurqi37taTzfN7zGhnXpw1L_YhewAdtKAAdLF7hWbAP_-TIFag0Y98XmP_bayOSHc1AkIcGvW5binlUZbfgUi8cIeje2foqmjjCBlOAyWJoI7o2h_hKCsXnPZujREfUMSvV7Lqlc0XIYTdf_dicN2cPHeQ', `SearchKey` = 'wofCscK4wrDgsOgwqDq8KDwqTDmsKrw5jCpMKdwqDChMKhw4DCvMOXwr7CjMwofCpMOIwrDg8OgwqCocKDwqTCwrrCisOkwqPCp8KewrLDqMKtwrDCwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8KhwwofCpMOWwrDgMwrHCisKpw6TCp8Kew6TDwrDCr8OCwwofC' WHERE `ID` = '2563'
# [03-Oct-2025 09:46:28] /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-Oct-2025 09:46:34] /finance/root/bg/invoices/2563.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` = 2563
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Oct-2025 09:46:50] /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-Oct-2025 09:46:53] /finance/root/bg/invoices/10472.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` = 10472
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Oct-2025 09:50:39] /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-Oct-2025 09:50:45] /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-Oct-2025 11:38:00] /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-Oct-2025 11:41: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
# [03-Oct-2025 11:42:33] /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-Oct-2025 11:42:37] /finance/root/bg/ajax/invoices/form.html?_=1759480957167 167.99.142.201

set names utf8

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-Oct-2025 11:42:41] /finance/root/bg/ajax/clients/select/type_0.html?keyword=ser&_=1759480961269 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCisOGw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCisOGw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [03-Oct-2025 11:42:45] /finance/root/bg/ajax/clients/select/type_0.html?keyword=log&_=1759480965427 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrnCn8Kpw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rnCn8Kpw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [03-Oct-2025 11:42:47] /finance/root/bg/ajax/clients/select/type_0.html?keyword=logi&_=1759480967002 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrnCn8Kpw5zCrs%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rnCn8Kpw5zCrs%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [03-Oct-2025 11:42:51] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [03-Oct-2025 11:43:12] /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-Oct-2025 11:43:14] /finance/root/bg/ajax/invoices/form.html?_=1759480994259 167.99.142.201

set names utf8

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-Oct-2025 11:43:16] /finance/root/bg/ajax/clients/select/type_0.html?keyword=servicelogistic&_=1759480996146 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCisOGw6fCscOZw5jDnsKtwqDpMOQwrCncOGw6nCuMKcwr7D%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCisOGw6fCscOZw5jDnsKtwqDpMOQwrCncOGw6nCuMKcwr7D%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [03-Oct-2025 11:43:20] /finance/root/bg/ajax/clients/select/type_0.html?keyword=servicelogisti&_=1759481000045 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCisOGw6fCscOZw5jDnsKtwqDpMOQwrCncOGw6nCuMKcw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCisOGw6fCscOZw5jDnsKtwqDpMOQwrCncOGw6nCuMKcw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [03-Oct-2025 11:43:25] /finance/root/bg/ajax/clients/select/type_0.html?keyword=Сър&_=1759481005041 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCscK4w4DCtsOgwrPC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCscK4w4DCtsOgwrPC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [03-Oct-2025 11:44:08] /finance/root/bg/ajax/invoices/insert.html?_=1759481048151 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 16 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` = '2564', `Language` = 'bg', `PostDate` = '2025-10-03', `LastUpdate` = '2025-10-03 11:44:08', `Type` = '1', `ParentID` = 0, `Data` = 'NiO7RxSsm4NkHpIwAU0JNlgNg6d4cwNf8Fh7EbNDVyQk5HHie4-n6b7UgRH_JV3SSoRTcsP4olxturCmS1iVTGhcOHEKCjUn-G8pv5hJZUyy7PAUsqewpvcXHlCUpGSJ88aHkD6BI36Szru9hbkQmJYBJOt18RH6UwFUfEDAu7ttdb2A5AckzP_A4xDnEMaLxKYB3qo4VyJ7f2lcVEkQ6bU9deMG07XWXiz0rP6uFO_cLpzD8FSZV7OvRFT3fw_tEkseYl9DguZz_2FfLrcrwzQQhIn2QNrbFvDhYhidH6xyQv2aRRACdN2itiYqutTsBSdTRVvrzGWS1B_aWSykijRQloPwSyYJeiNSR9WMgNKsiPK-5FGsT2a6jG3339W4Imagu2JVp-TKFLKkFzisAAr2rYbSrF5PVKnxS53X2Z_oI5eWYYt2b3ouycVAa4NBRmg8QSVhAcOxQgilflGBhikPHHf0-c0Y2I97eGlc0Lo31xPfPYxF3c980e_37dXllmS-ll0FrJ0ij44eSV3JbPaQoza7vsDMXeWmdGSthp4IYpd7TeaxvNCyhzhEApo--hL_4YiPeToNf9b2Z-QeVB5U20qzqxihIG_7Ozw-7d4VE65FPmuPQ1K13TfyQ0pfRZMRyxBpep5W1OjHbKaI0DZb8TIcBlKYhdRLa5qaLeuoymsyhOcqbosYIN24uXtfv0bNYwkseTRKGDrUfub1n-GLHb_bNECXQ2fDFOi95HYTVI9WRXgH1FyzWSZgeoNcKGVDGMtbHmjt8yHl89BZGk-4tXajWFWOeUHsrNDXvN4xB9-wjwhGJJsbcCP2ZGQl_r45NYQdlYHsrVhHHWixQXCfBy5Ig3k60BoYI-4PQsNS9tblw4sAWBN_XM04VXcj3BIu-lKRP3G3tyAlylj3p21TBySKWmnwH4kgx_edvCwSS5PFx9yR4kC11a6vDkEEW7M1Qc_BaS5AWsDBaPh_FxbvoyTCDFfmU7AXLz5ATW9BWAV-Xg9g7CV0MdNKbyLiMC6_2B0d6-HLZrWyNfuiEw', `SearchKey` = 'wofCscK4w4DCtsOgwrPCtcKDwqTCuMKrw5rCucKdwwofCpMOmwrDg8OgwqDrsKDwqTDlsKsw4zDj8KhwrLChMKhwrzCvMOWwwofCpMKnwrDg8OgwqCwrrCisOGw6fCscOZw5jDnsKtwqDpMOQwrCncOGw6nCuMKcwr7DwofCpMOEwrDg8OgwqDrMKDwqTCsMKrw5jDn8KhwrChMKhwoXCvMOVwwofCpMKjwrDgMwofCscOEw4DCtMKlwqCrcKDw'
# [03-Oct-2025 11:44:08] /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-Oct-2025 11:44:11] /finance/root/bg/ajax/invoices/form.html?_=1759481050802 167.99.142.201

set names utf8

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-Oct-2025 11:44:15] /finance/root/bg/ajax/clients/select/type_0.html?keyword=сър&_=1759481055052 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCscK4w4DCtsOgwrPC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCscK4w4DCtsOgwrPC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [03-Oct-2025 11:44:27] /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-Oct-2025 11:44:43] /finance/root/bg/invoices/2500.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` = 2500
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Oct-2025 11:45:57] /finance/root/bg/invoices/2500.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` = 2500
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Oct-2025 11:46:10] /finance/root/bg/invoices/2508.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` = 2508
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Oct-2025 11:48:23] /finance/root/bg/ajax/invoices/insert.html?_=1759481303021 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 16 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` = '2565', `Language` = 'bg', `PostDate` = '2025-10-03', `LastUpdate` = '2025-10-03 11:48:23', `Type` = '1', `ParentID` = 0, `Data` = 'OTwzWhTnEzUfF98-NTn5ZK0WfkrW9k5cEi_fs7yP2_0BfN1cDC017fODcn_c4EoQNkhYeZrrUkgiYK9EUS53Hra4I8SbSFHJ8kardEi4GCODcC27vEMnpY2QbXTy4NW5JYEoPJ9A-m-1VxQ_B4bzikW4RWb3GdGDHSBv7zgi6xWXVRih7yBm0NoUwC6VVlUQBCZhNHpOVHFb6G_IiAxIWdjCrf6O-9ibRTxxhmiibX2AGNQ-mxR3cnMt_b7kXn1Ac-sHZ7II00er5KMkJSAyUfEXvQ_gXoUAONpuFenua5gG-DnkiB5N4dHHvRDevsv_raGhpY30ZRGdp_GakqRFqP6SG6wBWWuGoS6IFOVqCVoT9292ZPn99m6qkS4UXjJVr1Y919cjTW4ztp-BJaPv2ynEfJfbaQdsDG8iigtGmtNvkqaWqdkuKzzdDZ5ukJIQoWerDJMJOmMgwheok6LTb3bhtOf45yEg_CDh88YNAF57oNiHgns2ysDVAXzDia-DsKstNFjxRzvSr5q5oT1egeipA7h1_o5tZ6G3B5qQzUORaqHrhi8U35tLEjnXiLbib7kuKpff7z3stqlgAbvLXBuD_kdfWWLGT9XRsvGUcRkm80ZdipOApyyPAox7NQeFvG0BxWYWTdOXIKf3GlQORQa0Gf19dwHQ_UY0OoP4yIT5LPasPkGBximH_23J1ToaCRevn7djFoNag2qXqDGcTYqH3E6QCyVbeX9MVLR94I1TUQYzFsmtbNWGW2DccZSfLbgm85Uyyk6fe1fme3yfD7dC8BlrwXDI-SJ6LQ6q2Uijfghzj3q1F9SD4YurhbvYG2VDSSq2j_8OFw6rFa_fBRRcp2EPh-8RQ58RvpUfz0MDpXK4EchX8jICDnj42eCrAKNS1yEG-L47LhOBs6gy9a8JB72VyOUO_F9B4_a4giWGe0rVbFDm672o_CLdYdxst9tw49iEC2-3QBCu04M6_NJFCptEspDTF0_9YLiIA9sM9PAU_fuFLX5QFdEAUajcnVXhU7gnysVy5pUguyRY8b-4POlCwWdVuh9RQY6rEYfh3d6Q7NnrsLlH0GBn7eX_Tm8nmYF43VS84I4aNQyM98XsSJoAcc1gXO68xm4dS3QYuZeXKgZDqU0-eSFwrdNcMGuy_T9hZI85aDqV-EiIHrTP0xCNrNpklzUCWzYxsr1zvXJ0cRYB5je0KYkeVAph7YghDiwTn4KO5kCwW6VRZesdD-cSE9aPYBnGnqGSoFuMhFiIFUGehinfcGkxFf8I80Yq-wc4STuUSpQKMLs7MxFQFxXPQ7_MXPZAYI3awFIMQfkMitaqqCHeXnVae87i0RRi18mz8YfG_b-tEC3FWSUrAz0QWsp7qg1S04wugKXqZGWNIOhQcYBeG553cXFGT0LQ2DiufYR-1Uo3gJOK0HZtPp-Vf-TS4-_Gn0AMOoyngmOPC75FocJGzPsJda4Dw-9FUipzB-fqfwtkwn6jA6h8JdIfZ3WuEP5_bDjfUiCdhxu3fGOyUSKkeFwac5F0ir3-GxHcrxsv4A-Kcuc8Pn-8JvI7czh9V_GzVtmUqG-epLBEjmgI7_OGbufvpwTEjlfEWfHsavruh3ZzSCmu25r1JyvckHNSBKz-jo6X38mIqVPIO27oCQkTThYK7Jct5lz0X4BPaYYbLlsVEPVjEFtPvNjPbHE_j-bF2q5qq2wqm4HfAOw73Vf1W4lYzh6fktKBy3FLi29rNS3P4Jm-6iJUB246PeEg7n5RDO_BdCradshO-1pvcV72gQjo1QWkhL0cxg419W3mLSIWcfMt_fxB20j948vvFnKOJ8nCMsaUsqEZvW6782JVqgvBZ-mq32WmQFSvuqs5ztme51jdtkdKUebpHFvnw2BO7kRwH88IpHQlx3UIMKB134mcPJfQ0GoV41hkkKw5PA_2WY2o-EY2NE1P9xMJ133YfT02jgK4tczslMg0MdOwRhUXhr5AJoR2aU03ZdJzhtkySnNwa2Hm2Cf-nGpnOgM9GAD71xE', `SearchKey` = 'wofCscK4w4DCtsOgwrPCtcKDwqTCuMKrw5rCucKdwwofCpMOmwrDg8OgwqDrsKDwqTDlsKsw4zDj8KhwrLChMKhwrzCvMOWwwofCpMKnwrDg8OgwqCwrrCisOGw6fCscOZw5jDnsKtwqDpMOQwrCncOGw6nCuMKcwr7DwofCscK4w4DCtsOgwqCp8KDwqTDgMKrw5jCucKdw6jChMKhwpbCvMOXw5TCiMwofCpMKjwrDgMwrHDhcK2w5jCp8ODw'
# [03-Oct-2025 11:48:23] /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-Oct-2025 11:48:25] /finance/root/bg/invoices/2565.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` = 2565
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Oct-2025 11:49:28] /finance/root/bg/invoices/2564.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` = 2564
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Oct-2025 11:49:44] /finance/root/bg/ajax/invoices/form/2564.html?_=1759481383944 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2564
            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-Oct-2025 11:49:53] /finance/root/bg/ajax/invoices/update/2564.html?_=1759481393298 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2564bg', 'cDmGYmCmMDhV3LcbNpyR-eQ3ra8tVGYKwMABM_fxv6JhNuazHaH1R65EIvye8WkJ6L0RNjiLSLmpa2XdjEXz1FM8KdqcAt1Rb4twm2fwHeCZ9dGPBt2QrH5cW5gFFyKQC6b9W-JubxGSKd3rVuqFzw0CN0_ta_knl3GwYvHW7k0C2yxuNOrUc0w3c9bFqJHdLFUmu5axTMTqoALDa4d3m2bL89XijZatoS-6fjhkwmJqPMUnU2daiD54a_cJ63oBqSSKTBlbxn6od5woJFN0Afqd33RuD3FTdEe0x1ZJqN4p8tVUeDqu6EK6X1hR_NlBzUu3MkZSHVyzCyw_5jZpTwuDxZYjLw5dSDDqFKpuvdbIZkeX1i5i-YLhWT1LsS-0hI_QuffVmPiHVNtERx2_5uj-FUkeQM-pYDiWRrZnVC5e52yJrQuXHFsluTC-F6KokZG3epKLZHgBg6pQn_XqWr7CZGMMRIiSBtKSDpa1BlgZHVEUf_06BmePL8N-kummC_Tlsq1jGoJvDVNoUO7n_vvqF5ztqN5mWF4RjqHQgJ8nETfYLxgNwKN1RDc_xLqe7hR4vF44DG3tqennuCR5CNX-kWT5RAGTyWlK83QtuwTsZn1dDvIDMZXBKvm8WUGUVKREKqYDQh_PuAcyj8brhGxTss9xBafwCU_MqlBrybnYkwvTcdXhWfnkfLMvhGUWBKbl44-sUYjyTK1CkruoTT74kQT04tN4xNKsylWQuM1Vwc-IZhOLsHGVzkSe3B8x_mflao_7NT_gVt0_4IgtbfosTJBD7b9OoEV7VZgFrGWTY9nt-6hxFkP7iivjo4R6s80xB9pyQNn_YyoM2mvafDvA5CejfLfNUPOABJKh4nT6CwuykS3DS01X6BhH1E3WyFqmoXPZ7EaVTYlRkihT_XI8qwTxxdCqYq89NACUu0ms0-zCxZOIf7ys-ooMMYuSzCK3C8oDl5kUO4ft5weVSEf9jB0N6odlZZjCaO5KXwlWW_dugkVrebKIiiM64tOLwvd-zlOEaVgfLcGry2Rh5XNW2XPc4x6lbTWimCkd3qypJLuQCni2RH560zQzH2AEtIUYoxOptkJupQp0mJRe32U12x4PTp0vtd7QFXYA4RcGfQt-0SfWtDBfxrSPc5xoJ_uIXXG6EPCmRqqN4AKrKQn9q90M8fKlnTD3T-heOotTyNrOOwm4etQhQlagZ_-RgVSyghgRT8g68m27D_XIyAwhtycleTnsV3ljK6qyU2vj4otWeOqNzxtZb5FyxuSwhpJrjHhcmQ66Qcm4V0D_YoP88H4iefH32CTbOoxeUrMTKcQMgFsxgAzfMzS9AXl1eUdU8KX9PkgGmutCbwh2L-h2mY83jAUMJpqtqIiflCWKqt2X32PlTJ3W3Gi0X330Vja5VW-NnzyYmrhai1F9q1sewtbiVSet8tPUbMPh70c07MOhNtxbajaWTjmT8ICA5E43ADJ4iYAeJH1hTVSjUI-PbF5C3WNjq6sO2SBgLlbtrSelFFhhQj2-xv07I6h6o88YPnYOk_rxkNM2m0kIERO8Y5okIm-6xVD9iwWqJtG6u094dvDx9WsiDjQoug0_NKZjwNxny_Z6j6-FoEroU9qc-sT0dWbGfKUE-pEGO6j1mRP1HlVboj9fGF1EMIx3f2bjNE5cKjFiRerMEaUfVPBlT99KSzjncRFbfyoukmjLFijJGEADHoojm_k3Q0MdWHM9zZVsH_N3ZHehwbQxFz3E0tg7FqzBcxtegmFkdALL9VFvUm7hjwPa6qbguHpDl2d5kdAxK6LDsFjqgVZG9mrA2jkc3-bsEyCw2EpHJAaYbhMl7aizQTJkFjYHiib-H93wnE5EPPfPM4HgHywyMpIN4CyOXxN7h-sdpiJlfKehbKcOi5WbwWMPntwW5eTvW4pLlJ55ogx16B02A8Aj8LMRD_SOpafLRdylSNskq9kSytI4tLTClnrBhbZ3tC5c8BuvT3D8WdzLWfxvcIbdsg')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2564', `Language` = 'bg', `PostDate` = '2025-10-03', `LastUpdate` = '2025-10-03 11:49:53', `Type` = '1', `ParentID` = 0, `Data` = 'sZJGnX1SjDLRUW_AbM8xQ1cUWyfmh9BGpgE4Mzwda-DZ8TBCKnqqLlNRshBf4XD6XoNK-nuOoRUxUYVbBDdNdo4i_T6LF2coea0x6yRWSituulyHYh_2uGsmmXRDMSdeGTSuioXvlshHN-XKNC9q2rppBM2PCpN-x7B64LP4CDHaVWwlmlGqB_vbfoTBUxIQhOBfmOMNXPFWnztDpoNN3pE7rzjIBqmmVVmlnMSQsC-nmUFzv3JPp1nmnyFWQpwQ0-xFgMvK6FBNiKobu_rFt8QsSh8qxSyJUIiNDxEI6amm5Y8OPAPNjBbadd64HeQlVOtyb8iS-4P123hlk-UO9TC3e7kVTQsHtQcXv0GX2xEqGXfX3v-Fmb27H4Dfucctl8QJBUz_95BtFLExBWsY0whoXrIFU0sTp9T3Qkw_aloyFSr7gZPRKtu0eHj5Fc7tCqVb2ECLAyxCnwfr6aH1O_f3m3iJR_IDXOJ8qkdUSbo0vDc4rVGKTOJbMhbRwGQiXCg9Sr4eBIFJQXJZmyMx-zSYCbrfLjBe2CmP2fXKjyrHTOoX747p0_qYQMbzRFvTHho4C0-J5xa4oUkj5oh_wOSRo-hW_-JixvYjiYFQ1iunsGSi8W_WAu7BwummJC42hc74XhAObr3G9-nfTlPsvuxW_Gn2FvAnNzZAlMKZhDfRSjbZ4-K4nNSqAMQd_oXd49fIMWPLhgqSnlmr8Rr9gGE2hEJ8tHHttZo-tmH4QCmwBytgG4VBS-a18pD3rLKF9rcwLiWWOloFY5ygOypqhPe0Ls-RXecY-ZW29aKAfOvICqmEfi20Rsour0-TuuIYAIdztcbsLJoy2DP-y0waYcytnpSEAQ9iCs9dbusB-NCUxJR3g8rutqpzcZZ1gTdxW2hiANVbtOL3G0Y9MBEAiALRysphrOOVyDZoDKRf7MHx2iqv4RnQ6CUSVDH2JA5nX1nRwGKSQnLGqBdKb6jsf4Z5x_P-YgikzyK6TzyKW3g1WWjDjAdxmloKn_WZMhikXeiZc_4Oajq6kic3VsF5dlmGZFhWvoHoP2ozaelhpcI', `SearchKey` = 'wofCscK4w4DCtsOgwrPCtcKDwqTCuMKrw5rCucKdwwofCpMOmwrDg8OgwqDrsKDwqTDlsKsw4zDj8KhwrLChMKhwrzCvMOWwwofCpMKnwrDg8OgwqCwrrCisOGw6fCscOZw5jDnsKtwqDpMOQwrCncOGw6nCuMKcwr7DwofCpMOEwrDg8OgwqDrMKDwqTCsMKrw5jDn8KhwrChMKhwoXCvMOVwwofCpMKjwrDgMwofCscOEw4DCtMKlwqCrcKDw' WHERE `ID` = '2564'
# [03-Oct-2025 11:49:53] /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-Oct-2025 11:49:56] /finance/root/bg/invoices/2564.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` = 2564
            LIMIT 1

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