# [25-Apr-2023 14:54:38] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

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

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [25-Apr-2023 14:54:47] /finance/root/bg/ajax/invoices/form/clone/10359.html?pid=10359&_=1682423690802 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10359
            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-Apr-2023 14:55:02] /finance/root/bg/ajax/invoices/insert.html?_=1682423705002 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 25 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` = '1990', `Language` = 'bg', `PostDate` = '2023-04-25 14:55:02', `LastUpdate` = '2023-04-25 14:55:02', `Type` = '1', `Data` = '7s1Vy97zNsxLgMWOEI8WDbtFZBE5kv96F_UViUbgKIhYX6Git9q4rbt29kVwRY9e0cZ1b8YvecMdJ1vjgHspu5LwvjRKoLkqjIy2fPQgwBzrO-ifm5ptw66NRF0X02S83KYnfBUUMYVWHL-uZGl7PoJA1-7Nih8Fv7N-NYONdfDxrDmTU6_I-8dwlc_CWCa3M9fe1x16nWNW-79_OlUi72wPs8a1TgK69E5uxiOAUUYPgvo5KMzSLrRufYxZi9TdA9JsKu5qvg7tey95wgWeUYq4glRlylt2GVSqc9zPEQs_yyTQY6GVWIxFbEEQYmqtTlvTzRvHFLNoJ8XTXBb8AfmweMGeUblnex82J7AoM_4iSnoOBUndt41BA20g-Vh-nE3ZQ9xvRSLlZkwQKwyjcxlahxFYb-zOpOwRfpg1KBIJoUax79mrt6jMZ6POzwMujeXNjPkSWUSWycnGxWcUrYqGET4lYQ5lAghslp3cbSSc5zYmtv6ln8iJci9E_bTq_9Dq1CyTj5lj8qTmgX62VjUuAJzxOx9EU8b8PNDgTmhGSWuISC9OKv08vKM4KyILlouinn5xkKl8j-dAR4Cuu0VqwnYJy7PBggbLr3LmkKebq5fzrTwU46wDOnKHVZaaEronf4uYRX6K-ycs3v1s6Kv_cwDMEZ8o7zgzs3Q8pVlcMymlS_FPzaaSomivVkrVW18MZAfLaOpDYeV9s_yFPIOXQsRGG6dzFgncDx6P7nM6ow5hoyUDBVTpbsWWXKcE5LdmdlCOdUz7woufMT6ocmoUdgW4OdK63gnWztysWZSIiN3CQkZJEXA4E4KH_niLJaAHuXGVl01AlQHoNAKBVVkdN_KzayqZGOriFQeL3bQctR9M_IKQv7PZpMIPxny0gCMbLeiUY9juVHoVar-eD8YHJEqxYeDgR68sncqgns9d0H_v-1SEwHjIlUn8XbAf3ylCLaI6FlANQ4FZAy0ynlXpc4ZWVDUBgBWZoLeYeg8SEGY2a7gLKKUoLotsnGZSXCZLuIkwYIms7zIQRjpI-BKg9RWpUWEFyquS-daE2js', `SearchKey` = 'wofCpMOPwrDgcOQwrPCwofCscK4w4DCtMOgwqDq8KDwqTDwofCpMKnwrDg8OgwqCwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rDj8KdwwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCu'
# [25-Apr-2023 14:55:02] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

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

set names utf8

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

set names utf8

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

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