# [09-Oct-2023 10:25:56] /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
# [09-Oct-2023 10:26:05] /finance/root/bg/invoices/2102.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2102
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [09-Oct-2023 16:44:17] /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
# [09-Oct-2023 16:44:24] /finance/root/bg/invoices.html?from=&to=&keyword=орлица 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wofCpMKnw4DCtMK6wqCq8KDwqTDlsKsw43Dn8Kdw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [09-Oct-2023 16:44:29] /finance/root/bg/ajax/invoices/form/clone/2046.html?pid=2046&_=1696859069908 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2046
            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
# [09-Oct-2023 16:45:09] /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
# [09-Oct-2023 16:45:25] /finance/root/bg/invoices/2100.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2100
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [09-Oct-2023 16:45:32] /finance/root/bg/invoices/2092.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2092
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [09-Oct-2023 16:45:46] /finance/root/bg/invoices.html?from=&to=&keyword=орлица 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wofCpMKnw4DCtMK6wqCq8KDwqTDlsKsw43Dn8Kdw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [09-Oct-2023 16:45:50] /finance/root/bg/invoices/2046.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2046
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [09-Oct-2023 16:46:17] /finance/root/bg/ajax/invoices/insert.html?_=1696859177224 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 35 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` = '2112', `Language` = 'bg', `PostDate` = '2023-10-09 16:46:17', `LastUpdate` = '2023-10-09 16:46:17', `Type` = '1', `ParentID` = 0, `Data` = 'to8XJjj03oSW2qCi-_AU25iNyg03WnmOsL7B5-bwdQ8hngiQ8vAkEDnm1w2RnE7i7yQr4HoaVuID22tu9vmYghF_e84BOAu7GpyA5rHMX4JMlh8FtDydt-uSlNIvK1nJ8cUK75kS73zszPecROBwkTeeX3BFnqsLmAWrjAOlM8FLDkfU_p4PSYTRVif1tofY9j32WM8e0iwybUpR1G02iIeJlq2Y8k4kstGw7StYsdmEfo6jMuknZZpVoMhbA4IKaJGGq3YLrAoLj7JTERa1PlnfqGghmfe64bbEArDG6qArILlYqn7zKf1JeS1zuhMERgbuseRjB6eqnv9rN_eCpYHgfqVhhlxvtWc-EM8vMnHnGx_X_x7o6KYw2LY4cwyut9e0DouW9CkjDMO-Pd0DwSF1kbGBA2nPcipihHYAJ29JLfjjJCwMzp-t2sCWY70RP8oORBPQlJzaH2Nk27-nAVByVBXPePzZ9Ha54COBD2x-di-JJ_9iQVrG09XpxYvXTLQPvyp-7rcD5sDyJvjUH8aKlQT8Yi3eD_tAXGiLZ9y7gLKnnnw2zPeeJiZNLXxx8EUxZTgM4uer9HZDmRLJ97h1EQQG6QyU2FyNqU-xIFG4XRK_7IeBkJ8pffX4GHi5E6fOAHXVfxvaiDhQHGIikJqKsnFsLdpdpqrdV36Tu8L9Lcr7eKy0D6Guhxa_UFO1g-3HDTh4HD2qz_DsBUfoF4vIv6Vwb6GgyblebRD--hld5rGr3r1-XKsExm3kgnsxkge_EeJC75CXvopaOLW6VSG9u879xNOWnppDyk_V0u6Y8sK8uKF1tjtdXrpNvhg88JAFuNmPoI13gi-IF7Ewh1gnKTvk2MBozvrbEyFtLqQ5s8FP0hYEDUfWlIm4aJfhadkus_wSiRFjtdMmKsJ0WdcTsymgPUUJFr3h1MAoAKe2uPy0w5QGidLFZQ4NxP3vQsSJ22fkYCOmCrGrB3a8JbRuK6nfqz045tOxnIWx58OUxMUo9R_IFTSZmfsf1QOT8nf2f9TekuKVVTwyovpNEdYSIeVvKoYR6EFUkCpVX3v8zmDxPAqtQWPtuneHgTBIIimgs9rN_pYZjXpmkwKn2RhNg-4V12044Bjjzv-LIQirZO-txeRBmQw29-bFOKjOxTHzKnvfMzenfxAD7c-XbrtIYRRPp_KupIXkJfLacYAIbOLcrZzVRH3E8qKw3ITeIce5nud0Ih-SvhzlVmSDMD5myYsoffNP5DOnxllJlAnmPzRjuAWS9aoiY1aioYX-xfsLk78YchX4TcSy_QJDaTSWTB1mbVkqEQ-GFt27bANdmkLsgK7-H7_bXd5L7_PO', `SearchKey` = 'wofCpMOPwrDg8OgwrPCvMKDwqTDlsKrw5jDn8KdwqjChMKhwwofCpMK4wrDgMK6wqCp8KDwqTCwofCpMKnw4DCtMK6wqCq8KDwqTDlsKsw43Dn8KdwwofCpMOPwrDgMK6wqCrMKDwqTDi8Krw5vDn8KhwrDChMKhwonCvMOUw6TCiMwrnCi8K6w6HCrsODwrrDwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8'
# [09-Oct-2023 16:46:17] /finance/root/bg/invoices.html?from=&to=&keyword=орлица 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wofCpMKnw4DCtMK6wqCq8KDwqTDlsKsw43Dn8Kdw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [09-Oct-2023 16:46:19] /finance/root/bg/invoices/2112.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2112
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [09-Oct-2023 16:46:34] /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
# [09-Oct-2023 16:46:42] /finance/root/bg/invoices/2112.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2112
            LIMIT 1

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