# [04-Apr-2023 10:28:36] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [04-Apr-2023 10:28:57] /finance/root/bg/ajax/invoices/form/1961.html?_=1680593342200 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 1961
            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
# [04-Apr-2023 10:44:58] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [04-Apr-2023 10:45:12] /finance/root/bg/ajax/invoices/form/1961.html?_=1680594317631 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 1961
            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
# [04-Apr-2023 10:45:27] /finance/root/bg/ajax/invoices/update/1961.html?_=1680594332112 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '1961bg', '6lK2n6Q0xGOpZY6CsJGk2r88FrPuNeaUsDPhuqjp39XYVCqcN5x-6k17uRIjIXT2zIn89adbwa3BH9ZTquocb-TA1Eh8jhXk9g3L1YS4N_reys45hJkgyabSM4MzUDYbgPlaGBnfHexrZo1hIH-Uxe4PILJzmgeIoNGqbugTrhlTkJE0mmu3XceSwNbodmKZvpM2MC_01SQcFsN6Ydn5hF5kj2pBuM-LOU5965NsHWd0dUzE8IvrK6g_mRtlWnrVEnKKyO5gPzv2mMtE7VQmBdXh7DmfRYtw05t1TlESzkR_y8w4ozSLXdFvwn6ubpaGo5Gn24vXajISHIiAGCTJDmylYowumhjXyh8n1F9bjnUYB2eoh8fSCtILImXh87ZXYRKgzigQMmg_lhS742QyyNMuoy5uZ1Qqi7bHFUr5t_Gr4onkmzVxufjrpoCqH3-hghF6BLiVcCp7gcyLu6kgvn5t5J65U7bbQMfl-GHc1SpKM-Q0T6ercjrs-6nw__1r5RFTYVOzjcFy5RHEN89mF7CUxaUjxWcWagYbCVSHGIW1mj1bGBp_h2THlUd4uloWk1Jswv87PXqaLQtt15VrAeNz8I1qafNij4Hs2uiVP0IWlc0Ri8XQPKGDzknKqQeW4SBC-yNqpbRYGPy7FGA5NgbHLB4QfYhWFY9kzrTtJFYF1hawgZj-ymI1LmsielR02FwKpLgbYHoEEszDjZvJclKbfmJMbLMfAB9gsbdEm88Rst8PcPEe4JDpnfVEdJXigkihWHHiC7GbV9oy7FCDgdvnZ0vxlwsucbcfYsPyo8B7DFZgLWh3F8s8d7AbD1H5B9RZLVNFM48cyyRv1B0ZepPW9sbYTBstDbi9sz6xZgX5Iqwd5-wFdoE_auaoXlDFRx5aaMA5pIIXw6ZI--SFM5P5LtVKGXZ2Ef1Qq2u5i2Db5kQwKXEbomQZk6YntA3l61j9aUDCc_KvFF7iSTtS56stTn9R47GltK-nQoX74JPVkC3Q0RgizYUgO5pJBhfKM4_NdXeoPJXp3xiLmWIw_ApdDZ9-DKCCQQsXvOAbczkBlbEUjNeyMoAP-rIvauzZ5RGj9Y-52m3D6_b2tiRvzYx8B89pUe3tcAau_scscEKniYF1sPHTyDyEryOre42JTAu4VvPKWbbNUHsErMlVbKEcYcRNFqkHWEWAeeLV6UaW0y5Y4l7lMREUrlgnIr870lpYNj_7k-CAdQFq115xc_uLFbwplxUVUSn8QlDut8c6DQ2J6JcAOiundMv1n1iEliylxVIkwp9m3mkB80nK2pxsfjz2OWsD0TjoYAontkguCjO3KiEyOuuMbMwzlVVLXIImr7dkVlxYgfouPzWwAaLrE1TKq3GZmvbCqyFkA6SJQghzL0pCEfG3YATO9U9FI4gTBYd91jheO4Mfoa1Dy_4q7KIJvPs5wFzFXqpqxXPQxKPHQiyn84nJpenbJNllFL_tHEimmaO3hNxG4rlwx2ETOIkezsj5hYhPW6rksV0mzRM3vtoT7KFw59gpf3u_BUczHXYf9WA3dZ0QU-__xhAtq2AOJ6Gqqiuf0k0ZDDKOKMbXN_tkqh66Edk66az26kZ1KyaZ1nzSCbElWfqW0VmCu02gl-jvSshuiHJqt21bPRIXCsfyznMEXu8vJvpERYtmCMEdZ6lOh81uL-3mmyKQnnAtEawWb7AWbcHx8fVLzCvq548BCE10a8Ue5L63gMPFeV-189cJNMk5bmxjt4IZRq86viK6HCeT-U3BtVlihEf92YzJQnP9rzlhKgcxqbEbD13RFtJHA68-NgXeuIA60MvrfLaebf6MgzMC-_OUveu_OhjYn3p0N6kw0va-6ilMFqgdnPrx-x0_CEEHL6Q8Lu_5O2g3ClnBLpoepuVuIz6n2Ic0z1qHBWiyLxyG72Iy03BWQmXZ9A8E6zjJjD_633RkH_4vGBds_h6uPH3wUA6Kb5HBa78FNZvMM7jAImY1-saHBIUaVHXs5qpGpbuixDYudKS-BsuK4KLzbh44sOq0Dx8aOYmNoLuCLVVvbIYjHlvSLT11q5c9xgmsoj-cka-ehHr8QGHTX_VTMu58-cXoYldhfO98tQBwkpKQGoVdBZ0yEZIBP-zDOCFRcG8LmcWtzom4fSQ4rU_mXKIKcAIjtCNVdAED7NXWhGbd-zUK8w8TN1i3vpRAfak71YwcMPdQeViZzYfwLtIWbbn3OSmjgQATAQlkLTD4_jl4f7EtN7k9DqW4b-F_mhSZysSkbWH-MpgEAf78CmpXCmw')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '1961', `Language` = 'bg', `PostDate` = '2023-03-01 10:45:27', `LastUpdate` = '2023-04-04 10:45:27', `Type` = '1', `Data` = '0MaP2vqC3anBRrOM43TMp6dDiF37d8lpxgSFflDWwjSkvyXQEVOstnXOyCBkEG7AvmBkY3nbedOHC0AHShn7N94Aht-1obWOQgWby5NJSaeeOA7rkgUHUBcaR2Wsh-kljLLpIdEbXfkINDQultFvQBpZXp2YZ91_yiCjpUK2oIkEUhV4T3QTwn_Uh5GKQHo6Ygiq_9snksNqwMdWlp1RDFpkIXmSG0r74wW8areL2ZjL1J7_SYGVvG8fCGSzlGRP-FHAi-HAugjgWpaH1AuBk240ovERNJgeLIYdrVD7q7ytIDcuhd65O-FE0H3DJq6XryYkSEgQcWfVT8q-HFTGuGfI-SobnmxlfojM3WK02DWDNcXYGFupz7j0wLSZSdFdxsddRBUx9G8I3TGWtwI6FZeE4iG0KE_gvfciYqsPfMFga75Ft8FQvhY-DOcxMV0rqCkcDXIllINl5EhDCuSedQR_aK2TN653PK-e5-a5th36zN5poTSGjBZGMt-Ju5rIVF8PODC_tIPftFM3x0rIU2CEIA-L7-WBRqPUwc5KFtZ3jZZ02VT49AZsEKmzekCvKfhF0vjeRknBryDrCjJCwBGWoBpYa9f5fq1vuWvXm5R8dHEn6WHzA6rNKrQjyiCDgFzAFtTUWiTbUzKgG4BvjmyImo8L2vGpxIviqpnxaKwB1HPmopzOj2LyaNataFnRmFTtjKK4VaklEY41IWfCAoMplkIQXqV6sBf4c373HMEuh8pKR9Qjw2uVfsYfN9crAA3PR1QL034qt6BhglilYqRoIsvdtiK-Y3_Nan-8mkkYgvdkFSlC7P3_Wb3TujW4TgfH1xm7MPzBu85Dna9QMZ4OMt8y7mvpFI3d9n8G74yoobJKeyrhYlrorP07bO7UZBQe127RlzcVRLiaWI3GOe63Xv7aO9HJe5nY5qHLv07IAXV10VquWv17EYeN66glmCJfFl1ywWQaSZJKQ-vC01oBXxg-q8_Czpc-m6gpc35wak5YuYKaBJIYICgQgoiPAwcZFqXNQjsV4i2PK0ilrX77IiHpvXHE4SpcUh5wPMSVwQSLtRhQ0K_7qg9ILX6t8XHkJYaasjAxXJ_tHtAJFVEIu3coAsHXGgbgYJl6-4knEBgyA26y9kDiTyxewaMI-OTw6sXSAmJ7gW2VnrIwR0FbHwjdYoy3HjpkMGQYUMMkM3y2rje38wkxjBmCEvjx3zHC90Ug_F-HFJN4fqTQ1lHLBmrePemVaI7YyDOKAiA', `SearchKey` = 'wofCpMOIwrDg8wofCpMOIw4DCtcwofCscK4wrDg8OgwqCq8KDwrHCvMKsw47CucKhwrrChMKhwoXCvcOIwwofCpMKnwrDg8OgwqCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqC' WHERE `ID` = '1961'
# [04-Apr-2023 10:45:27] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [04-Apr-2023 10:45:33] /finance/root/bg/invoices/1961.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Apr-2023 10:45:36] /finance/root/bg/invoices/1961.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Apr-2023 10:50:37] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [04-Apr-2023 10:50:43] /finance/root/bg/ajax/invoices/form/clone/10360.html?pid=10360&_=1680594648317 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10360
            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
