# [23-Jul-2025 10:11:59] /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
# [23-Jul-2025 10:12:14] /finance/root/bg/invoices/2500.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` = 2500
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [23-Jul-2025 10:12:23] /finance/root/bg/ajax/invoices/form/clone/2500.html?pid=2500&_=1753254743508 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2500
            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
# [23-Jul-2025 10:12:52] /finance/root/bg/ajax/invoices/insert.html?_=1753254772553 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 81 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` = '2514', `Language` = 'bg', `PostDate` = '2025-07-23', `LastUpdate` = '2025-07-23 10:12:52', `Type` = '1', `ParentID` = 10447, `Data` = 'AxvBqlUlTeX2aENj-CerOmjOjIJORUTzCjtx__d0XgQtzZt87J-WGcOxbU_yjdgodo6mMBFSQ9kd9t109gW5eGBWL9Nj8T1ZSUKdHVZj9WvPggRQYZ-iUNDwnq0ykFkqXh7HJtYX5dwhWdvfneQQBFG32TWQX6t-v5iMsbuuAwAZXByJ3g5ep5NJlhG3xBW2_I12LoGpaEuCtJPSqq7XofIeC7mTFBzUcSjlW5i1pdr5AZRcBjtn-RSLMFOUXg561ZiQ5efxdlCilSu6YAc_Ckx0q5FFHA8JY6Lzq4pUoH--7-kVB7Ah9J5OaKtKNplueTWMNe0Z3tiHtoQX0VXVCsDi6h1bfyyQObhukluUPA6LXOO8TghXjC-lzCdH9FlTJcDll36LShvM3KJ8aoXOYqRzyVpR7Oe8yagvi8DmYgF5396gUDMrmwsPBij_8G3ApheHHptkT5I8d8rn1FEvfArmoI4ZvOa9fTMYRKkcqq6pwLB931Nv8at1Ehj_SZbK1OsG1D1uUcbk_JItVfjoxggv2BVpgmvqh3JwhwOWHuwbR4GmWQZlqrh0-ljowhm6QLrIGD_bVHHt2P6CD6RaAD7c_-X39dadLgx8vetc48kt7a6EGKGkLeIAB9qupJants6vC32EYMvageWRtTkt7nOUeq8t5129AE50oqKmBVTzGQPdBueevMwjiB0-_cHl-l7IQfwk_HE-wNesNsIzuWvJ7FwaifBGCB0tCknTPXfO6qAROGsVDUBLJWFTUvz2Y0RxEaFbw8uv4K8hpzCV7cchlD-unKEZmeNpfY8KCF_1CjBlqGpHEaH1FdtxPDrbj7tWDvOwOb31kBNPvC3mTrfACta19uTmx8hTYjhDIi0k9PdYv_iwm8Oc7sjPKuSZp0FD3skRvDF365dJDB4jlCVSifSTUaZPe44sjN4Y91ofaHmZs8aln5E2ymlG171UQoCIWqiZydk5ZIMUlhoaR--R5K89mesccRQ-J33i9Tw', `SearchKey` = 'wofCpMOPwrDgcOQwrPCt8KDwqTDnsKrw5vDwofCpMK0wrDg8OQwqDrsKDwqTDhMKrw5rCpMKdwpzChMKhwwofCpMK4wrDgMwofCpMOIwrDg8OgwqCocKDwqTCwrrCn8OGwp7CrsKewqXDnMK1w4XDkMOGw4fCssKTwwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8K'
# [23-Jul-2025 10:12:52] /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
# [23-Jul-2025 10:12:55] /finance/root/bg/invoices/2514.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` = 2514
            LIMIT 1

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