# [25-Apr-2025 14:04:41] /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
# [25-Apr-2025 14:04:43] /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
# [25-Apr-2025 14:04:44] /finance/root/bg/ajax/invoices/form.html?_=1745579085194 167.99.142.201

set names utf8

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
# [25-Apr-2025 14:04:49] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [25-Apr-2025 14:04:50] /finance/root/bg/ajax/clients/form.html?_=1745579091082 167.99.142.201
# [25-Apr-2025 14:05:35] /finance/root/bg/ajax/clients/insert.html?_=1745579136108 167.99.142.201

set names utf8

SELECT MAX(`ID`) + 1 FROM `clients`

SELECT * FROM `clients` LIMIT 1

SHOW COLUMNS FROM `clients`

INSERT INTO `clients` SET `ID` = '79', `Language` = 'bg', `LastUpdate` = '2025-04-25 14:05:35', `Data` = 'RGYjXmdBUHn_F9ChDsFdEjGaxCVp8Q5MEfFDkZeKG0Fbk6Ek4gNU-8hxBJ1FbxPpsR7euHJjNrDAaKjAiMSIQABmErNY-1A71HmuLKfZgEhuvIJZd9fiAKg9la6wtUUUKLEJo1pvjSOxdL7NAunGqzTiN-NLvwTCLZYw9c-6NET5WQRZ9d1dzwuH9k8SE8T7ygu80DNLcRBeBb1-2u7IidWqMH9QC-a24JDd2Q08YhM8ZJPBeQD_TrvpB7ILOdwNkcr657WMEta72k8BJnMDylQnLJGtQICVY9K0w_5PwluPZyrGzmOb5OCdmRqMiPCDe9s_4J4tBo3uudCT5u1LPtFs42ie6yobM3ZDG2oRqT1TW3VzBhiS82qzhBqNXjkV5T7yQK0_6GxuEIqeHhyiUQ', `SearchKey` = 'wrvCn8Kpw5nCr8KfwwofCscK8wrDg8OgwqCpMKDwqTCo8Ksw4zCwofCpMOqwrDgsK6wrPCusKDwqTCsMKrw5rDj8KdwqbChMKhwonCvMOUwwofCpMOiwrDgMK6wrPCtcKDwqTCsMKrw5jCpMKhwrChMKuwqLCvcOIwr7CiMKAwp3DgMwofCscK8wrDg8OgwqCpMKDwqTCo8Ksw4zCwofCpMOiwrDgMK6wrPCtcKDwqTCsMKrw5jCpMKhwrChMKuwqLCvcOIwr7CiMKAwp3DgMwqTCrMOTwqLCnMKwwrnCqcKiwqzDj8', `Top` = 0, `Visible` = 1, `PostDate` = '2025-04-25 14:05:35'
# [25-Apr-2025 14:05:35] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [25-Apr-2025 14:05:40] /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
# [25-Apr-2025 14:05:42] /finance/root/bg/ajax/invoices/form.html?_=1745579142665 167.99.142.201