# [04-Apr-2023 10:50:52] /finance/root/bg/ajax/invoices/insert.html?_=1680594657511 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 15 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

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '1983', `Language` = 'bg', `PostDate` = '2023-04-04 10:50:52', `LastUpdate` = '2023-04-04 10:50:52', `Type` = '1', `Data` = 'tPeKjVvgXH7LiCOI7vCC25BYBrl9pd4i6Zv2E0eOF40GYmg_ORODSh3GOwHiEbomY-UelRLEbdiGiUzbbVF93ZhcrpVgdGHTIlPpaXLeibjbarTNrCFd1NTiueUSEsRbNt7mXhYacMGdt5zP4diPM7JPnQq43W0NhkSguHmZqTm6iPJYYKF7Oi52fem_SYHVVP9rcZagn5ptXKqttr9qQcRXF5fiQoRwiV09FtsvlxF8yrh86d-N5_o_fz9udZWmQzYOOMCcwC7DvN0PH-IoM_MEXbFe2Ygye8AklZnlu_og9Rp7rqsJqSsFNBSQub3aSMxPTjdLWxqeu3pRWAy7YHh_-AEt02KxN4BW2QRiVBcBMIg4EHcYVcPzBjp25DFojV3Gg5wBpApeCHFJSx-0gAblzLdz3XHRaIdtQwJyCE-A_9jTz-B_tWSNTQpuDy_Un99PxtRYocpf9sctAdZD9af04UQO_riyr56q0znkeeMBDSCyoLvVuXS8EY9AIQiIzFAHqMWHO8w0_Ixowfvkft7wHHPl3-daL2DcUwyWw_a-v2sFNg9Jvcyx_BZ3H2mdNRN3jOdSWtBCmUtznZRYjv4Gn6dnIFCMIU47TwGtLNtJIO_ouT0U_gcdPl8ez62dSuyUmCIQnXaPV1BOM-2TNcdxcJjr_BFiCcuzxRFhrtRawDuxsW30fySA735T2rSC2Rq_EqhlAz5F37QJAnPTIfcy21-PdEZS3D1yY7c0o7wjG8xMsVVcGH_na3A3GlK7Kv725-AMfOhQu_lFjzSI6pk2fCiGX6MUGRUhSvlSfAjsrD-YRW2sQ-psACTyup5pVAHCFcHhTHxnbVvMt6tcziEG3Ewfh1uqyryKSGCJl_wO2q70l4l2J6KuvotuW2YMI2_zLjhxmuDL54NPDFnikhwwGAZnAMXFXwZjUj7dsqe9EyS0ySwPCODeT93bmg-FPfH1UuuvfezhxpVXDwkEQPoObcQG4S66Zt1nH6E_KinW7_g2pM9_Loc7j8w190zr_3hMSziOIW4fiW11UdnbybzeG_3KstMxfgZKIT4wrnfwkUJFJHkwQ-AH8gG5ko8Vyw7rnkEa93wIlg490VXNHQEgyaQzkH3yji6HJDRJf99nofgl38eHzDXuGNstPWvE_fVknpB7JPzevuHNdYOn2LTXpBu0G3UYSTqRNRt4PzUIONTf8F63GQOUhYFUum_BFE2ujetbg-ub8hrH3Hhie_Zwr_5IVulxYc3lGkwpU3Z3HWwn3n2nJ8updVCGvZra', `SearchKey` = 'wofCpMOIwrDg8wofCpMOIw4DCtcwofCscK4wrDg8OgwqCq8KDwrHCvMKsw47CucKhwrrChMKhwoXCvcOIwwofCpMKnwrDg8OgwqCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqC'
# [04-Apr-2023 10:50:52] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [04-Apr-2023 10:50:59] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [04-Apr-2023 10:51:10] /finance/root/bg/invoices/1983.html 167.99.142.201

set names utf8

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

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