# [29-Jul-2025 09:34:00] /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
# [29-Jul-2025 09:34:23] /finance/root/bg/invoices.html?from=01.06.2024&to=30.06.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-06-01 00:00:00' AND '2024-06-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [29-Jul-2025 09:34:28] /finance/root/bg/invoices/2266.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` = 2266
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [29-Jul-2025 09:34:33] /finance/root/bg/ajax/invoices/form/clone/2266.html?pid=2266&_=1753770873347 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2266
            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
# [29-Jul-2025 09:34:43] /finance/root/bg/ajax/invoices/insert.html?_=1753770883530 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 31 AND
                `Visible` = 1
            LIMIT 1

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1 AND
                `Visible` = 1
            LIMIT 1

SELECT MAX(`ID`) + 1 FROM `invoices` WHERE `Type` > 0 AND `ID` < 1000000000

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '2515', `Language` = 'bg', `PostDate` = '2025-07-29', `LastUpdate` = '2025-07-29 09:34:43', `Type` = '1', `ParentID` = 10406, `Data` = 'iuAjkTCnjuTsFh_Ts-iFHanRHk8X9waBRDGnTspc_w-JB2QLPGhpTJDZs4J19TRlQMcB4dZTt3vH0fdpDiKXnnl7Xmc0fJGMUBEkup4MNPAm8FdKe9GuANmG6NURG3GdDJBqT0O7TsZy7b2UtLciQTyLpaUX4Q2RC6rYoz6KaahPpZVO2WgEm4FcRrSiQvlV6GOZDj3PAzGuUPX39oMIM3pRknF2qwYyZ57T73gvikJwEoDsJUiB8HR0mhk37nKIsGP5xrx060hyTICPCPRlyqfgiqmjLKgqdvIb5_h19gufR0-KtslgtmIEfHfgdDH0ZaFz4zU8IewAgTsw5fCyv3b1COWNd2Z9rFiE6OEqo5X-OEIMnj51G04ddgsvWZRiuflxCW-tPhksSlG0MpByANpnVAOshxNIKKrRBNlQ-vdkHOMjnzF9O80OR_iI4papnOMOtpbBfDT7KKOdxKompYrSxA-Vw9DmVis_W263SvBe1DyKnxApgCVh19NuvBSvtE3ESUCYn1zl2X6kU7xPnwGYDA7rjuLuNZeDB5akS-1I8EXxg-oI13SYUUQ1AYTXxFspT2i5X6U-lq_QSZ7V4a2uVDjT2xj9wil466qDUYLkwRVw_87HGchI6hEPrIkdUk2af-E2g5l30yaIyNiiwFETCFuTRo_UzyrlGQZnAyDYE0qG_tdtmjsb6rF46HwiFMzizk9WtjCqo1O-lOBAj-rt_ZhmVs79SyqBOoU9i-T34tvqKWwNeN7TBU9azvTqp_5h_0n9RvHT7RnTLYXBo9IbhpBwBIx9NCDquYW7UMqUPkRV4FgP8s_qkCGfELb_2VPOCzdwxsTa081_9nEGUeBGXLPYT01L2_UwuraFvvb41jzJpQiRWqDBwviEb-DXpxDuEVXMzFrrqL4h9lZBNLNWGtVm3hgydhiCZrOLheTyHekbK-4sY7gWkLp5pA0CjNYvz3dPhs3ecCjZw1FAh_FPhL4eJr5sKW_9_oIEp7W6HzbiCHiCEJZ6vs8q7sqQzUmVzZZB4H-voEvnCaYnAA', `SearchKey` = 'wofCpMOqwrDgcOQwqCpMKDwqTDlsKsw4DwofCpMOiwrDgcOQwqCwofCpMKnwrDg8OgwqCwrHDhsK6w5rCp8OEwr7DpMK1wqDwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwrrChMKhwrTCvMOWw6TCiMwofCpMOiw4DCtsOgwqCwofCscOAwrD'
# [29-Jul-2025 09:34:43] /finance/root/bg/invoices.html?from=01.06.2024&to=30.06.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-06-01 00:00:00' AND '2024-06-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [29-Jul-2025 09:34:50] /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
# [29-Jul-2025 09:34:55] /finance/root/bg/invoices/2515.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` = 2515
            LIMIT 1

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