# [07-May-2024 08:14: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
# [07-May-2024 08:14:38] /finance/root/bg/invoices/2228.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` = 2228
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-May-2024 08:14:47] /finance/root/bg/ajax/invoices/form/2228.html?_=1715058887321 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2228
            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
# [07-May-2024 08:15:24] /finance/root/bg/ajax/invoices/update/2228.html?_=1715058924236 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2228bg', 'Kwru-XpTTutCfoSm9VZz6cMV7RipugBkqt3SBrzVKHd5Fstj9norW2S9q3hNPykzpfOGkop1FhRViri20al42FrGse9C5pSIutQ7ArPGXz64gKl1uZ-ZiZbpgx4y-IT_SQQZReQjq2MR8psaaBl_s3AW0mGU-s57msKYzkxpewpyK9CyLBvBhudqHLNSTexGDY1hQooeJWrBheAMbKjrbL6ER7L0NfHJ2yneYngMx6yXfLHAlZ4sij58kfaSiR3e4PiicNKE9koT3-A_LsAqV8H6MdzXkniuvo1QFvaPCQIj-Be5wuW8iJddaPiJEDMPgaMeS_NRifr3xsbb2wmyjGFLxhZc-1xQT3XE12ef7JCgDMyzkaWJWeHd95Gp6o2DzcQ-KrJEHudD6RdzOhWXV59w3EpbSo8Upo7u5_Gc-w1Y_lK79jPy4uAYFj2OilOzRU_JeLvgQB03qRb9htTTQihVJnRtDFVAaGr5BsDKkQ33xXw6rJTiEJT5qtbneQsyUX8heFFCrp_OZE5U2eYZkQKzcIiXdLP1aNUrd6iv-Xll6bL0Ib8At2Yf1bNKM4GuKc5qJqjGWtTidcGo3deoLGi_uWDmRXR_ZZLRkjErRbaFIbFf7M4_u5AKIBqGaX_iEtLPj3ZuEmqN9pQUPRDqtJjTjGHbWiKztnNM6990LybBXhhtHPcESnQ1E2C4BY_AWZjCoUVP14vEUtM2XHGJm0ydrz87U35eGwnjiI-3WSHkEe1-r15C4q0qr9nd-YH-K92TSjZOkZ5lYdzfPJqKXzT4fXPc-uBXRk340poB02TcR9w4Op4c4VTy3nIl5z_cF0s8aD72Zat5bV-xJqwcG_IFjiXLSJAEiL5um3FK01U8EngR8epqnS62Rjrq5hrXvp6WBGWbQX3jJm-Mx3Px9cP1XDqdfQa15DtPlwAfvu4k0G6QtVh0FO5XuhIbAyZtgQmXmNILIM-6UGttHEKp2DxIz9JLtZjmZMZ10WGH620voOT4x6zZQYxbYQ6IkQddZFrxnnEbaT1gEwfM0zfoErHIA2vmnuCOm8kSO5NoJUZQFNTRTZYrK71Kit5G6C6x72ig_AQmsy10xFYO78iZB-7yINBYlGMlT3dMvN106mR8whVdeGPV2uF9NuKUQZpUsTiDaatwwu0q8CXugj6hM4UE-z0rFKA3eaVzPxwq1KpBypBZbcBJyym91Tou2oa29q9sOzB0O-RdtpJoleTJxCL3prXfYf7W0zbSBcyh1XY1Z-fkKXip_IMmMIdVTvYHEnZS6mdu-fIA4-QbCpR86oVTtnAqnjq2c7GkJyLshetuNjFuycQ4OkoyHIbXtQSiAdWoDJeByrJkXyTVLl4CBIh5nwC1XPEgVRpzzYwloK-ndfQHmyz7n0bnrw9TrwuHGduUZqWzlWR5eALXEzzucgTha-WN1btje5RKADPsNwNE22iCFQEm_XmPP8fKBHzZtCLsnIkERwa6wIyzByffA5fQeOb6rAJYhJh8thRDnzHvegWSmoDY69eUQz9p-KWKLYoPKxFY0eT6otJz9G3gT39lMH74-LU6y7-uQgUImKGN36ITG-Pp-TyQd0xyZOIEYqZJHP5AIs9KrDxGbt2p9VbRUEPwKYwRXHeTFeVs5Ab7w-0FZNsULeOvkY4Ct0XVLROYcVYg_DTSZc8Ya0UTH4Dzk25xAnEzL-Gg5zdWCC8tGhnxEmb2jtV6upBW19leJ0I8vZn7ndJkwsIt_KQNF58hMF2Jtwo_Eh1cw2qp-bjME_Gm_9c9p8FtX1Crf5kxZkDzFxdDtlzk5izN7Rc1tsuB29zBoFZeENmGnc3pRHJQyzKsSfUUN3CiiOd-fc02YpoiirokW47TGU6fBPTpum69e0B01zheNM3kRcPh-xm0eae4YWXTQYvTwGsVEhBwRzfpt55WkCHGkIFSM94tUxSp9Aq_ed8YOaqdWMloPrNqicf12jbIEoXI4U_EYHeYw_W4GnWC6OISBkGqt9Faqp67izdKExjPKmn2NopjhlOPbJFGhz_dxlTVQ3mwy9iM7GLlFMw_GfcfvFaN3a9i6Wsv5wBuNY4_diRlZURGfQhV0sKjNzwmSpjF-6rfhNYNpXtOwHwN6G_Shf2ViDdxfb8XFpjgqxOfAB1hIxsykCUsljn_OJtPUSpOqdA-tSLFEoj_pun8dwVr80wBxXzcrL7czeplKmTszxawK8bNUDXz6NAONRL4J-n80Yh7WlfzHc83UOxVxMdrcCwdFo5I_A_nIlz2roLy-3MqIy5iSkcvEhUbMVmfvhaFI_iUlCywD97BcV63HdXq2CubsRL3UuJFzNzijYrJmKU6LCc__twiDqD6yJe8RkomgpA4sl7kvy9Bu1xbl1hyrRRjDFYbxW_kc7BmcbOVOhGqSzAUOWIhewFAiL0C4UXo1qT4Vg8sQIzVIj3VuZXOYfFEvObUldrM282tDFMolVc09nElwGRAakxjk-HCX2j8n6hxRSAQEUPO1h-MyU0sc3kQjjc7prqqpQ7HTsqOzzKc26gnEFsOf0L_F0PbgYbPlY_VbOkragX2AferJwBybj-KgWpo-mDa30aAE4hfmth2oFrR7FgwQUBUXts-Z8QZ7HgNjTyXhxjwxDyuUn8tQo6tmAC0wPq0DsdYc_60XQAOtYaVeSpB3Zq1HTQyU9f9AMs_Oua6Xz0DLEhI1DFQvygFqmq5RPFpRevSXi6ua6BvK_GEp_Bsjlgz4_B6jzEypPQGI84n7nI6A9y7ersWaB5Xh6QueB2FTeRHkgxhzwyNCjp1iAx2j6tXnrElbUySkm1vlHSPfB0eyxShafgAyha4CAm3HaBS7dbE3AY5rfhpgwor4XAHhg8ejFWpv0fs_RcsUNiJsDdIlEZJnELvuLO-EtkGcPDT6PXz5QaAi87khhCtvPc')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2228', `Language` = 'bg', `PostDate` = '2024-05-02 08:15:24', `LastUpdate` = '2024-05-07 08:15:24', `Type` = '1', `ParentID` = 0, `Data` = 'A-dIicK0g8voMdvOiBRWEeJctlu7dFnztHRN2_iC0LYL0rR1UBE0sq3Xniy9mX1ub2DXfSICqr4HSzQlXRDnG9xnjEh6r493k0kcH_UsbZMvUW_vDtnTru_jPI0P5z6Mqj6vZBWIvx58Ep5C-S93CL90L-bvcQF7jM6gBaB82Yxc7Y_weK2bnJlyyEXrxOL5e_c9CEQjz7vYbnrm6Ch8uK6O8uDeYuNOK0x7YI_XFXtuzMywg02OLCd-1LJAnuFL2CmTlj-oAjoaLM2HCYMNAFmcvJWaceGrUE8pCbpef0PQX_sC7r2v3gPsxBFtSmCDUOqUTJ5z6kiRIMoh1h_E0zLXkmFrMbl3oSuUug-Y2mx-UY7g-YHjHfZUjcyUr5B4c9OoVSKQSFTB2Q7Lrq7aDlp4S7K-pzizRnKfx_m8ul0TRMTKWms-4j_asi3UodqYcbXLTRePa9vlA1zLMxPnaMelm8e0sfqDjkoIa3EHJZ4X6g5RT9clwhghgRHfGq4pgrVIA4EBVfBzKWR5tsqzpRFnjrfmr8XTVdspLtf0x94mLsbDLjeEHsZQFTvtU40hhX0T1bmOi2uZY0-JcxYnb1qrEZs6NXaCIG_XauTGq8h9bVrpL4zqJJ3v0uHo6JuYMvqCCEq4aTbcWfNuPA8bMpjhHVHvoRwUYkR4d_b8-xYsLVjeY5pXb7dmCOk_mgzKWa7F1JLmE0nOaDN6T_bmAPbYDnPgnezo0O2pJBy37_0QoKx0m935OYygC6AjrFaK0RoWsATdA_051bau-vjslVLCzh0itZR8qUqGKJlFtK9sKInWxiMxDHsejvqY2nqydXYuY4HjV0ovGAq2qdCgCC9LsO7C2WLbItjFdd7FFUGQ8NejFO7PuSaFnDEs7pwk6U4It4XC7PPhft_hIGOIdA5WioOdAQOG_NRNhFktgJANzbW4H-3-2PTOuqt_MwkL8-WMn6vqqmTEi1KelDFjqIb2YIJNmZHwBMJv3i11USmX_G6eNBRsugoN1RfEcu8QNIRMXEOLKy7OgEc_NsQyEgB2XrBO5ZNDUlq5Cg2nm0amDA_XqFU8BdAmE4G4_z9PrvELpT0T5vgu0pZFtskaknfs6k5UoofBEtFYcAuVjASzrut-Z0ubRxNG13iQpFiDU0f-EQxjny8h1NhA-XbwoZCZSSHPFRzY0OFobKd5Q-CS3VHcFu45cbWywbmQOCI2K1ql3lceeDSGQV4QWvYLl4TLuwoqeQVloumK7G9iN9N6L1_I-A4piIPq4euUvRhrzo4uTQm9r1FB66bGgnfz6V1RxhHx89iTcDGIV5MwBxVoRr912FWvW267QGA8c8fj-MUEONhQtOfOFiJIA0JI8j3kXrrVgH8bkxLCjsIfEyEJ6p3THxbBXiGTy3iH95KuvfYsFUR0Q_WkROr-P8rfTdAUhEPuH-7vYzHoTYS6qxG2KQ0dYmFKS29ufd_BdSzCPuv2pVrT9tOPYgUv_U9fwze9nD1on5_apT_2VClDcemXpSqqIsv6D1qbwZIrPscat5uUmZADP-tsjqPg5xzIhj3h-4w9mpN3mc_5NPDVFQLTEa-N6UxuupoNrUVsjV8ZoaEZGyovnOykfx0EyhuOXbYs34rsMRCsUM2yubyoVNKAU-Ct34sHJ_dEi6VqUtKuoOn6o6PTNsSrUEUUBi_rzD5AQH8mBtYw91jX1-1PcT4', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscOAwrDgcOQwqDwofCscK4w4DCtsOgwrPCtcKDwqTCuMKsw47Dn8KhwwofCpMOqwrDgcOQwrPCtsKDwqTDhMKsw43DwofCpMOqwrDgMK6' WHERE `ID` = '2228'
# [07-May-2024 08:15:24] /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
# [07-May-2024 08:15:33] /finance/root/bg/invoices/2229.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` = 2229
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-May-2024 08:15:44] /finance/root/bg/invoices/2209.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` = 2209
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-May-2024 08:15:59] /finance/root/bg/invoices/2228.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` = 2228
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-May-2024 10:24:02] /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
# [07-May-2024 10:24:06] /finance/root/bg/invoices/2242.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` = 2242
            LIMIT 1

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