# [05-Aug-2025 14:01:23] /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
# [05-Aug-2025 14:01: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
# [05-Aug-2025 14:01:31] /finance/root/bg/ajax/invoices/form/clone/10451.html?pid=10451&_=1754391691031 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10451
            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
# [05-Aug-2025 14:01:35] /finance/root/bg/ajax/invoices/insert.html?_=1754391695555 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 35 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` = '2531', `Language` = 'bg', `PostDate` = '2025-08-05', `LastUpdate` = '2025-08-05 14:01:35', `Type` = '1', `ParentID` = 10451, `Data` = '4qclkqgTZUH8MHRtBlqrJgcg8q_ISesiucoDCvM8Qwbfd7aMrXRNKT-lNAyg4kkTmWZo6LM4paMi_UsM3cPldxg-sQgl-yWCKgZvTBxwQqygitEwCW5zG3anmpRYQxwabMxpOc8Va3OPRhVx9lAxceSy1l7nV7QHJNpPAuygGG4N5vDciRtsAUG_cELTsR6Tb-hF_GGnB11C6JfelhImnpBZ-yrFY4MubK3AwGkXi0_5iwA3zJ8IAK-J-BJuR5EC78duCpzfvuBstZy-MEwy0vqfSQW05S8wyNXPfOkzgwLc8aCY3Q6jEYzItJDm9rzhzvhfOoSbZokzXfWVhE-3Q_12c4_T8JJIBJfbwv0MJm8TCVVOcTBDE3c5wG8SwGDYPEPuXtMu2xTBXD9bwXlX0mV2XBws5XbioE2l26Qd3fP2klsTzmmr14LGQaeLhwUixZWtK6DqsOHM0S-p4ipHGZw-CRK90HjdE0nI64Wi58UMUawOuJCELklgrs-lS9YvQmocmmDBZ2PsHcTlXB3dO4w4xIpMpeTx7OiDeQB8aL0RnBk6qWoflLnsQQiiPY8t4HRVKwMQCdjonUco8zfmIXdiI7SU6eVqiCt4BYqQw9wFL-Vk3hG-TxNenhsW0vZjHjvU60UR_0BiQnFQH45w40suQzIuzs6VevL4VrYKR8kDTKP3elStEnbRN-gY-Tb1hK2QhQbeaBW7JYcCbFET_TVD2icPYh_IxUUvrFXeT1Gu_7zWHrYTX2s_eUTSORhwcat7irr7NIn18iN_2WjaBDRsZP3Hfo_VGtPsJPV2hsIQo8woX3Em8VdXxcDIlYTWiR9XaYsP-6TiKjn4ajrwT1kJWv9BC8hK9GyHoHV_7ySUP_PPeHq5iQPzQTI4cCq4z1LBeVJzZoU95uXenyLS45GZOthJ7l8cYV82aPkWWAluERxylhjiO46yeG0ONDWmZYOh6j3yj59Bx-tpE2XXLXqrMNhk7HZOCycD9PL1SqTPIEDYOxi9L4z81SzMmR0QsFo0eXoC9SdGTfmpiT8Ti89oH9OsPcrodQ9A6NPY4v1JE1w6T-71hYDGoWA9KhP7mVe683pBIRaob0laboO7IurxtCVTrQPSn7I50kHgyzUHDzDKau6k4JQqomkJn87t', `SearchKey` = 'wofCpMOPwrDg8OgwrPCvMKDwqTDlsKrw5jDn8KdwqjChMKhwwofCpMK4wrDgMK6wqCp8KDwqTCwofCpMKnw4DCtMK6wqCq8KDwqTDlsKsw43Dn8KdwwofCpMOPwrDgMK6wqCrMKDwqTDi8Krw5vDn8KhwrDChMKhwonCvMOUw6TCiMwrnCi8K6w6HCrsODwrrDwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8'
# [05-Aug-2025 14:01:36] /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
# [05-Aug-2025 14:01:37] /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
# [05-Aug-2025 14:01:39] /finance/root/bg/invoices/2531.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` = 2531
            LIMIT 1

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