# [23-Mar-2023 20:01:36] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` ASC
# [23-Mar-2023 20:03:29] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [23-Mar-2023 20:03:33] /finance/root/bg/ajax/clients/form.html?_=1679594621224 167.99.142.201
# [23-Mar-2023 20:05:27] /finance/root/bg/ajax/clients/insert.html?_=1679594734785 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` = '22', `Language` = 'bg', `LastUpdate` = '2023-03-23 20:05:27', `Data` = '2BaUMKqJzH-SX40RaMPWLOyV9rtI_qMxDyIOvHlUot9rx8R7A4wDBCi6qK5GhTdOAPibD5mT1Nnq_Vuo14LwB4v-8FnWg8wiI1oOaT9IfTnbyCHYHAEZy98bMdEyyuCCHUudkosz7gXU4SK4ac0s322heqmRMwz16YzYPBVZL39h29yyFacHrlw-j58wsNz-aV6vIYo5d6m8m8gUjeRP-vy938lWJkf9Nb67LIWFDCfO2biT8lBBHVdvTqGvqu1eapD-u_0oDaWzM9tNETRasTgu05JNeWe9pqK39lvvMKcTxYu8DU05xMbLbuMN1ARzYvH4X35D6nyOE-Yx28vdAl1GhFew8OigK9zy0gwpOVc', `SearchKey` = 'wofCpMOewrDg8OgwrPCtcKDwqTDgMKrw5jCucKdwwofCpMOqwrDgsK6wqCq8KDwqTCsMKrw5vDj8KdwpzChMKhwwofCpMOewrDg8OgwrPCtcKDwqTDgMKrw5jCucKdwwofCpMOqwrDgsK6wqCq8KDwqTCsMKrw5vDj8KdwpzChMKhwwqTCnMKxw6XCmsKwwq3Dq8KgwpzCrcORwrLC', `Top` = 0, `Visible` = 1, `PostDate` = '2023-03-23 20:05:27'
# [23-Mar-2023 20:05:27] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [23-Mar-2023 20:05:32] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` ASC
# [23-Mar-2023 20:05:36] /finance/root/bg/ajax/invoices/form.html?_=1679594743555 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
# [23-Mar-2023 20:05:49] /finance/root/bg/ajax/clients/select/type_0.html?keyword=йор&_=1679594757400 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCpMOewrDg8OgwrPC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCpMOewrDg8OgwrPC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [23-Mar-2023 20:08:23] /finance/root/bg/ajax/invoices/insert.html?_=1679594910388 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` = '10358', `Language` = 'bg', `PostDate` = '2023-03-23 20:08:23', `LastUpdate` = '2023-03-23 20:08:23', `Type` = '0', `Data` = '1MXlq8GgiSNPpPWij6VJRe_t6wWAb9XTbJKHB_k4OEDbC0QtPq8edwvr5CER0l26n4WSP51H1G91l6Zj-UWXqjwjjGSg6xVvjoEN08CG5XTzObs4IFGca0ggAJ3UgYbOqxjvUeNoQ4uXmkR2epovwwzRwS1zvLnPMpz6kZZoMtPn-Zxm4OA4jHRs6j-LB7U8hE9dj_El-znSIE5fBJH4puGSzolKNh_zJykb5EEcucvUVDagbC5_RQGk39YcVN8uRV8o1yDN5SrfzzDimDdgrddZHR06FHsoqVJAJuSDDhPab7XJMwkJ3AJtPQ3bL9AQFTuLmSrme1Pp-AXGd_sgJP--49_0bm6JNJl4jdyz8S_-2miltPYYruUlFyjh73NhQfMGBLL-V7jvqSbEEDbQM1ZLttvU36JpwDHL_86syvwQdwpqDKy7vf4kqe_5VJd-LEy_RyERoxOOwR1fhxZo92Hn1U6gs-LHHcMIoQ0D5hswdZYSprRxMgw4BrN7486UhETXZ6B4GJMwybKBjT9CH12BbuYVWPvTLPbfLH_E2r-So-lvqe2BFcNnIkor71coSxnKO3k6TwK-RQ3HLOMT6tYwnDrE21-lvUAZcS-TbO1_4gKA-E3SoHaXPNkCBirI_M3duPbt6LZWgKXi9zeez9n7NZvALwoI_kASauuNjGUl3wQAinRkiGYQpDKZa7pF9dGXptkaHUzC0SBrO_Q3Vf0AANneWd0XJGVrbN6GRAnGRNdY2yO-igbV1M4z3e0WyD-ocM2YdafF-0S7XhDdwyjRf5zfOsJ5_fnVsSgUXCqvJmRWtL-7CI6XPDW2tmGkl8zZvLm_W_8Ea05UKs_Ka00DFI5jqhDZ0aZ2aYiypgkvnKixnFSHQEx9T3LuTFVRS6iavDCOkj8TEDk8pa_B2rIBL1Fs3Y3ECJjOA3Kp7zi0J1OG69m95_6NsCCdDn5QSwpArK_kvVX9IPW1s5FVlOqcR6s7MohFeY96AusHA2YEkgRZw2Zjs9iOcN9wlcuepSnwcydWof_xHxSZzbQtpK2864NFr4GJE8QEsXbIyoxYZP28FX8grIhWWurd92I3uq-6dUKYs0epJQLRkl24AKEbufmfW6df9a8fjAUQR6HvWJkMb_14SV6se1-18sX1zLkMGHJbeKYn4YucmEzhJfwTfa3h0LHqZwvcaeCBBsZ7SdSBcN0qkjXTSkAmhNhHTShuH0tVOSDOH3n1Q9UnnG4lUNDCATcj19ryjO3EV_17KrvuhiBvJEKFJZ-d3Y3O', `SearchKey` = 'wofCpMOewrDg8OgwrPCtcKDwqTDgMKrw5jCucKdwwofCpMOqwrDgsK6wqCq8KDwqTCsMKrw5vDj8KdwpzChMKhwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw'
# [23-Mar-2023 20:08:23] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` ASC
# [23-Mar-2023 20:09:29] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` ASC
# [23-Mar-2023 20:09:39] /finance/root/bg/invoices/10358.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [23-Mar-2023 20:10:03] /finance/root/bg/invoices/10358.html 167.99.142.201

set names utf8

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

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