# [11-Jul-2023 12:56: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
# [11-Jul-2023 12:57:00] /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
# [11-Jul-2023 12:57:03] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [11-Jul-2023 12:57:23] /finance/root/bg/ajax/clients/form.html?_=1689069443267 167.99.142.201
# [11-Jul-2023 12:58:21] /finance/root/bg/ajax/clients/insert.html?_=1689069501380 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` = '38', `Language` = 'bg', `LastUpdate` = '2023-07-11 12:58:21', `Data` = 'NwJ_0rfrffgBEI_7F2oSxJtRYo8xRIQpnGKO-a9JshJV-tctqUiG7bx_JJIaOTbXW8bJzfR3_QgXNM2q51zAdZV9gk2dTskX4myLrTGCSZJDAb5W830ErVdhEjkDfosYaUKa_tqLKBHFaZhjMOpeGQJGOz61-r48cmQqOdgsukoDhYIyFA0HicSTuurh4dtCIdqeLCk420LdLXTJm-Ht2Z5oefUVGkRYByrnFJTLyLiiAn2g9wNn-nf1z0M6KRdQgDoTaqFvEl7TzeHbviAbqUXRv8TWgYg5Uzk1MglelVYbOOokKNBH2g1wPFSUTT8L6HQc-4iwf_Os8E9ZCXJuj3E0C9kjbhqFLtKrOg4sKSNh_qdWgYv0OyOygsEp8aWn', `SearchKey` = 'wrDDhcOGw5rCsMKew5TDqsK2wwofCpMOqwrDgMK6wqCqsKDwrHCsMKrw5vDwofCscK8w4DCtMK6wqCpcKDwqTDmsKrw5nCucKdwqPChMKhwoXCvMOUwwofCpMOIwrDg8OgwqCocKDwqTCwofCscOIwrDgMK6wrPCtsKDwqTCsMKrw5vCwofCscK0wrDgMK6wrPCucKDwqTDhMKsw4zDwofCscOIwrDgMK6wrPCtsKDwqTCsMKrw5vCwqTDgsKxwpCm8Omw4XDrMKhwqzDj8', `Top` = 0, `Visible` = 1, `PostDate` = '2023-07-11 12:58:21'
# [11-Jul-2023 12:58:21] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [11-Jul-2023 12:58: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
# [11-Jul-2023 12:58:27] /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
# [11-Jul-2023 12:58:29] /finance/root/bg/ajax/invoices/form.html?_=1689069509538 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
# [11-Jul-2023 12:58:33] /finance/root/bg/ajax/clients/select/type_0.html?keyword=bee&_=1689069513611 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrDDhcOGw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rDDhcOGw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [11-Jul-2023 12:58:51] /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
# [11-Jul-2023 12:58:57] /finance/root/bg/invoices/2042.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jul-2023 12:59:55] /finance/root/bg/ajax/invoices/insert.html?_=1689069595245 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 38 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` = '10370', `Language` = 'bg', `PostDate` = '2023-07-11 12:59:55', `LastUpdate` = '2023-07-11 12:59:55', `Type` = '0', `ParentID` = 0, `Data` = 'edpP-g-0KY2_7L9cohKCoJN5IkjCJj3-ui5wPq6UX6BNZu-A6wB3xlXVlNnjhDxGKeOZ4QlVAYChwRWR7dEQZWWrW5aO5IDepna9yi708WkRdIFwqunF6eSXCJjmR_OKIHA1VNQmeo9diNN1ZftCeNCEUhowY_1LBEFzt7H9u5cjwLtYMio3_gdyelqiGwUvYrpR347jADsC-4rHrg6ahXn6TgyGfkrbdWGK_1lhihQwpWEWH6yjx9fv6-V-1-ObGYj9nGegw_E5nEIpmSkI2JIFQo-vhWp3QZlfAvKfOLxTBixZ9KKxAklf1_m1MquGYcc3Qhxk5x4uv4GgrMO_FaLHkLFX1k52sSXgyFBE5QlagfYgu89_Zoeg_gm0VkaePawsqkJlre1dnfaiep8iuYm-Z3Qziq-6p1nNqoMyzl2D_EJkE_XWTG0I9Mptif7y1JdSjzLQpvLWkeQA5ZpF9eTJ-q5l7UdWfj7SeXXTAhrcWXImWcguDXoUbfDBRRbPvncTPNXA3LrzX9P69xrFtCr_tiwoKGjXt6H4jYtxyemeB4s7POGnlhGbBIUsrhJ6LcNEINx1EzO1PXFXf0iigQbv8NxyHW7HtICEum1MoJAhf2uCRwR5q9431LDNM3cpviWZWSX4EuhoiQY74Ywc-qIDJRBtejnWhBH7-cB5vSGSDNaJU_mZbaWE3qUF7b_hfVauiXoXwcfUtRExroEN1SG1vPVhmwW5K8echG5ZslsxbVfKi4Qd4xN--sGaDMHkHo7RE7rP97Mnfv0KsOGa1PG_MV1uPJl4cw8Bu2U2xswrdlAXAyU9zAEneRTbDMDdB3LPojkSxGQW21CcHdkF_Q1Mg5_OMJtfvACiw41pG87wL7Bn2a5PgtS5v4N610BjCL8tM8uVeLzhvklFbTluajnwcRHyQIwtrSte-0Bo_g78DdhoxX_jzF6t7JGWY8zlF2UG63szouSKDck3WKX-vNbeZyTQEsibkMpKluegiTbvIy1sJPOLbJK2-yPxhGmBEfOHIXFkF8v6dOfMqrvBEsomlekbGFhRU8XI-rxF_ebLIiLYCGD8ci6rCrfzI8wdJEAegWJvDwiZpVqKq7CjA3oWfJmSNZssniVCqnH0_i_-Q8Rh8dMVEalEM2dbLxS66M5L58L_X6d_mj_rPw2J624vK0oBs1sClYEbsPRrVsEyVivL0qb8EKM6RCytOwoJ6F3z0ocKJyhEIE36It8XwZfJV8o3z6HuImdOXxTN-EAbvsJCjSH-HSyLGpbucfRY', `SearchKey` = 'wofCpMOqwrDgMK6wqCqsKDwrHCsMKrw5vDwofCscK8w4DCtMK6wqCpcKDwqTDmsKrw5nCucKdwqPChMKhwoXCvMOUwwofCpMOIwrDg8OgwqCocKDwqTCwrDDhcOGw5rCsMKew5TDqsK2wwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5'
# [11-Jul-2023 12:59:55] /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
# [11-Jul-2023 12:59:59] /finance/root/bg/ajax/invoices/form/10370.html?_=1689069598746 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10370
            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
