# [25-May-2023 10:31:51] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [25-May-2023 10:32:07] /finance/root/bg/ajax/invoices/form/clone/1989.html?pid=1989&_=1684999928832 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 1989
            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
# [25-May-2023 10:32:49] /finance/root/bg/ajax/invoices/insert.html?_=1684999971547 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 9 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` = '2007', `Language` = 'bg', `PostDate` = '2023-05-25 10:32:49', `LastUpdate` = '2023-05-25 10:32:49', `Type` = '1', `Data` = 'NzGaZCN-hnCj6fC8p_yVcVSP-Q5HWZW4mJi8wCS4pArOytaSEDlBfq-vIEi2NwMFFGgSqH-azf0Ik7DvFt9g5bIbPZgZQ_r5Ie7ZMER1Teq3894O3Q9W7jU4RZk8f-bA_IVvvXg58rTY81k93v-vsKQAhno3_waEl5y8Mnib5FUGtnHUmMpEBKP-WNlgu9wqMXhG3JTJFbf2BLn28fCrjxEFqI6YZ6khXRLvpgTLfwpOPnzZjp2iKms17I9LWZaFeEidwsZBoOiflC1MkCB-4I0OS0T0qy_zutXME3Alx7kIxxSqaIvawMqEwchXE1R-_TWOvIpSjAofBFTg_jgnFzDmjgShGSACK0HZJZsDd_hlpXOc0ssPZADsnxpkQ6B98gtIeKERIN31QzAh590DSGeJqYJm2uQ80h8CZnpPx_hvJXdsImi-AVIvhSThgeQAYuchTM6hwxVrFn1z8Drhy-MHTdQr77UutWso7l6trm_FD-eyZgmdubYSO4ioTyDQ_XeGY0i62HVLO28mnMEVqdiPSus845O_gIg5MkytoGwce4sXOqDS55sEAGHOwSEeslf0owx1wTB51-LxnkWBy0CvqGlMGQGaniGuhsMFrVlldeye4HWCAob2eCLSuMLsxYC88qFRnB69WJPpIt2DfCQa88omAp0c2dicJE109bLq0Ny671uxagUNX8Ev8MeKuLK32Am4OcQt39FdtEan6uapjJgpOOwRATX9xkzoFDJkZZ8p7Fl_Fma7tB8CLPij2DIjMmKVGnRuOc2oTo19CHnSopG_nolvwp1JV8U8mjV6gXt5XoSFvaMq_zTH9G2L6ZrHI_ylRMPqsImD8wlNk8n7qxT4qiC8e90IyfK4Ik72RNuAA3qIzUPpoLX6cMR-Go-cH2blnUsJtw-iRnQ0a80n2b5hrB7_LGUqMDA19aGh2xg5g9l-VPQFl32KTh4cc_ocaUwUllVWoqRmf1H1DAlGBjU-rzZaZMwZbh9gRhlaSAUE_-6lMiMopo996c56a105_gZ7eYhODOWDPdaEbfi0vUJAlmXwP-AfPpo0ypEnyGTyt3Q6FlSC3v7WdiCOjGR9M0wJMd7CnqsbBhXA6wTDzhSH2EDZNxCuK5NyUVe1xXtecci-jKAtWHh-0HpbVODviEbEXU4MeOqBDPVJuunVCYKviXc-uiE5xNyj4oS4cPkkFET4TQ7Y2O_8VrUEwe8BfRjDf0yr4clI-rdem3zJWGwqwbAtS7z-hCs1nLwPuR8C1vG-016lyEhBD8CaLECKGVoGqqWzXMuzLqUCjlqINoDgN-QN2kTUdSeN1esMsCnXXo7F23Rfw23PG32qnD7ccQ17a2NmZfXFRED-3yI-70FkdAfaBiYLxfVPfRltXLPrUqliuloTFQWmbKWnf9lcWIVbxUF8KGuR3sYXFt5A0ct_Gjk_8-86_QbcC2jjo7keaMW5zbNpu_2kPlB54cvcpVoIos5D-FYmv2zezk0uJln1eNlqhuRW8H7BGdmx_-2_naX5IoRS9sX48Wona_M6iIew_wsv62vsVcTVETXOWFk6nFQUlJ4u7QUmni5kD3u-JM_ygREi8e0xNlWn2mu4lerBih9rl_C2MH2VK7bDVEil9WDtzeT-HitHVFhg0VpFwkcbTopCH_JTCxRBVrU2UCP8qhYiWqF3exiveOj66U4hHQwLUp3MmfZ4pS4VAC6B2wW58YiFnGgIBXs74K4sAcLdhcIz-Vj-SS2MMGCbbRroPiWmZBZOZkO3ETuQfamFvdTOS6wesccXb_oZKEKU7h3Lx9cTQOnCfHmPHQ', `SearchKey` = 'wofCpMK4wrDgsKlwqDrcKDwqTCwofCpMKnwrDg8OgwqCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw5jCucKdwqjChMKhwrzCvcOLwwrrCisOGw6PCsMKewwr'
# [25-May-2023 10:32:50] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [25-May-2023 10:32:54] /finance/root/bg/ajax/invoices/form/clone/1991.html?pid=1991&_=1684999976238 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
# [25-May-2023 10:33:06] /finance/root/bg/ajax/invoices/insert.html?_=1684999988481 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` = '2008', `Language` = 'bg', `PostDate` = '2023-05-25 10:33:06', `LastUpdate` = '2023-05-25 10:33:06', `Type` = '1', `Data` = 'iq7AqJfJMpRJGY_bqiMGMB6O6cOIU_h8usd5cTWi1L3pQxaHbcbSUNEGvQEMcGKI6DQ8QnqS3uSnAEcxcbI4XVgGPar9qNNLcSi1f8qBP5VkONs4YV3QhOEuvGwleIn4XGO8NXLJ0dqJFVXSJiMXcit5CHq5GlULri17xAgBpgBoNb6awfvTtk1qFG40EGPpLxIjVov-TNsObikLxkzAmyjSQEL9xhDGvwhUGCnmWWxNC8ZV68QrMcgwm2atIilMfKi8W9F8heaZgUPEvRSe08QnPqUqrjV9bK76PXpcxpE0DL6OkwpNZN7cFLtUdCSYiO2qkagzRZc2msfkl5NDkdS904UPZns0EyFLS4UCAPpwQgIj7jlkd9Se0a3bC0PYsSXAHfRaBwEhNU_Zvh6WDCgsZbILgePtKjYQZRD3UmgSQKz9HnqE1VTB7KcG4qcD_NdH7qG1BzW0EID0ep0pJFn1hySFa8roL1sQKp8PlX-K-g4wsy4N7EquL1QgaVx0xrhI-qczjq-mOe185FyOB8DdxULmOzboRvVBl86l5wWgfRiUYvDJyktt23EcJrAXOH85aLpkwmxHSjCCgD4h6jHN8rFmXmIOXAc03tHo9VLk05PrFGNVbkIY0SGVd3kMEDYeB0iYiYHtF1yd4psS89TbD6VHBHrMBkcyaW6HddPsQy3FqCW1uGF9F0Cg7GsyF61Ldpl6wt6RqSTJat-gXXQ0EiN2N-qoghFKtjFOdCbUNNPAAL929L1MBX63emvb9AET3LHlWFnOOOqj3zHlTUZizOARfjnvvBHvIoO3vKwPYh2U7BdRyIedz9D2K1hvfdVn-CZNeUUvH5hudd4rw2V4Apb5ZqDAa75b59W7Xztb-xG3Jrf1XBIfZ1LANR2gIUG2yM3c8jUeoZJxmXv_0fE1RgVXLA_bKZ7bpESUAXqXhU6-A9xCE6_ZfqexH_FUgpcz0kLNm-1L4mifYyZ9Za5kefr_h062zEGDET2uxJXnN_tXq34QYNK9bNgQ2ACIDIqW72ZN7lLK3PDp0ysgyUEO4dxzBGwVhzT0terHgCGqitF-RKi08YOzaVxkqW1VDsvEqXsL47-GpknPJu3CLw8qrbJu9JmaOBBHsk4qYbI5_a4VaacoCCkKCec2x_bZ85AEIG1c1PbtsRu3aRhQ03rplw8roeYeRARe9O2WeHYMXTvrHTSlntPDeCfoS8P417E_b7v5XWiTMRhBmPIjgj1QABN24GUO1jAOjeOY85yI7vf1gtiJr95LeFNzDLPc', `SearchKey` = 'wofCpMOewrDg8OgwrPCtcKDwqTDgMKrw5jCucKdwwofCpMOqwrDgsK6wqCq8KDwqTCsMKrw5vDj8KdwpzChMKhwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw'
# [25-May-2023 10:33:07] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [25-May-2023 10:33:12] /finance/root/bg/invoices/2007.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [25-May-2023 10:33:21] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [25-May-2023 10:33:33] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [25-May-2023 10:33:37] /finance/root/bg/invoices/2008.html 167.99.142.201

set names utf8

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

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

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [25-May-2023 10:34:20] /finance/root/bg/invoices/2007.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [25-May-2023 10:35:01] /finance/root/bg/invoices/2008.html 167.99.142.201

set names utf8

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

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