# [28-Apr-2025 10:27:53] /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
# [28-Apr-2025 10:28:06] /finance/root/bg/invoices.html?from=01.05.2024&to=31.05.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-05-01 00:00:00' AND '2024-05-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [28-Apr-2025 10:28:49] /finance/root/bg/invoices/2240.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` = 2240
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Apr-2025 10:29:11] /finance/root/bg/invoices/2245.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` = 2245
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Apr-2025 14:07:18] /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
# [28-Apr-2025 14:07:25] /finance/root/bg/ajax/invoices/form/clone/2452.html?pid=2452&_=1745838445208 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2452
            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
# [28-Apr-2025 14:07:39] /finance/root/bg/ajax/invoices/insert.html?_=1745838459707 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 11 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` = '2466', `Language` = 'bg', `PostDate` = '2025-04-28', `LastUpdate` = '2025-04-28 14:07:39', `Type` = '1', `ParentID` = 0, `Data` = 'mh7YTO5Gt1-58fnrsuHy-FbpOf4BAxxz51-2DoQnW-VerU5sF35H05PwVVqiKccunXIQeMT7TOwDP11R9Z49ZNPsUako4CJ3zwuz_d95cbkOA9hTB5heQVpZ4dtj3b0mAElvx55UmRc1Jpmp7Rc3JJw7JienbzbYo4TKpeKXDHXx3mbTv6ty_C2MYGuTH0VwF_OeFbKtKQ_oBN6mB5AibasdCAg0U5sR5IgKhYXeLfmuvElrvaXVqZY8FBX_Vfgl6I8_e87EweyImRruS1dQOubcCTz97GXhyU70nkc-ERJKkOQ6U6ZKrqTC3Rn9-vVOqNtxKAVxQVmEJWEttShmqyvOgSQBhYFUw0rgZ6I8jNdzTkYi_WMQ9Y7fm7MZBHHHEAtAuioAkaHoy-KZyUMsKdSACe5U46EZrD2apQFO1UkKT9WS--Tn6waBzEjXLzZ5o4Bk4RzPygi-dywwmS1U1H8bNFrlSwixUGHrerSRvFFlCnFN1AkqYlUwyb1GNKcJM2OCelXjtIGqHf3-AAOKrnJVK5mYBfjd1owdZ1yAgcSK2XU8-z8T_CMXGA5cjWW_9EARmACDH6Pq6OzoQOw8xJBEWrWPOpyAHmvn3_X-FasOaIeezQ51tv1QXhTVWlVJ0EWn4RkUgVTw6iTiqdTwWKQyGzWleeUsjl2ESbxizngl-OHi1zaiG7O-G7wFphM6sZThixqKKuW9fWZoOACskVRDqWC89QtipIjsYNuEw-U6_FZpBEXjooPLZfr8-wGPqG_jJYsHUvPMTi56AuKDfaHEff3dB9kBkgfMVYnwH27QLlZEB77V8hG1MDzWFt24sCZHUgdPMasWEXh70b81oG_kbbz7oHq3AnY4rqHWMOvTNHLr50MqUHbpCDYYbUpLsIt6ySvOTpoZ81yIU9Pt4UmKvhqGwcDW3dvPRwaQ9u1OCX8hqutR6l1BwuE9o7gXIUmLXtg08CMHr1nxDqfQFGyg2trgzPV4QX8dEr3pO7ZZmUKIpGPMw0WFkZcfUn7bzf6PKdzSyktZaAFzFVaKBOx1ylgGUCzEGxJXX8nXyl5OUS4PW9KQRn6syW-LmC6yzGy57Oz4Zt6MBRQRDoxnbPNVsZCOL4n6O8iWmhJEGZtBWEsOTqriDpbv0X3YmHwJOHj6MSPHmgdKxMSCDCQMQ_VynBWXYuBp2WVvpgQApbVugBykKdisR40oP0waWLNn7qE2TTnc_q-bNiWjneNA-UDall211YczpH_4k2o4lcKMzgYWdcBz5lJV8Dc-iR8ItXS7qqpqYp_bc_-W7F4-bf8e3xzqTFIFix-ged1OZo2Z0iZzVrmUbKjmUj0347K4wYRHueaDLNgz5_2W16m-yh14Av_vlgFhJf2PhvreuBDBHreDDb9m_6mjAE9x8rIdS1L0eyLHx4bd1elFNT3uf_MPzNmP-JQdimzltPMdd3M', `SearchKey` = 'wofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLwwofCpMOPw4DCtMK6wqCocKDwqTCvMKsw4zCucKdw6bChMKhw4zCvMOVw5TCiMwofCpMK0wrDg8OQwqDq8KDwqTDosKrw5rCucKhwrLChMKhwrzCvcOJwqnCiMKEwp3DgMwofCscOSwrDgcOQwqCrcKDwrHCuMKsw47Dn8KhwwofCpMOWwrDgMwofCpMOIwrDgMOgwrPC'
# [28-Apr-2025 14:07: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
# [28-Apr-2025 14:07:45] /finance/root/bg/ajax/invoices/form/clone/2453.html?pid=2453&_=1745838465711 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2453
            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
