# [26-Mar-2023 13:49:11] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` ASC
# [26-Mar-2023 13:49:19] /finance/root/bg/invoices.html?sort=01 167.99.142.201

set names utf8

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

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` ASC
# [26-Mar-2023 13:49:37] /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
