# [09-Oct-2024 06:36:35] /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
# [09-Oct-2024 06:36:50] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT
                    `Inv`.*,
                    `Original`.`ID` AS `OriginalID`
                FROM
                    `invoices` AS `Inv`
                    LEFT JOIN `invoices` AS `Original` ON `Inv`.`ID` = `Original`.`ParentID`
                WHERE
                    `Inv`.`Type` = 0
             ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [09-Oct-2024 06:36:58] /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
# [09-Oct-2024 06:37:05] /finance/root/bg/invoices.html?from=01.10.2024&to=09.10.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-10-01 00:00:00' AND '2024-10-09 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [09-Oct-2024 06:37:07] /finance/root/bg/invoices.html?from=01.10.2024&to=09.10.2024&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-10-01 00:00:00' AND '2024-10-09 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