# [28-Apr-2025 14:07:55] /finance/root/bg/ajax/invoices/insert.html?_=1745838475153 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 11 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` = '2467', `Language` = 'bg', `PostDate` = '2025-04-28', `LastUpdate` = '2025-04-28 14:07:55', `Type` = '1', `ParentID` = 0, `Data` = '1YNSyKdzME7eczhW_cwK1ZGQCdEJbAEWOEGjFyF5TCOzeWwkOqN2sa9pFtrbSSCel7ro7KOzlO1LvNyzoVhT01BDNrh67VbcldxTR2B4DaufLVj3W7tJpdUMaoDubk0OPtjyuoQZAaEi7H3LH5RRbjhr6oE4rc5TKgXyKso0gqgxtKeKvKO4PcbRIgkUnlOSDHlb4AD3WY8ybc7j9OYeN2HR_pyy5BkTY5ClRNKtEHd1VykzrZnjdb4wrfn5y1gBtphjkMnoJTAh2Vq4Vae5yHbI_j8lVxw78t_W6pbL5sEn2MAm9EU7Q4CvzJ5hrGONhUo3qS-xo8_zy-lete6hmpartQtbZUUdmfwxv0N6falAJe2smZccfiMELBziaRfrH5d71uPMJet8BH21zplDEy5xa6_4ylNoDvigi5NV_KvdDECUuS2fjEYXHwHCy0q8fNv9iiZnLlyvhB4irKp-7JryAy6WvtwuR52baPkf7KXdD8gJfc-6058DLtB9O9clCxtHx7mrorDTMSl-l4w57zZvwN2KtqH-TlU_9EA6F1Ub8Y2lFh8MctASK3QFOp2Cj0fgfOBXvT5DOCkSFzIWb5JZtpxxSy1e_Dsk8k-abX_kmHsBPo49Q0rGBodV8hy9YFZ_a-pAN_yEHY-XcDUn4PdrId80ZSGZarRyjaLBOlgIB4J-4GroK91Fl-JPGhkPFQ_vvFC6EFvByXV8Hs-9UyKFSZUn7IktC8qMyC8d_y4CYjnnJy1Y5y9Am0yL4u7LNnWSDDVb6vnrVTmLMBu5amysnvEr8Khk1RhgPob7XplEh5xusNjko3uIraC5WCX9fHLIBu5kfAX1Sv5EdT2EI8mEq-fmW0KjusRlyseYnS2MMEtIs8naEc3COdWL8SOgxTUdOk7AZvAtgx2ogskXZ7c8mF9iGUQIxEKrsHSC4eo5b6RBvjfYIaXNfvxUaPkSPBtXNctiS9vzhBzy2z_jytOcnZDg7vHfqid7wSXIAOaJBLh1q-pxsGFyzrsAxvLmot6SBdocUim5rglnPbucOYCUq-YbqUezltqjCmZuSjz3CBhMWN0c9ST8VW4_xY7fIImqAR0VJ4bR6lMf98Iu7wsPueBEfOZBS06ThpLy4t4fr4TjIK02vbW4kLWm70yUwM4rBBndQFU5JfYoE-tvObhUSwdG1HY9BQ5SeB7MFxF4qzuV2FRjJVuxH6tAdo5uXkgWX4j_LKNfu40mAHOMNMUr27mUAD8y7RpldUYXS9usAJ9XbSDK7WLiwIVJ3WzvOgCxVW5s2wlPxvKlv-kyu-SGZVRvAJpJxMiw0g-q9nmlv7nGVZQuhEy3ULdVZJU4CTgiNw4b_A2klfVaBE7UsTd_ZrOVhoI79nlZYOBvVKI4zev0JFzCSDhzGN6VVuEl2w2j-zytw5-ElDyB1-EwuM1DyGoM_5Q5DuT5Km8FfmQ', `SearchKey` = 'wofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLwwofCpMOPw4DCtMK6wqCocKDwqTCvMKsw4zCucKdw6bChMKhw4zCvMOVw5TCiMwofCpMK0wrDg8OQwqDq8KDwqTDosKrw5rCucKhwrLChMKhwrzCvcOJwqnCiMKEwp3DgMwofCscOSwrDgcOQwqCrcKDwrHCuMKsw47Dn8KhwwofCpMOWwrDgMwofCpMOIwrDgMOgwrPC'
# [28-Apr-2025 14:07:55] /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
# [28-Apr-2025 14:07: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
# [28-Apr-2025 14:08: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
# [28-Apr-2025 14:08:39] /finance/root/bg/invoices/2466.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` = 2466
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Apr-2025 14:08:41] /finance/root/bg/invoices/2467.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` = 2467
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Apr-2025 14:22:13] /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
# [28-Apr-2025 14:22:20] /finance/root/bg/invoices.html?from=01.04.2025&to=30.04.2025&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-04-01 00:00:00' AND '2025-04-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [28-Apr-2025 14:22:59] /finance/root/bg/invoices/2463.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` = 2463
            LIMIT 1

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

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2444
            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
