# [27-Jun-2025 07:10:25] /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
# [27-Jun-2025 07:10:27] /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
# [27-Jun-2025 07:10:31] /finance/root/bg/ajax/invoices/form/clone/10448.html?pid=10448&_=1750997432868 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10448
            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
# [27-Jun-2025 07:11:15] /finance/root/bg/ajax/invoices/insert.html?_=1750997476597 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 82 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` = '2501', `Language` = 'bg', `PostDate` = '2025-06-26', `LastUpdate` = '2025-06-27 07:11:15', `Type` = '1', `ParentID` = 10448, `Data` = 'fBTnN-aAklzOoSRtZbTMmVZWVxEZpArGAU9iorDy9AKcN-l3howFlEM4jfWy_TAFZSjpXJ64GnSUyStq6gX37GD6SNbjCIoYObtVPpYwMvoHS13WkE0x5UeFdBQ9Ekdo-79G1xFMfARtkbXcF_CEoNluCWMycGKx-aJr1nqdUHWw7akj82jquIOaeU11fs5JU6FHNOKrEgdGMXZNL_yamJa6rz3m48SPaT5W9EVoS8qHkDNToeqVW3LIef2vzf9Sov7cp2zL5Mv2gxvpJ3MHl04bvxnh2w6iC-1rQTtutvC0QEGjUHxoqaP3x1uGMp6IMt-QlXp347KYuFi3kyclqWbmya93P30v6ej1qhw893Tq9syrKOsxMI2h15UERDscjveFRlMNoiV_xlnyjxRt8aeaAp3y8vwIJ_R1duxRVvbxbh_gBa7CBA2hv17F24Run4TitoIdwX5nOQtvWAuBwHg2nsnCrGA-mFgc4drkkmvUzSx1gaMArXXvB8IBV2_Naw7my-MVvl7h1ILhe6-mi281KgbxaPbMz4DnwNttF5F4siF3VncDQW0RUPXm0bq5gYgFR9-7lbjCp9H-5h8NWzyf-AyH38USmARAKBCZVCDOnW70eT1YmnhokuzmZ9MiIF8lwmva7wGcWEHJrRUoBPI1eoGloQ4gGvHPAHTapH7YB-OoMh2CIEfuDuXuLT7YUgy_hhT8SJ8JDg53y4jxEphHVJS1gkMfn1DkhS9VwI8628ChlI_8SYCXORJwtK4i-FHjXIbAMXXdmjokeRXD5GbTmgf_DUXIiJvTE8sxp-tmfWhVrtq2-kCj5dz1PMP6Q7aVpHryszX_cGpSkCALXZ5Za4SVQY_66fyqit6yKeXuCaB8w7NsofxK74QZbtPpQ1z74HAHaGlAcj2Z4bi9WFf3myFAZiyN6Rkdn7uakirmhgfJ4JhG2GRimEDrneT9HlFaKQjKbsPBR5ThMQSXc3NXBI7N7_ygCsbM7wDIH1V_Xh_xAiDIx-SxhNTvueMkJWLW2EiwWayxCzXMZjcQU0eonjF0SPyC5vcafcO3p0RA8SYHtTYNfMWDBsclipoIFp62NmbKgz2psQUZ4Chy-DhEcYMKfeT4DirkgCHEOtr1qs6zTNj1nmK6oDO7XpJQHVQrFNowSQLvV7D61kv_GvLIVsb82uR7O5EImjoE9Ur37rGb1iX9SKfOU6uMEKfOw1VeYpNRQkjp6fDndm6WJli7pcDRgHtM_oAuYGw-ElXIXHuNEpGJPKvoVZFXVYxyxLJbAfGvhhHuvZAoQ6GRDw', `SearchKey` = 'wofCpMOPw4DCtsOgwrPCt8KDwqTDlsKrw5vDj8KdwqHChMKhwqrCvMOXw5TCiMKEwp3DjcKlwqPCvMOCwpfCpcKCwoCwofCpMKnwrDg8OgwqCwrrCn8K2wp7Cp8ODwqHDwofCscK4w4DCtsOgwqCp8KDwqTDgMKrw5jCucKdw6jChMKhwpbCvMOXw5TCiMwofCpMKjwrDgMwofCpMOPw4DCtMK6wqCocKDwrHDgMKrw5rCucKdwwrHCisKpw6TC'
# [27-Jun-2025 07:11:15] /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
# [27-Jun-2025 07:11:17] /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
# [27-Jun-2025 07:11:19] /finance/root/bg/invoices/2501.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` = 2501
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [27-Jun-2025 17:20: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
# [27-Jun-2025 17:20:46] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [27-Jun-2025 17:20:48] /finance/root/bg/ajax/clients/form.html?_=1751034048347 167.99.142.201
# [27-Jun-2025 17:27:34] /finance/root/bg/ajax/clients/insert.html?_=1751034454728 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` = '83', `Language` = 'bg', `LastUpdate` = '2025-06-27 17:27:34', `Data` = 'U4piUS6a2GXIFyHax-eXkzvlAufxCIO4NUJO8AJKlMMh-sIjoHjiqSxZijdsYVKZomIysxaClKC46TG34LdBl2CZ5b04gWgn0QpaSV9oFwJfFkioFcwrV9_IIEp6L5c97NcZTKOW72VdkoCccZ_35ufm9gyfBNYnHDWjHFbOv4EbGM_03EOl3-YRQmI1sYYvQ96q8vjwD4TB3o1Tdliec1bPur9qZjUb4WRejdi-M0Dpp0e8O4g-0EGSrET6M6gK5keEjqVP9qfhIFnqMY4UC07UMfAVUV2U0z8BcBZXs_gvRyclc2YC0ENq5MVtAZ9WKiB5GsPnIR45CTeetV2J5g', `SearchKey` = 'wrrCisOkwqPCp8KewrLDqMKtwrDCwofCscK4wrDgsOgwqDq8KDwqTDmsKrw5jCpMKdwqDChMKhw4DCvMOXwr7CjMwofCpMOIwrDg8OgwqCocKDwqTCwofCpMK0wrDg8OQwqDrsKDwqTDhMKrw5rDwofCpMK0wrDg8OQwqDrsKDwqTDhMKrw5rCpMKdwpzChMKhwwqTDgsKxw6jCm8OWwrXCpsKgw5LDl8', `Top` = 0, `Visible` = 1, `PostDate` = '2025-06-27 17:27:34'
# [27-Jun-2025 17:27:34] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [27-Jun-2025 17:27:39] /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
# [27-Jun-2025 17:27:42] /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
# [27-Jun-2025 17:27:44] /finance/root/bg/ajax/invoices/form.html?_=1751034464017 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
# [27-Jun-2025 17:27:49] /finance/root/bg/ajax/clients/select/type_0.html?keyword=скъ&_=1751034469164 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCscK4wrDgsOgwrPC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCscK4wrDgsOgwrPC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [27-Jun-2025 17:27:50] /finance/root/bg/ajax/clients/select/type_0.html?keyword=скъ====&_=1751034470181 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCscK4wrDgsOgwrPC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCscK4wrDgsOgwrPC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [27-Jun-2025 17:27:55] /finance/root/bg/ajax/clients/select/type_0.html?keyword=sky&_=1751034475603 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCisOkw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCisOkw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [27-Jun-2025 17:30:59] /finance/root/bg/ajax/invoices/insert.html?_=1751034659716 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 83 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` = '10449', `Language` = 'bg', `PostDate` = '2025-06-27', `LastUpdate` = '2025-06-27 17:30:59', `Type` = '0', `ParentID` = 0, `Data` = 'LvIy0UZ8v69e_SaMdmQCOzmA2-jv8_45M73USTqqhsieOMQQZ-ATJu17ofqPzq68WaBAT2qqEdd7aCFEuJUd59LTUa4Pxre2AG3wZp1Nado-MuJoOyeHem0v0-1XWw1QR-d77PqlTXy1t6M7a0FdKHMenBAarJcOHZqt8LlTvWvynzmZJq35tA2Bv3jqeaT8S51u2qtDycPPggx8SBh02vZthMXEFx7666_z2g_WB5xVUD7QkpPrKpjYWU-FpPRFcXjlqWuUwKf3Cwf7IIM4qRvT5Sl2xMZg3uaGK3FJnnZly18n33FvNOfzBaBHULvS5hb2G6w7-EU0b2PQlwuKSMDK9HMVOeRtwEGvmLFZfNiVMH4nWw5CcCPLYuyqck_Al0lUqVRNsnjmX0_g2B-uhiV4N7sL4AiSuH-RbSBfwBqHw3ablPIWJ4QE9KsRXJzbFBX4nIpboPBtg4u8gOwXZsWbh2rnPqz7PU1GugwO8kKDKOX9kJ56qGpBbCHBM42IFCZPxhAeM5qNpopQVbN-t9jrOEcI1vWuu6ivm-VGa0kG4uuvF47rhROTScYvGlHz88s5Ikvp2IvMcj2CYB_CQeLxNqCuZA1CylQzQVSO7TGxoWXhCP-_Fu3D-9qFaOD4gc75O08Hd5BsbmQosFuvp43MIh4IWRhThFz3I1v6VbrpHSp7ckztOoXrFwDJQyZCRLPv865xOdXkZTVcXEgygf__4uMZ667HhzNaVMF71jLFJ6TfaSxh28CQFeW3XG5hGnNyr-mueAcMR59X5KfiVZKRcT3dFCk5BdYf48Sjl2JrKbQij90oLiYAm2QlDz-8QWMzC3L9eQMBhzq6FFq1aeuIsCChstvMdj0wy1jx_EdQAIiIUJJ_7YAegRfN-2_uH5xs5usiWPommd89vemXDrq6aGvKNLs7iilUwOn0-eTBL_CvGV15EJQj9rfCJzyQuWY_Zp43o7zjzbGnFpeR8fcFHwScEpS_iLxCecfbCx7jvLbOc0gcw2sY29P947mPij8N0LfkZo_wMn3yZwRbVsoiX2pgD7BoDOdI1GEZ-WavMEQaaSKnf-ZDt5oK0URKi7wgu0GRsMtukRZWjUg9Huerj6ZU-yrWUTafmfeOxQ4_4YX2SiuEP8rTGrcUh8ucrhCiR0pOgwSK3v6Dtb9EdCnCSz_UuPVlEJPY_SboJinxquaxJ4av0Q2T-fZiNVxbVNH1sEYb10oSKN-moeCm1Yq3P8_46DG5Pfg_7mcg2ZRCwLUm5s7lD1p0XNdhLsV3uymKNEe475rHcTrmtY8tlXFnz7QC72kwEpejATTUIOHl-kPOAtRX9aAU6CDb4CZ_', `SearchKey` = 'wofCscK4wrDgsOgwqDq8KDwqTDmsKrw5jCpMKdwqDChMKhw4DCvMOXwr7CjMwofCpMOIwrDg8OgwqCocKDwqTCwrrCisOkwqPCp8KewrLDqMKtwrDCwofCscK4w4DCtsOgwqCp8KDwqTDgMKrw5jCucKdw6jChMKhwpbCvMOXw5TCiMwofCpMKjwrDgMwofCpMOPw4DCtMK6wqCocKDwrHDgMKrw5rCucKdwwrHCisKpw6TCp8Kew6TDwrDCr8O'
# [27-Jun-2025 17:30:59] /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
# [27-Jun-2025 17:31:02] /finance/root/bg/invoices/10449.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` = 10449
            LIMIT 1

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