# [04-Feb-2025 06:34: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
# [04-Feb-2025 06:34: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
# [04-Feb-2025 06:34:31] /finance/root/bg/ajax/invoices/form/clone/10439.html?pid=10439&_=1738643671244 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10439
            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
# [04-Feb-2025 06:34:49] /finance/root/bg/ajax/invoices/insert.html?_=1738643689895 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 16 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` = '2421', `Language` = 'bg', `PostDate` = '2025-02-03', `LastUpdate` = '2025-02-04 06:34:49', `Type` = '1', `ParentID` = 10439, `Data` = '23imdqRcOwgOPfRxyZUe9CR16TBY7JyNpTK16dRVLL0T6Of_iuJy-X8w3uGcHFXV4HF8VFi0pQMMGgRK4SRgJOsMdWjcl7Mj_xzECclrxhu4-M5WJU90d_xTtBjXqHIMbULUxisJHoLSambfC-_rCcYsSd-58b749Pjepe-gR1J9FlfcbVXnR-jvp-MPlM80qjkIKs5Hg2JgdBEZV4eMXdSEW6gXS7ZM4SxJCaSZjXimoROdlU2ZNIg8EZ92riBk2PA0LbDVOgefDpmADPeVDsl-_ItVRzykSwWxQsr9MhVMmiS9mZTCzJTBTA1jH22Uf9kPnHHee-Q2cU1r-KSFczpQqGjs9ryNqDFMRh9-n2FfC2rOhnL71XBLa7nOLE5TXQiQtZEdk_h1asbC8X-39OBUAEyNtBLqoIrLiGWYEY0liM5EfQ1uz91SpNfZdd4wDA-wjdJm9WKl0mau_c4XgsctZFBxbRMJr9fyptLGQfc9waJQrOJk_JfjgS9iEVIZPIOtYU40AsTybsL7_Cw9Okw3SNESu7GWFJpgv-K1YlCsn1igT3RCsWmzehyuZvMPGbiXksm_nDW25CbZdzv-oXFJvYJITphI7icDM2dSfFiThmK1ttGBP6aBMKwhhpgjYBO7ZbQSk7xUDFEEA50zFXy2n4LHhc8QmfW7lihGwKJEUYE99hZ6uqb8rRKt3xShmkh54ojX4I8MXpgtF6-cpBmh65PiIcqJk8DN846na28AxfY4IKJ9_5Jm1PFfAvC3afrhIAdfv2Wysyx6SOHSlffZn0WPBFHgUubEgq0nPpFamUuqPV3A5vosC0gkvQl0ZQh2M00Y2ftb_LT_6CkFNhuiQ5RAZXA5fMpoX10yuvKuU07tmc9Ga3jD3TlQYgC4bLDAMMZ27kUtZr2rfh7v-LqHV8mg7kRQnw9Xg5yYGjLqIm7qQ_qoRN6KR4IKAjKKFW0jYzOgA8FYFXJ6su6y5K-TcIvLNxrYly-0lKzdwudcrwtse7C7UGoZPH0rI53UZSghiMxmYC7tb0UhzytNBQajQx574d81Zpu4JMq5M_rvgPPkri7Y_JCtBK3xQO-Td40BhJsKcAqRnljAt5WZZh_x8LDkFlYgYG65Mp_RMiUmj09ErMBo0Nb2WnwT8-_b', `SearchKey` = 'wofCscK4w4DCtsOgwrPCtcKDwqTCuMKrw5rCucKdwwofCpMOmwrDg8OgwqDrsKDwqTDlsKsw4zDj8KhwrLChMKhwrzCvMOWwwofCpMKnwrDg8OgwqCwrrCisOGw6fCscOZw5jDnsKtwqDpMOQwrCncOGw6nCuMKcwr7DwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rDj8KdwwrrC'
# [04-Feb-2025 06:34:49] /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
# [04-Feb-2025 06:34:52] /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
# [04-Feb-2025 06:36:20] /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
# [04-Feb-2025 06:36:20] /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
# [04-Feb-2025 09:05: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
# [04-Feb-2025 09:05:52] /finance/root/bg/ajax/invoices/form/clone/2403.html?pid=2403&_=1738652751967 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2403
            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
