# [04-Dec-2025 17:20:07] /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
# [04-Dec-2025 17:20:10] /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
# [04-Dec-2025 17:20:16] /finance/root/bg/ajax/invoices/form/clone/10478.html?pid=10478&_=1764861617638 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10478
            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
# [04-Dec-2025 17:20:23] /finance/root/bg/ajax/invoices/insert.html?_=1764861624210 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 70 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` = '2604', `Language` = 'bg', `PostDate` = '2025-12-04', `LastUpdate` = '2025-12-04 17:20:23', `Type` = '1', `ParentID` = 10478, `Data` = '9V9bTPfSmgoesqbyAw4Wc5i7i8mhpb6K_gVJ-eVE0s5B-NyvxQQ67sNxHvGk0otIm5Zn1zorYrAuu6eIb8acR84Jg1ZV8BHdVvq6SCLhU0zKFbeIiZOAxQrxFzaW9Y-mwBvVWcVEREpdk1NsGPCFBfySoT-UcMyU9UR6gXt3o8HJE9fyasMrQicIHtniRA1jlTVEBU5vS9WUnyPkj7Z-KMlJeNsOn2Y2-oJvzA9BsjQO4lGinNFX_A89HG3__Uu_hLM2NgbU040F3ZNJht0AJTiAXhOCdYjR31uQSJVgExp4rT1pysgAHc_bUgkyYkpqjJZLfvU3HhXZKYM015Of5ghQ-SuLbH1KeX_wfNA168PCPQM86Vx32DJSsQh6ehCQephNo1FhPRCRf6DF8v8R707XDM4ydRbLcNcXsMOWs-84UE9C3osdWS8gQ1l2CHFuMntuGSt1mQXlwyTEkuLjBYWsTT3XhTK_SrnFZTcOwzEfC0oWG0-9j5Pv1JQqWq6P1gtIkzeRGhdcjJwzXNhQOBBKvxEVYxuCHbkLQVhh75DVP7MmTFudiw4vdaMP66zrIRej8JUkV5bUMEUFIYni0h2jmMVAawYySSZDbSXevqyayT_LQI_i9n703-3yMPt9OELH9sQbVh8B1zopBMKssvZrQqAA-wY4xp5dXou0I9dKOiY34SABxnF8UpXI7KhlF55ePVPbmE7mHHs1paXP18vjeVtDtGfdOWnIie_b4Bvo_EkNd2B77ikvB7nZH5t2IpdsDq4V8iesu-olRL3IXI-7SN9oF2OpzA-Ju-rex9qCIX2llTeTehp097GlTn-6S4NO1eqbCmE3vnDvAbBaFNaotNdQT1yVJzVi1p-iGrwqegkqg9s6SYyNpleCFx7-bViIs8DIB2t_QZD978vT0jfD4E334WyQXyA_F2KHVXBYmOFhLTb3WoMsXgCWtmuBKaaDWli_kdZBAHgnB2GNNw', `SearchKey` = 'wofCscOIwrDgMK6wrPCt8KDwrHCwofCpMOAw4DCtMK6wrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwrjCn8K2wp7CsMwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscOAwr'
# [04-Dec-2025 17:20: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
# [04-Dec-2025 17:20:24] /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
# [04-Dec-2025 17:20:26] /finance/root/bg/invoices/2604.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` = 2604
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Dec-2025 18:05: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
