# [05-Mar-2024 10:34:14] /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-Mar-2024 10:35:12] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [05-Mar-2024 10:35:19] /finance/root/bg/ajax/clients/form.html?_=1709627718226 167.99.142.201
# [05-Mar-2024 10:38:02] /finance/root/bg/ajax/clients/insert.html?_=1709627881138 167.99.142.201

set names utf8

SELECT MAX(`ID`) + 1 FROM `clients`

SELECT * FROM `clients` LIMIT 1

SHOW COLUMNS FROM `clients`

INSERT INTO `clients` SET `ID` = '61', `Language` = 'bg', `LastUpdate` = '2024-03-05 10:38:02', `Data` = 'qWioxLhsykY0TzgS2r65BXz-laButx4wRdCDGuFeSmoXcZTx1pRMRyuwENL0lUN-3eKqGOXNLgoRLSAcEP9LDTsidKPXYEnEpX0WhNTreoiJdwyj4DZy8Ipry3Omr5oWTq2KNxhcaP_6cwYQeY0VIyRtWV484j5WlddB8h1OfA2jPQ2bz9HKOmO2N7Y0T3YEOGGx8DGQo0-2FfdNfIztW5opv6hSB22E7O164AjsLgwitzNotS6YRTGKJ5oRgv4aqOYaVWNUszBYo0alvPFBXa2hEikK_V9dwnboXh3QK8xc9qO7ejUsn7i41kJoJW8YhkAPQUIRLo02VloHlV8RljMLbHYmkJPkAZSGiTo4H2E', `SearchKey` = 'wrvCn8OYw5rCr8OZw4LDrsK3wpCtswofCpMKjwrDgcOQwrPCtsKDwrHCwofCpMK4w4DCtsOgwqCq8KDwqTCvMKrw5jCucKhwrDChMKhwrzCvcOLwwofCpMKnwrDg8OgwqCwofCpMOawrDgMOgwqDq8KDwqTCwofCpMK4wrDgcOQwqCq8KDwqTCo8Krw5vCucKdwpzChMKuwpbCvcOIw5TCiMKJwp3DgMwqTDgsKxwqDCmsOmw4XCpMKgwqzDgc', `Top` = 0, `Visible` = 1, `PostDate` = '2024-03-05 10:38:02'
# [05-Mar-2024 10:38:02] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [05-Mar-2024 10:38:07] /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-Mar-2024 10:38:12] /finance/root/bg/ajax/invoices/form/2202.html?_=1709627891193 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2202
            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-Mar-2024 10:38:17] /finance/root/bg/ajax/clients/select/type_0.html?keyword=the&_=1709627896357 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrvCn8OYw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rvCn8OYw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [05-Mar-2024 10:38:31] /finance/root/bg/ajax/invoices/update/2202.html?_=1709627909636 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2202bg', 'PSqWfvhbvWewJyY0PBJYP2GDdeNiDMRgPHYSTIha68AAx_Ik7X2jvs2Sm-FaGmhkdGU3PekmY-YuppxE1Y4P8XBjLeOAmDsgXkyUuAtiSsJ7f_0C-oN9orPcbU8D8uBWm8KrFl2KjrPxCqDcRB1JPc16VlvKq-lP3XCWGVKpDf5DS1tN72hub3c9J5KqjoXm_fGZ9kijdh_pRmdJR1rsflWoeLpfGfXPyyp4yZRGaaT2ow4OZUsN3KX4642Fqd5qlXdOE8sBTfl6ZRWoQPfpOjl9YOKC-lJLGnMGV3INC6bjiQgJF-X2HyBnPDzeMmSQkMkvK_gwEJZ-sqn5kLwJJSduO8m2ZRPfee8a2yPYrYwg3WRWN51m3tUdzXV3HrlvUN80MvxN52OwTzdKyR0olfIRfzLk-G-Ri7X3fnBAdketB2aQozlSGGWrigqF2AzLPlTH82DzAPVDENL4Qe__uAOT2KNNStiS3LwGAWSyGgIV6061JC0PIlTXV5QIUCa5eBNSrr4TvVrln2yEdRdGP41pd3Zq42NOcODlYD_Ew6zklaA29SJ12KnvkZ_H5RAd9w0fpZf-FKq8AddGFcJQMuPJLIr8HVJXXWzFi60vqB-tufDeO_6jKp_O9VPE9Sx_Hgz1-Nfef92qbcoYuTVZLWWI-93m1AZHvlZzAHcSiDCvXqPGR8QkgHmDI6_dEMyvIxUs4x762zeFsoUWCYGko7kj-EG3zbah0dddjh49TuJ-ONzv5Zf5ZjtNPsY1bs7lElSzvjVfxPNAlVYHCjlZ9k891lk9yB9bY1lt3RDVnDI2xhdH-95_wlzmCPKqDa5rSxHqpigSXmnYyw6qtzdnMXzEDdFkt7d5afcrjJbMbM83igVibz4KK5Xl9-ibdfl4ZodAhVjUYOoNtJjuhI76H6qUleEBQjKjg0uAWklRk4K6-Y8cTOmCStUNgmuyW-AUn_-Iu6IlfGYrKzB1xLJrR3DIxdB_WZQMOgwoZi_UK0U-YJVtYOrbjaMGiEk37blMU9SpXGtEDfgVcGQ5CUAxCOI79Im3BZco6pguANf8uDY3qvCkhppAKjGo2M6zjHog_RTyYu9mI5VcwOCAmT2mFHkmDJ-jfBkVwvX4LsvECgCxftiIXGr81E8F8X9bkipkikf2ZPpGfTSjvqD4bIy8u4-SdAxIXDqrHJKcelsllR0FJ39_wyqE9H0uN2KfU1XjYraoZoe-ZHv-sz2vElTJbqGb2Bcw07KwVtwmDnBn5PAOhQYy2WGyko0xq5WBQ3RWAir-FTLBRVaWgkjrb24o_11Gmn4xJHv9seAVpqIo3bFlWyS97IjgrfWXmLk5dsOUPpJ5QnG3sIIdiUrY5Ec37_AI7thMK7fRg04kQNZpMsm9OsruELFkyXWvDLWNMxJWUfoH4oYWoUWPzjKq6ToKeyEbgn-uZKZZFk6BMwht9B6Gs5dOL0A5o6cJlywYPJHWgITAqTI2ZSgu-FVnq_cJSBixkya6jcan4QLRAAEgeI2JzGQBN4KnKlsLRu9CZv4N9AOOQJpg8qM98tWMq8FF1IuppS5Q-c6577t_YlWqex883aaqYXzkF33VJMQa5Ovn7KpLv6_xrGahNnGDIMsuyCPLwW4QoRnh5lP2EYDK2kHMEioLfe890sMJk2awNiU5iCziiUIs8oB-wNP03bpgrq9ZaZ3eaHzauZ315dpuZnE46EvG9mhV_U0Y8PuH6pVxbSqRRA6qQO8sNGZUNPRty450Ts7j235LjWbwqczL0YVB_UM9b8HWVINILMQuo9H_jwZA-LAU4MqQbehqrA5k7lI-mitrU8WY9kBNPz75hmvNKIX0yzrNRn7n9000KXRLOTcBAJidF2nmj6LpWVqOmZsi7tCv5h4QE0fBah421nRzZiToSTs4iZDiE-jqLJCBAEKVbozT7hqp8b6Fg9TiJamPMtPXbNtifMTRVQlmAL3io5nxlMNEdndi72XgFxEWx8Ub0iKbr9-hUnuvD_2w9GTUg-5NEeyyYiXhkqIJoQGwP8zEjV3SbN-x_ytquNEAXSbHamOafI0wZ49gn94v-EtnCWzqvM347fFESUetym-TSAVPzs_prXu5HUNUGCqrWug3FKGDtKhbaMGqAYqveAvi583VpWA6t55hEFbuR4-JMAwfzCR5BWucZwHBGPC2I5dShJHtgEy18gt9ZjJTeki7Aw0I-JZ4JL5HfTo_IXAqH4pV9b0vobTr71ityuQxj_V_PVxVP49cIAE_DgA65GGxE9f3qiCooKXN08buEkTXwGoAKnxBCHR8U71xQTRnH80ooP8o2H1q7GPIgyfzke9EoAaEZUOAr5QvWezdicI7Qr_dX9q11T9SbQ0dM7ohKV8vGtuMr1yc6y6n8xGgUZZya3ps8wyRRvjcO28Yk6pkXr3xL_2HBuK6iwEiE4_vsBT8az5hfH_30eB06s5EbY5l354p_xDtEcpjOEZKxuCrzQ8tzS6I5iNVSZsrn5-_xJFEo0QIitwbMMg7pVDh86CRpLFpbowE1Lwx8NwvtbcwAfTo42AM5OY2hYkoWCIBhD-wTmpo1SfNixpz-ZTCF9QWT1oxLYFQ7OQ3sj6645xIIoAFNztAaOml0RIBFPapsQAcYnNCGC6dGEotjC4llE6I4X7KZoXjhfUfe-20hjQ_RumRsLaBPZ-R9hewq1-7-KFq8JdzadBIG_8fmTfwSuGCE6GrprGCXnDVAO05WUhZrwlpxnkDqtj2U-NPPatLbqofXhJICpRiu_M3zEK4Uvtm0Y24nOr0Nclyu6itlFb_9FVBzCoa1spHqWr-JbsfM7o_1WUGKSS53b_m8gYiyQUJvxRnN0UTvZ4OEEQGNyJCv7bXwD8PxEfndrQzZOf0QxuLiX_xkeKk-zNRPaGBswuKCcXHdmIe_1F0vp17DIVGKpSFBY7tT19GfKszk77K')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2202', `Language` = 'bg', `PostDate` = '2024-03-05 10:38:31', `LastUpdate` = '2024-03-05 10:38:31', `Type` = '1', `ParentID` = 0, `Data` = 'na_k6ESs3d5cYk9-V7G-CQguQ6vQaYNIdDwzC1y14ijV9KHydM8U6tSrwQZ3wB3bgYL2y6u1TEnFMnss3bkjJBB91-bYcd1_eMXvGbQZQ2i6-CSzFdWOIl_V4TAS1smN9KNWze4q1q_hC3Ef9A-wecYeBu82v0irdiFGTditiXzgbAiGV8XW1c3xv1fYA5vNHr7VLD_5sG43mKAKC2utzcavK0f0kj7qdADWn2sOdQDjk4LrrQ_KBUstjD0t-HeoVxkVxFZBt3XNvJiT4E19YTN_KaH2MKfgRNcoH9xz72iG84C2QQ25Gx0kak3Dba6SGgV60dLQm8xZe6ap7sXGViTO8JcE0J-uctGO5BgItLWib4mGmRzRzF3gBZDgjORRgz9lbBxyb7DGiTGt7idbPY0D-A6HSvLiVA2xRwRk0g4VSEfbwTt8AdmhngogbQEZbWXbzRXCaoySHrktPjKAmdHF9kjnUryBwf5uQiNgsxcrw19FRkWvRAbnl12is2ygqBVV0XWRC7liuCaZ1VNK11q4W0FA8MvljK9mVd2ljftHKcOgEYvmzo7E-3Y26Cstwk-mpmMF8CrY_eEz-GB1CYIDZzxIZee571glUZ69ZaaKSBVIza08btpKApj2tYhzUNJMWIpi5vCSiP3DbZ0WsxCxkYB-jBAIIn-AKXasg6u1stVgCWr__qUCBTPbAHXYGDOJYY7-wmJwVG8q8ec_joxxZ9tIdB2McChrNtUmA-FmkALGt_GD7QJEpu3-d45UX-JM8malT6VNu03n1gAhccAZsTZbtPoK2j2v61rcv56Zg6jHn04UQg7Zr_Dp3XQwoTQgs9y6MXqvE05S7SAS3mC2_v4X7Kp7BnjBzu89iE-qEeSHfjwCd9_nCtMoMrKy9CJWZ_AVoakWmckc-Jy1wBaKIwX5dPH2-RywYz010Wew91MtR3wuQMlg0xfM3HippUp8fNtzucSKbYBrEiW7bRcwPb37Xd4JiDZaXkTpObCR_ZGSRVNCo6vQYqyxhSEhTk8plZWQAsKEs658MJLynFaCcV4W8m-DsctJm9sfdT0oXUfiUWSLlGN47rpv2PRjN7Cl_yRR_iJGGXBvg8aKVsaf--mNPlLYitOghME_WWPVRgsG6g8D9Mo1j2JH11jvBGXNmnD1aTH9gH7jkPqrp-O9fqenPMaclv5BzAOdUikTojtAW3AQk1myGdHZAFOybTwEhMMW790b-sSTXiL_xlSwl7o3cLvJHQ7OBG5NKTpPi1sc5CkXqdEi4tsQfbmCs0KakBWBDNg0S2hsyqdHDstZyoO2P4yNuqOS1j4WFukiAu9cSTjIF_Y-4u665JYl9YO1yYCyj4QvnO0xeS-uEy846MwE1knno-yJyU4bxnjK-nlw3hHIwXPSmCS8mulCfMinTOo6TZ--lkB590ViGSJRU7XTQe5HAgIL_DeOvOa-o3FyOL7sfdzz5FswU2X8fuMXwYwqN3q1_ovNbC4jhmuK2K7AhSeGkmPVR0LoBTn5ug9ztV6uypJKw6_9lWvkHAykJDzfaouccHGrtSr7aRVYwkiJP5R02XZw2ReXHCTj0OMwGR5YcYOwhThUKV6m7iABLPmmfRrYQB3xvj1NCbgmt5jBDLyY06Rg1h7TwmhXVrHcrqTG7T5CZ3tm1LoLBLh1QjrV6GAo6Dmm-dRTvER21wEMI03JqopiuR7QsHCFLBNzMRAWMDdsI48i8z4yQBZk9QeyJSY03gvA93F_qcD1BAZt1T4Rzm4OcMCZsps', `SearchKey` = 'wofCpMKjwrDgcOQwrPCtsKDwrHCwofCpMK4w4DCtsOgwqCq8KDwqTCvMKrw5jCucKhwrDChMKhwrzCvcOLwwofCpMKnwrDg8OgwqCwrvCn8OYw5rCr8OZw4LDrsK3wpCtswofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfCh' WHERE `ID` = '2202'
