# [27-Apr-2023 12:04:42] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

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

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [27-Apr-2023 12:06:43] /finance/root/bg/ajax/clients/form.html?_=1682586409171 167.99.142.201
# [27-Apr-2023 12:51:48] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [27-Apr-2023 12:54:08] /finance/root/bg/ajax/clients/form.html?_=1682589254640 167.99.142.201
# [27-Apr-2023 12:57:08] /finance/root/bg/ajax/clients/insert.html?_=1682589434200 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` = '27', `Language` = 'bg', `LastUpdate` = '2023-04-27 12:57:08', `Data` = 'bigZ69pVl6F7v61o0LGloFNEmTw9mIczKw-7a-LXsCqj65OPrm6AeTOHnpO9xyUgvho3lz53pebHu-NF1P2lOYupWFa3HVWlXaK4SL6NdyhfxZahjuiHkZ8OOis6pQE_Rx6pm9ocQVhwBO6n0-LLP01kM8zuvPeKUH0vqrNMDe9mqGG4Lrh5Vo5w1DKyPxQ0n_jMCe0RQBzzxkNfRagGPm5qcx4ln_sIOmCbVqR9Sym5O4wE4A5893x7Onf0zF7jvNUGH_vDcFQ33TK3wj00j-Z977alt9Z3MU_QvH85hKEjeT5oA18NnY_gHKCtCO_kprby5upCtef7wl4DTMP7PhOHhzKocoL2DCuZV7WrFqOWZJIC5NeGE6iauWJPfGfFKsJhTi98aI3Tx_PuiyIlrkRZ9j0uPyMWbHEl4I2lz1k', `SearchKey` = 'wofCpMOWwrDgMK6wrPCusKDwqTCsMKsw4zCucKdwqPChMKhwqrCvMOUw6TCiMwofCpMOIwrDg8OgwqCocKDwqTCwofCpMK8wrDgsK6wqCocKDwqTDosKrw5nDj8KhwrLChMKhwwofCpMOiwrDgMK6wrPCtcKDwqTCsMKrw5jDn8KdwqDChMKhw4jCvMOXw6TCiMOMwp3DgMwqTDgsKxwqDCnMKwwr3CpcKiwqzDk8', `Top` = 0, `Visible` = 1, `PostDate` = '2023-04-27 12:57:08'
# [27-Apr-2023 12:57:08] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [27-Apr-2023 12:57:11] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [27-Apr-2023 12:57:13] /finance/root/bg/ajax/invoices/form.html?_=1682589439031 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
# [27-Apr-2023 12:57:16] /finance/root/bg/ajax/clients/select/type_0.html?keyword=зах&_=1682589442440 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCpMOWwrDgMK6wrPC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCpMOWwrDgMK6wrPC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [27-Apr-2023 12:57:47] /finance/root/bg/ajax/invoices/insert.html?_=1682589473238 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 27 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` = '10362', `Language` = 'bg', `PostDate` = '2023-04-27 12:57:47', `LastUpdate` = '2023-04-27 12:57:47', `Type` = '0', `Data` = '72ZGzixB5Chsw7oFcoR83EnpZQOy7dCIbKOXuSz8mViv9uoW81HK27x1X2oLo93O2_mu42_2y0cwAzmMaEPimL49MQ7vWNm1tfZnha9koghHxHg9l9mguV4e2xWK8HsU5YGJM7_NttFQlAOzsDHUXjngQOGv1by_KIR8hmvC1xYsNUYaOQG-6l-HNlqhCeUEkRSZT0XRQPgk0mxICxevPcFiy1FE28M9SE67bqn_ZK5td42ueBFe76eqxLkFu2HIkgF0Yf4dcOq0Ul0AqPKC4q1tPYjbXFDLdFV3-cP3Doskh3dDDiCF7QumrkfXuE22U42j5TaFKGmfXgHm-LaOmELb4AeZlTZtYqoqK-uGLAK9D9xrWNa7X7ieZ2kcdASmclSVB7fBreBUX0QAFxGyV78W-HJE-ZpMZnxEsIj_BoVU_wlEUPKaYjsCOCZAmkqN6Sul8_T4hLDpRsq8MW7_rjukwryc7loqFPLfpp8NIYyTRYZ09m6_Hul-1_t-p56clDSw7gNwC3dmDeFQzTTgA-iLkWwR6JmfsVqNe65n0GODaafpr9bJYqcGXKclZevGIbWFM2cSbJtWv40storwGqVfYNP8kVWo8CnPUNYypF1zPgtoGk0hltDmaZTvlI-D-C9--X2Uj3J656Y36t2BqjUepQ4t7uNb2qbOJ6KWuwzj2R2ON-u5LDYCwfXgWZ9wM4e0kwRKsq8SB2KXf5Gejw82hqD0qL1ZIbcsWyspyVbJtgTdUJiy26ATGfmybTfO2GwMt81jlpqhOdqFiSM4WmFuxd-eVLAg_3tXCg2yCBrbXDAwSPfhl56Wn-iVC-1OEUq6RJEMJAd7bVORWVE_hLMDfY9LxAHa7tDecTJMu4tsoXiS_BDfgy9kv5RCH6HCnp6F8h6ug3f1qyDzuP06Hol-kF56gcajXFcNYcbTbzlSYBqdjMyWf_2YyXOpvvDmJ3HDyg4qiBSx0mAJ05yOmI99QCcrSZb84KyF89Ll7IzlDePM7at6QSbE-dpIqLz2', `SearchKey` = 'wofCpMOWwrDgMK6wrPCusKDwqTCsMKsw4zCucKdwqPChMKhwqrCvMOUw6TCiMwofCpMOIwrDg8OgwqCocKDwqTCwofCpMOawrDgcKlwrPCtcKDwqTCsMKrw5jDj8KdwpzChMKuwp7CvMOWw6TCiMwofCpMKjwrDgMwofCpMK0wrDg8OQwqCqMKDwqTDpsKrw5rCucKhwrDChMKhwpbCvMOXwwofCpMK4wrDgMK6wqCrcKDwqTDhMKsw4zC'
# [27-Apr-2023 12:57:47] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [27-Apr-2023 12:57:49] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [27-Apr-2023 12:57:51] /finance/root/bg/invoices/10362.html 167.99.142.201

set names utf8

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

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

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [27-Apr-2023 14:14:38] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [27-Apr-2023 14:14:42] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [27-Apr-2023 14:14:47] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