# [28-Apr-2025 16:34:37] /finance/root/bg/ajax/invoices/insert.html?_=1745847278150 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 2 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` = '2468', `Language` = 'bg', `PostDate` = '2025-04-28', `LastUpdate` = '2025-04-28 16:34:37', `Type` = '1', `ParentID` = 0, `Data` = '6xPwBkxOEvg6hiceifJchH-NXT0AvK2SavshrDsr4D0zJsHGYXk38TtBpcTqOnVoul4OhGwE5Udv37apUFF17h32MkGQL1yFt66opb-u6gGeYwezpCpo8EW07uJVXKZKY1X3jbovx77vWHcRkW4JxM7QgR-iQD1hxGy4bwhEHnhAC4NoklmEAMM6TahgjXFKqT9Vv7zjfSIU4YAxw65qO4W1oxd5SXcLcGawoUoB4_waAE4s5YROkJC2HRQGjfW7qhJrUEBTurv4uL6UOSVXoAignaUBrxmiJZLFf2dZZuQtj0VivRwTLMQQyXPeFbsWamfR2tvXxb0gawVh3W9JzvKEj46IYmEeF8MAoHLbwecqNyXRKf4naIbCDJqcZAaK6pJtIYPLohOzXa03qZe_oP9iqJQWh_l3LMXWeOQv2O6o7Zwkl1hndDbeCRqjgewyuKtP711Tq-jc6TgM6c7_VQMronEiqU-JnnATTvVt3obu7GgMRwfP0Vhpdr_hkbAal7gyigdbHygDDCuLdy8igYY7tE_bMCB-yu-Y0X_T_cZvrs-ybXI7iU-ltujLxj90poDNJLF3PAu8zLTzgo0MaPDmWQOO4B87bm4JZ6nTUaWq8a-qorZhil0wviErajt8Hfw_5w_O4Q91kt27B-ks0A9y9IjrThVowaAMMRbwNrQha5qZ3FXsdw45m2cztqUBCKRjtIWmNpR1JrdBmLiWE84vJc15zuk5xbbUhIzo9CKPwZL3nQwcEKx5bMqLanEtuAR_Ceejbw0IJlP5s_zlFTEgvhGGVRgWUN3BX_QY6TT_6TIM0a0_fFQZ3mF2rcf08GlDbwlfOBgGylDQv0aTWL3dGCtl7Ab7wnVY5Zw3zDE21JynFwNjzjaJ2OeSWbjpaEplfNdbxuBtPATHRBD5J2ZMJI0xmTtvduzYf76iq_qIu7q_qy1A63TK8raAqpFmmj7wOp_qvYMU-P9eJ31_niLu0fAQQpDcIbw1GtNxlFkHrZu4uE-11wR6MaJihQaY8HyDynL6IYaRdKqfLeRtIw', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMO'
# [28-Apr-2025 16:34: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
# [28-Apr-2025 16:34:41] /finance/root/bg/invoices/2468.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` = 2468
            LIMIT 1

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