# [24-Jun-2025 06:39:49] /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
# [24-Jun-2025 06:39:52] /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
# [24-Jun-2025 06:39:58] /finance/root/bg/ajax/invoices/form/clone/10447.html?pid=10447&_=1750736398392 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10447
            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
# [24-Jun-2025 06:40:10] /finance/root/bg/ajax/invoices/insert.html?_=1750736410799 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 81 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` = '2500', `Language` = 'bg', `PostDate` = '2025-06-23', `LastUpdate` = '2025-06-24 06:40:10', `Type` = '1', `ParentID` = 10447, `Data` = 'YCFroGEWlOTZyGNFDHHWdicoWUQahE_yrZPEMlMsLdPyZP--ZEq8TiLYV-npFLiFMeQQqqeE22knouuKL3g57lhfWr3Zj8N-EvM28cDAHamFvu25aQZx-x9Pt4ciktAa7jY35vuMGyUenKmBf8bSTOb_jhIw7Bc3N21-a1Cff47rDYw7jcGfo8KR6D1rqzjCevEEYkG05sPtH03uqCZykAtMlAKHxV52BNr5APEM3zCDmDUqWyw2NtdIDnNQluL37ITfF6ewt6_Jeog8izo6lkjYLtL25T5z5bwLwCg8xwvjP-OWbhE3k7EHdogYNnfwebMDJVXHYCj60lANCI6X1fbgr3AhrRFhZIu8CEoi7lQX_GoOQrRs-zQANxMO-PSz4NnK9vgFj-oT8r4OnICR6c3nrhh0kopFcKhflC8EPoZvwimV47s782lt4mfxxMPOCJ9D2s7Zcenn15ROqkr_NUP5a6v8I9yeHwT4Ul8D9W8_9Y8VC1INdpTGMAAteC8t6tSGf9GxC81nI9TbN-ylmFFMyWM5PvNqA2H576P-u7MF9pfvnshPuCbrv-HXKexOCGQgLSgq0QFrqor2LNjn1oX47UDq-HaEIXHpZ8W9uHNrcwlvDpROyiuunMSVLk1AwgNjcPL3nTbSlIkre5pBD3tRQDZVHtoL20y1euJ7KISzhjyVhBvKUGwXtKNdnK8Xdys4A4rFOARVw4p3brbV36cumaNaByNvuIkZcSZbY6CYmXnShTyv9YcFpuwiOJoLEfGSgTErTSlvcftSHB9lvTm-7CrPIDiZfqaLmBj0fRlNMA9rFLiehwnzmr3debpSI1gYRWBg2efcfc3Ii6M8X4ZE6Gs2Uan8m271XN3OlFnmnd2z46JpKJV0Fdag54lDqki2NuqAIuc48dFePgrqc-hvS4vZmpXXrY-LQoeH_M6tSLknxIlr6HnrnX2uDaqOdf1Jvcnz36-XtO1PwBQHaX1EZgS6ukC0vK455F3ewPNrWxmPsqdRVQqx7fNM7vEdqr5Em4wXHJcHjU3ERL_CM2uIozvooiYMrC-TfA-6_2A2SPXB6cmcyKS6oVycuCCe492seH2Yz52cAuAnpIWd746bZRAuDLoriq6-sICGYxrx9jFF9ZscKc1mbtdh5FcfXQcmGFOmnMnep_ODwQWVFt2vKuvvGuw451zUpp4r1pHHCIYwXEOW66qZw12TKdEqOdr8uE1aCKQ687iDsQxocwO9D3R4__UTRHBZnTOdvub6haE8edCoolrm6guUlAENPbbxGnDVhNnziXGQ_JLJhQ', `SearchKey` = 'wofCpMOPwrDgcOQwrPCt8KDwqTDnsKrw5vDwofCpMK0wrDg8OQwqDrsKDwqTDhMKrw5rCpMKdwpzChMKhwwofCpMK4wrDgMwofCpMOIwrDg8OgwqCocKDwqTCwrrCn8OGwp7CrsKewqXDnMK1w4XDkMOGw4fCssKTwwofCscK4w4DCtsOgwqCp8KDwqTDgMKrw5jCucKdw6jChMKhwpbCvMOXw5TCiMwofCpMKjwrDgMwrHDhcK2w5jCp8ODwrb'
# [24-Jun-2025 06:40: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
# [24-Jun-2025 06:40:15] /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
# [24-Jun-2025 06:40:24] /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
# [24-Jun-2025 11:29:23] /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
# [24-Jun-2025 11:29:25] /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
