# [12-Aug-2023 08:05: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
# [12-Aug-2023 10:59:42] /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
# [12-Aug-2023 11:00:13] /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
# [12-Aug-2023 11:01:40] /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
# [12-Aug-2023 11:02:06] /finance/root/bg/invoices.html?from=01.08.2023&to=31.08.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2023-08-01 00:00:00' AND '2023-08-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [12-Aug-2023 11:02:26] /finance/root/bg/ajax/invoices/form/2067.html?_=1691827345933 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2067
            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
# [12-Aug-2023 11:02:31] /finance/root/bg/ajax/invoices/update/2067.html?_=1691827351663 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2067bg', 'WPQTA1R9c6lM00VZEcxXg6WFQjScDE6bgthQVcK8gs1rCi6g4YmslhggKRZqzpKN062KifP73PVyHcL3SeRsm1QHfbu2rojhmOriKEk3SpqAvT2KQ0KR8iZ_gdoGDsZ__GOlXdTGYu379FcUldfelbx2wxAsqb5gxqfDvG1bxvi9qDlqyOlqWTrK7IcLtkH6pZT9Zjc7X_nox-mHWJY7NhmMtUU6yTHR0R87qZzqOtVHozrN2Y7KZKiL9YBe4YvuPcDWawwdZE298LhDguW3CBNg4Bs0D2sizrnuldT6zCroYVx9AA_XR15xxVbkdJZo7Jo8DKQ5FCymiUa7ibt7Ab1LB6IgqQ9ksHqbOLgA1kFrgMBQVDhlgUUncf9fAtpvj7Qe8dLOAfOHvoOmbL_n-0qErgrp7p7Tgq6LcLjxoVDfG345YdEJd98vHOdYI5DXKDxK-TnbVjbdxYojfQ3TfbdY21Xd9qagWySXdy5BldlNG0cxSKvchkP_ja_MjYWJjAh_nC1dmFFgSmbR0XSGzH3cq-U-qyaFhHLXqGCZDCmRxMQGh_oFU2F-emAIFUlorj1fbqaeNiefuCiMYQ5tfwk0CnWGDdV_YJoitsNt1u-3EuGcT6kl3NpIjNAb2VSbdVEePVtesqmZTFDKBMp-6PHfMRcqv5lIKgrPMBSXZJtUB7fa9v7_cbawXGcfctatI1jS1y3Kz6dlBd1Pg4f6Iaf06v6AVnlIlNqOrxliaVB5uoUAarx11TSe-sYOxNvSidiI6nkAU_XVt-ZHi4ffNwm1BcIQGUjB2ei3I9YmF4EBFooSGFF9tzbwsdvvngKMh1ja0SmI6R4IgtUYBGmUduhWmVBV8OpPh09ZVKU98GjhmIvfqv-8hDERYCF-E6OBxKGdEjH-KiLgmAqOh6vG8uSsLucq-E4ZO7kyIE2xt1-a96fzEPzA2eJpLCU_wekXt4iSS5CLWvbuuyRmDaep9Qyc-Vdw_Rc3_jRGsjIErJHP2rSmjH-LZy4Ep7fmWPju180Rk-BpeoGVL5ENJ99e4KAdxFdg_3ecpHfyR01IDeQ-pqu3G1_9l6cLLtwbg2RViIpqCyGTdqKWiL75WnEMELNLUTWNj3UO-Z8z73TLYP5MHt7oxy00gN7UFPxBv7I5majq_sr4YaxOk9I24xz0ncT4V4deQYPws92d0j5UufL4Dz-hjkIi6JY6F4st8IRtfZgMSCE5u2vTZQIvVMafFTOpij5X1ChZN9FGoPkxHwLfctR6J7n3ccJ5bsBSosrRNFTnuajXJZ507DyBlKneID2Y3Lm2_AWyV6tUvNB-hQWYCTZtv0vM75H6pkiXLIsnKsi5uc71MJhbTDMzHMJRvKLs4xQdHEg2CcLnWSL3IT2rgrt4C15aX5vZWJ_OfP9L-p6WvlomNmurbxuZtnmnL6qkcT9Mw8GJJ8xSS85Wj8GIALvg44b51FO_4xTrPRyxSUzXKjf_SvsZlhKwFVSmx8jIeNg7lB5hf-xSqZX_tv-lSTs__7PsfZcRlWpXCH0JQyHQTwawIB08Z6DvQj7JL1PGOcwT1hUt_UO5P9AQt1yM48jyUESWK0DqnKH2VHSiO-g7H25zbB7b1rkpDAeQbLCLvevkPBGctWygQrgczQNP2Bw4yHd5J2GiO4l3ntj1b5uyJqJ2crHiI47bxJooBzaVJYItvX1Ey-ffiY3XIVpQkxWFTzoVqs4RYX0tKAMdvZgvGf5OgjmH3Vl1HTuCs_pXAimEUFkaJtfrkPRccxS_c65Y6CmgRdkQONIGqxwLUQHrqoB8rffCBC44ygxE8mFHkgqAJaxys9hD0Nq8kXNU99uppgJhlWeA-oKYltwNce2fS7mahlP0eskNWO_3HBJa0CDfXx6F0vUrjKmewUzE8U8dkjhWvdyqL3AIUTyFHMQKtNk80n72XIkFRNy6iT7n-ZDG0ezop36hH2Vm6kwmh79UmpoCWMQYyonx0Q2IhCEpnKQJilkwZmlvdL1TjBQYM6dXcaUL9ncKAljGdBJzYETl0QlJHT27nkOGyJyV-uMHCIVyxUUmBD85M2poVGiJxK-giWb9ZhJsfAsMxOs6fzXxyychL_LbYOCXH8b1DxHzVcXMUYvSp6cZEldMEskebky78tX6hoo5hQJsevfbtnZ83z5cMtRTtz8wWmdsQEKRdCWkH44AdffEZ3M5iB3GFpCqjJWM73cPpDb-513Yg6_UEX4jUrenKcwNIWqGhj5MRTh3VFGuRkl9vZoHN19g_Qg0yPdzgi0aGyNF90V5rfluZkgiTNxZmafG7qyTc6AmjHbPVdlt6mudMOYOxw')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2067', `Language` = 'bg', `PostDate` = '2023-08-12 11:02:31', `LastUpdate` = '2023-08-12 11:02:31', `Type` = '99', `ParentID` = 0, `Data` = 'UQj-JxQo3_5oklRDQr5BfVyZgW6QBQShlOAeoKVUL4ZQE3pkBgkrHbFazCCjqm1p6fmcaXGRjvd-ST36S0k34OgTw2PJ0ag-RocBhZOGeIML1b0TUZ7LhPLtsJwT4GVW5iGurNzON70TTweefwM88ADr-VtA1mGu9kYmEdckU5hmolKUfta9h4ci9u8ypP2p45IhjllNjqdFuJgYs9XfCF3qvSwizSBpG6KWpwj2PXQMG3nxZT9km1gzGYiK-XiF0ISYUoFm22VVDQMIpk-NZUk17-kpKoK9Oc9Atp8Z2dOtj5LuA91ye1ojBeDh8fzryDRUJ32iZSWk_B7BEJxIfZmqUgbCQRisl2M1LeHQ5Jtj1vnSjGLhbIWb_7bZnl8Us9bdQElLSROiUaTHOuVDq9iPHovEidluJdnObB-ogFTVlrfV7TrLhDgeD4jWNQWhAVgBLNGLfun_zLTjYlPKq0YVvHxmHDOIuqpsKxAdGgr0vMjXNU06lJUmqdVhN4P054SJfGfLgkKVhe6molMAxnueIL2glz7SFLKKus_0bnbDBXU_bCdEJPsFFNW9ozYy5McIovYTNOH3MZu8Xxvntl7mYmXnxTahilK0wgDZL3qG2hSGds6LlQ78SL5mxaHVPcbVbu4J0M22teeusSIqAwc0gPmCJz-r0kitl-NDERQ5o6IhU4GkwUgGHEZYaN4Pgcn3FS4LzYmie9Qr3rq_R0peXYalQrb1FZNL_uL59kFhR-SBqPaceTN1SMIZpu6WDH-aCa16QdnXxn1fVbYw-fVs2jlKn6qCGoXmuLfSL7BqX4coE45FSmHCPn4ZqH2uLfZ6faZtu74FZJ0PIP09OfET_vgTAooA35tqTmUzZjohQlIg0F_i57l7dVssBY68EaBmT5TwQQcmoPL9GX2gQiiOPgh1m1n14LsIlsoflYZIN3thn72TgzlrkZ00Eq2_0UyYQFMSudNwtqMB6RhG27uoiqKehQnCnAuhUZBuWG0tqf9NaIlpSfHk-aIS138pL_naUaTjtnwvq1durzevduR7-MsE_CNaqbd6yaGQ-YfcufZKf_lRCoM2DDgrKQYaAXObKjXkuBZDXgmmAWcg0eMnCSBL3qzt0MbiRMSsOZ8qTxO7bEuxTQUMBA1TEU4qKL2Q5zpRz18NsufRIEk0kYQuBOqz6vmw0cJIwP2i0vRdJm9F5nWEIm6bT7TcXrfUECIR7tPQVu9yj5qU1DoY4SQHbZG6m1ecFPRmlD7HfxCaYiz2XYpOHQh7kEDnk-AO', `SearchKey` = 'wofCpMOewrDg8OgwrPCtcKDwqTDgMKrw5jCucKdwwofCpMOqwrDgsK6wqCq8KDwqTCsMKrw5vDj8KdwpzChMKhwwrrDhcOGw6PCscKzwqHDoMK2w4XDkMONw4nDgsKowwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMK' WHERE `ID` = '2067'
# [12-Aug-2023 11:02:31] /finance/root/bg/invoices.html?from=01.08.2023&to=31.08.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2023-08-01 00:00:00' AND '2023-08-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [12-Aug-2023 11:02:54] /finance/root/bg/ajax/invoices/form/2064.html?_=1691827374236 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2064
            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
