# [05-Feb-2024 07:32:21] /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
# [05-Feb-2024 07:32:29] /finance/root/bg/invoices/2169.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` = 2169
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Feb-2024 10:37:47] /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
# [05-Feb-2024 10:37:51] /finance/root/bg/flow.html 167.99.142.201

set names utf8

SELECT * FROM `flow` ORDER BY `PostDate` ASC
# [05-Feb-2024 10:37:53] /finance/root/bg/ajax/flow/form.html?_=1707122272816 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
        
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20
# [05-Feb-2024 10:38:37] /finance/root/bg/ajax/clients/select.html?keyword=ser&_=1707122317332 167.99.142.201
# [05-Feb-2024 10:39:27] /finance/root/bg/ajax/flow/form/clone/5.html?_=1707122367390 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `flow`
            WHERE
                `ID` = 5
            LIMIT 1

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
        
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20
# [05-Feb-2024 12:04:05] /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
# [05-Feb-2024 12:04:11] /finance/root/bg/ajax/invoices/form/2163.html?_=1707127451032 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2163
            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
# [05-Feb-2024 12:04:23] /finance/root/bg/invoices/2163.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` = 2163
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Feb-2024 12:04:32] /finance/root/bg/ajax/invoices/form/2163.html?_=1707127472599 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2163
            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
