# [26-Jun-2025 14:04:19] /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
# [26-Jun-2025 14:04:21] /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
# [26-Jun-2025 14:04:24] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [26-Jun-2025 14:04:31] /finance/root/bg/ajax/clients/form.html?_=1750935871297 167.99.142.201
# [26-Jun-2025 14:05:33] /finance/root/bg/ajax/clients/insert.html?_=1750935933579 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` = '82', `Language` = 'bg', `LastUpdate` = '2025-06-26 14:05:33', `Data` = 'NMjLkwmcHON5EZS0n4f3OBl2ZhTYv0uczN4epStdzkLKWVC1Hk5hm8l0fkfQXoTnizhlMMzvGm5CsqI6T5N7uP5y9J-ZUUocSyrlgv9dVDOjWnF772T0QKGcBsAtj9I28w-zlOGRNpudwSlxCUOyUFjhEYV8qUf-Kboly-SH7X4CrpRfTNUWfP5BEmOO3l6YDo8hjor1O-nJVTT5vYLtvtX1rLmTosAzvzgcQxC0GCkjVJGTZke4qKzFXRSUA28w-Yqr_x3dt2x7urYDg5EYr0WtMn6xcW2SikEDtci21wYZR6CspKbhNg8fJJ0cOWTL6fqVAygAZd9A5J9IanzUmZpNq0IluKsYA6F8Hl4YLnU', `SearchKey` = 'wrrCn8K2wp7Cp8ODwqHDwofCpMOPw4DCtsOgwrPCt8KDwqTDlsKrw5vDj8KdwqHChMKhwqrCvMOXw5TCiMKEwp3DjcKlwqPCvMOCwpfCpcKCwoCwofCpMKnwrDg8OgwqCwofCpMKjwrDgcOQwqCpMKDwrHDi8Krw5rCpMKdwqXChMKhwwofCpMK4wrDgcOQwqCqsKDwqTDlsKsw4zCucKdwpzChMKhwwqTCrMK1wpCmsKwwrHCpcKgwpzDhc', `Top` = 0, `Visible` = 1, `PostDate` = '2025-06-26 14:05:33'
# [26-Jun-2025 14:05:33] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [26-Jun-2025 14:05:38] /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
# [26-Jun-2025 14:05:39] /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
# [26-Jun-2025 14:05:41] /finance/root/bg/ajax/invoices/form.html?_=1750935941357 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
# [26-Jun-2025 14:05:46] /finance/root/bg/ajax/clients/select/type_0.html?keyword=pat&_=1750935946489 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCn8K2w%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCn8K2w%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [26-Jun-2025 14:08:33] /finance/root/bg/ajax/invoices/insert.html?_=1750936113081 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` = '10448', `Language` = 'bg', `PostDate` = '2025-06-26', `LastUpdate` = '2025-06-26 14:08:33', `Type` = '0', `ParentID` = 0, `Data` = 'FYcUIp3RJ_plLl5Ppfwhv-gZDLoodvxdZhcechhAvWF4Je-k03VgbiFzCEktGIFf94--rea6QLr4is7T5ozcB-0hLFxIgbntX9BVlyXkRiYULYtOIsDT-nZ8PlmWgc8SMeU74jNts2wFsdNDOrXobuRznYbCgKxHZDYdciX0V_GOYJB7HEIisgYhoppbWzDvU58E9otzSXqCy5zuwGVL0HKiFuFQWDdI5LkemCRok1XQggUFkiCujUmToZp_Mwg8bz9hBSPe35QDze1sWd60ZQ5ZP8MVA-KHP0xf1OsppWDjUKLBWYXz3CZvLZe08tb43FqlftlD3kEybCbjeG1qScxZ4j1lKzDUehEMnFSXriloQLGNDZRij7pPD-zPmezM-AvMnrQ_aeQkBL_UeN_Qns0UxOYQ9oRThZmzeq95ay_9-IPMzUJvEJyIkqO6Cd3Zvn1ChrdT3gWUoxf8tejT8dgQ4C8PYKg3sJZ2zQcfY4u2eGGdhZ5GlKda7-kf5nc4ElIvHg92FxiWEWj1hkZtOd0z-DIp_yapQEVdG7GNn4yX24-qahL8C-a4C2lbpWMHx1h5NhnKxcNLm3Uf7r0Da3UDhwkvBvVm3tVjOtqlbQsPrsPN08aJ1EKs4Jc_TqxA3sQhxMbwcn2yl_jTiAw6jJVFG5c4-Gg6sNgZXqS2hYkhQxrZWvGtsPjNW3XiKBYLptgIlzD4V4UEAGuwB21QbLSs6c5Q-pEUtibonyMWMrAH2edFoErfP7nlJKfxGNeKJxogs0o2z-aa1sSAD8rVqotFqmlVEUJd9s7_VmJU8E92KXJHjRm34M0Jr68NdSdUi9iL87y8mpz7EJApkIxpm8aTtJlH1wVj31kYWO5w1J2bG8JNcXiMyWQwt_RSZ_7hmw5fmBwOQJ_Vc3BJrNGHHJRV120wgEmmhx2V6AaBVKexc5RHDw8Yn7Z_rwrAt8Pqg-wDnm_M0Ezbhtnzs7OlUqDJ5Mvh1ezeoHOXTE9OnHiXXellZde42Ih5a7Go5pqEWhZgSQL5TQPKWkduPJszzQ3UTs8LrkAxQc1_-cRge46QGbjozjYhUNnr85r4kcdjI9Ncn_hxq90hO4rEkrpmeNkMoE9BdRP4bPkhgQbpVTqbRd54R8edoJr-5znFq1hNI1i5tqx2ZSexw4Nens6BFFFdYMm0cC3iazLkmtI-99U2ftKwR_N4Jc6J5Ht0G9znvGtpP7G-LBeDmckQenqnOzYt0RCwSnozL1jzFxbxOAyHi4513LyST5S6_pOlvHjerz8yXVKMXUkCp6-Pm6gSbw', `SearchKey` = 'wofCpMOPw4DCtsOgwrPCt8KDwqTDlsKrw5vDj8KdwqHChMKhwqrCvMOXw5TCiMKEwp3DjcKlwqPCvMOCwpfCpcKCwoCwofCpMKnwrDg8OgwqCwrrCn8K2wp7Cp8ODwqHDwofCscK4w4DCtsOgwqCp8KDwqTDgMKrw5jCucKdw6jChMKhwpbCvMOXw5TCiMwofCpMKjwrDgMwofCpMOPw4DCtMK6wqCocKDwrHDgMKrw5rCucKdwwrHCisKpw6TC'
# [26-Jun-2025 14:08:33] /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
# [26-Jun-2025 14:08:40] /finance/root/bg/invoices/10448.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` = 10448
            LIMIT 1

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