# [21-Dec-2023 12:45:20] /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-Dec-2023 12:45:32] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [21-Dec-2023 12:45:52] /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-Dec-2023 12:45:55] /finance/root/bg/ajax/invoices/form.html?_=1703155554949 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
# [21-Dec-2023 12:45:59] /finance/root/bg/ajax/clients/select/type_0.html?keyword=ves&_=1703155558663 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrvDhcOGw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rvDhcOGw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [21-Dec-2023 12:47:05] /finance/root/bg/ajax/invoices/insert.html?_=1703155624799 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 52 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` = '10384', `Language` = 'bg', `PostDate` = '2023-12-21 12:47:05', `LastUpdate` = '2023-12-21 12:47:05', `Type` = '0', `ParentID` = 0, `Data` = 'fOrQGWyo236LwkTuGmd0njNDa7QkYMTITiBYRcKeso1WZAD8xAGXb5LcFFSphenrNImvM6BBZQsSUs4joMC514WmldItyRbkZnEjgogw5hIpXLO4zY_-_ldoeq-UTqqL7c5APmTf2dNGBB_pTne-aZCeUgBCXcxiM0NAPukt9u7_k9lplwlYWrjdYMUa1AiTAxEecg0tMoKsEmmxqzmy5MWsjr3LywcV67zbprYX35kDFpLArW8ZG9TvWr8EM5LkS-eWvAZjJV3zj0JudlgEWj-6SRTN__IQESrms0GIKaixtgOdfp5Sf5kcujj85BIKSUcA_seulb6Sf5D2iml3jMyTLVuRCfA-ePe4I8Ajf_USZLEMKVAaUTP0Ehp71MAfGxtkq1Kwa8eog4RFfBehCQSSyerd1AEPJUI79VB-mUsEiRhHRXjbCym6s-qIHp6eYSN8FhPgsbdzFYGeWeERrK4GApKnvjTz85VTzizRczId-O8ZXrVNL6Qt9U3ikyCfKmXtgvAUPE6uIlTqfhKtSR9RqniyHoHVQNsvi699-prRPQ8Prd2ZbCd12xm0jSUPKC5gCw-Tm6SgwNEZw7dbyDuXRIM2MWVCFRMuE_4y4bDzo6jGNd7-315QvrDRaZAhmx1Yy6YdWORfxKkLMcJNls7qOdJfR8ulnRD-N6WY6pjxDalQJ7nJDWvJTRf5Azvr9E1FUqmqjfFl4T-PVHDeUF586ZSv63zjHJBykcflrEVvIFWhetyQ9sJ0mrkghebgYi8RQOGBj0NqpCgjPYFkOCbjuABhW03hZf7GNtEoAuvYRIioZ43fIFtBR6N8TYiwy7rnBRXpL6zSwDkY9x7vhoPiQ-D7ne7M8FdeqyKH76kNRWUMXmWppAdxNhDUn3P4xkXO8gFPEa2JRRcEwCeib01aXn7RQfgkwSy4z2JJoRs1PhWnMvM4Bl60Dc9_uASRU7BKytPP3kQlsQXjiEhw-Z1TzT0IjUaEUz6n3xdjkiaEz4DmWGQ-DHtxykTaO5zKmI1EgmNSvjT6L08TccRubGJYDeVKSkfaayiXcq5LS_U', `SearchKey` = 'wofCpMOiwrDgsK6wrPCtcKDwqTDlsKrw5rDwofCpMK0w4DCtMOgwqDq8KDwqTCn8Krw5jCucKhwrHChMKhwonCvMOUwwofCpMK8wrDgcOQwrPCtsKDwqTDhMKrw5rCpMKdwqPChMKhwoXCvcOIw5TCiMKJwp3DgMwrvDhcOGw6jCp8ODw6TDpMK1w4bCusOMw4bCwofCpMOiwrDg8OgwqCrcKDwrHCtMKsw4zCpMKdwqbChMKuwp7CvMOUwr7Cj'
# [21-Dec-2023 12:47:05] /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-Dec-2023 12:47: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-Dec-2023 12:47:16] /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-Dec-2023 12:47:23] /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-Dec-2023 12:47:31] /finance/root/bg/invoices/10384.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` = 10384
            LIMIT 1

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