# [05-Mar-2024 10:38:31] /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-Mar-2024 10:38:45] /finance/root/bg/ajax/invoices/form/2202.html?_=1709627923881 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2202
            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-Mar-2024 10:38:49] /finance/root/bg/ajax/invoices/update/2202.html?_=1709627927508 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2202bg', 'CbMF3ZiPHLb1rjkqvCWluFD9D6UZJ5uRve3ynV87mSUWXCQCydgIk4AZHyTPMQlMIlaw0OI5I7Nf05KpRX3wFia0_6HUAW7340GtHdTZZ9hXoSIOYoGs4BzTA-ds1G34fzOEluwQbXJZUGeSS0YHYB2dl29NprLVXLLEQLzav2MdUb8h0U_K0sMsDEIUtqoSJZnPeB7I1719yFTIdpZieDHHiBWj7nen0Z7AHVEUBnmXlcfSKSSgKMdWJhoytdBrwFzFWDatJHLtBJMAbETLv5wK7RxiV4DXcuM0Arx9Fa7xNA-VV1y_dxQu8OytBS81T-B1IDYNtrgPcOqHz96GpSj50CiSpx2N-MeV_6mOgMatbgzA0k04hNGA2eTrsqHKzubSS9bpBCUKe1jZL-_3477Z5Tz9MULbohIMFP7s48hZBXNZkuEP-OARns6a5lmQ9ksWipAtSMLh9LIWeOsIT9u7lVOsIlazj4h56yTF-etnVDYccuxkm2T3Y85zWatpVZkHtdm-by_vC_84Lzi0jAZeyN5Ijqfk_Ym1qh5jEVUyFMgO4sj4F32X3ke_WzwFApRI2CgJD-JAmKyAcpvCG41LwEnqVTkhuDaqPjDxNsJezGzcx7C2JM0GuouFQb35Y9xOty4eaTGGCSdy4hMXH1vgI6uyc9jNFaCnQXPldZ4uNKROUkslWftB0MNcQgjnO1dy1b7HVGUJz7rGOX_b2Fm-LP-DEJuR-ungs9y18H9sZ9JaLcwX5Z4bXTleHIQyUC2HB1sSHehe-XL2ggfrsPiY8BkquzszhbXe0nmbJTKt5595QWwgPxjhVBg4F4RlaRbMIn2OI_K79imjd8n9_9V-uD_NQbEMKyH-dbvLYLSYIc0FPJbVydFvOaQXg2bI95IIP465SjLCflD1YV1l8yMOQIl_ckRuizy6GWl_iRmtVjEA2XqOzkk9td1aSYUZjn0WyUrjvNEvc8j-25cAGDTPf5JuUzfdE2Max0Y59wrQ9kX9GIrWOr2kOyTg7zXQICpV2b75E4kzWDdbbCVYJDtMBg9n7w2F4oukl-irrOfSWZIMgU3K534XxUMBYJW9c3Vr1erU_CiVGjA3bKx4Z0PtEy03u5Z3KP0s3CD9hwdHHEdB7Ae-RYoe8tz4-rytJeo14n6XdX1mvT7gh2AI25RPtcvbeNEQ5pfdjwh_zQOriZ1y8qP_ViuS8pLAhciI-1VArBV7flOeu1Xx9lRQgoDMHEE-tBfXA_mt9YlVF1GAhnpCrgkPw3GCEbxWRxpvHCO-9H2geFcZVEChCk5tigmGn2DfD8f_oIWgsKpBmLuYMmEZs8n_XObXra2i_bKomfqeruvpTdP1wmhuXc6jrJucgNjFF7ZN2Q_8QbL28Fo-QLqc7eiHv9XHDUfLagChXoLKESau3ENq2U9nSEyK9q9BreI4LrwrYnByvs__AKk_yu-PuQ3vj5gHqmkaT0ELlZ51zT9iWAIQxAhPAiufKxytVSFacAxNFCOdQe3M3NMjNL51BchRzeCWJJaxQjxsb6WnJJfrUrFtGkTeWBiAbjrmQOsI6pvd9oUuc-YklXUICR4BAaTtSlFRTy5dmvMHqPxX0nSTOxBhiGUogt0y2xiqn0Nqt7QYW49UtrqVQPoXXKzFmb-5_oVPDm5FFmWESEWnKOAoTr36OwNpP-Vn_GJdcmQ3ebCC_Msc1hj2Fp4-qyfAIHcC-OVrN2r9csT4D6zy2pLeLU7oGAW6Y0vm2iq6wRLgaXElrM5Vx2i5OOrU8EPrFFA0-g9_AhT3HrOVut-UO-yfjshvoRX8NkZfpYuwy-miLVMcBC6IGpkbyd9MUmYLtIUho4HuI7CsJgnU4mwd-lenDqx7QJJbgSJOoFeXUNHbK_pXnWQbeH2zskYV_ITSPrlzazlh5_BwHm24zv4pwV899Qr-GtJjligvM0jGI7rie3JGAIZLeVq4X8ogOc61MJGtml044lNlDdQIRKD3HyHav8jFRvvIna97guQUmVZpS6JDyMuCGmvqLTWuAOqC9g0IliNHz--5_9el9rWv9J4AtIBw_DXoAvLZYanDyG4Xo7ogLVsMD8X8FKX-1jY45f1PX_uYxDSbEq97fkm1Jl6VqGX7bb7oqHZil6RbFiZsjmOZQuedGb50OgmyGxQEdTLjDVWNw2uj7YIz1mzf8BwodnrDu-AaxGdmDhaw9j98qttbGkpGo1klDMWKqlM7TARLTMwiUI4ZLyXvAWzZDOmInYLdG_1imYzGXpP66YbMQfvKvywDLx9FVATs0R0_AoZSyyoxrcL6yU0aCtm5OSIjEP73eUUEoViKahogwkjSVC0WsirB3dBxPobLhpwKH_8Az3kaCivAOIKg1zGA1vke2xEh7ro41AbP5iFZF1FJ2rOTypj8DkobcTkyQEajErkKKhn-9m5aST_EJFL9K2vi0TLu9kFjCUWG8UgUkNPuwcMPtDUyepS8lWfP6EWETtBYODZPLVEiuRo6Jy-69otGbmRqz99uKjSdZeTU9mXMxEZU6Mi7o3pfPl4tpKUrXq5NjrxYGGrWbQACS-gSZqWVYSoyx2_IzENxs68lEnsDpDGV0dm-JLGz3DB_S4U5a30geiLf5-8IPw1RyWNpq-Q-xp79cY0Ymcb3VDPk6OQ9ytDSQFiPgg5dZ20F1VME8eg1FC7mopA5qnHhKEpjVy4jSux0yq6Z5a7gwhqciZarYEFzfyNxfa1o4ntn7hUrOXuU2Jat4Mq5Cejn9Z1ujUFQSVPnFkp4WP8ubejBFYff2vuni-41WIeh4UkR9Z9uE-av1GTeyh9-nfHjTKHZQ0j5VrQdXs7jCxnatdaXPICS4bm7ED95x-_wOixHLghVir6Sy3I6Kmz-TXNaVYgSM133A1YTaqc96Gvu2CTnMUI9_IincXA1EkHweqY_wtMy3rnmkoCHyFHSPR8Lxksc2sfepePW0cIqjiw7XA')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2202', `Language` = 'bg', `PostDate` = '2024-03-01 10:38:49', `LastUpdate` = '2024-03-05 10:38:49', `Type` = '1', `ParentID` = 0, `Data` = 'k3rCKasLKSr9i20GCuIVuINKurXym3wleG51mPIU2snbwtPC5ML_ewd2AzaMXcickFEKgnHP3C591MQqn-PLQnkvxuhkrY9uRguwjB5jZtZ-_-4auEwhjf7wpbRtv-N7KHlr-aHH_uv9WA_jbm04kEe34bEs0Z0ooen6R2f7Nx5SYHGqp6Y_ovC89yS81qjwLk4PIJxskZ2yBJte1z9vxM1Yj4xsPKe9DeGgaXLXvkmH5HOoGL200912MmTNyNX_PyNAXycSWQ1eE8nblF3xXnko1ScFQ4CKzfnJmQ470bYtZWUc6CJWie4wAD_yP7SN8uxwzTAtHm6MAGhoxy-iKKQdPotgSIEU8XK7wiQmb0q1aOcwfM5ny0STeh37rABXtCVbUqA5ks_2OSyxZr_N6oRPcTYBUs6RprqRsL8Ga2t6Q_20e80xupBw9yQV0fqlt1AjlDmf31aKEawK72j-Q5XZDBHIjcKYhwhXVMlVyn4cgEXarhpBfmNtE63yBkpwpJYyKkcFIn1piF0YJTU4iN7quPdW4Lf_x7g04xyWJW9M_-09C2-7w5UYui9gAZbKr_96xfWzk9CvCUwkyLP069-nn32XqLU0XtbO6VSxev5Byb4tnLcCl9MJTIzRYU2XESWvjLczsy0p72IiG1RRsga4p7_971MThN49IkUOAabdgQ6e_n0TCGMpsk6cGPAFmZVxM9q1pXJMQLis_c7u2aXvtiprQsojZ0A4C7mVDwJztryqJFtWCEOlExidzm9tm7M0syouT_R7OE2Rxb_5P9PLn4RRT6fNVfbzzyLrFF8hl19hl-bIM8gs6Lb0-yISY_Pgt42xrPe5J2v_ojZYO4JDZBApoxHgwiYwoNtqWNxPa2AVNqCVViKBAv6xI68FDGoQ4HoJnUYZvI0dtXgC22sGXErQtHj5l71O5t3Tn2i_X_sBGX7pllOVUVLqNYHsJhQQtgG9tJYjD47416BKsNkmh4gANed24V5VoSe5qFrY9d5r9gckCCQ_O-XORyy81FMcaJ2Ts5OW9yau4xTQJQ5MWEQOpjHhxOxyB7f0vyMDrYxNYNWS78gSkXtbO03NLgSz5vKHPFvWVFnmqBDZBXD8FOshW9el8OpagazAU3rRKcet30fmAxqJPcLKGqc5LxM5-TTqcSAO0ezagciahi0v3lmk7gM37UKgi6UqvshRWZn6lN3mA5tmCl5SDgTnGDF2Rd7jhZztgeOuBMHY3qJ7g_bM11ycYAzw3E2kHedhRWDHYwENvqIo-MSaEMiKxS7GmhGCaSvZUKLoFdEQmPcQCwfe4zyDuUYhufG7AOPtJ2tf4JIF34HogGgUQkkldlWVxav-fNZaHweze8nMFpn_Qk3w7_ITq3CoTPgfskKHnemJ-I5grYSNV1ep9aXnJyvXBiemua9zu49X9T4uJEu5wvvUuKNu0pU_qPWuGslWQ48kMHSv2Gvfe9WGyQNBxPCAfnPPTtrwJDXX2ezraCBfLLG9dvbxlBnJNX4Q3thPlPDBZdmlkN3hCiNzHfGUnwp3F-GTxT6cv2W9wcwGZSvVsw60fGN2h8KIt7nHJDizuG7trg-sXKHpP_Xr-3IIAMEwATEPWm5EgE8C3urAHhTBOvSDn3gmsg-QnfMw_AUuqpyCR9jCKaTwPOgbWf-YuQJJPbXckDM1JGZC941Gd2OaTgi4OCFUwrcyhOsjyIdMLKV4H_aY54K7qunw-9D1swHjRsnl7LvVGIxQa_rBy2W000dPgQaEIG_5-wHfGOA', `SearchKey` = 'wofCpMKjwrDgcOQwrPCtsKDwrHCwofCpMK4w4DCtsOgwqCq8KDwqTCvMKrw5jCucKhwrDChMKhwrzCvcOLwwofCpMKnwrDg8OgwqCwrvCn8OYw5rCr8OZw4LDrsK3wpCtswofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfCh' WHERE `ID` = '2202'
# [05-Mar-2024 10:38: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
# [05-Mar-2024 10:38:52] /finance/root/bg/invoices.html?sort=00 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`ID`  ASC
# [05-Mar-2024 10:38:53] /finance/root/bg/invoices.html?sort=01 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`ID`  DESC
# [05-Mar-2024 10:39:02] /finance/root/bg/invoices/2202.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` = 2202
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Mar-2024 13:30: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
# [05-Mar-2024 13:30:51] /finance/root/bg/invoices.html?from=01.01.2023&to=01.01.2024&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2023-01-01 00:00:00' AND '2024-01-01 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
