# [07-Nov-2025 03:02:31] /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-Nov-2025 03:02:34] /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
# [07-Nov-2025 03:02:44] /finance/root/bg/invoices/10476.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` = 10476
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-Nov-2025 03:03:25] /finance/root/bg/ajax/invoices/form/clone/10476.html?pid=10476&_=1762477404463 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10476
            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
# [07-Nov-2025 03:03:32] /finance/root/bg/ajax/invoices/insert.html?_=1762477411652 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 16 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` = '2588', `Language` = 'bg', `PostDate` = '2025-11-07', `LastUpdate` = '2025-11-07 03:03:32', `Type` = '1', `ParentID` = 10476, `Data` = 'SItDPrKWutXdzbcdY12G7HfOhX4hAOEHJUNzYqRWm8TKOToZvu3GS1JLdonkiGPw0M2Sa30H1enuJPngy4nlRiX-tjsn9Tyo6UJg8Hrvu4CED_THLcDbAasJima-kQInXM4SBRg8gE2RUMgylwplRAnu6h1uiLReqVrBdq3lvmnQdNqfXl5GzijOaAkg4AfFYpcJcDdoy-ohcFqj3mKBmbjc4LTDdHC7kDIceSkCgHn8S9XNBRyeXPChFH7F2zOQNljIzj45wdMf1fabB1yFVUR_5atqeIQN74QzkcLFlgwbR8GUkDr6XnCnHhyP2yeb-xKCsvbrdPKbairSBLyUse3aanNL4sWiyhy1RlfHHXs2h2r0vt8GHbjEx62t9YHsEq11kCt7VFK43CKhTlapIpNsc3kcLbdzKI3NhhGXE0_B5fEaX1JeslNMvCN7RUYx2ThUybZMIwVIjVO1tL91pt-gwradohsnquvZByisb9istE0gVGjOox2t61zJUOLrXOCOw2xb2xZoDwCIn4_ZhTg-Ow6e0HU7rakE2crYbuzcvzBhwK3yNCgu4vsHXnPjCq3PjEAb0ftJj0L1cC4XK1ZXNm1aYVPS59RQw59klRFS1W1B4Lsgr0V3AVoTo0WMniA_HvU9TbM4pXvsElENS482u-dB4TIPt98JXiCQXIjp2VDIMRgAfEV94hWX-QWGtbgrxG6ssxUSudA2jZ08cyo68nzB587J1-8h2HIaAVK26qrsNYZ5QmN09d9-z02DZoJCUrJxnmM7jEo0VLHAynVp5bEhQDwkxEp91fsgMk4Mkut9LMGfryUZWqpQrAWvcoz1Ldc2r2NuQpy84c43EtixG5AGyugFfPVEd9-lveu-JfDk1HxiU6eA7gNxob1ARpQxfMDbf58rvuIW3jtETCUY3Eky8oIZWNsr4s-cu4cCxESWZQtD4mx0fwP8iCBWyLjZtSvvbd6X1sBZhk_hztnnBFD2zCAm9YffI-Rrja0vNF2FeF9ZzcNlh5fDluIEm3Tb9ZJKi8wWXhfnsz7jiFT26tUDdQAsWd3Q2zksaBwJJks8A4u9FUzjwXo1K-NpDMG3TUhoG_mo5yJov3eAyKit4sw3eaq3uV0OaP1T1urIuRmR50tKKAEzpEx_6asWi5m5wwDWuv3U4A-GlhySlpyhjF2jQ03AKdmprwn43deVB3hPhP9tdP9QDsQi2qsz_wLK-eWDf1-hc3b_NBqc8fNqeoeh0Rs-s4uc_YAyLyII3f_zZUbduQusn1CpgP6uTfFxSYJVSP7wTey_sbbyLZ9D07ttg5yXHxGzqcMcQWHgpJHrYhjHxH6-RAYXYZnh', `SearchKey` = 'wofCscK4w4DCtsOgwrPCtcKDwqTCuMKrw5rCucKdwwofCpMOmwrDg8OgwqDrsKDwqTDlsKsw4zDj8KhwrLChMKhwrzCvMOWwwofCpMKnwrDg8OgwqCwrrCisOGw6fCscOZw5jDnsKtwqDpMOQwrCncOGw6nCuMKcwr7DwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0w'
# [07-Nov-2025 03:03:32] /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
# [07-Nov-2025 03:04:13] /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-Nov-2025 03:50: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
# [07-Nov-2025 03:50:07] /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
# [07-Nov-2025 03:50:11] /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-Nov-2025 03:50:43] /finance/root/bg/invoices.html?from=31.10.2025&to=07.11.2025&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-10-31 00:00:00' AND '2025-11-07 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [07-Nov-2025 03:50:44] /finance/root/bg/invoices.html?from=31.10.2025&to=07.11.2025&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-10-31 00:00:00' AND '2025-11-07 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [07-Nov-2025 10:36:13] /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
