# [03-Apr-2025 09:58: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
# [03-Apr-2025 09:58: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
# [03-Apr-2025 09:58:10] /finance/root/bg/ajax/invoices/form/clone/10445.html?pid=10445&_=1743663490792 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10445
            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-Apr-2025 09:58:13] /finance/root/bg/ajax/invoices/insert.html?_=1743663493525 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` = '2463', `Language` = 'bg', `PostDate` = '2025-04-03', `LastUpdate` = '2025-04-03 09:58:13', `Type` = '1', `ParentID` = 10445, `Data` = 'UuyR4y4uzf8xJROZNct6lbBJP-kxmoiZorFMNXWeSG6GtCN2uMPkpfDNN5-1zyyWpI2szllfFYvNScfcriW_H5WybFMVJEsPhSD0v-wXTBNCfCQysYzRcECm-x2YJLvQz6q0ZdBXjJLaNEEsVGlipysI0H2HIqqigRWQdbsKnAwtcXaeSURZQ3kfqMvp7VgkC8PNXIIhxuf-YgdSzHAYGx-GNHLjD3his_NwiCosS7HxppYi342dkrNYFkgypWVlAepv8kNoUIR3_hx0_IMyviNq2BHe30Vc8-dwYfUQidK1BNVEIrKPzBjg4iReHEaTVvT3MipnTBp3_0n1No2mjE6L82gqcJtI9MFF4zU246FKxPCKUzT6TXt2CcAtqSxywPCsxLPwJBqNlrARbc4YxHIBCkcZowcoClhdzLN20i6kJmoamajW0KBJgWVPEHOZ0wP3m1v3wQ952sC-WdjynUC70XoTwRcUjvVXqJ2YzS1ULh4k0zBlyuppytZ64lJWVhHm8B1453ZK64g4UwL-GCQdz_ySbRehCl0baaVounHVAqYLUWzOvUNPbSCsLnL_h8lFYtEa45mwCjK_n9zTWImSdx-k3GlKru2BNE4pov6n4dsQf3SgVMmTFDnOGZzaVX8TkYd3VSjrYrNZI_0pAbq2xoiZYY-xlRBhqb6bouRY2SxvhB8HPla0xg89rS5eM6a3cgHT6VhMyUZzVhpIy0q0MatJK-0xfeNBcsp0oTsAsc3VrFoxYkRlXit_3GziB3EyPs69cu3X2AM_F7gG99hjFSLXw3HAgXXfny9gT7gDWRN859ZYVErUZbU1gEPHho5QFGg-dFDIWiMObn6jLQp6EnTsMakpDwt20LBgQWuQNCygd9mmLGx2Z3ELywozQZ57x154xs6QgdED3lIibEmg05g0aeZhz1yrgUypJrm_fPU83YTTnW09HeR35XnjKtpDsEuC7oRlyhZYUdQI16wXpKqYOtWmHKmKl6jfzRFbCdlErvTrqnD0mlV5HoowMAgmRq18anpk__PrjBPpBDZNTBNrNl-lle7mL92b6UKxX_PetE1nAp6cbEa2pAJR', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwrnCisKpwqPCp8OEwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6w'
# [03-Apr-2025 09:58:13] /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-Apr-2025 09:58: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-Apr-2025 09:58:18] /finance/root/bg/invoices/2463.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` = 2463
            LIMIT 1

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