# [05-Feb-2024 12:04:42] /finance/root/bg/ajax/invoices/update/2163.html?_=1707127482362 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2163bg', 'M3ytKhZ6TrrojvVLPBP8nEAxcwEqUN1mC-Yjtm6WCEcnohUYA6ySJg0i3ANKDrqL0vs1404wSyK7tvxeHFeqHIohNiWgT5BomOeTgfHQah7ft_gGA9gEUzGJhCNe6tm8Vp9QF6wPy1yY22WqO_9iX4hngcW2bBVsdmcnLX9FaOtcY7yBoy57ZgaiYl9J_2EmZBCzwHnWgqsvoc8HM3sGuOZ1RTzp0h84HwsFyjNMOlm9hFGn-VNZiRLNtfT6tg2y8bY7cF4SUMj-w9inkRJ3EOpww3ztk_ENwgU71bBhEqvTZ5pWLJm-OSrvOuqRSTrrgtJlJnGMDgjihObNXA8siHfe4epDymzF-0zDN221uY1XUumst6AEj-pvwVJgQ_jvMnekOg2Abn2b_9DUDBIsl1ofKkKdFL0fWezf-3YuAo3MO7gtlYp1uynnWgOBKl2IzcdVTDGccWb6PM_vfxmAsc-0xETpz3_gj2gFon8uvKKKLukw6P36D2r857jyUfVRtRhjy6pci5_GvuG-mKtrqYpJQBybG3kZP__6TL_FN7DR3hccjHGFxyiafp1XapvvYUbi8Om_lvTEiz3ZDN56cnJtXU5K9ieM1XWsQ-p6Tr7js_V9XQXh8jatMn6VtsRJLMK0_Gl0DLTBQ1Z9znSq3wbPrNdmBq-5bpWk0OUDbQqK0BdwJM328fghIT5ZvcYXhnW9uk3LpBf6_BOlWZ9dUazIhMZmw98aP58EyrP9-YRMVgg5RBVO3-YZQc7JOVDWvhMHfaQLR1C4mtlgLFoGCWAA6OudXyaiIbPqVSAqHPrhcRwRun6c0ZkOqmqpHMATXYAeul-7_ZyFo3N7iQo6WyRjQOYEOim3_7KXHxkEtmLpbWj2lmSaTInA-g4eL6G234sFUXkeZU-S7zJaa6SQxrOg8sCI1IwGqhDv8-U9xkbcwQfzl0f231d5JwTLOkHrk5Ltia5NvbnNiMQat_WXbm6qLmbE5GMzCos0aFRwRAKlfHeqRbS7IuWCP_ZXVMJufoHNGx48Wao9DoI_NL3XnSeODoqyX96lHMYsHzPX_t2Q3v058UB73A3dvA6IUt6ehDeTFKN_szKQqIdr9Zem8smqqUJ-fKG02P6IKnL-SWDPvVknkqVPNIN3Yhaa-3EVegpnBNfj0z76D8Xr1sJY8zmLYh379dJnL3yT21hOWm-BoqR3jdh7RABqDf1BCT_CQwzOLe3VAjQrlPjO455FMgDZNhu4JxHDvUYIixDoUcDoe5Usm7bbbqHSK_ztuWSlkUVVljjmE40Lrn4Eba-s2NU9a5mMA_YEBE7lJ-BRvetJ_eCYuu53j5bc76w49VdyG62vYb4DtdU8fRh3kUHB2OChMOizqtZSUDoxfUAZG4Q-2MQ8KaUKoW3OJ6CuuD_NWJifu8SN4wl2U7J-exf3F38iyNqZPBQWuiebbOT4CgwqV4eRh71F6iE_PggETw7L_fQmY499PT7F-EHSsIWFuosLFlw6aBly_pIZVbdmN-Gc4xDa_A2No1C00eF8vDLL2l07TYcWTzdj8qZY16saL5MKDBGtGjUlndcX1lsJb3JBE62ZSNeK1n1Pvt8IfTdfny-cn1LWIs8q1zvR-ZSKxa_bn1OwCp3rOhEB9KNcFwHhTO0IEmLEZtlMnZDmrpqUF-gXX7Y0sHdEaYx3g66UOXaf9kgTzWsbHF6GNzqp2LBg4JpCHymO1g3SZlWe_CLQ4pk8VORe4fCuEi3MUDgCcWsOBzQkI-qs0QKnK2wB1mPJs6bZygitHjo1mn8uSRFuPZHO4e3faCfteesW93Dp1d_4_XmqxQQTpWpgSSsCmBU2Ufz_YK4vKlByjdmEPlhebjXb9banoBXEWMXJXYbeN8Zp7lFIZor9KN9eleq-CxGikvyr3-oCuZ8qVu6Y2umND6U6o28UzOd0sYPAy0S7pZjt7kMLmjqIub0-bySzEmQ_g9_wHPN-ZF6iiRK9qj_xOwkC-XoHAmMXmNUsIJdcJFNDLzOpsmsJdAp5MSE7NgDLBk4fGq4OC2ylq-jrBIjCtRxeolmd9JlaF2QdxocuN4bdEHRr6xnJVUyik6ryhmnkaqVty5FMZL6lKTjuPEvbi_-mWJmgM8hZxNb824AnGlPW4zsmlb42gv68LhEQSsABEYfXIeGyQZ49oTm4Y8230V8yxsESq82X0_v07bDbspsxNI2dNa5oYl8N-UqxOqGj2SzsxnXHZHwIuqOo1P9BQ95O9eG7oBtU8l585_W0UyjnpdL587CQ-uu6sTwzJ_N_avLR3hfkr-VLSrImIqtuLdf0d8jlw11Kn7r_cPyWP2SarF8juFv57S8shb5oxG8wtux31Pt2rwOD977ZqOEmpX-jeB9xWA9UNI7H4bCe9izpPc0w3QMpMbaHOUEjNPT8KuqWk4g3fYj_XPxkYsT9WYKv9Gro-xN4p720G8B8Nv1qgtk4NrcWhoPtIjhHObOP9yWYUR8jVhWA1iwN-u4Gov_MqQn2xTy0x6PQDUHhUiVuNJP61JKZYkFQId9Ehiee4g9HTf1yKjYombNmQyiEMbU-jdRfMaAWKipA770jFxIv7ii9oLFQIiJ_0oTZHPBIv2kLEEebD3EJPyzYK4QX9nwHjVlOMS11v7Hhtt-k3P7b7mLBsiAE_hamyT_xbOv6FkjIYpctPMaQhZT_cjgeuvPf75F7RISdygXq5CQInpfZFrrmJZdSYlsWCR5J8O-sTHg7TIGYMyChPv_Uprer8m3rdnRMGVh0s7DB0JeHmRoUZD5e7f6Ibx9HLUmurdXn28_8ZqAhANDQOTkS-Ix-EGjl9n6m-bvLdK38xSnN-IK3UJz0YoOyzSVwPyHOTlE2_kIsyo7OONYQdKeea7yjlPcUUlBo9zmeLxBID5X_IOm9l3fAttsD8le-vYBIAI2LnxlMOYTuQPA1KgaM0JkrYXoQu-jvd5QsdE54BLZxzU-v5F2950Z3yEOXdo8PC2k')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2163', `Language` = 'bg', `PostDate` = '2024-01-05 12:04:42', `LastUpdate` = '2024-02-05 12:04:42', `Type` = '1', `ParentID` = 10388, `Data` = 'uUlEq-hcyFEFnaWoQRl-rgvAnwSEq0U0VIdd6-4yX665tpKuuQbqeOz0n3swedWIYdD-aEFv0V4bnkO65SKbagAOfy-mNpPZI01yiP1_SdnapMTcMsV5uVRJwCjxvrBOKWNowSWXP2UZmkaVph_SIFFSNzOzcww2JP-XlfLTFaj01hzPK6-7kiyT-NshM2QuOez4FgtCw5pWGCm4WaDr75rmO5gdGIofbCCakom5Tti5a0YlQ-0zbui-lUsWqNSZ0ZZsKbEb2d0_e9wjRY-b10f4DQSfJC-K1W1B7Hl8wYaGFRw2L9pv_0vT069MUKwTY8hJY5os8CfTlVFOkgClFvViFbx2nwe0DwJOpZ9UO6nnKP2_a3nT8fxi47XwV10uZQMcI__43JRr1IrZyl_y6J0eFngnnrHTMHLBQhID57zSKIdiRAss9glWhHinyKUPmXQWqIAb6DxL5N6zPTYUK50HySVM2tHWB3WkfMg1qfRDDsLDZcvJ4X-328j5LQj0YPxiqUtXJUApz7GVL2dznvHKuJ9_a3TOtYL7QuyRtbJ1K8tzLlQV_deKTCnnpfo328wPyHMghqQu2nWPyn5M7_w1JFlo3-XhHyJpsPNYme1aBj4I-6L5EpUOsp6vaA1EVj0YQCA9sf4z5qNvtg77FMD6w26MeCc2DH8HQMNrRQv3tqPVPYCSZeF1YWggs_1RHJgQzWST8WGOSBR4Fz30UPWvMpXhTQZXA1DOEh3UfYdO7IBWjKaiVJfHhwkvEmAw1YHsEYgENR7yqg4NfgP8pRNAwBG6ZT-GndghfPJG0oEOJc4yvcUkiZayus5Zt6gQqH1eMNmHpfTybDG8gxbonuX6_CgjZ0W95HfpQ0RaIHsSBD4v6dRbnEimT78G3wr9Kf9JRSjoim9GKykDL_4oEtZ-8nwv8_5hebXyCAJ18faAy3E97YGvVn9YUef-7gQ4iVd1xmoZiYyKEE5AZuyB8QfA0GWvBP46F32n6S34PrldWFMyjvssZ-D1etfsP7zulTjznh8--Tu0RxF_z4YopE_4dppiwuNV6CVU-NmhMYzQjU02Onumxz9dKWVpw_7xxDImqRycK2wJUbBMuW65rxDlerTw3Bnukq2Y2USXIwIxTc0Q5LhQTUF5SpHMRgSgtTu3y4JvWupaHzu7VOtMl18_EqLE_KYyhnrd5KJSXsZsocFQ3fWPB12skZyIHvzK2eH2iGcVSvWFYqHfwz4Fv0Q906PCCke4Qu6LrQ9guRajtKxWSuP41vI69Thah8lXLIyGguhlUEjkG2YIGlkhvwe0PXQMAmABnit881f2zp_Si4yQBSbS9mZGJG84Tv0rKJ3O_ZbIdMf4uulLjAJARi2YX8o-0Im2BDUclKXGwhk5lAkgDtwO9svQOb_OLRLCPGguHG9NHd4OZ_kaZWSZtoynwS-Y7o0jdHbjy1jXlY-8dC5MK8Q63QwENB1LHt920vLEaX0pLrLtCLU39YLL3W3-TDbtgkQmp1sTQUgD7r7sBKrdZ3D1Cpi4Rtnnt7alhu3XhYujuPp2x9NLuAh83HsUzwb-zzsj3YzCbleyiQdsmcw8MywyridNSID4j2vetVcjEqx57OCvc13QAv-r_vB2Lhcos5OTjyrK_kEtjp-TfUhIvVlI-5JuYgrqNWgd1Uug5HsI9vKC5ypsbtl-5jTpI2wIteDcribXInV5VeKXxL7Jt1fQ_DiOAgTJ5Fg109La2lpMRCMvNP4gDQ0UlX56K-e3PPV33JiRtfehgwI', `SearchKey` = 'wrDCr8Klw6DCpsOEw5jDwrvDhcOGw6PCscK0w4LDrcKtwrDCwrnCoMOCwwrvCn8OYw5rCr8OZw4LDrsK3wwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw5jCuc' WHERE `ID` = '2163'
# [05-Feb-2024 12:04:42] /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
# [05-Feb-2024 12:04:50] /finance/root/bg/invoices/2163.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` = 2163
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Feb-2024 14:27: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
