# [30-Jan-2024 07:07:14] /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-Jan-2024 09:42:41] /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-Jan-2024 09:42:47] /finance/root/bg/invoices.html?from=&to=&keyword=arapya 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrDCsMK6w5bCsMK0w5jD%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Jan-2024 09:42:50] /finance/root/bg/invoices.html?from=&to=&keyword= 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-Jan-2024 10:27:08] /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-Jan-2024 10:27:12] /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-Jan-2024 10:27:14] /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-Jan-2024 10:27:26] /finance/root/bg/ajax/invoices/form/clone/10389.html?pid=10389&_=1706603246569 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10389
            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-Jan-2024 10:27:32] /finance/root/bg/ajax/invoices/insert.html?_=1706603252461 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 58 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` = '2167', `Language` = 'bg', `PostDate` = '2024-01-30 10:27:32', `LastUpdate` = '2024-01-30 10:27:32', `Type` = '1', `ParentID` = 10389, `Data` = 'B1rVKiLK2gRkydpi98Leu6W658QC5Bm_N_BW5MKVK8UYEEda_70eQJn8-3AyyVa7JfP_uADSiGUQIROaU5Z6LFB9IB6bs-f_Z4bMRsrB0sVGFWwgB8OcZZEtHqXqa9zANU4roLkDJkOFhhMUqYBsHmo9PgYbKn8YcFp4EDaMjVKaKFdc-CMK7uLc-eQnsA66F80K9t_9f7n3x_lD5-kBNlsgni8NtML0UvTeBNc_i8iTeLH6H2_MzBdvXPO5eyLz4Tp2-Hy-j3ken7BjDBwBkJuX-bpGUsgJe-pGVeAVrjr8f2B5n52qvYFLyP3NgXzq3Aw6HPJjVHCemcELFV7mmzrmbmskv0sJn28Sh3dzXhcyM-O575Y6P0vSb2jGMyX1aUD7qMJuJXNbmAluzIr6JbpFXNRn1ZAiccGbsKT3V2meDPrnAOxe0uuEnndFKquW4BkSerz1RJzm81HHElEW945zE6Wvswom0ZmifNneQ-039RF1nKONxpPp8sbehPgQvDFFJZ4xTOksT3OrP6x6mSvRx1PqyjneJaWIYzNIwva7GrFzaCrIvh7fBS9grhvSr2a0PNriNi5dy17aBnPdgXmcLdx6cqdRHD5QS7S5YhPOiu9sydM43vh4jn5gR01P9PuQrtkGKPVqoS7NvgMQSXjKen58_bMfkd3nV7UH6BPlVse8Uec7DH1E8WdB9gDvcENga4FfzVf7-XV4OCFYUhX34CbB2vM95Hk9HH_q12DGpEnPsN0IC0KDUOSkipH0NDn8RRAwxJ_5IsgDOOtJidQm-rqwbB0aRDLUNsdu5dS9muMtyC3bHdFvmaEG0PuAMQr_4fXZ66Otfjv4RK7QR2V2PGRZQoTpfdnDaYXitpV2j-ouFMy0x-gcYBzFB_oUyLfxZ2KxWTTFEdE1NMA1R4lEIXWBVfM2EYXBZ76r6EKj-TNZ-ukzTPjHVFhVWtMxptrTQIhQb3Tk1Ccok-wedCk8diAXy-uwt7tNZfcGjBk6jX0damffBK6_y6RIyTto38LnU1YK4-T4YqfNs0x-lT_MXiWW-tO-suDJjs2vA8E', `SearchKey` = 'wofCscK4wrDgsK6wqCq8KDwqTCuMKsw47Dn8KhwwofCpMOqwrDgMK6wrPCtcKDwqTDlsKsw4DwofCpMOIwrDg8OgwqCocKDwqTCwrrCisOcw6HCscOZw4LDwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOU'
# [30-Jan-2024 10:27:32] /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-Jan-2024 10:27:34] /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-Jan-2024 10:27:37] /finance/root/bg/invoices/2167.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` = 2167
            LIMIT 1

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