# [08-Jul-2024 10:50:51] /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
# [08-Jul-2024 10:50:56] /finance/root/bg/invoices/2269.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` = 2269
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Jul-2024 13:49: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
# [08-Jul-2024 15:11:06] /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
# [08-Jul-2024 15:11:20] /finance/root/bg/invoices.html?from=&to=&keyword=process 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCoMK6w6TCpsKew4LDrsK2w%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [08-Jul-2024 15:11:22] /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
# [08-Jul-2024 15:11:27] /finance/root/bg/contacts.html 167.99.142.201

set names utf8

SELECT * FROM `contacts` ORDER BY `PostDate` ASC
# [08-Jul-2024 15:11:32] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [08-Jul-2024 15:11:51] /finance/root/bg/invoices.html?from=&to=&keyword=processspace 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCoMK6w6TCpsKew4LDrsK2wovCusORwr7DgsKow%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [08-Jul-2024 15:11:58] /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
# [08-Jul-2024 15:12:01] /finance/root/bg/ajax/invoices/form.html?_=1720440724957 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
# [08-Jul-2024 15:12:05] /finance/root/bg/ajax/clients/select/type_0.html?keyword=processspace&_=1720440729163 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCoMK6w6TCpsKew4LDrsK2wovCusORwr7DgsKow%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCoMK6w6TCpsKew4LDrsK2wovCusORwr7DgsKow%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [08-Jul-2024 15:12:54] /finance/root/bg/ajax/invoices/insert.html?_=1720440777909 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 33 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` = '2283', `Language` = 'bg', `PostDate` = '2024-07-08', `LastUpdate` = '2024-07-08 15:12:54', `Type` = '1', `ParentID` = 0, `Data` = 'QNcQeuA5ure3LbsXpSCyPCQ2S_ABrTXmu0oy61bQdfiBNuWfW4oIM1GpchbaU9N6YUclpgK4rND5GU4E6iJ-XzejuoUjMBmbMPHUEZve-GfZPkfkqnzOK9p7o7gzV-k-TdjXjHXSftf09RIlZ111NlNlBAnDBOAa7LmRSXQg8GobHehZ1hqgaqbi_0bmkEQS74RPtGjBe1jNClSW4n-zRizLgexwrH6hKZNAj2CTID31AA5BlMwtBkeAezWh-HtjjdYIXGYuMHgtSIegPMCva3bT9XMlhjfGN54SuNH74sTaKBD44A4IKgjg51E2uTNUAT-YLpKZxsmuDInQcRU3YKy-vpRvMJv8bBqHD125spTqtrsdx6pw3iUWx0xz5ol3STaKqRs1aSL2PSxszzkIBWuTuJzRamrf91fRbaJLKHVC9xrE2iBO4uhcAPsdPYZ2QiyDHClA51gXLNVe57UooUyNxWJ4-xI_70-k_lsH5Vc6rMs6qBBoCwVLw9vLvVMsIr1heWz6HRcxPeXdrGF4-SOH9w5vx71LJfYXsrirYnIofBjc0rKaHmW7Kzxf29ETuY5RWRD7hs-mvkMyDwzdkvEbu03yzHOSpZUPI6TMgWqohI-gqBqjjgb_LP7cfSlS2DzEXq6b6q9h3xBVNL5jHa-6aQKdAM5EN4U-KIc23dh2y4DgJGaS_C8GQVF6gJTGcNoeRJnGzq5IcW2hFj3302bpa8l2wqzoB8C7hdFgMCeDbjNglWbQg6J-vHHFHySbdo7CtzAeUcQzuqijKhQkCqxBAvOaa5JQpjqfjMKy99IHROqTa6vmJa9YI_Vv1QJWpCex6z5a6mqtlkYdY2NmU69mm98nnz0sKBy6IK0lvrBdrpCa_UQWidRX5bKcQQh4AHQADhLK6zMM1mHKTLzoMyTWhPco2Zj5P_f4FaAFnhlkOvULzNecGT0MW-Gjw06H79U9invmd8D0WUxJ9oXerI7uROEjcYUer_pRYweeK5Vq6WoWEJA3jdXbcz1evJLaF0UkGn3tIsS67xUsI7fBYWI5IMWEM-_4L_3X__CO8lx6dO_ym4T9xCiegnXOoSUw_eM-AekpvkPwaX84RXlVcV8aTrdCdHw_0-Enh_w5kVbsz0IaiMQpqtmQ7vkBfsCdYqJ7_gJoAmB47JpbKASqZMBt4znvssdT5qLTq-ymhLUNUbKwHd8J4GOM71SWWwrz0prBCSa4KNdj1bYb_vOzwdFWbESmSNSjDcn6CTjS-m4', `SearchKey` = 'wofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLwwofCpMOPw4DCtMK6wqCocKDwrHDjsKrw5nDj8KhwwofCpMOPw4DCtMK6wqCocKDwrHCtMKsw4zDn8KhwrDChMKhwpbCvMOXw5TCjMKVwp3DjcKtwqPCusOowpfCwrrCoMK6w6TCpsKew4LDrsK2wovCusORwr7DgsKowwofCpMOPwrDgsKlwqDq8KDwrHCuMKrw5nDj8'
# [08-Jul-2024 15:12:54] /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
# [08-Jul-2024 15:12:57] /finance/root/bg/invoices/2283.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` = 2283
            LIMIT 1

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