# [07-Mar-2025 09:58:10] /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-Mar-2025 09:58:13] /finance/root/bg/ajax/invoices/form/2442.html?_=1741334292770 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2442
            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-Mar-2025 09:58:43] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [07-Mar-2025 09:59:01] /finance/root/bg/ajax/clients/form/33.html?_=1741334341264 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 33
            LIMIT 1
# [07-Mar-2025 09:59:41] /finance/root/bg/ajax/clients/form/33.html?_=1741334381340 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 33
            LIMIT 1
# [07-Mar-2025 10:00:08] /finance/root/bg/ajax/clients/form.html?_=1741334408684 167.99.142.201
# [07-Mar-2025 10:00:46] /finance/root/bg/ajax/clients/form.html?_=1741334446579 167.99.142.201
# [07-Mar-2025 10:01:15] /finance/root/bg/ajax/clients/insert.html?_=1741334475111 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` = '77', `Language` = 'bg', `LastUpdate` = '2025-03-07 10:01:15', `Data` = 'oQgUdElL6hG2LafwJ7wlAUF9c053qIHZjrCwI7Ii-sw0IgA7pDL7SeIH_NM-ixaSvdN40w300lmVkF04AooXSV2qCBua8-hOTzGoRZev0vLvjUlSACW-Rroy26fdSt5-NZfaHUyPdWbDZHCtk4Nsd-Cst0_DuZ3jwfijes5PUvC9AkpmJu15Enohxn8A75fBu6MxwciY299H1sv-2VYLSkWsnJ9GCZcrwC79hjRIKFZFzvUrsA-xUqNpYoOWuLh0s8GS4P5-FxyflRxORVWgqAn03xXtrQCW6-QTE6wnnPqkF8oVOsUN8lLh0FF2XL-JpxM0czxeREuzYLnA4Mu3hPGTQ6WapVIAnRdVcbqJd9-m5Rsn59WB-dC05U0zBVcyruIqtL-GGW1z6z1XzthneOAzzNoUAYgwAQkB6I8XDy1B91ajRf0Bw_YKNCmcCIMn', `SearchKey` = 'wrrCoMK6w6TCpsKew4LDrsK2wovCusORwr7DgsKow5vCt8KHwovDmMOCw4fCwofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLwwofCpMOPw4DCtMK6wqCocKDwrHDjsKrw5nDj8KhwwofCpMOPw4DCtMK6wqCocKDwrHCtMKsw4zDn8KhwrDChMKhwpbCvMOXw5TCjMKVwp3DjcKtwqPCusOowpfCwofCpMOiwrDgsKlwqCocKDwqTCwofCscK4wrDg8OgwrPCucKDwqTDlsKsw4DwofCscOIw4DCtMK6wqCqMKDwrHCtMKsw4zDn8KdwqPChMKhwoXCvMOUwwofCpMK4wrDg8OgwqDrMKDwqTCo8Krw5rDn8KdwpzChMKhwp7CvMOUwwqTCrMOTwqDCm8OWw4HCpsKgwpzDl8OUwrLCr8Kbw6fCoc', `Top` = 0, `Visible` = 1, `PostDate` = '2025-03-07 10:01:15'
# [07-Mar-2025 10:01:15] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [07-Mar-2025 10:01:29] /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-Mar-2025 10:01:31] /finance/root/bg/ajax/invoices/form/2442.html?_=1741334491373 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2442
            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-Mar-2025 10:01:37] /finance/root/bg/ajax/clients/select/type_0.html?keyword=Фондация&_=1741334497377 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [07-Mar-2025 10:01:47] /finance/root/bg/ajax/invoices/update/2442.html?_=1741334507056 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2442bg', 'm1ae4yIl8zY0AQGo_0Ti5R0J6xLMrIDUJfiY1ozQeNjLo-f2BCDMv2SfS1SHvm_Cy8UMR3WzY8f7tO1MoNCu_YqOiXfiiWP3sYDfs5dF5yT-98Q5b1Ed0tNT8_w5AvtE6sKLhD_SzU-2O7MfC9TQ-v-H3djeblCP3EPFJtS3Pw0hqo-Q1_ssiVOP64vBqQYo-SY-d7oYZn8W1unoQdtRg1zpnBWmcCU_XYbUzuvEOyWfLk3ZiKb38TxbkHML6BhlReLQL8fdUp-CXujyYt92agPzgG9vu3D128P_9cVApMVTtWDOykqPcdUv_n-xffY6i0-jNx0AHZous5nBO4-8QtBbDMfnJbK2dzFcpYatRMxcq7K2WcTthI0PIK3H4IQ2wJB3SHOtaZ6NB4FzE8Zrr1LXNKfj0680WlFEt7zLLeoexvi7-SAHn2T-NS5yf45UxBoh-cuvfWnu_BJ0yW40OFEpIsKVMpFahXeklqnTeA4MaRpzOivKCkoOFwwq61cWQA7dpiyAf605KdhK13ARPMOtspMMteZkri-UgNs96m-2x5Vl6Id8Y3-qY1lLuw89HvXHS92jFpKTov8vrFxvZC6mYRvPxPSDCL7UQdxEAa5BMY4dcWsKWhtZsFF7r97eDUiX2oeTMvCJc2pndNuzfRbeylBhDuUIpAammV3LiRMa4Wide-i-oQsLNibzvXLVPhbfCBGJlE8VYQzTx81d3fKZ_fzo9sGBl68PwCSCW2klhtGsycC-GEyv4xly7_UkgOQ2tptDo6VBMjH6bpmLWuBxnRvNQUxUsCwtKRoezdKGZZT5gzA5G8v4VH4mpnzDG5mlyB-53TA3VR4upyTotPNqsuA9yNLlzZB7EBJf6LtqVEd9kZHA7-CLaXgO3DcbV00M-oqYXYWoHG5n0IdXkAYi4O9T7WaqG_1B46pjUIT2mxg8If348OUSUdGx0s7y_DnPTc682dTz2kmKYkb15uGggAbWhMAOOlgX4cgmIoDmzVV9zZ1Ry1x8aEpGHzBvo0Kkf83lP9XDrDlRlujjsIJNsYlXHvdCdzCwK2uzS5Ot247YKyKW5WHO52O50GUNu-1Xx60yRNJyGYu76xLPqZOD10kNZ5IrAg1lLjw-Wsucr90WHs8HFP_L6seNuaXHWkBrmtTvVixEFJZmPezCpjI4sO0wtCyJD9mrJkkfcDlY5Id24t6KICcIMvfOmG7eGD2e7W03k9XB-sfS155rGQO0X7gSR2RSHE17PwVwPp03bzUKa7b6BIcYg-A6njxFdI9LHqDJ7S6HVAhU2FF_MfCTh_gKpFZWB40byVudoFWMoyBZ_MyJ7dN1WXPMee62_Jr49dfv0yjlOJNXxM73L1qJqXuMH836fQCeHNkZQND7VwX8Ba7U3wOljeO7wCSQ2LxGqthMGLGwD5rbpPDiv_yv29kBeYgsFE--JPyPZxt4LORaMP0GmuwXf3apJ4Bm4eSh15Mnpe8bnXO1UdvcqpCRTiPQY5fSCscdNg1BgSyi0pFjrHQR5RE1GcJMAyX6c5z6GbMsJrvhpkOUJg1eZZBAaKSkoK65JcR6Jnbh_Q6S8QOxRduBE6qUF-50pM-9VXK-uU90XmzX0qY5ORZUUl63Xr37QNvbLnKFq_38I1R9wfd66V4VfxPfYeiJBPkBHilOAP-TEZSUFzJCw_V2vjPrtEpDDPe_RSr8toQ94BNJJhFBuKJTJ_LjlJxE10__jjzwIYwPbOP9tieGhw_vyXQYgAeXd_Z7nkGUwS_ZnvmHcYMlaWaA2aUQ1bLQZkQ97480ZpoiyQy0GNg3f0rt_bfsAbdjswN9ROiPnWPA5u9q5CO7nPy2QK6U6-0Z3ggeYq2D97ykyHU5QtI4xB4iN9PddYnbnzsQHVgbb5slpOCBQILuISgVPlIqYCeWUgLMjKnUgNnhJMCeDgHdLowTDNj3WZwTx8OaWVw9P1GsM9NWMHEPDWiLWxJxAKb4SD4GggSXFHS3fuXrIggLHciV2UDvXfCZOX0Ht1klfYZP-7J-vfpk7bSfPe2VYxaBF17jalGTqnCS5FnmPrhsfWqycRa9ESWJXI6h6Y1n-81a7Eg')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2442', `Language` = 'bg', `PostDate` = '2025-03-05', `LastUpdate` = '2025-03-07 10:01:47', `Type` = '1', `ParentID` = 0, `Data` = 'O7XlNi5XUovhpIr0TI6U__I7oxFQXZ1a7qH5Jx87MKyKOCHr_rtEuQlJfa_sBsSc8RjBIqRRlHnwhufYB12KbBg_dHT-c2Vzsq7z3--LZxcD21B5PmsPsYiQ1NUZu3y3HKOl3bRnVPbavvGlFTb50WKSmFltDTV3CG94GCTBWzyLzU0DyFEplWrcOpRpzRw95-yRQeWtBFPF0CGZpLuo1218G9UYb8EedYGB3LRHOqKX8i16embVe4-m-LkI2qhlGdvHopZn7S44nozW_fgxD3kxlnqUT4hV2VabQnepqLamiWbgqrltoYlSNFqmhr5CpWd5WmM3GxNMttIoUYEGWhBVcwk8Q9Swqoyb416BJ01vS29u3_-OEJvnyr0PQnM_EzsDKmPnZFd5nUOxR1KwqrHm5yFJ6tTO0Hwnxom9kLVFCrOY9BdCUbZ-MgzmiRIeFxnMbeuD2OVqZEBqB06ayYOboCnyJHQtsGZZyM7BPnYnmfUTUQnIjHei_gpaLaPAFLkrEHECiJdDYLtDxKpJpGGznmODa-u35BuMWs6bGzI5w4_QRwCyc0ZVTsHrewmBaHIUnAOOf2Aje8FSI9VuAxGPprvmOe6BOGHsJB9Sq1C5jm__36jJ161u0AcoR7UjkmA3zeqYmpXc0acwkS2-C2xax0r3KlycbBdOAbdLhMXm0SlrwlefvMhoiEbhqMBa7J_RmQHMJGPY5OjSYCBwwrcsMFpqlKFbDUl3BbUKPnhBcIlTJYXFDGLUOacXz5arVUW6PkaEnGoPiCluGetRo9uVlt_V-e3YSaD2ZtPdvhEmyV_sOLJp71UsmOQ0TJDmaZdVjoQomkw9AG6dZe7RJKDfm9wowsYVZpoyoHMHTDAzVjY1tAEyhl7SYxfvxEvdSN-Dr-hRjFtfWc_E579T_BC-aDW8QrSEGawnPiP7wjdxmq5Mg-ZC4hyjruenmLvl-WF0GUbtjCKJFXT_8gOon3_pBDUc5DOxDPrjzaVMCI_yCSE3jBNfnO3bxc45fNsdhfk0GSC_OROy_zHyfrkxNWopBqRXVWO_0ER-kaAwr6_oKm3Uq7hc1wuAUXg8agMsitioh1PuiH7LpCNKzicWCbZisky5a0rybdZLLXIRls2YvWa2AguUcSu79aKI2_4j', `SearchKey` = 'wofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLwwofCpMOPw4DCtMK6wqCocKDwrHDjsKrw5nDj8KhwwofCpMOPw4DCtMK6wqCocKDwrHCtMKsw4zDn8KhwrDChMKhwpbCvMOXw5TCjMKVwp3DjcKtwqPCusOowpfCwofCpMOiwrDgsKlwqCocKDwqTCwofCscK4wrDg8OgwrPCucKDwqTDlsKsw4DwrrCoMK6w6TCpsKew' WHERE `ID` = '2442'
# [07-Mar-2025 10:01:47] /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-Mar-2025 10:01:50] /finance/root/bg/invoices/2442.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` = 2442
            LIMIT 1

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