# [25-Sep-2023 10:04:40] /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
# [25-Sep-2023 10: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
# [25-Sep-2023 10:15: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
# [25-Sep-2023 14:17:22] /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
# [25-Sep-2023 14:17:35] /finance/root/bg/invoices/2072.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [25-Sep-2023 14:17:48] /finance/root/bg/ajax/invoices/form/clone/2072.html?pid=2072&_=1695640668090 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 9 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` = '2095', `Language` = 'bg', `PostDate` = '2023-09-25 14:18:27', `LastUpdate` = '2023-09-25 14:18:27', `Type` = '1', `ParentID` = 0, `Data` = 'xVwDiQdifwzzLp-P8PQ-newgZczYqb8kPVFdZf-AWrjoFVQGfd96jS9gp7UyGPgvLjiGzxcJyqQrzjFNJZjrX3f929QY0kWgscFJ1eMkchHXpwgfuGco5PC0OxPrcr9BwiGJZtyWLiNE_3JbDD0xlCy1dCPdEUpCqX83tSjAA4e-9dVxmWZu8EkAs5dmY_ul3ExWEXYbRV6Jb4MhiG9xh6rkyYiNdq7uv7imieh0M0iqNmBSqt_F4Sz3Ez_8IifHupeRcFhrc6PhJXGEkdnCOFgPvUF1jEMYVhqV5-FSiFw2skOmQuPXedG_W3dBI30DcwiZLCkJyiP8BZhOP7ZK5thyGsTiL-8JVloVTp_XVeQQ3e4xHI1F8k_zuA2SyAY28GdyUWfsvijVkprlZ5rVvmGWKJlcDgiBJGixGeWjV-HwQFKhokkdx5cGKS6Xn-1VUXkL03Gg0a7FCNv3MoH6tkyaYAM9XqwD63pA0gTiu1T8fKFEVQA4Q-xDM5H7b_BAgUJ_lBgiT66pKiJwhyLPmUxhAbV-ulfvP1zXWt_hK1GmI1cpFjJw3LTqx-bWHiHTMRkGYEkCPK-wlWf6D0hyuKGK1c4Jiu12gAZ5aBBgjYEPcLEg1Ei2_vReQwso3wwAr9bQu6xFruMiIPnPKKTLj86_qNyIMOusDYvzREdbSXGwNS_lZZGvLwjXcIvzouiIxZksrHBt_AM9x6uoEoYbbUOgc51VvdLEVxGWJfhaGWkvUbvWjHddq_WZv2yVJscdOnghP897g8eBUa5wpIUnjokFct1cobJEIYmc0Ztxl1wO6YRXq7_tMCT3nlWJhPM6ZKygInzIgenHBxWMvstQAku3W5367zkHmR-soOR0jk3QpbDwe5wN5ePH0YnmUuc4IImOp9BkkHN9NxZJQKGTN6c--Dq5jv4NinwCsw7ba39xqUpByVbeROCcI9uo2b1cV_lpJnoDuYUGG8Y_P19gay1R9nc4vbf2ygzu3PtJTpk4ojocXs0LzcGgpaUdHmswcqwRtmAlVyKYfeuFn_l2MrS8MtfbwjcBBidtDF_ri5EwR9ndPaG0C0xnfDSS0jvnMjziQpyuoevXdnoFaNEOocPxL2yoQuwdYwwQAyNvmoFGQHuuPhMNvQK_EcH0bIPvVPG6S_nfVX9Zi1eN9CHMLopJ5JGXm8BAiVCZwZuqJLHuttUVXz0SJ12vuBk3YkvMZ8r2p_U40c-M_VOXO1IMEpblWK9AM2zKO-dz6bxecLXRqEqYyyT494s5EPlTepmlRerII-54r4nRDBLn5_zrhQRkihLQQ50S90A6-7rKdMCtzw1N1gGeRGs_nF49Va6MzSJpMgQSywFccHfVM7KslWB30VJfsEqacrYHnlwcMrXx6izq3FydbjSeJA3QoNCtbwXonsBg43Tv05iIp0g9M4Vx04v72WGDwaWPeyAuve8m5wZk6qaRB4j7ubmqB9I3QihccKvhk3pgXycJsb-D5vJhsNbmB1eXJHMV48M35ozhB3Xand79sYDM1gVdjwulso_3YId1bgcnk6Euoy-YcXAxAR9_uSNVymPLNtlnBowNk1_IzCuXcLdW7YRFG447PlcYWfZspTfLgGMSKaUMRh3WBc4ehzH5sHg2pWiSR4IviGbtzL8RLvwpjQ6bxTyZq-LdvXAxyMTd4MgO1XrQcd--MLSl416CiZm2eu3Dwu13vbBPTKWo2N5bWOMurY_c1qE_RxEXTgf5okp3xyQyiwEtqbHOo_MVwAdqNAP63asxLITyui1YJo9ghADVkF-XtPB7ebPMWLpjSnQuIjeLZWbdEd-WnHCmnIKmlfsDQkmzbVOMJ2fN__AxMNLQtHJPsNZHU6vyYJE8VpymOUYi5Q', `SearchKey` = 'wofCpMK4wrDgsKlwqDrcKDwqTCwofCpMKnwrDg8OgwqCwrrCisOGw6PCsMKew4LDo8K1wovCvsOGw4fCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw5jCucKd'
# [25-Sep-2023 14:18:27] /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
# [25-Sep-2023 14:18:31] /finance/root/bg/invoices/2095.html 167.99.142.201

set names utf8

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

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