# [07-Mar-2024 12:49:40] /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
# [07-Mar-2024 12:49:48] /finance/root/bg/invoices.html?from=01.03.2024&to=01.03.2024&keyword= 167.99.142.201

set names utf8

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