# [23-Aug-2023 11:33:57] /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
# [23-Aug-2023 11:34:10] /finance/root/bg/ajax/invoices/form/clone/2049.html?pid=2049&_=1692779653394 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2049
            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
# [23-Aug-2023 11:34:21] /finance/root/bg/ajax/invoices/form/clone/2049.html?pid=2049&_=1692779664784 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2049
            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
# [23-Aug-2023 11:34:25] /finance/root/bg/ajax/invoices/insert.html?_=1692779668525 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 9 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` = '2072', `Language` = 'bg', `PostDate` = '2023-08-23 11:34:25', `LastUpdate` = '2023-08-23 11:34:25', `Type` = '1', `ParentID` = 0, `Data` = 'jigJ-3eiTny-X6df65jmZrgurBhFzr5M91DPG_bAUHuF0QtXmmNDfFaSBzYguBW216uMEzGHkoFUY_gEbdu3Vz1tpZd_7ANKvsxNDgE943uHlFPiy8S0k8AiyGVhvVrspmgnQQxwf7Cg8BRYuLC3KLwjIiGQVqHoicY_pDdCU7I682GNQ3YUgatfYY-ipuSZJ4boMJ6z_eyzaGcliCsY4kV7QoGUp6i1uwkdBS_gUlpOHvBYe2Ej-9TYlZnDkmKS3dRcX-AlwiTxiOFAmvg6CchBp0NiO6jMU1QaBwLurqn-OcbSSpajNzOVAHjc9aFHvrNn7xkakYQeaQdrlUVoTDj95Lqv-93tasw0kfQ1TURt0hBtI1hDN7qTtSnRuxViMoxAXEvCrg94VbIsbllhK59ffppSQzQAq4ccWDmtrB5fFhGVclFGnfpCxiObW7eOKFt10PlzTo4d0X8fTPnhD5-qqn5PFtT2kuDunEq2KiJfrsRgJpyJEnajWimWyKYdORc_0uj7G5PoSIKTAu7P-c6wCQKi2Q-H7HLzDPi4GMiHC3ojcHMufoE4bM2a5SihRZyPWO_r5UPzkzcBpV6FA21GL-6ZkBOXeZIUAG3zX3EPacqaTJwMgy8eEefPLHKBJqUicyYHZPWyaumLBvEtNSnUHdScxp3LEwsuRPeEubcSdRGOHPVjDl25KmphkQtzDbNRgr-TwiGky7qY8ZyIVEixkgPqx_UMTen6qV3AsIzY--wHk9jSEtlE-G2-dprWsOfm6Ll1zHcJMn7Q3eU4ef6BdI-LBw_35KaQpbT30RsoyG44IhjWOSM7Lese7f8RBBcb4PFoxLfpBTNXUZvX1m4H3ePAciDpwfojA_Q-ih0qNB3FHPz9DsWHUMBOZrrBUJHQn3DZuwd2c4oyrurUIY5iHlM-cnZTU0TVex5EPRt1RIaxVUwElozzPCk8QjSmTIhrhi0ahsJl4Gcg_07OteX6vH6X8IGlHo2t03LNVRPg8bmDPixfj48O3l_qR2z69vQwkILY6ISGHDWQc761YmX9EB6C9F8Q8gLYIQRR2gfCD0kulXvgCyBR6X0d-R-OqtRjudMKJ0g3WkHoe8-ek7H1ySSvs6hyHNPIyB804KjNo6VHYHkraGggyOZNe8-orInnzswUk7Xa9eV2fRDu474Pc4_amRk_IZj7fsFhCWXsF6nW5DuG_5e9UMV_2izvPBE9iEhj1KlcU_I-a00i9jGNT8KcLAb8B1GQ8Z9hORQWYU2mq5N3Kzdmmlmp1J624w62kL63ZAeRwFed7Aq-MLu6cQO4bQksKA35b0_CZbot4LJ3zn-naw3_anypMuihOQyPsoLIlO6jaeFgYps0VDEgt4BF4NCRBpEutB1SVP4Ik7KIUzt0E2a1ILRhYo_Zr0NI6KHll9gtJnWUNtofDBxMOXlB4sdPyiqjWq0phetGXBJrIQOR__HjhJZ8lomYJ4laurlcrzhyi3XFGTTvv6GIC3YwV8_uBu95DjcybQVfM0Q7YdlGn1j2uJClyoQ5SlcBH8ojsxUKnosl9OAoRkthaDJRlYd8W9SbJ7pqUgEryEw1SJI2hxcWpjDoG9h851CYuDXloumj2nInFL6Eca2Nk17-OS8uL8_skH5nxjw0IAbCTz3_APKHChBkEiUF3ybigoH4oRQLCvgzTFu5D3QiYogJQfItzEa-f6GT_p4aW4p_-ppThgRKY2iwSca_0nJ62002IMfjc_xMqhp_VDCIA5hIy2nRg2pMz_vSvSZ0WWnh6ulpewesGvo7NXNnji8UG8joUPRSq8TEcV_5v_nja6V0vPxwg4aAtr9-TJhA7i0BUVsLeimOer8s5jv_', `SearchKey` = 'wofCpMK4wrDgsKlwqDrcKDwqTCwofCpMKnwrDg8OgwqCwrrCisOGw6PCsMKew4LDo8K1wovCvsOGw4fCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw5jCucKd'
# [23-Aug-2023 11:34:25] /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
# [23-Aug-2023 11:34:31] /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
# [23-Aug-2023 11:34: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
# [23-Aug-2023 11:34:38] /finance/root/bg/invoices/2072.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2072
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [23-Aug-2023 13:27:06] /finance/root/bg/ajax/invoices/form/2072.html?_=1692786430121 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2072
            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