set names utf8

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
# [25-Apr-2025 14:05:44] /finance/root/bg/ajax/clients/select/type_0.html?keyword=todor&_=1745579145661 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrvCn8Kpw5nCr8Kfw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rvCn8Kpw5nCr8Kfw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [25-Apr-2025 14:06:45] /finance/root/bg/ajax/invoices/insert.html?_=1745579206638 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 79 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` = '10446', `Language` = 'bg', `PostDate` = '2025-04-25', `LastUpdate` = '2025-04-25 14:06:45', `Type` = '0', `ParentID` = 0, `Data` = 'jpUk4Xu33vPU8qZvktoPfNjxjTf7BguNmcX0KQIik5LrUYi9IZbKwsm1wgArDPZ4GZzsrP1dB2sUZTE0YPhrzJG_aGstbWz5F5izYQV4TYUlHrSxiJn7qaupreiaZD0orUKGwqmIa9vzAcYCJfCd2iKZrjqnDrfH2VZs0Gu8Gem6rYHxfuDgz68ktnkVmUfkfVEJ8aAWejotY8BSELtO_QU-6vhA-4holxh91P1BQlWQ53mqPoiooH-Ct-pm1sJ3p6gXGehSWQSaTsXDLLmhhtpppp7OgvWZSp-oZy-dm3WqA812iJq100vDwHwzrFtkk-d2CE-KjeClAEpOXlpB447Snfis5OSkNlRI_zrXycCvaVW0gOnF3l70edCaOJhrw0uoqLa5nHaP6Xb0uJQT7k59sVgd0BS5DabbFlno4dcgBByrNMQdE3_J_jqMuuQSXvZ8-bV_M0n_jPC8DQ_dhKjaDS_FM_cb_K-CDA0QMeDjskBzYRUcOc2YKyOZIV2AObG32LUBBFilzgieTHYQw-UgAyxzsdKf3rJ4DGFQPfPExS-IhDA-NHbvmaj_Ax_IOelTSYYD1OgX-ilIp9YgsWtXsh3Q6xUW1669J0bPtZa2K0BJv__AE8c07fVKJtdQaRAalxfPc2YqEEGixUL0QoOW7cME0T3ToxUS0CthrGN4Y8JkS5Tf6Y08GWLohrq8VO_EWPEZP1Xx0qb7lj6xiKUEU1vUuOk3rRwCqtAJxs7b8VZwNfPHOqJxjRj1VlnDLd74gUKdaqMi2-OWE_yuLTdztSaj2M5PECqrLsz6UkeGpAXScxPfSW1iubRKfxxkRisYlvqNuJgTZXydBhI022AWg6iCXb5E6hM9tkROlOorMI8zDRZ162s7220XT-vMGcTKTkc3jYOj9wCw4hPHEM-2PG_FaHXdoH3ppAUaON8_ehxNolYVomVz6fgwroiEeKvQrWufyDdrA0COxHmELCGztP9LPhXmvMGy70bJXCg_bUeQjUd_bDszbgV9InVWk73J81AfUA--DqWUrvtji0oERv1FMhW1W6SrHih0XaPzmQ_CJXOkgKw1Q43gAJqomKqko7R9YvldsQYC0UQFBhE1girIYbkB-PcQSAWPruUHkZ1fFEHCeCukW8bDqsp1OIz3w5wE5JswjLBWM4dfjFJUBG6t8MQbY13GbKJPxNl2d6BHTDgmQ_Ymc8CIQOL8Zy6_DbUBV6ePQX1aoCFLU4pVXzinLWWAQ8IJAogz6bG38LVFxOuYaDVL0vSfwj-2tgzVLegg4Aqw2NiRSg3EGNAnseOmRlfEmZs51mmvkOSm3eXpDSHvD-zXQ7eWFReCXrcvO5OUh5u8YRY7Zfurd4L0TLFUf5TCD7ztjWjYF4GBSNdtVShgttZHFrWx94Un2l4zddxIzt41ST5e9tFcIE0PGU1frbP1iVYYFoRUlHtYFLYFkS-9CCiQLRoBYtFIc8vl3xZuHIwkyeLJzi2XKwlhGkkTFcmKnJLKuy51IZ1mMhMxX9qXQn6q7mKHHCH5', `SearchKey` = 'wofCscK8wrDg8OgwqCpMKDwqTCo8Ksw4zCwofCpMOqwrDgsK6wrPCusKDwqTCsMKrw5rDj8KdwqbChMKhwonCvMOUwwofCpMOiwrDgMK6wrPCtcKDwqTCsMKrw5jCpMKhwrChMKuwqLCvcOIwr7CiMKAwp3DgMwrvCn8Kpw5nCr8KfwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrD'
# [25-Apr-2025 14:06:46] /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
# [25-Apr-2025 14:06:47] /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
# [25-Apr-2025 14:07:18] /finance/root/bg/invoices/10446.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` = 10446
            LIMIT 1

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