# [25-Aug-2025 08:40:50] /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-Aug-2025 09:49:44] /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-Aug-2025 09:49:47] /finance/root/bg/ajax/invoices/form.html?_=1756104588173 167.99.142.201

set names utf8

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-Aug-2025 09:49:53] /finance/root/bg/ajax/clients/select/type_0.html?keyword=hea&_=1756104593571 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrjCn8OGw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rjCn8OGw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [25-Aug-2025 09:50:37] /finance/root/bg/ajax/invoices/insert.html?_=1756104638177 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 44 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` = '2533', `Language` = 'bg', `PostDate` = '2025-08-25', `LastUpdate` = '2025-08-25 09:50:37', `Type` = '1', `ParentID` = 0, `Data` = 'I918RFAWmY7zXmdERNJwtJ8gf3puZVEWwS2t3dgBCORYypH7QZzKwGzUwD5d_sDzjVnbkmlOM5Iy8H28TkVcQm1dIW7GdhAdFgPyZEeRer0cS7X6tIAcRdZz5LXb-Jy4tHrIF8HBVyYZUZtWS8_E7pvvjcznQqu6yb1ydKPXEkoNk1dFZi0b14hWo0VGZfVAYgkHAHR9XRWDu2J8bepEJw5caXCVx8Gz5teDWYZpCRDTRoa9-WGtD3LKqba-IIq4CBmnCPnGeJ7CM5y2GWvifEYyPg5RkQ0qhHRMmDm6idaR3fwLlKueAvBoNSVYztG8s-dT3SJ1vmeQ_ZuQRe9Wqzzpvsb6Fj9xJTvYC9wNhKnRJwJfnXdeeM1gHhWkQd8QkkJRBuhq7XfSaN_EDFIzZvZwov9jrLegT4KDxpVPlULseASvd8WoutoJKui7684ysWgDFaUjFDyinpvsI0UHuUqa75Fxm6ab-P6VNin-5_NAcwz5PX9V8tOrV-tdw_HzmB19Vloez8Agmkwv7YrC3m38TNOkCR6n7Nx1sPRlByzPsiSTL85yvBPHKkn1ZYrcacjnPDeZTDyy5d5_MMKNncaKnDKw4IEpLixHVX8ZFwtKjxYc8x3oT-bqnECKkKSSxpVEAcKuYq3__T6mpEBBneul28hz-XdD8wfbos4agyDAXbLZXlwoWexiidvGJ_pDJ9lYCvcecV5vbyD4NtvURdh9rY5hHZCnM8pE948C5j-GtJnH_u--GoHdrVCXAblSnBJ5QxR4jFjnLAvRMDk-8EPBSkbDR0gYCBF2JF1GPG2qsK5jRV_9573AGkFdaxh9QfMU0Q0vc7HmxqEC0b72LT0FR_zBZI4ISQ0u8ioqpzBuIweN7mTqExDVJ-yx8R08w4HJ1dqMPZOFR6mZuN48xr_B1UI4AXgylYDOMO-_X1LldTK2KCkpkkzQt27AjMQGfKwAa9dKXAtuGq2OZxuvZMuX1gf5XyGOBpPj7bdM1VZ5ZeDTn4LNk7hV0qbia_K5S316v_Vq9wvguPYYK6gNZg', `SearchKey` = 'wofCscOIwrDgcOQwqDrcKDwqTDwofCpMOiwrDgsKlwrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwrjCn8OGwqDCrsODwrrDp8K3wqCwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rDj8KdwwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMK'
# [25-Aug-2025 09:50:37] /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-Aug-2025 09:50:40] /finance/root/bg/invoices/2533.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` = 2533
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [25-Aug-2025 10:06:10] /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-Aug-2025 10:06:17] /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