# [12-Aug-2023 11:02:58] /finance/root/bg/ajax/invoices/update/2064.html?_=1691827378462 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2064bg', 'MV61Atg0HKia9yIDBJsOlgSqC_6qtjLzL4itnPUIcaMS81ipMtSeHGod_hGtPezCZFxAfAs-2Txdveu9FmbQ92HA63LLFyTJYYnHnWzDQQE_fQd4v36oPoWz0zxN09IxzjQIjYIspTBSym0uOgqKXJKT8nJMAo_eKvDXraLpchoOJkydzoapK_XOBMuBqEyLq7xiu_Om149EXg9IF2C6OekxgnpkjbmfhtorKglVCo8oH7aF0jHXA1xsSkgtSZzB2THH7WO3j7z5e-XWUgqyFKEWpH4aPdtS44EsnPxAwgweBn67mF_ict8TPw2HkqZ53lTGLKtz-Hkfji-r2qGZF-BoRLcD488PNpGrBJbSyb5nF8e-FqGeSL-oIANsxxHr2MK4dYbvKWrJqSO5CwbfUrnNdN11XxFjDgs9ZyeBrldp7Rp7_j0D7ITosv_HVBlVq_5TmKaE945HtRUUIqo0BIUkbykjP5gJhX29USN3puUu3sUcvcBMUi4f6eFks9F04Ug7u8b7K72iRYbCEEk0cAXWstLEFsE9Cqbgks-wwwKoROwbPZR7Nj8ICZ8jg_-RgxE759pZJPxXWL5tNvletmo9LOwydIf5bmCbA4SMbo9i_BU2iorqWMRTdqSvZDhRLNB-9pj1ew8zRNhSnzB9XilI5d76WM72CQEIQw3Hf5mUQcQR5wtnK8Zh5E9A8HKloInRtoRBrJ-xxlnixubABCoLZo7TGQqJZpVPbydeegyTZ6eIcezzF4kFnG_uvpU4-k7k6I5cHRd14xKmy9srLXO5LAr8xV5GCNgOqHgNi4L__KolEggf4UgApmTwAJtvGOhJCQbkR3kZgazja90t-2-gHODOUvkjXbosyGfJOeXcLB9uYZmt5usL3-NwIErV-47avTgW_FlvUp-TfoKDPZIOv6p7gcYNR1ep2jco36OB_jKWtjlALvVq99JYLN2CNF_wabgMybF0DIxFrnY92hupa5MdgGNTV2UUCho-KrrI-bEJzSZrijVXLgbarq_1lcHqjDVWr8A4tR2rbd22_6J3aWrdPhRVry8ktwfdPb9_UcWkIXu001ZSkeQvflUMgKKg_acSeCVc3yUlfTNXs00dGNFnBKV7r_fy21Tf4M3BYOEFbZa3u16WhVlZAF8yoAaIwFFcXcooLkmenduUXndFOt7TrTCrsEiyn-vd9V1jjK8HZnI-e9aVGgDRhoUXtKdIli6TmkNxqXpr7sllBhAbMDFhR_Hr9mHzi_-1EO5IPHw8Mqh9u11DrU0rmi7SD-0h9MP8BD9Igf8l_iee84IluuIbPijxxuD6DUOF9kYomYTX0Fnu550Sl32j0ysbrHepr4UZw5UqtR8qaBbFm5yIGW_yjD9DmDQSRzk9B9sQ8mZMDFBb35b-B-dshHTcp1eL4FSuO7bbSbo1jYhCGdd_pey1yWFTKxRpyaUXnu3VtMnJs1-VcJlSBw9Gq3wzOYy81E-ksSt-xrhFRDw3SNkX2RZz8rkayVvFTFRlgqVx4wJMMkMHnLtIT2NKiVPw-SqtWDOcwkIXYyA99qM9WU1uBuyCn_7LLkmeXqdVdctbSxfIbHUk2BZaCiSVNuSsc74c81WNUey6NHyiu_slOTAz9qyY6eU3KuYufWZRTAipD6v-F6wTORvLu55XV7YvW0Lkg8EV__uuf1_YsUtVcSddawunjt7Iv73z8GTqchKWqYwSNRnx0AF-44CH1kq6ZpPWkuirdfByPaKivJK2ckaDuE2dGSY_ZrTbgA2B3Mhyuf5bg2_fuNIg1Lai47SKpB90m23Bm9wVoIX_MZic1O5TDbueBi4dRHSoTopErAnyFDCrg61Wzgqvs3yvyRPmkV78FdzDsv8r2xFsqi6Udz1hUov9H9z51DkYDLDI4VWBSdyVccg30jMLo2q_A6Ara_rDoVyadhukWpDqcutQiicYiEc2fAib9A-pET3M6tXIzis6jpv2owm-vHoFbm8XsC3n4BZB6cyVOVMqS3z3qt_wLvS_x4-E0rc0yaCZ4rYULNiD48A4eo_5t3AFt905mO5YXxT8h9Itn6oyrFLbNA')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2064', `Language` = 'bg', `PostDate` = '2023-08-12 11:02:58', `LastUpdate` = '2023-08-12 11:02:58', `Type` = '99', `ParentID` = 0, `Data` = 'Go7raNNDaMqI_ncT7OX2OdnbSE8knYsiCMoQwoBidyp0Fde902h2jF62d-uzBBCi0FojEIZULhS85q8MRX_q0y9Yj9Q-J_2sxmrwWOGCH_1QjTLeNqcyscoRrN4Fj5QIziluCvzbBvN7GfJJOPcxXuAk5_MB-NfCD5JmTYU8KOt_4fymnKHK5mQeqNctTN4tO4Z1DwcoXVJY8yYc5C9qh9G6QtnpbEchRKL-vEH1VslPnLl06deV7uQjp2efPSonV-0kzSzQKr-acaKebn2kuxNBn3pCnM1KE-KP5mmNdn2Bv6wsmPexP2as7G3m33w5j7lvDjMkHFQ_oiNSWSmy6mFApV3TxN9UforZrOGvG6t7vR6SL66zn9RI_89H3S4LjntYdfkEkQP8idHAiYddKb2cRGFgG018ZI2YnCvkcyYdVAIx7IsmrLn0eX-MvEdHrB4cW7rJRNM6sCjnj2z2_gSMQyxuNAr5j1J9ll4fvsyws2UJYYteYCPjpCNWtZSSBmFAoJ1-BIuDMXueHQQETevFfoRQn5YH4Jt8DvqoHWwHf_BMpbQ5vAlUAxkpcSvCk41USfZ_N8MX9ZUwR5rAa1mr1FXVgILiYI29E0AqgM71v8hVnBSX6PXwJTaD_FEk77vqSacwNwB0_32FY6yM75emApQeWgVg5iEXQ79fGWUEdvJwg_ptUQOrIjkfnttaLXg231Q_3BZnYbSLoJ3iiWw3H42E47TmpvSZQxNxVNlVlifGB-OHe9xVST5IFSS7hbIHzj1U6KOgLvM9p_VnLvboqiF-2Jah_OSy_GTKtU8zW9Klbgdil58z9DzGVekLutpnmItnfeoieoWIQZ-hq5Y33O9kH7nrzMH3XNT6xyv9cBtXuqwmz4SX72qo2WzVWLLP_y8NTzHKxdy_vKNjQCLhfCE1FGTEAqsHE-FVxliR6XtSu74-ccxQONwMnCv4NAAi0rxB8YoeNl9_R6PmUyElE5Ty2TV3X7ocZ2y7gcxrgGpihfBmNH1txuAb2e4v2a8WF4d_22dOJM4YkSwNf8pYeoTX_ulY2MEfEgnAqUEd7dU5ccMhXISKEuPZ8ALU', `SearchKey` = 'wofCpMOIwrDgsKlwqCpMKDwqTCo8Krw5vCucKhwrDChMKhwqrCvMOXwr7CiMKAwp3DgMKUwqTCrswofCpMOIwrDg8OgwqCocKDwqTCwrDCsMK6w6LCssODwrbDwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCv' WHERE `ID` = '2064'
# [12-Aug-2023 11:02:58] /finance/root/bg/invoices.html?from=01.08.2023&to=31.08.2023&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2023-08-01 00:00:00' AND '2023-08-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [12-Aug-2023 11:03:29] /finance/root/bg/invoices.html?from=01.08.2023&to=31.08.2023&keyword=&sum=1&sort=00 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2023-08-01 00:00:00' AND '2023-08-31 23:59:59'  ORDER BY `Inv`.`ID`  ASC
# [12-Aug-2023 11:03:30] /finance/root/bg/invoices.html?from=01.08.2023&to=31.08.2023&keyword=&sum=1&sort=01 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2023-08-01 00:00:00' AND '2023-08-31 23:59:59'  ORDER BY `Inv`.`ID`  DESC
# [12-Aug-2023 11:04:49] /finance/root/bg/invoices/2067.html 167.99.142.201

set names utf8

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

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