# [04-Feb-2025 09:06:18] /finance/root/bg/invoices.html?from=&to=&keyword=tricom 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvCoMK6w57CpsKewqXD%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [04-Feb-2025 09:06:46] /finance/root/bg/invoices/2303.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` = 2303
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Feb-2025 09:09:52] /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
# [04-Feb-2025 09:10:05] /finance/root/bg/invoices.html?from=&to=&keyword=tricom 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvCoMK6w57CpsKewqXD%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [04-Feb-2025 09:10:11] /finance/root/bg/invoices/2303.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` = 2303
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Feb-2025 09:10:13] /finance/root/bg/ajax/invoices/form/clone/2403.html?pid=2403&_=1738653013469 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2403
            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
# [04-Feb-2025 09:10:19] /finance/root/bg/ajax/invoices/form/clone/2403.html?pid=2403&_=1738653019332 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2403
            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
# [04-Feb-2025 09:10:59] /finance/root/bg/ajax/invoices/insert.html?_=1738653059689 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 68 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` = '2422', `Language` = 'bg', `PostDate` = '2025-02-04', `LastUpdate` = '2025-02-04 09:10:59', `Type` = '1', `ParentID` = 0, `Data` = 'WPLRlm31x9Dg6Lv22vtyAoxtvsGppoxBBWn54UOa_kjXSB48a4z6FtzIwqUv72p4sHann07ygKzRgBF9sHlR9dNrBeAisOqnKFqX4slPWv4TYvdwl4XDbus89hNJbIzAjYKGG_FpQkOaAsf_f2xlvL9B64bgfsGbxEPjRm1VQeIoUfq0ZdTBXnwayHWYKHmv1bdBrTwmelL8svKMIqSeBOoqtvWcy1HSLGYcz4avDQvBPzBM2gad-vNpzRgegs39df_bqTvTnFTECnx5mufVCregkVusal4mkfxR8_2OsE-lj3T99CkoX0QbvnqCHN5kz5TLHXvoCOCjMKH7JEfcFvbe6bdiJpU0Ej_UZ4TH6gnizRFJtQQpQeAq4dVj9L9xWli9YLPc0rM2Dr1itcbnq4vyzSvb7LplEdADDKWyxgjNn8_uDyvPKflhCAIlW91TOztq3goT1fLFnSYVIqZKLxTkyRDB4_da9HlxSZjpl3fIFQ8imhQ_A48xzlqZZrtFs4EVRU5LOYZvHgGi9pvko-lDeWLl43nfsAbcX8mLy2qup1uYOE0O911QX2YxTrHLEqZV7x2NXqBpHPeSITrCG5tBb5gnJSNALYToADUNRV-OmoRalWgcrK8ae9X6jBp5fuHZeqy1v2m8bS45tzMdZw_bUuFeEwelU7Q1uwQ7ha1JM5GBapl5IskbuvRaTynQAJSLxTWOHkv9WLKHJyC_S1lBMiJNNn1oJbj63KnaR3YEkzxCUPBGb8VMLiqNvyTUB5gilsj9XhO1v-11LD_-l9z31lFJyO-b91Yy1LA2O9Koy_74dYPOv3GHdpp7LNpHZJu-IF1gfABjQ9MSnpXCtxU0CNp0tgitV-34BYgh-PnecXcK1NkT0WSZn7czaBeSe_lW4up4S0oMlmnl1dhmB6e296t0cjJ7YTXMUTTglwB5KEq4P5PuGrIBJpSt0NSBGv9k0WwVvPAIiGbpSqix4_KQPQw_b2YP67Jyp4p4FBf3MwbMeieB6l9Fpc77-5GzaM64Y1QcLkTpga2pH_Q_oJos9WjBQiDdZmWYUXQMXnEmK5NMLvXjJ2AtadUyiiv2wIr1jhWOzfwxYTe3oXl-uuOmalxM3dDVJzE422q76O7kMTjd8-ItzaLlH_zhsjozyzjrMXoHHM7e1bQbwy6hHo-CC6HtWyF0DcZBve_pQOf_AJJAP6L4tAyqxrGpTwq1ehKw7lhdhG4JGXfz9rFmSA', `SearchKey` = 'wofCscK8w4DCtMK6wqCqMKDwqTDnsKrw5vDn8KdwwofCpMOAw4DCtMwofCpMOIwrDg8OgwqCocKDwqTCwrvCoMK6w57CpsKewqXDwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqC'
# [04-Feb-2025 09:10:59] /finance/root/bg/invoices.html?from=&to=&keyword=tricom 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvCoMK6w57CpsKewqXD%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [04-Feb-2025 09:11:03] /finance/root/bg/invoices.html?from=&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [04-Feb-2025 09:11:05] /finance/root/bg/invoices/2422.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` = 2422
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Feb-2025 10:09:21] /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
# [04-Feb-2025 11:50: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
# [04-Feb-2025 11:50:10] /finance/root/bg/ajax/invoices/form/clone/2405.html?pid=2405&_=1738662610539 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2405
            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
