# [29-Sep-2025 10:13:34] /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
# [29-Sep-2025 10:14:03] /finance/root/bg/invoices/2551.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` = 2551
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [29-Sep-2025 10:14:50] /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
# [29-Sep-2025 10:14:53] /finance/root/bg/ajax/invoices/form/clone/10464.html?pid=10464&_=1759130092503 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10464
            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
# [29-Sep-2025 10:15:03] /finance/root/bg/ajax/invoices/insert.html?_=1759130103043 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 85 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` = '2552', `Language` = 'bg', `PostDate` = '2025-09-29', `LastUpdate` = '2025-09-29 10:15:03', `Type` = '1', `ParentID` = 10464, `Data` = 'ukb4mKGhG1E8tusXnHDGQmTVPJXTYr5B8TiAOcSY6RnVNYWkTAmMW8MWzFVVd5cegGrkpCZpHgMDxxgEnsyKUHRT_xieZYTf3m1Lkxz1PbF6OyNcbXS3IYWQTZkgBdLXXf54syVOF26eurio5CYQTcQdbVnAoOub-LwN42ssFKu8dd8sHrWjHyYU2KrMnHYpgfUlG8c9kbxL8boCo2-WWYGeJegdMNK6HibG4sj9foiZAJQjL3bEWZnQq2X4bdxTbh_tsrIhIo86WU_JcI0ptaPHFxU_lzP5Jn-uQvpsoaLxDdp-uHXVsQN-lDywREss7JBAySHNImkhtG8G0GDM2qd9ue2uYI41G9kxjd5laSvJ5EeGInp5EnqCBVakvJTSxEjA5dCBtfvukjKFH7BbOEypQaXxljGYY1vzUW6D4CX2fqeG2pjw35Zx6UphkJRVXUYus2iLgkG6f4C7kYQvXvv_v02gSBhGhfr0S5-0Dy9o4ayQiaKy9QIeH0Su9fu5Miw9LJ7byUQ35rY1n2ekUuMIFBOqZVFaOYZ3LJtljbuyyUEcSmiCeeCgKdD5vBJbEZceMM5bjNEZTUTcngLGVlfNZUlbKVaBeM8UGayhMtFm955MZ66RmPx5CzM0DuHk-GZlzGJfP_paiVaPH1s7G5MzEkMJ-KjE1PwERQIv7JZ1VESUGTM_mSFKEjlsuwwUfxxF8cAsevBBF9Gf3wmy3_nUHpad9s32gFgKazTQhfQ0zwj3ev_x6XZ2WMV49I1PKtaJghQ2hTsmnd9IpHX0g_AXnFmwFAZ9omrOa3RJTnQlqWx6rA7jpDiHC_9gGgqcPyVCa8elx1Je5lMSwoP5QhEiaQnyuPcMeIxq0sl63ZUNBLsFJSuFBUTcJy-KJzs8TVHxV0aKz7d7uFtREl50uQ', `SearchKey` = 'wrHCn8KlwwrDDhcK2w6DCp8OEwrbCwrnCoMOCwwrDDhcKpw6fCr8OZw4LDwofCpMOawrDgcKlwrPCtcKDwqTCsMKrw5jDj8KdwpzChMKuwp7CvMOWw6TCiMwofCpMOPw4DCtMKlwqDrMKDwqTDosKrw5rCucKdwqXChMKuwqLCvMOUw6TCiMOKwp3DgMKUwqPCu8wofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4wrDgMK6wqCqcKDwrHCwr'
# [29-Sep-2025 10:15:03] /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
# [29-Sep-2025 10:15:05] /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
# [29-Sep-2025 10:15:09] /finance/root/bg/invoices/2552.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` = 2552
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [29-Sep-2025 10:15: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
