# [16-Oct-2023 16:01:19] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [16-Oct-2023 16:01:24] /finance/root/bg/invoices.html?from=&to=&keyword=rapsody 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrDhcK2w6XCsMKewqXDn8K4w%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [16-Oct-2023 16:01:29] /finance/root/bg/invoices.html?from=&to=&keyword=rap 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrDhcK2w%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [16-Oct-2023 16:01:33] /finance/root/bg/invoices.html?from=&to=&keyword=rapsody 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrDhcK2w6XCsMKewqXDn8K4w%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [16-Oct-2023 16:04:29] /finance/root/bg/invoices.html?from=01.06.2023&to=30.06.2023&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [16-Oct-2023 16:04:43] /finance/root/bg/invoices.html?from=01.06.2023&to=30.06.2023&keyword=rapsody 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrDhcK2w6XCsMKewqXDn8K4w%' AND `Inv`.`PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [16-Oct-2023 16:04:49] /finance/root/bg/invoices.html?from=01.06.2023&to=30.06.2023&keyword=Рапсодъ 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wofCscK0wrDgMK6wqDk8KDwrHCtMKrw5vDn8KdwpChMKuw%' AND `Inv`.`PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [16-Oct-2023 16:04:51] /finance/root/bg/invoices.html?from=01.06.2023&to=30.06.2023&keyword=Рапсод 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wofCscK0wrDgMK6wqDk8KDwrHCtMKrw5vDn8Kdw%' AND `Inv`.`PostDate` BETWEEN '2023-06-01 00:00:00' AND '2023-06-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [16-Oct-2023 16:05:01] /finance/root/bg/invoices/2032.html 167.99.142.201

set names utf8

SELECT
                `Inv`.*,
                `Original`.`PostDate` AS `OriginalPostDate`
            FROM
                `invoices` AS `Inv`
                LEFT JOIN `invoices` AS `Original` ON `Inv`.`ParentID` = `Original`.`ID`
            WHERE
                `Inv`.`ID` = 2032
            LIMIT 1

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