# [04-Feb-2025 11:50:19] /finance/root/bg/ajax/invoices/insert.html?_=1738662619669 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 72 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` = '2423', `Language` = 'bg', `PostDate` = '2025-02-04', `LastUpdate` = '2025-02-04 11:50:20', `Type` = '1', `ParentID` = 0, `Data` = 'bZjow8t3ig_SnJuo69U6OlmbS3VNGwXlLdiumLSZ1OgtDwHEl7qdzsYX5vxWUT6Hh5EwECRy6tyySJDFzMsugmWJtP26Yg8eZNWf-gWCui8didakD7lZmZnDiwjVlhZBUTXbS2jRyghs_ued0hl-FUf3JjaW3KvQA2c1tGa_FxD-rKpl0TyvZc4BKrB8pu_kJrVQZ8Rj3p99a0L8UluuOtebZCGENFVRy7W4dMUSSSUHFTWawG9Yr_QaA7l7HDvEo9i4Ne0G7ye2XAXyFkFMxZ2m9VSt2XX2bF8wpcn2aqrHCUBlV_tircAUeeZYEQ1K1ujM5qDkWciKfqaKiw18HSCpKmWMJRczXKLIfapgcelkmGxOMr9ByQ3VCf18mNs4RG-r5jJ3ZmhnuQRxevJWHhomKA6WhUG53s4xpL4GR4MAXUaVHPvX6MdkCUPCNm3c2vPVLQEbhocaOSfNKd-u9k8OVaVPUL5xYwR6UhaRdOb8RtDrMr2p9NieCdQMhGYki-qdp_GnnMCPCV-lFqNBe4xYnROXrraj9n7u4TmP5XRKoVJnh0YmgYOGJ3MlstdFs-KMVKKNoUX8cKw3MPtOhhKXg1tCyB-OV7J1MigFg1pGCe6rCmunqJ2Q8uf78vSsqSFr6Y6-E7KcY40i92yhPXSUeubljooCPRkiGUL7oz4tBP5SD03LNd0PXN5DBa569SEOaE8VdNwV8XOczK1Z5VxhrTiV-OC-kSGrzP2uZq2ioH3tCDQq0ARbXjCbElmfe9YImBlWrmAESn4rd5h3RSDx8vT8AwQVq4-sSYTNHuVP6Ix_Mn3MfNJCQefrqIAW3tJXGyyQVNTrd6DaVCW23tQ3XejkS4VKbWFDkKSD-S8R74JRoYN3OPuU4e2rbbJEPhRsMG691oJAc80wSwNqzTRYLzC1dwOty-hxf-tofgdwsk5K5Gx7b_RecOisNAlp', `SearchKey` = 'wofCscK8wrDgcOQwqCwofCpMOEwrDgsK6wqCp8KDwqTCsMKrw5rDj8KdwwofCpMKnwrDg8OgwqCwrvCn8OGw6LCp8Kzw4LDrsK0wqDkMwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4wrDgMK6'
# [04-Feb-2025 11:50:20] /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
# [04-Feb-2025 11:50:23] /finance/root/bg/invoices/2423.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` = 2423
            LIMIT 1

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