# [31-Jan-2024 10:43:38] /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
# [31-Jan-2024 10:43:42] /finance/root/bg/ajax/invoices/form.html?_=1706690621410 167.99.142.201

set names utf8

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
# [31-Jan-2024 10:43:45] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [31-Jan-2024 10:43:47] /finance/root/bg/ajax/clients/form.html?_=1706690626714 167.99.142.201
# [31-Jan-2024 10:45:03] /finance/root/bg/ajax/clients/insert.html?_=1706690703193 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` = '59', `Language` = 'bg', `LastUpdate` = '2024-01-31 10:45:03', `Data` = 'kJtyLZRHqs7RTpA67sQ-zggQAM8awijwioYvXGF-OrL5-gN_ZfNbmh0GMHs87shJrM-vzzCQ6D8ZqYyHUqZcagShqZyT6JoZzBsWCrGMGwL6t8QTnXIp6_J2Nf0-JDdifWZSUhX-wgixncZxh_aR7v7b0Xq08HgUueBiOeoK3OySLQi6dR6kfiPShBvfn0oSe0vjl3GNgdqdJEiANqGLNAgcG1HxMH4vT4rsPX_tZBxgVyJqa_90rCfpc4kXb5A_FZPTFsVAlS3nfNJoWWmb6qQPmr9Lc1kXpmtjYobj9QTanzszRlznTzRTpnzU6HKnDZi4AlcyQ516YTnu2iv2R-ioPSmGday-P_2hoiShTEHauGnzzW3zKdurYZW1PKK6', `SearchKey` = 'wrrCisKpw6HCpsOEwwofCscK4wrDg8OgwqCq8KDwqTCsMKsw4zCwofCpMOIwrDg8K6wqDk8KDwqTCsMKrw5rDj8KhwrrChMKuwwofCpMOIwrDg8OgwqCocKDwqTCwofCpMOAwrDgMK6wqCq8KDwqTDlsKrw5vCwofCpMOEwrDgsK6wqCrcKDwqTDhMKrw5jDwqTDgsKxwqHCmsOmw4HDrMKgw5LCtc', `Top` = 0, `Visible` = 1, `PostDate` = '2024-01-31 10:45:03'
# [31-Jan-2024 10:45:03] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [31-Jan-2024 10:45:09] /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
# [31-Jan-2024 10:45:10] /finance/root/bg/ajax/invoices/form.html?_=1706690709814 167.99.142.201

set names utf8

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
# [31-Jan-2024 10:45:14] /finance/root/bg/ajax/clients/select/type_0.html?keyword=sol&_=1706690713641 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCisKpw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCisKpw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [31-Jan-2024 10:46:06] /finance/root/bg/ajax/invoices/insert.html?_=1706690766401 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 59 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` = '10390', `Language` = 'bg', `PostDate` = '2024-01-31 10:46:07', `LastUpdate` = '2024-01-31 10:46:07', `Type` = '0', `ParentID` = 0, `Data` = 'MdMv03IxMEPR7q3gHWo7gLNc1omcbPGFYgWWKZiULMT5xKvsgYZjjDU-sRIdDwSHRSrWaA3vTXuoDw7XA6n_SYAXYB4yUpzFHfhyh8Bzqa6zRtp0j1rH7QwqVgMUaNQb1OGcZfVhNRZfixzrjan_yE64ffGtAQKbUb7Qrviy5SwEiHYDS0ucmKcpYbynOorjjx6qdMZC89YkxFHEuz53gHSXgDxIp2Afw9sH25jko3o18WwPXpmnvXJbQzgZ_UV9FnSX8FdNcHr2_zdWsn-ImxSXLtZLxPXtlQEfii8nHVkJ6ALJq_NVkr8uzk4gTvaLTkkZ70K9gYFedMxqQxGbqR5EjvQhoWt-rRu3YkOHYmGyPrOrthRUnemFWfOv1eX0pzB6hJTpSmXNx2UvCY1qVJ7P4bJVjsdWPZ5OWMK_P4VqG8zFxv-vts7j-9prTpm6ZsikMEfaEL1HVlcQBQXk6tZ_1GFrOhSleFUJwDVZEmSiMPc4A0Pzo7mCQmyrCV-3PykJjkePseVnjfBQSYBfUnJwBQV_6gG-P8Am2F4e_3okN9TaW4ZAjS0zOF0WXCro8CzX3TUo_AINBbEG9GyS3YSzOjQH6fNe_A1eQwqg0An77jM-pUv9gF3kQdWeVUccXzPrCnhut_DQZJw7rndxuCBShQ02ITxH0MFzTA79arWSl3quyZxcBIl5UFpe7PrL5xEB3apniEhfXJg24KApxmu-akHZDoQGc1RcueXO2l8F0kCf-hE_3MbqQ8688ljfW0lBiiEdQ9llYwYIDdG5TC83jlKa5jxNl8AZyN28MYjqOM_9FEgbt4gJV4giO15pI4dXEdLzjkjccHCsaoBeNk3Q5d_g2c0Inj7OPHddk6IJskBew3T8jOAsNGcefJYxTmgPKY2J7xbxz_GyeXwPZigCHGK9RoL5Z0cbjLetkGLrPHfnLNz4t5wzIY8oAs82sTqc91ceECZ_-XFsC4jm5_BMnMGu8VPmCZw519ASW3xQkmXmcenoY0EY5JkA51Kj8E_0e0MUP5vty06RgCfiTFH169vijXGwXZXFnSLJimI', `SearchKey` = 'wofCscK4wrDg8OgwqCq8KDwqTCsMKsw4zCwofCpMOIwrDg8K6wqDk8KDwqTCsMKrw5rDj8KhwrrChMKuwwofCpMOIwrDg8OgwqCocKDwqTCwrrCisKpw6HCpsOEwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoX'
# [31-Jan-2024 10:46: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
# [31-Jan-2024 10:46:09] /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
# [31-Jan-2024 10:46:11] /finance/root/bg/invoices/10390.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` = 10390
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [31-Jan-2024 10:48:28] /finance/root/bg/ajax/invoices/form/10390.html?_=1706690907543 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10390
            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