# [11-Jul-2023 13:00:09] /finance/root/bg/ajax/invoices/update/10370.html?_=1689069609205 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '10370bg', 'Yrgzf4w4z6nbbI088uLEp-86aco5RrzZXsD7tNVUlGTdHOAXZ3Bljreo-krA_FZddwKxZ8Cig9vApQgIdNjYLcX9TxNs4JKJBXk6rQ1Ph3hPdEV5N4azwEeJg4pbt_lDJnwwgjkvxzX1jqOnTkvA5vabOmxam23sBuZcS2nDn4YibGInSb_xdleFL8RKTOvEcOJ0gKbzPI_upfdFfFMK_x9r9KJ7IKyQnax00NNF3Oq_QC0M6cxUJMgG2aeGu9YEWgF42Mm3I5gvq1CqQlh1I2UeGyA_3fNqVtgQg5pp3YYaIJVg8BdGvixYaNK81V20qdfAFXILWXsghlWMn3O3cDkK3qC0m8CoFhxJWAcRRMV5_Lpm2A06jcW5OjGYRxKwTT91MOAC3D1JC4TL7dalJtYQDCLUPcLFrnVqYOWgMGTllfgPUnFkxRBRlCZwXndARzJAoXcSE_2UxhwdITjdG55kJWHjgz69Vz_thcWeAD-aoktu6gnheGzc2UwusTkk5DMbqI0jZNLDh_R_VN0rUPRFSMtH8kj-sgcOMUzqOjNFBdStBM2fEbKFlwMn0VhqeTce4z0eSYzfX8DnURlLUwpfG_opeqLnTjwEqdfW64-f3zFpfsE-NNqqLhgDCGXktAF2xoDwrybrw9MeQxFuMIIdNDs2j9XX34MMCrgz9Dz2hqZyltJ-njqEB1A1RB8QelY8ydvFA30wExALc5D7OBNxjBPPtbmAUTK9bNFlzMCmb9EQwvD23bSg71mpYRmMXrymTCv0eGaU26BzK66t-6w-BFvEuWgg2gO9IScdR9Hnil9RFC_ABiLpoqo2LTZQdZbARitsAgixAmErmyRbCVrX0Xbj995Orjcwcyb-b1YUO250nTY4X0Ly6oKkA4EEpR6vY9VxuPSSzdW9HTTMqj7UCd0gR-tVIsnis1fRm0fNb48K_Pi3N9tRifSKwMM1u_D8G-UbRP_8jtBZuhgxWaexyyQlw5Xz-TdKGcGgMNhe0gvONlJeTnj520Z1-cI2BS1-fyhsOi1nHRtTu_ZXP3mzDcI-RNI-6WXK3Qt5I1nIK9Ug5VJHxvPhiRRe_sxIWaSncKLzXGtdD9CLnrVmHU7FcLdSt1N9pFDlZRzeSmlQyPvhFXGrZOoZlndOuWdCsbbJuuQZD0u8d7LSdpweZg1J7RYOeUag6ybgIFqfHtk_KZm_vVQzvjdFo9e_fQx8GwavTZ-QLQ6FbOBdryi9THsZePzfR1_dquNo2W32TqrXMn7vutAKmEF6Aq_othkAhe8fwzzfSMigpQwryikSXd2I5dcaKZaNpctRQqvVpfQYKXSS0xTf2dfN6FwerCv6rA0MgV-FYD2-P19qssUpaKRFvxrBWuHTR7MFuyZPQ0tG9MSgylEmm4IQgWFbEFHpYVqlJINFpZsqJYyDwwbVV2se4cpYYJbJQAzLv0zWpkQcsnvDwbdkl-HQfhya-OSHdtAhK89iyF06L9R2YnBtPY4-buliXcR8sa3c-64nofHIKsCCS778bUAL4WAfGYclzJO4h8aLVIhGC-tM1F8H9ahNxEDMt7yj9bnXs_1yhCy53E0HLud7gmPK3rt56ZqMARL87h4TOD1oNyq70xYYAh1rAiUUFcypzxUe-vy_9mKUyoWrqUP9rHf4X1vNRonOOA8Q7KCCB2TjLkJ1mpQQRurXuwz_pu7eLWne5maLLiA2lMXxomgCJvUVamkPg57STcmeZUP2edhr22l0PRX4HQ5SaLYlUR1BZhSOGMLTKhyxaEWzqjZDumrXZ04R5qOncWyokuhViYEDJajADpX_ELyGvAq-beCNbKLWxiY0gpcnE9nyAEioWkj3Opy1Zvww8M7Ej18bqU0OQrUXfVg0MUhvQA7lKcWykYLSzkxfSBzJV4Dw6p9VomFw8bVIZkFkL70mnDMLdOFOohCU6nUcSi5x-PXJZaKCnk6a4saNlZxUtTplxiAAVG7cbdjxjRNARNtA0z0OnA7LM7AsbAuTOI-7teWeb2Gazhwml0JrKQNMivWEBqfIoqMldbUAdpdhwMi2i_xIaC2eSZokP1_DRwnv20IojQo2mDjDJUmJxrZEkQwyVKw9kh9vyPRBwPYQqeZi2ZPtKw_n45d6IMuC3NRa9dLJ6D82Il4VScUxwD0B0pivTg8enJsTxqv89zQvvpmnnnbyeCV44h6vMxRLvsOHafIu5cJlKIhSdtUMShxw_HG-sVswetXqXxY1khpZ9RxnzAfWI88R2m-rCxYqndthctCyETIeilKfM4fQD-CpGgEfvenojutfi90vc8tMreW-G-BngA6H4B7dv9HDBg')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '10370', `Language` = 'bg', `PostDate` = '2023-07-11 13:00:09', `LastUpdate` = '2023-07-11 13:00:09', `Type` = '0', `ParentID` = 0, `Data` = 'XOY1X75hJhWJhmu4QKmJf_mrkFOZsrHSoh2zfCbO9CnT7qPtW35RF3CYnd6NwCFYrUyW9mjU5E1F-kQ5sqRK1I7gfu260o0MErNc7iUtwcACviZDO6rmJP8NO-n3rEFHgsrTGfgv9P-YdikEP-hdU7JBAMRJe09NujbSkMI-Beb2bk2fcAGrKLC7eKjNit9LwTQdhpvRgUbmbY1Uke57Ekf9eOW0fUT4BYFb_Ew2YXuhXg7AtGnpg2aLm3vEiVPvjJUIY348Aw4jupXhAZyespZa7bNtuF6urO91m6_tIdpdOtrc4zCZdMxo-a6j4UTJUlz6C7FopS3fUovxYRfNbCJZcXcoJ75kpJuuuiOmh1Iab4Sby1Rs4JedbGC10zMtcbRgoyBCnmRDDqfexwZmhf-tHK2_KHNhuXxbNIGBNvGZOhVVNgdrA8kbYPDuG-_mzkkAANtnKIpNn4gSiH-abW6N82rk-Xp4nXtp47Qeban3T4juVr_jt7nD-751K_IDmKLBBC2x4UHjTicoM-UGgkqP02svUlX7Jy9SfG5AZTUY1IjcyEBqY8O1yFnrceV6puXT0TTj-_FcW_WKig6q7Uxn1DUWCIGYQQgqRzIq1HepyWyL3Uha-K3qZ6b_Ta0qqw1BFTt-87qjkjA0ehj8-SLJviuF755drpAQxM3-c3u_QQ6vugMzQmSxnbJSY6jOtpqCmvFdK23Vb7PpBQMe3nkuGBj0OhugvM5tTZuVQBg9UAebCmrWYoUksDzs6NgkDp41m-cA-_HbFsW7KRRiUer6lV_4WT7hxpYHaLvdmLsl-b-4OOxeW-80QzUKUBpCb27v4C70SXjtQY1L65NPTwslCCDr975cBFM0FNx9SWhVZS9kGGHwhQoMJSssPm4GQ5iYY13Gc794OW7zCRj9Da4Cmum6jd_1h0LBy9C9ExRLo0VBWtnB9Su6H0a2d7og3exyml4NFuhiLqHYHNYp5ZxGlgDJpJxWYjPq66IrxdRi_7LD0J6QX3j8A17udEqg3_lAwX_hY4e1F7fIPo_dkz23OJXgQj4799yTwq2gJOEqUqAi86jfngsddZaYmawOMqhvdZh9q_qPAmJf9fnT8TfBYKbm1qpbDD9U5UjOr_hFtZbWw2qwtwvpjalJHMltcv0q58OpvHfsVpWJsm1u1s7rwqTT96xTjd9VEOr3hhgWuS5Ic8eGJ-3OmC49O5J_qcr5k2xxYXe9sZKMwil2W63S60VA0CsgyqjFNgY0S5B1cN4zg5kl5xO-NcwxCRah', `SearchKey` = 'wofCpMOqwrDgMK6wqCqsKDwrHCsMKrw5vDwofCscK8w4DCtMK6wqCpcKDwqTDmsKrw5nCucKdwqPChMKhwoXCvMOUwwofCpMOIwrDg8OgwqCocKDwqTCwrDDhcOGw5rCsMKew5TDqsK2wwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5' WHERE `ID` = '10370'
# [11-Jul-2023 13:00: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
# [11-Jul-2023 13:00:18] /finance/root/bg/invoices/10370.html 167.99.142.201

set names utf8

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

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