# [26-Apr-2023 12:07:33] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [26-Apr-2023 12:07:45] /finance/root/bg/ajax/invoices/form/clone/1968.html?pid=1968&_=1682500069823 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 1968
            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
# [26-Apr-2023 12:07:53] /finance/root/bg/ajax/invoices/insert.html?_=1682500077912 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 22 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` = '1991', `Language` = 'bg', `PostDate` = '2023-04-26 12:07:53', `LastUpdate` = '2023-04-26 12:07:53', `Type` = '1', `Data` = 'QRkvCtAn_9fnPic0YgPUEmEBZQwCUi4p2rB0p6hmli_cQ-f5oM-nbyemVgIaxfA-Rqo3wpEqnFN9Qya8ijg08-A4SF9aeuCoxJ_eIno2l6xnhTVF-jLAqMQ29LPGuvX0JZuEfadgurThgIraevxomWKIfKuFpokz4e_mvmh1qZJLXz6kkZWnvrg4gDjBVFYhxUrxUgWuRuaJ8lTb3rYh4hspsR3xzpotDZmxJ8ay1tHo2Sa90uWz-OS4taWMfQOplmeba8weV5BMw1Oq8aKWAcMmxQ0e8xiXFd5L8FTKROePjiwr_THrQ-G_Kx-0TzdRD8pNAXQE6OB6kFsqOpJbk-FmwhFT_Jni7dRXRtjJAbqldyp5OCfU-bnN4S5PTym8KtIWAU-r6UQcy4SR3uN0wwRbt31bktJBmEmBSrhJKBPAR0_4vS6s0uiErMpVI3TTUj_hTIvEbyA0Xx5n9nsN6AH6ROuC5_Bki29g95dSweuFBpSlVnjLRLmnNlwlFZOSZ_3avwKvjcQojqhuGvDZgUdcnd5rlvWT4QTJv8xpTk_m9loC4RIPR1hvCdyg7W0lPjucdzs0rPpTNDyv3FdiZ2dunE_d-uiECruwwPFIWCEPsTM_QueDg8N0vK8tl06BSGYt7r6aWCsXKnmPWlInRUimMu1DzPJ0xxof6jJrvm-w0z-CBIfNp28YQPQaxzim-Hl2tKK_roD6LVV6a3R037CQI_PfkAqoJqoL9T4E3HJ3TJakTRZUFlygfiynEbwn6K91jyaZZ6c7Tl23oPEkPoiZGpHLpbd-xA-4qtAnJZIjuevSyWhvY65lFY3Yx4gtC4aQ0YsgTYevOvPFsVRC_T7ejHN-eOTaXZv67zmgANgczztxpvK43I_8b1V8pU1UgXxjdTH0-gXZok0-s9tYZJ4gKeJRXYqzPMjH_w7-T50IU5gi1H9kaEotu1L5qVsT3dq6BsGKOg8zn2DhH1fAW3vPXsDRsrwkLiAc_xbGqrXVVKNH_KOrlRDKO5Myb4WgvJQLJ41WFvh4JuzdrXxwmym-h8SCqCvgJCvmnROyxJp4s6SIlXTmYE_9_X9XZLM046c5iL1uThcKD9HqdIhp1IgX1sxzVuUcvyMlBx-Wo1_YHLjz9lHR0ON28yXwSQXCMv58e7jHD3KWNIIdhhU_dMaE71sr1OgYCugp4s8xl874TSZnQDv9SF4vVjEan4QASmMsb19JuW9PIKa22vCK_gAYlHarmiNk6iogQ6gUDvTCfL-hWwJZB6iX5QO11Hmn', `SearchKey` = 'wofCpMOewrDg8OgwrPCtcKDwqTDgMKrw5jCucKdwwofCpMOqwrDgsK6wqCq8KDwqTCsMKrw5vDj8KdwpzChMKhwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw'
# [26-Apr-2023 12:07:53] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [26-Apr-2023 12:08:01] /finance/root/bg/invoices/1991.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Apr-2023 12:10:56] /finance/root/bg/invoices/1991.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Apr-2023 12:11:03] /finance/root/bg/ajax/invoices/form/1991.html?_=1682500268525 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 1991
            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
