# [03-Nov-2025 13:05:15] /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
# [03-Nov-2025 13:05:17] /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
# [03-Nov-2025 13:05:20] /finance/root/bg/ajax/invoices/form/clone/10475.html?pid=10475&_=1762167919660 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10475
            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
# [03-Nov-2025 13:05:25] /finance/root/bg/ajax/invoices/insert.html?_=1762167923838 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 83 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` = '2586', `Language` = 'bg', `PostDate` = '2025-11-03', `LastUpdate` = '2025-11-03 13:05:25', `Type` = '1', `ParentID` = 10475, `Data` = 'Q71uPPgab0chN4bsYtPxHSK2eJJ-fo_wE9-e58EW4aXv9p_ddmscuvPK5wKbt7p9PunJBmenns7yOXNJhz-kmm_n6JJjWayN371Qev293kzbZ2tgdhWcZrN-DUWTwcUfbltpEPUf6VExM_5YsFkXYr_DLSZPHbbSsmeAISIVqOA1ZoOWatLTvG42RFTtkVIOsvfMnZpGmWwEHxYDPKNwpZV2zDCWHkY-E6FDx7ZKBEvCqFNAev9UJ08UPzLIVv3eNIeugmbJK0RjZlmn-dZYfQ-sHFAowPmFalXny-5ZVL0GHpLzeyR3BOGsDqJ32t2CFTSwLAXTMT5Z2xElQAyG_mGJIA1M73KFx8wZRsINn5KbU8Po877XRseKhfxwxCBoKMyYCwxQ5wnE-TDOW6UaUac3e14c4dd7MfZcSKN9LHrFqxBqNZEWU532K8_zf9KpEcGcjzS-1DXrksGjf8jMYeaAF7LjmJPS_BeH3f5lZ4kmWQemTJmnLYlLlqs1Axs3clPndE4SM5QO6XeGswjEngDh1jDNCFgMk9Z-NvwQ-MVDfQ5Ap3OeW9ZI-HBuRT-vx_x5hv1k86l13imiEWAblcjNMncFaV_Zt24aHjMzcL4kyS7U8YIQO50kSdcgtQ_asXOKKTQLzCvXvfQ7Dqm31g1peZwLe9mHF-y73N4NMOdfJmUWU69RqrQUeMHEt4XZgmi3xZinIDz41OopmQxz_0iujUFdA8IA1kct8eZ9PsXVXvudHItegnmulWA3_-QAEdgEMYE7ir8SRc5038kf-N5ifHWZM14XOFcu_03lM0FFAxwpPsoUpPiltaApylY5SZ9dxfHNtyiJn5E8zJ6PLC34fsehq22Oh6zy5Z614Gt4kFmF3kIfXBo9XrB7tZ6Fuya3xI9YCGZ2EUTH23o2L0xH6x_7XXP4e5rorEX7QMoSbTPt-edv5DogD8lebPGP536Ia7N2dLDHkX7p_Ra3Aw', `SearchKey` = 'wofCscK4wrDgsOgwqDq8KDwqTDmsKrw5jCpMKdwqDChMKhw4DCvMOXwr7CjMwofCpMOIwrDg8OgwqCocKDwqTCwrrCisOkwqPCp8KewrLDqMKtwrDCwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8KhwwofCpMOWwrDgMwrHCisKpw6TCp8Kew6TDwrDCr8OCwwofC'
# [03-Nov-2025 13:05:25] /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
# [03-Nov-2025 13:05:30] /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
# [03-Nov-2025 13:05:49] /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
# [03-Nov-2025 13:05:54] /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
# [03-Nov-2025 13:05:59] /finance/root/bg/invoices/2586.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` = 2586
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Nov-2025 13:11:04] /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
