# [10-Nov-2025 07:34:38] /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
# [10-Nov-2025 07:34:42] /finance/root/bg/invoices.html?from=&to=&keyword=bobi 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrDDhcKpw5fCrs%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [10-Nov-2025 07:34:45] /finance/root/bg/invoices.html?from=&to=&keyword=tem 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvCn8OGw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [10-Nov-2025 07:34:52] /finance/root/bg/invoices/2423.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` = 2423
            LIMIT 1

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

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2423
            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
# [10-Nov-2025 07:35:06] /finance/root/bg/ajax/invoices/insert.html?_=1762752905618 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 72 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` = '2590', `Language` = 'bg', `PostDate` = '2025-11-10', `LastUpdate` = '2025-11-10 07:35:06', `Type` = '1', `ParentID` = 0, `Data` = 'NLU2Ulzt2XprNIc4SBB9c3RLhVRXTX3XWAy2-spcXD-sZ2j7W1U-qGldzXVJVkbbfldvMJelY4ZiZRFK1_tZmGlEPF4-HaU2W9mGX3sc8_o_R9oGrtDUPIzVRsIPWgvDSwpQZwPoJ4PnAWbIhzVWJO90GBLjWQpWQAUFPh01-EEoYoX9kBUn239L_5hNWt6jSGD-Z_O5WYqzh_P_wQpyGEnO2sQeyUfhZTufrVvnouwtVd-BDJqxBlFEkQXm6GfyGhhJ_pnTyR3ZdP_qRa5rGjrpRoqUmCotmIXSnqCRx8yf5zvkpI6NtDOfg9kTzdc8Rds0Y3fayl9kHugMZLiDxTSISoYOzGcksAyA6UV1ToCg7q1Zooaznrp7LmLBoU3atrJxpthrQSyoWkpruEOeOZt1SzK5wHR6DFXl4lq7nZwfU0K7WEyls-tp64KIS9aH9oPUpH6hHY_4WlLHsNSvcCGVGeTtmMnBvUvauWbLzdcmEWyCmByvB-wyEIiNGeKZNs4ZFCv0k6UOnhbl5DYbPk7PO2mLMxXzI5ZR6SH-zb65wDZgrDxmdmAUYdn7fvugmKUr5QbBqv8SedUTcQdfA0S9kcZrGrA_mL4QRPsIbzH3FUKXeQ2YBVwY8KnXhDqeR4wPmItNyNd4UGTqMO5TNLCFp8EZVC7DMTii0ItoFruNyKcg8APn9IF3YSLStHs3thwSKF-HsuS_nTZbCS2AW5v_8rCF50D0UAT5dVilzm-Y98ty6jlGFNg-GlhuGqCrEwW-dmC92oh4NbZF50OMlZHc9xD9IUdKUL1VdcEAIhl0qIOFB0SMf-UMmaBVlUltS5yXADzKCCKsi1xw94p_PmvbH_yTqisVPOq_BcT00qZCBdi6TLFsOtdt2BQpkBvIQx1qW5FbN08zEpUwUJc0H7-4CFOqZlUnvxJniIX63134t0kpOBFCw6DEE5tbIDgi', `SearchKey` = 'wofCscK8wrDgcOQwqCwofCpMOEwrDgsK6wqCp8KDwqTCsMKrw5rDj8KdwwofCpMKnwrDg8OgwqCwrvCn8OGw6LCp8Kzw4LDrsK0wqDkMwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4wrDgMK6'
# [10-Nov-2025 07:35:06] /finance/root/bg/invoices.html?from=&to=&keyword=tem 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvCn8OGw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [10-Nov-2025 07:35:12] /finance/root/bg/invoices/2590.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` = 2590
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Nov-2025 07:35:18] /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
# [10-Nov-2025 07:35:26] /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
# [10-Nov-2025 07:35:32] /finance/root/bg/invoices/2590.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` = 2590
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Nov-2025 07:36:17] /finance/root/bg/invoices/2590.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` = 2590
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Nov-2025 09:08:42] /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
# [10-Nov-2025 09:09:24] /finance/root/bg/invoices/2590.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` = 2590
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Nov-2025 09:09:35] /finance/root/bg/invoices/2589.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` = 2589
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Nov-2025 09:09:52] /finance/root/bg/invoices/2588.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` = 2588
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Nov-2025 09:20:58] /finance/root/bg/invoices.html?sort=21 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`LastUpdate`  DESC
# [10-Nov-2025 09:21:00] /finance/root/bg/invoices.html?sort=20 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`LastUpdate`  ASC
