# [02-Jul-2023 10:06:39] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `PostDate` DESC, `ID` DESC
# [02-Jul-2023 10:08:24] /finance/root/bg/invoices/2022.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Jul-2023 10:15:37] /finance/root/bg/invoices.html?from=01.06.2023&to=30.06.2023&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-30 23:59:59'  ORDER BY `PostDate` DESC, `ID` DESC
# [02-Jul-2023 15:13:35] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `PostDate` DESC, `ID` DESC
# [02-Jul-2023 15:13:44] /finance/root/bg/invoices.html?from=01.06.2023&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` >= '2023-06-01 00:00:00'  ORDER BY `PostDate` DESC, `ID` DESC
# [02-Jul-2023 15:13:50] /finance/root/bg/ajax/invoices/form/clone/2009.html?pid=2009&_=1688300029283 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2009
            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
# [02-Jul-2023 15:14:04] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `PostDate` DESC, `ID` DESC
# [02-Jul-2023 15:16:05] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `PostDate` DESC, `ID` DESC
# [02-Jul-2023 15:21:22] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `PostDate` DESC, `ID` DESC
# [02-Jul-2023 15:22:20] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `PostDate` DESC, `ID` DESC
# [02-Jul-2023 15:22:28] /finance/root/bg/invoices.html?from=01.06.2023&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` >= '2023-06-01 00:00:00'  ORDER BY `PostDate` DESC, `ID` DESC
# [02-Jul-2023 15:22:57] /finance/root/bg/invoices.html?from=01.06.2023&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` >= '2023-06-01 00:00:00'  ORDER BY `PostDate` DESC, `ID` DESC
# [02-Jul-2023 15:23:10] /finance/root/bg/invoices.html?from=01.06.2023&to=30.06.2023&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-30 23:59:59'  ORDER BY `PostDate` DESC, `ID` DESC
# [02-Jul-2023 15:23:16] /finance/root/bg/ajax/invoices/form/clone/2009.html?pid=2009&_=1688300595164 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2009
            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
# [02-Jul-2023 16:09:35] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `PostDate` DESC, `ID` DESC
# [02-Jul-2023 16:09:50] /finance/root/bg/invoices/2017.html 167.99.142.201

set names utf8

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

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