# [31-Jan-2024 10:48:57] /finance/root/bg/ajax/invoices/update/10390.html?_=1706690936698 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '10390bg', 'a9eg2DuH4D4Cy7bEmu2ape6YTamfOjadHIU6WMMzDKSZnQCAEos_JQaR9awv7ufpHqhsx_ClwD7bTda1yw0qPomKH4qOArpf-JrUQX5LH2U9W0AWHONJ3db1PcK-JTt8O5sbVP3BBbnUyubpRd9OGLFwQ2uyeGcsraM9S3p34g1vvtGnXz2Gv5LhT9a5_qCJwHgr0MHFBmJKN1bZXCJ5cZF8KarIWWZuhnMIq18TJqaSH_xGNcVr10EAhQgCSsbMa6ydjG37AKUeKFMhBreMGLu8U0KrhRg3OlmUVBSqp3UFzbtTn8mC5GNkir-aoD2VxFBev1lHKIOAGa6qRPIGGgXYqVs26YkVJtRGktZGNp3JZbvCEHm3wfybwn5Jw_qSbxsPW2FBmEb3nHgXApUA1ugvIgtG5dDm5c9DrhCOETNwFwsX_33THCqijXMLigwPI3OwQm8WnLr5Pi_RrLwMN85uRm6NHN5fILYqzER4sPr0rPFSdqclDhXAQ5QhxUm_Jm7_nRcCV2GiuBdugMkEva4W41455TFDhprV6dMCRTnfSLcsoP3paxjHBPazVbUmDyERi-K-Us2JigYI0oOMTKS10t215CJHxCVIa-QbFLtK-nYuqlLz13IFRMzow1Vt3N9qgerlSpOVMaZkImto_wJI8_2q8Niu-PmwVC-vqBUwRjzn0LmdwmraMxVaS5BXpWfhTOBlVpYVa7CmwOu49IdFz-DcuyNtSrXVUIhoaOeD5CPo-Q0pK-NaQiwuDNvgGtPtNoS-y6s6wsP1dAzCdpzvtR7LbjrqwFtDq2OJwBYDW4y3GWBC_b_y7kbd7szcvploYAAB9n3JHsJIfVDR2q653K-Kgwo9GU4qG3fNRbkCzUTrbovJ3OZ5wJ7L-HP8tpod6wSwa41TFXqIoi9SPEaizeHZXv-z0By72Zbk85tyC9yoYVap1ncrlLvAAOKx-fUIQrlegFspkosbcvw3zSLPDvBDgQVdTNKKmBMORTopzdvyYOJeIeqL7kifOhaJOiwFoHd5SsI6_kAGIDJvKXxNqtkVud1cf_8KYTSgALQwEJ7GLJcu1QbhqlDHEWF7hWun-59CEUSNogSof_BjLeEW6zyCQa5Dy0rmMn--LZU0-yT7YEQdTTOMd3aYTDv-Shns4wqbZCfz0piLvfsQVS-u93PJmWhoPyNj7d4flkFtPjUgn6WBawMPgriPmoN7E0Xh0bPBAfxex9OuA7ej3jnof1vzn9ACUp2CWjY3iae5dj6o_FKhwjkEA3sihTU-8KkDIOcExbKWKMKd0cs5NM0z4pzmK8pr5Da6XeYzMNv_IFIQQOCFINK4KL6z19zxp_qy0PDfF2LlCneSZ9uX0f1TZNxmCUcJ-jGRUqwXarM-uf90UyUh-Xsswu1TqIyyRybJr5MC0HAlKiYgvV-g2Se1pRUN--tequVH0FcwKu_h3qAf8EUhfonkMcNHZe8uR1g_X16e-0swd27tDMpWQbpaOTNl8cCecr_ge0t3YJHTe3gdVv3uB-jy7GDYM-ifVVdxdqUy0jWIe4zF1o96oDY3vPXodV-DF-b7T5-E_Tyazf7Vga2Ct50J15YmrywKzqfrqc8_9fg-czr1bYraBEQL1OuQFVQvkkUaGT6iRw7w9fHZy_SilGM99Akg9Xn7zx3tW2Bav6LGFB610mYQl__rR7aOeIRid5jQWNDSTD427OM3_1LH2UIY_EAYV0mzc2cBGVa1Un1bHqM85F7E_UF2Xo44_0d-EqRgo2PqtbDVRL_xg83lgVfWL1F9S7e-c_KQWRO3r9g2G81FMe9Ej6n735_1zPQfH7yz8wEDwJxcd6aW_tdtRPKYn26IHVFiObCsxMy-2no5AQW8Zyx4FuWt-C_KhyYVndRt2PNHh_Pby-P7sj5YnBhgKZF_TnNYfx5C7dCo1AB70pIEwf_CwtTfPMqMAaCqXSe_MoSmuWfIaTWzcwg_r9ZKwUuHKov1546LGdxrUA39YuLlL-64D8uTUPKZ17w3z7bQAgLo8Ps')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '10390', `Language` = 'bg', `PostDate` = '2024-01-31 10:48:57', `LastUpdate` = '2024-01-31 10:48:57', `Type` = '0', `ParentID` = 0, `Data` = 'K4ueIQPVcMKlgtbfMV5sm-pza8Un4IPTnHf7zjtHBcp4tbIAYp81g2xsKI7lQTAzRBHg8b-wH6mhbgSCmZjK10_lvz6VvkmnzoCIO-hXh1JpA0R6CdXRntfwks0KV0G8Eiyw52PEJhfbpY-D13ux2gPWRrXkKpeM2iq0ZILmyZGR8zyF2KhHZ9G8EwYZJfVLU9gDQc1Az3gnIddd1sn4WyxJajywRmMB96SF1j0RjZ6Np76X664HBDCRJK4evMm0oj9MewSUwJZNxLkSs4jv0lT3Y-MbNeYxe0TrOE2eMqBNSx0ylYRJqf5M4KmzU1hlLeocCbYTy2SbfBmyKiU9Iszw7EuNWALzX1BDCNDALNwxy_26xx1eNISVS6Z6Kl5EBFiRPaqDy2JThmB2ZuxJpT7_Z-0jkmmWc8g3qddxt4roti_SQgtYPUivDJ1AgZxsr2THq-FJuB3c4MN0sqZV0rqbx_CRdsRzo9pTAsakhvcBTclRLB4ytYWrz2fx2Xc2zkr8J7r0nBowx54GwtArYTzm5GZNe__BO5MCOFYDlknRNL9f4eIAv3tN_u0pMY-d9BqCAtCyLW75sDfQFLCKEmXxTK_vEaCvvSt7mtnV59HZYtssT4ek5C3b5YAj53q-l_4dMgAMEYbzBE4zfX40W3U0txIZR-gjsuGlgeLHy7ujadfFuND_OQF6cVfU4cHcrQTFFCzcHrh5so4ROayzED4bZJ73ZLiMGh3QldS2EOecdy5yWfeh_ZnzTxO0iILtZMAV-w3JD4Vmg5m8NqopK7RRv_oM0IMhlaWe9SxbKUcwuTRxdQuBVdXpQ5I3tmZE3x8Uxs1Ck0ckyQaOfoe0e30WZLsOYICEgUUwEklxLWwU-TQg4tYGsSJ9jN00YAGv8UXgPBffrepBTGexDlK6FDRZ0lAAwfJ3XV3ztykJrZubvJS_eikNdtlR499yPIpFW6_cRngONm8U3o1tnfqgMRoZVNYLZzNxFa91_wQA0LgsJtuUcjuqM3xF3it9hlLWmu9miivxochrw_6IDGrQSCMB7D9ur5H2KVbLxiwucKIU8rE8ep7PQgPTBr8bE-CE0fErFmn69elj1AIehBHsCrB9gC4MoCvr_osCvESuzsN-JBJUU03WXNEYN70DFFKLwbOQMvbTfeVm7KJea5uO0VvXSCaYgP0vrLEKN85goN0AOr9YSk78fj_bDEVHAr3sHrnKIfcrZGk_2wjMAoAtXU0KDX-UWkCzDMPTKnvR-T8', `SearchKey` = 'wofCscK4wrDg8OgwqCq8KDwqTCsMKsw4zCwofCpMOIwrDg8K6wqDk8KDwqTCsMKrw5rDj8KhwrrChMKuwwofCpMOIwrDg8OgwqCocKDwqTCwrrCisKpw6HCpsOEwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoX' WHERE `ID` = '10390'
# [31-Jan-2024 10:48:57] /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
# [31-Jan-2024 10:49:00] /finance/root/bg/invoices/10390.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` = 10390
            LIMIT 1

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