# [26-Apr-2023 12:11:15] /finance/root/bg/ajax/invoices/update/1991.html?_=1682500280485 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '1991bg', 'ABVI8x6ahBOt4-caF3XyBlP0mHOBzsn-GMewSuM-rrrjl4r-zjvanuE7HfMcvsPFeo15HXNxGmT0e3H7tHuV9FQ4vAD6R17ww82PrIyaxaqm6VKH1NEk9l427zSu_d_PzZfTB3_pb_QZx_r7jEroeDuOPPFA9bNUlQ_WxBJ_HizM0ZGHYIqf4pwN9zHspb_edNGxqt3u6NxVJvRzQHOgQRUGQfKrgmB8wrEjgljwcQdNDgFcv6wlh0e_xJy56nnxM2noToNieLSMS_lJJhoYE5wsvKAiQP19xKYBY1R-uWgT8vtDSK6iIxPDcBSiKSATTWklAIp0vgA2_nGdKU9hYHCdd2QEUZkObnIe-3qIJhrC7nGDVowpv00fc9DRmfxZIPmlVyydc1e4BBoG4O48YcT179VACSE27dd7m-2jIhPkY6rwKrya2vIXlnjPsC_L1rQO3KDNXgsX2bxmdq9pMafvlATnz8pKqPVk_XCqStitmalSx5YUv-FQPOxV-gE04J6c1wahzIPpn1ZihIa8XE_h6LZyTeUX7kCoN1VxmMjwFHiOXWabzpEx4n2-WHa0AWRKmkub0OKAkxXdldKuCXHyHQNtXyg3VlzM-QOTGkVtdoZ3UpyW4qp_c4hcHFOVpGl4CUHU-iwbNKLVcSZDGjYTHjJCcAU-IDeq0cAv9opO5sC5PlLhfC8g_Dbxv7KJvH6XbyyB3uCle4K8Fsy-r1-NVPAvQ6T9B3zJK00sOX_8b7iHPEysr6T1c2oOBXG6zDSSP2HgTjBWOj4BCZ_sx1ql7Ww8jkQ3MQjNw2P5f1jZRssD_L53m07ny1Vnn_qARAe2Ju2PnTl4bNht8mQdIlOwwV6kOQlGe_PPMYev2W5d0gZLCBJ-qu_F5KTMmCz4v0PQF-FRknPPGyDX5mHhJyeWYy7ajE2oYNkFkgNrk-ZQtJKboYkNe3TDi6rw4a2a5G11oo1YaoVH87Xz9ddGF_8lmYTWxj38s1zDTxSMeR7ZdSuGmRuUpdy_DBVysqPIQECN7bj1fBaZt2shGipjh4dI_JMzVy_6mmHbH-WyxEcP-UabugkHjKpsH0VhoHmTmaN3acs0_GLlXeUDQBfXk3mJfZj2a8376nl7cD5Fb26Eiw93W_nx85by9cqO1AMH6W8cSnLOxljJe8Nk2shdCqmrk6hpdierAMtqBcaeEZRye9IrBK9vgfQWXRAhgeTPxX7cSo0pxLi5Qwx46ev7jm6GDWkYbtV16ThnYb9jm_BlkL718OlRS3YgYaFVPmZXL3sRvNss4y1Uwi74OqwstjQlw4oUQv2qhsQZ1t00daiGd0wYj9GvhT-HL51koZzZnWbvyXdWCLgmzgiX3h9iR_ditntBwxuLHiESpX0GQeNxCFZ1_rl5wDXlNOfJcF7ETXzhzZZ0ODi75s_vri45moxPqeqlT9jcU4OG_6ZvCRwdRKziR1-T-6LdHQQZ0BYkBpSpQYN78sbL4lmCLqu6LaN5EbgxpAaCQjWmRZVO4Dza3NO7IQqUeDPihqwugphrq7uIQfrLAlcvUhFDj-HDaRj9OVfy6ba_UhG51B-btmruPBqukp13O2m6Wppy2lbo0lxhMYwWDzLg8RMXCED6iaPt7FRgN1IG6GkdJelLOSNk8REI2udJiR64kAQ52AVST5w6Sv98_S6y5-RNJO4OVJ5hQ-jCQLNEj_q7zK5mm9WRzIDY_2fD_FgX6CP40P_mSWm8ola98djaDQMzr_Wkh3clwyL0xD2IMiy4shjGTNraasze_IR-7oA1iOx_qfNFlSj2WX1KhH2d2YnA9xRoVldkNMbNPwN4rXGujqxA3861M1FbKOmsl2SXmDpCqymkCjuVF49FUY7YYn1ON78L3Ov-19vW6GovXnIJaSHsBxvO4m2njEDvVfs6t_wrrjbSDUgtRfrqYvWliNztuz8HKbAPRgGCQN43Ey2Gvc-vcTVZZ2c0a6DVAZuOMj0PPqlGXSxSwQs_d2ctkw3-OaEBakEywy62Y4QUjdV7NDJD-lHIQ19yahUvZ8bmMnaZxP4LZBUhwGBi2n3Cd4OPRZUC5fCbp5jAiW-mo3mJJmxMAyaA7ZbK68zq1tekbDiW6FesYtYlULj4k8xgxAwVna7BADPiaLT1cnQnjFFn4hOVTMVfG4PW5UsK3LFC5Jb0ab-_oUNnUdLOuqW3N8T2kA3o4FqNxFp7xM4cHuf-Mx82bLy0EdgxridObVJeVfBScMcrS-bu0tePGQcq1lUn2eDboZ3EQkWg-gJSzxiiqxBLCLl7kRr5YG7Oa7yPPkifQb9810ymulFRKT6Z666d_3yRQw')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '1991', `Language` = 'bg', `PostDate` = '2023-04-26 12:11:15', `LastUpdate` = '2023-04-26 12:11:15', `Type` = '1', `Data` = 'TKGuxzFIwZsmkl2wj_sp1AhyJ4f-laWCBfnIvGpx3URSV4LTpy_6GxioJMMRHs_CUps9W_RiVvKoDXX26YiSX_7R8he3uhvB4sXN13ERkC8Ik5WGdELN4aD6n_xaT9R-6vqhXe2pM1tpVy6206rUpFKq9F9puYkrA61dZMWno_il9e2dJZJk-eXuI6J1mj3Bqse4ZzL48dmU3GouqLVd5YWCngHzOqvr55inzsZ7hFdLceN8aktefHkEkI31jpLlnsJBaWsrbdNmp9Fxs7GADvW7MSZNTuIqQ1Ze7iJLWHxW9XBJdeiyzcBvjTKrUd2GxDTDoggS_5tKxbY96CnvoiSHHsgAVf0DqfC-0-EiLolIYU0LRi2DGDXGg24Qi08Wh49aYS5T_SIFxtOxCM1bnBNpgI9jB3wKsSoXSzHi8fWOh5UtOJyvYOKVH5ytrpkyjJ3cHXW2xQoUx9FrBUuvEe6ZiCM2xkRMJ2dzDpFdSC3PAQB_7vNX_-j5rc-KJvEYnkJ0a_DeiPlW1abPu3Pp3hPSB8Sa-ScgiahwN3-vD4DAbwlRAPvcEVNLSE7KloiDDheduvJgZ_GZTeHJk_4yOWSx42dQmkojaPQ85drjITYGoL2jmiDIoJg50TCeIpGx_rSVW0rmYwpSiZAiTlIzolXWp2VDQldVWgIodt_bdbqnL3ge1131yD74gy9QoFkzoGx7-YJd2uqkjqRt_oUxkjgpisnMPuj2uzzLb_7vEsw2FzINaTvdTU40ASE0heI3-PVVffe3EBwUZMT0SY04a4e_XkZGRnwb26wGd98Olnj4UlfSye7p7J2_Zd_4ZDld9Uq0nR_pmyEi9n8K2uQXKZzv1qXhx7GCnCxZHRaTvwU9miUBUtafBdoi6qgjn6-3QkCJolDIQ2SkHyWqISc74LUia_MPOjHrBM-O6kl59-rwsyLxxn2btIWA2iHYAKwyXpK7SQJpdwy2lT4v6civKVTaRcPDAGI6dFBnBGl62p7lEtfwjeIm54KYwkJDqveUeVufMnw0TL0RVutFiMDnTG1WYQUYgngJpF8_rA72NP8phAglZhoQEKYj3UVHTzOpDjGjv82iVYgWToqtp7YuEItBbiiN1hh71BgqKvb3tNL8bNKTQ51b9IWhp1ek46Qgh9L5Q5Ged8FoSwiTgg3yWViFqzVHjLx5VN2ET6uQU1862IECL7LSGfG_NIqf5wyCGDD2jGNAx0QnE8Qzdg_fzgeE1Jcxl5YYwAE7KDyDNTOLQDFPxZZ90Ked3C1e5zvq', `SearchKey` = 'wofCpMOewrDg8OgwrPCtcKDwqTDgMKrw5jCucKdwwofCpMOqwrDgsK6wqCq8KDwqTCsMKrw5vDj8KdwpzChMKhwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw' WHERE `ID` = '1991'
# [26-Apr-2023 12:11:15] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [26-Apr-2023 12:11:17] /finance/root/bg/invoices/1991.html 167.99.142.201

set names utf8

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

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