# [10-Feb-2025 12:34:29] /finance/root/bg/invoices.html 167.99.142.201
# [10-Feb-2025 12:34:34] /finance/root/bg/invoices.html 167.99.142.201
# [10-Feb-2025 12:34:41] /finance/root/bg/invoices.html 167.99.142.201
# [10-Feb-2025 12:50: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
# [10-Feb-2025 12:50:56] /finance/root/bg/invoices.html?from=&to=&keyword=ooyes 167.99.142.201

set names utf8

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

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

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

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2311
            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
# [10-Feb-2025 12:52:54] /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
# [10-Feb-2025 12:53:11] /finance/root/bg/invoices/2407.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` = 2407
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Feb-2025 12:54:11] /finance/root/bg/ajax/invoices/insert.html?_=1739184850852 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 62 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` = '2425', `Language` = 'bg', `PostDate` = '2025-02-10', `LastUpdate` = '2025-02-10 12:54:11', `Type` = '1', `ParentID` = 0, `Data` = 'MJrgZQiR6xZZoCUVHfg5nbs_QdtGLNvGLd9bvJpBgbl4kkDP68xEHr_xzvlu7fxoXs4LxhryG8ubP52GtpOArRpOFqrbIu_rDkXSaO0mE2lZDr6GerDV9Hk6QULe0Z5I1BhUS0i1_hxubcha18WELDo6EGL5B_9_EXQ1J_-FRlGlZVzrFlJRMys9jrzCrPkDy3r6FsTDa5YNDneOZ6j7jycRO5IVMbsYbqJmupiM1Kri3WigMvOqd2Lz_N5n1jj_25GqEq9S3AGnolxDoaI1PpA83kpTke0Lx4HZXC4qKBJ0I1NFfDJIUwgFAJjMPaVwGjCr-Os5J8Ge-djZYmnSpdNo4OwH3eWcVdD-N_ObC1OGJv9Sd-aahNdxRDV9C2bl7VQ30H4fp4DiWuMIP71qe8ei-smEbfRHZvOfqtCKon2BXt7yKEry0inENwvQP8KnBwWGmCEXbZLeitum1v8Cued_6sIJ_eeX3ijgFUf2BgthFv__jNutK-dKQGQafleRNzMnKRPumbog-FKFi0eqVO35D7hWwLLvmOgO0fR7cjCQYO9t4XK-vPpYuCFeLVVmrmg-mY_ZnoX9cb28cxztBYDlAOq5G1qOJAalL-0GlgQU7JCS4yfmrOmATpMjOuiIjWkyfXWGsdKQHnVBGWnBA2cTGUkmHOSEg_si9rH17J63-af1aauoYHoQbBi9xGXAzNG0aNFj1r1Q_u-HEkGT4dOR1hYPSPYFfPDJ9pf3Xda7qHDQpWV3mtlSkDyrAPMMs6NnexqvLdw5z87luHD_yuYYFlD8WQ3652bFz1iLvZpXJZvdR6MrpmWQURACRFrqwnsGM4Sq1fKbeQvQL2o-kxKQtdvjU61odG2GF0wOGGlUhLeXzkO1XINjAptwN7LA8mfERZtqVyYQpaF9Yz4k-MnnZaB5flGj7mpUTVaNSy6yiIshz3_MGM_rJtDXBRjupWf7KY3KHZqQOhu_dpaICXTfcUmdtl2CJVeKsNLH_TQmlX4SKe3CyFFphlLa_aAS4s4UE3du67hnjzH53qRbfqiasmQCnQAxJvk2rkyirivnW4nbaRqWJVSILpoMXisWfXRB9ZDJLQcSZOLNX1WteUXluZaA91IDADz3Hl6KxZXjKZ8ONvg7LBC-0gSWJThLoGZ093GJXDI2kgCLM2aT8yYLc89fjS3aWtvoR5_i2_lstvgGybk1794ToWF9Cv1jJ1tD7HFY3hDdY2oE9fwH_a4O1TpaUsTsr5CuUtVTfqm63rNHnbQELqwLIdNrluuOcysPf-vBkfBu26yo8RpkPXEy63b5Jnw8-xuFIygPquBQ9Hm51dilZmPjWQdnpRuf', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwrnCisKpwqPCp8OEwwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4wrDgMK6wqCqcKDwrHCwrnCisKpwqPCp8OEwwofCpMK0wrD'
# [10-Feb-2025 12:54:11] /finance/root/bg/invoices.html?from=&to=&keyword=ooyes 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Feb-2025 12:54:36] /finance/root/bg/ajax/invoices/form/clone/2425.html?pid=2425&_=1739184876166 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2425
            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
# [10-Feb-2025 12:54:49] /finance/root/bg/invoices/2415.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` = 2415
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Feb-2025 12:55:15] /finance/root/bg/invoices/2399.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` = 2399
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Feb-2025 12:56:00] /finance/root/bg/ajax/invoices/insert.html?_=1739184960146 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 62 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` = '2426', `Language` = 'bg', `PostDate` = '2025-02-10', `LastUpdate` = '2025-02-10 12:56:00', `Type` = '1', `ParentID` = 0, `Data` = '0M9hNLijc18e8PH3obHKzuFrRDI6g6wCZrZvfMx1az_nyIDkI4PdPcoFaoOWh5WguqiHs5EWeh77Bsleh_s1Dw8ZAR2RYgSDPrpmpPQ4lqiuWzB8KQ8i3qWy4K1U6NQJdf1wEX5X_M94WVPJW0HtedTpFnfIUcvOVN8gAEQS1aazBHGbwjqGimRL3TNTgv10gy7WvAKofOdsgi9Fi2GbgU832CSNGhP6KPSnJ7gNnrmPtJ1GJJG9S2CjF9_dKIuZt6AFILku0mUnYvBmPxnfr30InXs29uvcfXPQuvU33iQCJrxME-UUSSKtwVGdkseDUYz-6chbfYtzqHcdrOytDRkJ3to78mQleMqV-mKxCzYi2iT4KVHLwy6vz_asvCXrV-Cggfb5q_yX4AD_yVt3bjmJQGpbSNGUDbwaXLcvSp2cq-djND4ayUuU5ioz8cdnjJtZGbaGnazphb7bDcgkhAn8RjspYgpUxnm1yOohYOz_fJ-fbiWLv-k2zuMmCOKAWQOfwLtU2SVQwurKdJ8X0_hWnN3CGoR4PlzaYcSL-qdFEyddBRnGZOw_hfJ8f3x2BvHJy-ijfS4j3el6cvN9VpUUjeRP5cmZEghgHUPGAxLUffD8HT8ADtPhV1JLYglTAWyevkbg3jZDp9P0rBFeujndif_KIy3GBa9iNHRPQFHKeLR3fD55-J8eZhrAxDvRsMzjxADCABbtinDOmn58NpynFERRdlOnYbRxIzNPSiWNQXQd6qKGSOUYY32usmBMMD1GP-YpowpIruslTU9C20hDNR19lcnWzMWXzbuOycxdvdUdIQ55Z-8DK1mfAd0Zu3mpEBMkeR-yLFyJhkwX7HTMccGoXl-wlnudsRWSot61bLwuebDLQPPDgfFzUwTPufRyloho5gThecAZgNTd4ii-cFRZbYTLF7YOREwoomPvcy5fPBI1yCNjilge6dzx_eWhCWleKiJQcTtKP3VGgydCK1zsEjzhuqy8LzeFo-ZUKkEAQ-ftq2YFxWfQpkZ963nv_FgVHOQ7gVqrhg6_92zTJaerV2whHQaPp8lTZ6hss5_XCGRQzebyD8QbxgFI', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwrnCisKpwqPCp8OEwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6w'
# [10-Feb-2025 12:56:00] /finance/root/bg/invoices.html?from=&to=&keyword=ooyes 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Feb-2025 13:01:55] /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
# [10-Feb-2025 13:01: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
# [10-Feb-2025 13:02:03] /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
# [10-Feb-2025 13:05:04] /finance/root/bg/invoices.html?from=01.02.2025&to=28.02.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-02-01 00:00:00' AND '2025-02-28 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
