# [19-Feb-2025 17:33: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
# [19-Feb-2025 17:33:09] /finance/root/bg/ajax/invoices/form/clone/2426.html?pid=2426&_=1739979190342 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2426
            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
# [19-Feb-2025 17:34:54] /finance/root/bg/ajax/invoices/insert.html?_=1739979295114 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 62 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` = '2427', `Language` = 'bg', `PostDate` = '2025-02-19', `LastUpdate` = '2025-02-19 17:34:54', `Type` = '1', `ParentID` = 0, `Data` = 'AA0HOmL2E6Gu9kNtoUfnsgcq_-_xQ1guDsPEw-RJqrkiVDYQyfUCek9R0ekBSbXeyDBBTCITpnyXPNQUJZnSPKmA0IIfUGzUinY6iZIckvf5Z5c88Vn9BBehKl-haITNWRfesoAX9ezrhcxCBdkCV5KJDClsjnj97_1__zbjbIEnyr1vx8CpKMCSJcYW572ZjztunYG4fipj_kznwQzwDMOFWjS5R4JlsiBAjT_xen9gaXtmDkZcHPp4Mv5-eMdDkpYRLtrSdF6tSxriZunegs-mvKJf_6nXJFq1hhZaY0AoX_4JAwSaTTvmuOr3QnSRu3VcQ0ey2pA4NEz7vfo5mTEsYlWIMs_7qBzASgDJSh6lCC2B0PvrQkfZXMHsOuXz15xEkzI-7lK5QHMimIEqwPviDR_JocsiO-Xbsh1055v4ENW7pt25CkmcmAqhZjwZKVcCsoCH0L_vrfgIEVF64Jo0RUSNZ5kxIoxh1S6HBJBeXOoDqlRjvHo5brrgwwC11uthR_gjBXkvKFhGCyzxkiZTjQDq2U9Dg0s7U-Pfy_rDfgaTfdvPd5i3rdYeXWjeZUjVKIi11T9I_IFNI4AHo7qEEwwtrFNUKxstN7iDxnBBuxtRZh5nC5PQWkIqk_G-TBCml4rHhuKJ54ZC8pi83JajD9N8KQfGZf3eg4gRe7t2kmxcr7VFS67uOPyoDDiA6GZ_QDh5YXiIWwOV-u9-FXVj5lbS-ivP9flThuUBn3DNFGzpCz0x7NC_anzKC9jwCYGVBbfgFN1mNrnJXoPOZaSZJCBJc88AMjsSl2A3uizlh2Kte9tBqFMFrb0lPNyrvBtmt1KOfAp6TqBz8xTi29nM6n1hYtMwWpeWP1WRHFRRtG5oXKWOuYFKAWNR8_H1evF6CbefcufieAKeslpl4WrB61Lt74Hep7H35Wk5ttU', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwrnCisKpwqPCp8OEwwofCpMOEwrDg8OgwqCqsKDwqTDosKrw5jCucKdwwrHCisKpw6TCp8Kew6TDwofCpMK0wrDg8OQwqDq8KDwqTDosKrw5rCucKdw'
# [19-Feb-2025 17:34: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
# [19-Feb-2025 17:34:59] /finance/root/bg/invoices/2427.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` = 2427
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-Feb-2025 17:36:16] /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
# [19-Feb-2025 17:36:22] /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
