# [21-Nov-2024 14:37:10] /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
# [21-Nov-2024 14:37:21] /finance/root/bg/ajax/invoices/form/clone/2352.html?pid=2352&_=1732192641413 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2352
            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
# [21-Nov-2024 14:37:38] /finance/root/bg/invoices.html?from=&to=&keyword=smarts 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCisKhw5bCsMOawr7D%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [21-Nov-2024 14:37:45] /finance/root/bg/invoices/2145.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` = 2145
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [21-Nov-2024 14:38:00] /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
# [21-Nov-2024 14:38:06] /finance/root/bg/ajax/invoices/form/clone/2352.html?pid=2352&_=1732192686069 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2352
            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
# [21-Nov-2024 14:38:10] /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
# [21-Nov-2024 14:38:12] /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
# [21-Nov-2024 14:38:17] /finance/root/bg/ajax/invoices/form/clone/2353.html?pid=2353&_=1732192697093 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2353
            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
# [21-Nov-2024 14:39:07] /finance/root/bg/ajax/invoices/insert.html?_=1732192747096 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 70 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` = '10437', `Language` = 'bg', `PostDate` = '2024-11-21', `LastUpdate` = '2024-11-21 14:39:07', `Type` = '0', `ParentID` = 0, `Data` = '_ZuVCbPJgxXuS20SCfwsM9Jhn7BntTjBk91tOx-QloZhcgGzl3Dvo7IPuDv62NgNQSmBefvZn5DHf5rs37_DOb9v4Y0OA1BZDSlu383fURY3apT82RwkTB9pKqJQprRtoKEry9-1JJ2nyLyMsXwmX6dXcdJEGkmJYIxYhMwSTsJxwSuQViodpt-qCUidt1M7r2NOZ79mB_ML_mA5jqL0Rx6zVLtwl5ZQEQLwS61C3JV0Cd5VPMN_kb5Jgxb3pj1UchPSS4L12R_2W-R_ZxAQmV_5dO2LHviovZp9vVgzEgW652zxXN9rsDBrWEEcH9fNNGZYMVw5r4Ymj_WBU6wSVj1srcz9MVqz-vINTJZSKKR3OCz8LI7f-r6BYaCYDFxa1NFi6EWL8XMxb3IbJy1wUbhb0hH0JQst_ojccWD5RCFzxWpxDRCEYJc9QNngdy7C5rlSEoljun89obY4-hUz3CBKJbuVCQoJ6qUDEQeMeB8qdOW8RgXq5kqAP8maXjrpVcsHhMfybmdztZ3iwQFV2vcpxLp27m9bycatP82LnF0m9VubMsxGxgy6pvXZXYrW7huQZl5sIw_srZVcWiAOnXP-7jt7CdjU1prXQhRZv82ftQ19a1Cktw6VkBZJ1UGkd0kxROkD2DpTWEHztNVKArubZkjaJ-J7u6B2dkdP8Afp47fvL09h6rGsF4IsTm4UoIXIq50mKz5h0zeBKwimvIrh0DHPrnQE2FdEb5MpHDuUXVtsyI7_MUlBs4KQvM1F8l97lWMUchUhoiW7YONAz7oHEgDh7OQpl6qZe69jARfA6h09RmfjpfxO9_S3Uj3wx3z2YQp8OWD_PZFuhu7BJbAByI_NiAYpI4FOPXrsvpw1h-xgraJOCSc_kpjrobAh7RptcCGDAcfbi109yehT73z_8kIdIimxWt-zLCR_7l2r7XXmlaqB5rH3kSJT87GPjdpNASv-DBgeIJpo3yRb7Q', `SearchKey` = 'wofCscOIwrDgMK6wrPCt8KDwrHCwofCpMOAw4DCtMK6wrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwrjCn8K2wp7CsMwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscOAwr'
# [21-Nov-2024 14:39:07] /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
# [21-Nov-2024 14:39:09] /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
# [21-Nov-2024 14:39:13] /finance/root/bg/invoices/10437.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` = 10437
            LIMIT 1

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