# [23-Aug-2023 13:27:49] /finance/root/bg/ajax/invoices/update/2072.html?_=1692786472716 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2072bg', 'N6TNXeN8FhJJHVGLxfYKgoV8U-h01qMNGTBLVve7o8q6w1jp7iuWl7ZPFu7D4mgVB8RkzHi3Gy4ANiV6NCo1i8N5MnnjHAU3yjvTMVzY92sPLZjH6lUrI5Hj-AKFN2tqkpJ33qbihzkKWeJGo74egBcYodbXWEghzfbx54HeGBgDb46N4ZdMD9ygtjCzyo84Q2llNJbH1NuestBzYuCVkmI6GuBUtBioV6qq13XVIQJY4Uvi5izD8alsR5jLWuQbJ-t1nOfpeu1Flvs7Mnm6X7EgBSz75XhTO0mDqUtn1jzgy1mek5B0buP771ynmrMC9ZXdzWzeHa-KpyLucm7vYtndrbZT5RtpFoAZLXjesQVC9nzbwJiZjj_S65ikESgwiKtQoY-LPvOM2fPVI0HEhRdRLt8u5gf4OOnUTVM7mnX11SHTOqlY5LgckgnLxnbjakWPR3z6IXEMFjYRcRWKUMO_7aJjKg7UKI6aO32r4q59hWpRc9DzGAIdfqMicJHzGBRCsufB5k45Rw95zEfZzTN9OvnQWFeFHXZvI2Tm4oPeQtQAmwsbEoZzRPpjPPWmh30DA8LFPlDzfMClQPOnBeuZFiObmu3ML8Tawr09iPnYi9qRkSYqzeZlIO3aNCyuRiPyDoK_HBYbjnOoU7LoIj5FWEkJwGWATfPh9C_MYod-LJx72M_Ic8AKt0xriSjDswUl8Ov7rkUkpVTImDwRdtVCDl8Y8tZU8bP-9ykBmJDOpRUY5yv1N--ujaRv5AM-_ZQIToP_oZpmoHrYLj9knMfJQ8byZTpfw5eqphzA_LlGTf1y0NNAP2uCwgoka64IUNR-Lmkgbt4icE_Pwm3M8XhUtWM2t8bIfBxtrfIcSWAoLmHUR7T6vXc7v1sbDYOcaXgTEcVtJIZ8XVeHQMXUvWnvlljsQnufViZ98gpo46YL2GDqHLodNqkWJOQqsA3Y9P7LH10sI25vREH3BVx1CkSpMPYkZ22t69ajJg_Tvjgz3hegrZwRJZaQTXy_s1MFI9c0ry0Yi4jrou6Af_EeB71_Rz8hcYdFnPBcJdCh7rR7hVB494deYmI-J6vVKkQjEbTIQnPURspc4yD5TRdhDqfMGWFR40heY6ImPDaZ_UXDupifUc5Xw97fHnvzQ4wMdGvg7yvkJO_2E8YW90MnZjBdD2-o2fhh96I2gBEsY43Y25GuhB4CcC83S2X2SP_7Wt9kIcDux2gHsPUrcniU5Ldk4CBZSGtf1B3Qh8CQwlxKy5-ViPB0UrBuLfzf0OdMwch7LP5oeOZOUsHPHGG9urNoDjuINvbeoDj0dRb4GlGA-N0WCShRBZ8Z3Qe6cbnm5R7V9yd0r3u1wGLG9jFgbQjl4cuZnSmYLleMQ7X3OeDcWc3dgPNG5EZCbRFK_NYfCzeYEbLMRVqMTPoRxSBt2QCwvWA0MbyRl7hlBJGtKGFezIfTDFNfRzdPhXHUTtvPCbjrt_C80rDp9-_s3JzRx2rHVdIGOT9VbQyRzop3WjAM5EnMvGT1WfN7wAsYvMnqmRfBVQVoArqutoL-ozTijuHz9WVUHYb7i8eMsMV1fjITSnyvH7FL9z9nkexdW9veafV5r4ajm9AnQwCJ0A4PKDNa3P4lwNI_eLZX6790zjtOFYo7y5u0swNftUYeaxt395ldY_91tKE4Xqn4h1ipIRVSg2bW5smqXigkFxqY6bacD30yGjPyb79aKSL6yyeG3VcMb5pFjPcAXnEWLkxLKr9i5Hha1byQHyDLgSFa4W4KBSmZXGuvfmXDfS1jpAzxsyEcbEOTx3Mf0nklzm4cv5GLBa2HTtOChjMt4I1JW4D18JoAFZDdhVZMc36Z7pm2uVklgjU4o5NJrZOiQXoMrU5HXBC-xRTZetH74xwiRnd8O7wA1xnuVpSC6bdzAb5Q-ajbwtLXEhmk68BAP8ciIpc0IX1qG44X3kpT9SJ23aHOLt67P9FJhAcKiJealajROMa_1rRPRbXUJpGp3hWNNXlcJWL4z-YL5v9v2hH7OCEQGHTHLdPAwSPzTUtHwpb8Jmu1ybfXrj_tfFiLUTqVzfKObRsDierHdaYcUBhPEZtOc-hvRch1iJMpH4p72l3pXJNTZxNgkfCI7EPo2lhf8xNUwYKPwNo5LpWjty-HQCk7L0eI1uBP3bxLSBUswwsSCVYLk7lxa9b2e54B6tuvAHAakCIKbnqqc71VtGiXS-cP6kKSJWTbGqA8CB8UdsodGenPKIMDnAvlqVBMlWwdIIgyO6MswSW-rW9cnJOAz6XkH9JHUitz5rOjFxNciipNYj4B95hDyB9TYClZ5BPX8X4xyZEPKVVO44mcpYteBWHH2V2MMO4S1OM0PXwCQ1D9FmmvxIAPIU2xtDrIvHcnWopvqWsyagGQj0jbm8gbYgZGt18A6m3GPWf1NwozRiyH1iIv8ogI5-6nBulUN2L6W_YBHKmXp2FTg05WVYWtghYLcZsJ80KJDl1aY0h1A5J-IUwZ3C6J04whrtairq-kDQYMmNGL9jOtuqAQg5Z4rTXdSi_hUsvOcrHHE-mWkL6i6W1smDMDD7tzt6xIuJ_MHzAMugv8wFl8TIRgCX55qJAl71r7FuKgkJ_cwPImYmYU7D0qFc-gsXzjq-AuM7TfR4_a1UJEHLq0ownfHHalIoS2OGLJnGL9LD4FLqom_JfyFR8527VFITO-nn0gIVHXSxxIdyIhxRynFZEtNfo0AtkcFKm8WeCLXUidb8SHy-wmWwsoYW80x99_ut_5m_Ot1CTOI9MwWKPuJEjkEVF_qIWJgxirkycFuTVSs42JayesX5O65hSQOu4WSc7BFwacCpXYd0KamY5nJIO5wKYCioiLnH1QfTdz81gOIi8MaZB_KLSDcjzQbGGQgfhQXUQvnhLkqc-skAtAuQnNdXU54RFpMqE_TuWcwCaCWu8rfGeb45OptEr5UsJKt_Dbjea1SJt0NqYeUE1emHw91HhidWXmJxVQTuIwfgfsAhWWJIyfp08g6_XKDXazYzUavwaI1D8ljYIj7mPBr4u3ORsTYqp-VQFkaBNT8fqAhuB7Wpb-IdLjMngqnfQBrUMW2ZgppQ')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2072', `Language` = 'bg', `PostDate` = '2023-08-23 13:27:49', `LastUpdate` = '2023-08-23 13:27:49', `Type` = '1', `ParentID` = 0, `Data` = 'nLDtiPnNlcqwheKXT2JBCODk_GnbkohDsEPP5Oa_v68srTCHPUr-LTytfYz2cIPJKUvNiDH5Co-ZT-1c9QwAqTQCJoVHbwXU7O2fBA3W09LCgGNvdiH7keTioUCNY4S9aaXycOenvd6gvAR9wZYL2ax8n_KWZd-H8z-6fWK0i9ZnD80aQ_jt8EenvzvzFKcxVhdR35QRytSr46SsCwmdA21GYs6jA5-VKsPP1odob4u7pHIUITq6p9wW62FAa4rXX8r6WR4hVj4E4JARhhOrejI8bOIhVuVpqvT_kuX675GjYqYeo9tsCxOOfHIg-xNWhI2z9fp8yIrplCjGdFtr-PHks0811DWcwaVFRHvyacQAjJYKJ0EOSY3ZmI9OpwaD1GNANz4BtzREF_pRstY7o7bbMECIFWj5NCQdzmMyrecQ9q5_H9VPZNDrkDi6Lpg7go6RKTngu3Iwdp3AHJ6xc3QpxZ0IEWVBKYfkXzYcwXxD9VHB054Jb3-RCcaNi01DB8ORexzPu3QhkKQEG4PsoZb-adyTUTBnCEuw_erecgCkKoTdFfCd25qu6qvfIGvwyUV7Ew2MIfs7M-zguVRNbrBm_i9XoadgT59uWxm9AudQr5JXJZeARcPXMOqF4b-MHTBVZcNS4td-kiYdg4vwHgS_2iS2n8teLYyJlJ6gMNIBeozwjwyvNTGH6WHvT8YBBw-NARU-j2srJ9rKRW4OFLAi7D-R9omsIA8DO6nYO2PYbZpnH5rrAr3pIuPWI79Wg4BISVVUlMpACtBE2iQvpAIJN31O6C9NMk2OLlcuSbi0vTkCGKpF4cDhN5GXexGirNfcoaDhzWcyE6p9TUvK_TL_CkH3BETZlVcvgchWYA-qqBVR1irBNx9zNkRvKcYi3JoywCpLreEAeCwZIGxTqheD4N5yp_lVqHCFuyp2DR2BobJKTYLyzEoWKCGPXKaC1jhD-jk9NDFi5RuBdezQJeVz9gKVnd3cK2wqWTGxVdu9Y7-39wsd-BFwf2NfcgBpAgJz6aoVAmQ1qojkOGGSF5cddHVGukb3xctTmCo86GoxyYS2Px1fWp-JH3dSb9R0aWicPSfeJl4IwLlaPXmvvRdAWoQiRtX8CZ7hzJcYt_3lHX_Nl-IQz7wMVUhtdpPMokefNugiS8733oFSsq1V7eCDJlQnySuqWid99-4UCKNVTyT5Dn8lVLTOM0uCs7Pk8vGZGuNiDxF3Fg7LljIEC04FXf8gnKivwW-waCJfwjr-1IYeGnCr4gq6LRwn_sirR1Ue9ue9bXzCUzlZwzRVQ_AH2vdfS-nO_C1rZ6KJ_QpiJ9axPDYAExAa_aFEwHkgG219NwAFLxpd6g1gn4M5gYQjPnXo4Lh1NE-rAsQ99p2BkhOo1iuyoZO4AduaDsrhKQrbYYU8KwdVE6vgqvxBJIqHXSo_xMJXD73mkgqFjxbYbvE7pGWTGU66bkuGOiPWyNeyeTPeWyBsCvbgEif8MEkwxE2jpqbSlwlMBVEuctGI3L7OkGIUVWmYYKdKnHiqJ1MJ8sFBxgzirdUPvY_dodP__xY9VNdJS7v6qaF8uKGe6G3phWBCzwZu311pGiwSSNs2nZZLD3xMIIdoiIWPkel_sa1OTqYsChrngBvth5cSGpBR4AGwhDMQaUYYx6JvEj7wsOvFls9BIAJ-7KMC_14Fx740AqwaapWfMk72fUdPdnXgg4TlSTxmnDDZR2jsQ8UslWRmRorrmXt4LVgW3TmNhn1kmsauS22ihWOpkJyzNZpU65U5nj3aS1gf9w4C-uS1ov4WhkH3ikuZSKNuNEr9Mip9_3fDNF0YUK_CYSW4TyLztciTfNktJJzwAHxlKW7NLEouM-XzWUooUiOyZQ', `SearchKey` = 'wofCpMK4wrDgsKlwqDrcKDwqTCwofCpMKnwrDg8OgwqCwrrCisOGw6PCsMKew4LDo8K1wovCvsOGw4fCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw5jCucKd' WHERE `ID` = '2072'
# [23-Aug-2023 13:27:49] /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
# [23-Aug-2023 13:27:51] /finance/root/bg/invoices/2072.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2072
            LIMIT 1

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