# [19-Jun-2023 11:08:00] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [19-Jun-2023 11:08:06] /finance/root/bg/invoices.html?from=&to=&keyword=sof 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `SearchKey` LIKE '%wrrCisKpw%' ORDER BY `ID` DESC
# [19-Jun-2023 11:08:10] /finance/root/bg/invoices.html?from=&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [19-Jun-2023 11:08:31] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [19-Jun-2023 11:08:57] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [19-Jun-2023 11:09:42] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [19-Jun-2023 11:09:46] /finance/root/bg/invoices.html?from=&to=&keyword=София 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `SearchKey` LIKE '%wofCscK4wrDg8OgwrPCucKDwqTDlsKsw4D%' ORDER BY `ID` DESC
# [19-Jun-2023 11:09:54] /finance/root/bg/invoices/1980.html 167.99.142.201

set names utf8

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

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