# [30-Sep-2025 08:12: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
# [30-Sep-2025 08:12:08] /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
# [30-Sep-2025 08:12:13] /finance/root/bg/ajax/invoices/form/clone/10458.html?pid=10458&_=1759209133297 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10458
            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
# [30-Sep-2025 08:12:20] /finance/root/bg/ajax/invoices/insert.html?_=1759209140698 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 65 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` = '2553', `Language` = 'bg', `PostDate` = '2025-09-30', `LastUpdate` = '2025-09-30 08:12:20', `Type` = '1', `ParentID` = 10458, `Data` = 'KWde_bUb9mBI0EDWLpdGf3wik9tdWH6oZAIJ5otzbr8Pq9SkGP9dNRkzk7Sz45JZzIMrosgimO0ahsfAQvfXGv0Io1mV_g1HdiA-07Hoihqsz-hWK2uk0IpyThN535cEaPy2cXdnREhrGHx6xV7JNA8WpxnBcxkZHI8AEKNReT-RdE23o2GEZ-FlwIMW2OCIxK30qwsF8yJRe1Ho9W0DKoqmq0OC3w3BlFgW166Lcx32IsCXiL07cv-7R7TysvrmhBnF10eRiMiZhXpOceOYzPfe4O2H0zVLg42LsPqbB3C1IptRCqkXezwXbklMnkLjwigqTo5EmhJ1yJOwK-gHqPkPTcyIZXvJ8fmMXFQFCwork8NfF28Rj71AJt-uqNSrrglB6MUaziyMsfodIuqpcUgYN-SeY83D_O_sxwDYzeeOv4D4rg1CvaDQi2D2QZ1xG-g8QQL8gDIOdZWDkQUB2NKS_Ki8hJchZCeqixlMRVqvggsbvyoA7sJCo2kh8LjCFW-ssLUWExQuFwZqmSL8VDDmTjIP5LE6Rh6rL82HRpXYejw3zt79tAZMHrZ61VSjRogHcHzD6Ja09VafLVRLjSmBGpGEYXMYaTFrKqeXvcAeW-TUW9jeL8aEvEh5hMsqU2_5Rhaswg4trZ4VdLsqqIe8nx9g0umEHFtolZ51R1GLD82se7T2HuaT0tQZ_xcvdk18Ms2s0TxbS2xnQtbAhP0CsUBYG-FOAQ1GQVUrZADcwbPXxBrEwm7JBC3kYK_mABaPkUnHKM7r4HNoMpxO7URHJTBQstm9UCLcsYdlFBcMirwmxByRX0q-rmqiBclo7368sUSS5044pfYAoDA9H32DnLM8r5pkltOgvrYNo5IaRDm__iEBFnZzuvAF3gOTa883ZTy2RxT4JOy_LbmIXRrdQIDXjY-26T-upg-b-qCFNGdySevS-vuPlDsXxXdbQJoPGO2W5JyqNbsJJVbuhZEN8wp9WHBRYU9yqjWCsFTf1l_fFRVE0iJffYJZOTAGoHA1cQbhdo1FursRGGr5Ig-ZxvhGaEHGnKMdpWmIrhgkGr9ktCCiG6uWcqJuIrm-tWkJJe2b0mbNvA2Npv3r5HL82sPTnVxBaNoAlEzGVRAgeOf8ZFunUdgh7mhgaQgqj9uBqoe7-sO1GzsArKvEBYj_0PI1ngR0yvX2xzbQnrZqijFoXnHuH5C94YKiIhvrfnbVEeNWUK3KamHuia-BL0U65JwHlLRw_eq62PRTfsI77ecdon8oj886GyDrFGbqRkE5Ve3soHdeL6gtGhW78wtc7RW2SpznULoe4I_3TNMr_bvwz2IK_VDHeV5rlWdaDmZme_hiqmehUXybEP2GKzqO6W7JiHttPwl-mT3MWG97OaWvNQcvkN-ZHJY7hrcSdGpWOC_KCKRNfdGc4M04NA', `SearchKey` = 'wofCscOAwrDgcKlwrPCuMKDwqTCn8Krw5nCucKdwqHChMKhwonCvMOUw6TCjMKVwp3DgMOTwqPCuswqTDgsKxw6fCm8wofCpMKnwrDg8OgwqCwrDCsMK6w57CpswofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rDj8KdwwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChM'
# [30-Sep-2025 08:12:20] /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
# [30-Sep-2025 08:12: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
# [30-Sep-2025 08:19:18] /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
# [30-Sep-2025 08:19:28] /finance/root/bg/invoices.html?from=01.10.2024&to=31.10.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-10-01 00:00:00' AND '2024-10-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Sep-2025 08:23:16] /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
# [30-Sep-2025 08:23:30] /finance/root/bg/invoices/10447.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` = 10447
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [30-Sep-2025 08:24:18] /finance/root/bg/invoices/2500.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` = 2500
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [30-Sep-2025 08:24:30] /finance/root/bg/invoices/10448.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` = 10448
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [30-Sep-2025 11:01:39] /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
# [30-Sep-2025 11:01:41] /finance/root/bg/invoices/2553.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` = 2553
            LIMIT 1

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