# [13-Sep-2023 09:24: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
# [13-Sep-2023 09:24:26] /finance/root/bg/invoices/2090.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Sep-2023 09:28:33] /finance/root/bg/invoices/2091.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Sep-2023 11:11:43] /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
# [13-Sep-2023 11:11:51] /finance/root/bg/invoices/2087.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Sep-2023 11:12:07] /finance/root/bg/invoices/2073.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Sep-2023 11:12:27] /finance/root/bg/invoices.html?from=&to=&keyword=spisanie8 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCi8Kyw57CsMKewrLDqcK0wqDgc%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [13-Sep-2023 11:12:38] /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 '%wofCpMOiwrDgsKlwrPCuMKDwqTC%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [13-Sep-2023 11:12:45] /finance/root/bg/invoices/2045.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Sep-2023 11:12:59] /finance/root/bg/ajax/invoices/form/clone/2045.html?pid=2045&_=1694592779264 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2045
            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
# [13-Sep-2023 11:14:18] /finance/root/bg/ajax/invoices/insert.html?_=1694592858355 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 5 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` = '2092', `Language` = 'bg', `PostDate` = '2023-09-13 11:14:18', `LastUpdate` = '2023-09-13 11:14:18', `Type` = '1', `ParentID` = 0, `Data` = '3YObm1Tgmo7BvJGKsgXyPKrgLTqXbK6OtJ6gydwmKx9t1xyKY5CL1FvqKWP58XPkFcGNu07XkT9SPYAn7sjrVSFKAfADTE7uqa1q4Ao-MuIyd9OB1hEwePdzURwJ-8qrjH5FjpY54QhQWrm36LJpBCrW2Z8DtaI0yYcHV6MeA1aJoxhDV3kvrTX5myj00hutF39F4R72No1o99MJ1SnTusQUZvvHuujTuJ9neklLg7RsMvsu6RqsnS1-NUqddHjRnO8PWF1jeuwXsvrtK-ZtfLp17gW7HlJNoo8eESz8COIyO9Gc6XlXyx7w4L6SEVabMZTVCMpieAbKe2lRuZGCCQxktyToIeNfg2ul1JR4lG2ESy5GlBGs0N44XodAbBc7yQVWOlScT8rjnK7yIg_50nWYSykk8ei9kH4rSrhzQDpkrHRfIQNN2YgH92pCrtE9t-zvQBUYP-tGyJUFBMG59lHI1o-xsVWwsCh3vTY3MH5BakEQ7NeqwC-EVMtSky2QTe3pNlIoo7Y20aiSEcfswZfgeYhjlLQjP6JfPHazHEoOnEsfRU4DBxAOlr-zq1Hvf9Pun0LhUISp-UxOQ_NFNOHSK5EH7EwIougjPAWavD5aL9JjtdISzuxA9E6ThxVXkgMD9BSjnDKnNgjVgffgLNei_1FoubJOts7LxHbz7O3QmzNi2bCAqKIkXG5ahH5qnOWF8A1Zy_1kVFOG4BEI6X38IBGWf5aszA4QaPLSMKo5Uk9n6A8E5WavBwLew_9su3F99biiFHaGfgWXVdcNir0KgnxgJXIHXLEuk69W92a-uHm5CqthQrbXQCxRU6khym6M1NK1Vrlxmud3vmg4TkprqyhpDdqA5L_qyJ3DhiStxup9HmRijfxiJFy-MIjRCqQf3WY8y2-wLph3Qr9tKntn3kiJdMdLU3nWqNk6yxBQxekRNqVQOOXXYs2q3OkrgNg8wT7SDR8PXBdxhFRhOcLAv5SdNs_sj85eRnkQW_vMaBWaLRUHcU7TOahedwIDNPBCpBKcdMGe1tPsJ38IvorTUuKU__VewM-9A9yfrSnwSI9lJQ2T833ZCSaJrrXYR8WZp7OX1hYzPFgLAtZejFYiPDmC3-pAk1ImGi0FXn01yrXueTXDGcgKliKRHrSz43gAynP5JJYvEylkrTIFWvY5xlU1NBgxhBoO-22MdMn_xYZUEjyixEloPBh6r8T5ezBIJH5RMHGGXNiFh8zgtbiKGHqp_pE2Xl9j96dQ8ep7YzRKYYSxh8-htlWAZcDY', `SearchKey` = 'wofCpMOiwrDgsKlwrPCuMKDwqTCwofCpMKnwrDg8OgwqCwrrCi8Kyw57CsMKewrLDqcK0wqDgcwofCscK0wrDgcOQwqCpMKDwqTDlsKrw5nCpMKdw6bChMKhw4DCvMOXwwofCpMOEwrDg8OgwqDrMKDwqTCsMKrw5jDn8KhwrChMKhwoXCvMOVwwofCpMKjwrDgMwofCpMKjwrDg8OgwqDrcKDwqTCwofCscOEw4DCtMKlwqCrcKDwqTDnsKsw4'
# [13-Sep-2023 11:14:18] /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 '%wofCpMOiwrDgsKlwrPCuMKDwqTC%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [13-Sep-2023 11:14:26] /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
# [13-Sep-2023 11:14: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
# [13-Sep-2023 11:15:06] /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
# [13-Sep-2023 11:15:16] /finance/root/bg/invoices/10371.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Sep-2023 11:17: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
# [13-Sep-2023 15:45:29] /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
# [13-Sep-2023 15:45:36] /finance/root/bg/invoices/2074.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Sep-2023 15:45:49] /finance/root/bg/invoices/2073.html 167.99.142.201

set names utf8

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

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