# [15-Jan-2025 09:06: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
# [15-Jan-2025 09:06:41] /finance/root/bg/ajax/invoices/form.html?_=1736924801848 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
# [15-Jan-2025 09:06:47] /finance/root/bg/ajax/clients/select/type_0.html?keyword=tem&_=1736924807984 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrvCn8OGw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rvCn8OGw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [15-Jan-2025 09:06:57] /finance/root/bg/invoices.html?from=&to=&keyword=tem 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvCn8OGw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [15-Jan-2025 09:06:59] /finance/root/bg/invoices/2370.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` = 2370
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [15-Jan-2025 09:07:04] /finance/root/bg/ajax/invoices/form/clone/2370.html?pid=2370&_=1736924824585 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2370
            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
# [15-Jan-2025 09:07:16] /finance/root/bg/ajax/invoices/insert.html?_=1736924836589 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 72 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` = '2405', `Language` = 'bg', `PostDate` = '2025-01-15', `LastUpdate` = '2025-01-15 09:07:16', `Type` = '1', `ParentID` = 0, `Data` = 'ECnAl669YZhi7J44Bzps583OXbCXXgeYZQa7CImcjT0orbI0LUjhys4A8TkK6Y9xoMnVsU_-qsY5cPmqLrtpd-pGZmESL03ItA6CQ1SI6sfNrTY5jaWiEajqXtdZHa9LQ77ysucSwgvjSN2MZ6rY6FgB1gTHTC7ncnKwsdvHtYCGIOisMlFExECb7Okl88tDmbNLRFKWoT0J3f3cvBmWXGQCsSn3n6ofdM7eTrEkIJ1KPquHb97M3GMi5WAQnK9N51P5ERw-8dhCHlzbl_PQthgO58JYG0ndB-lNkhHP8bIEmk84EKGZqQL5AJPAtrW-GSN7KsgWV92uNGIEhNy9J9rBHHDrezHzbVGw6fdjszVP4_CXO4d8GUOcrXWprNSn7uZDae5l2TM-9t3-YcByJtbuNd8sITIi6ggW1jW9xiEbp1xod3mvkUT2Uq5E_xIhoXEIm7AjsFCClgmC7pCRhmFYTiPyAVA-ATsqo-reaO07Rl6LdrH0OZS4FBv-YP2qauQVX_WsB81UGsD6I27J8e7d5qglQbPOMDx3Pwc3hNAiohXtrE5Hdx8yRXwIbSo23FG6QY9wQm5TEGyuebbroqF3qo60rDa_8b1i7Ff1gbElkEy4T_bQwhHhjHvWfIdgkJxOI9qapeye8nEvF12sI-suj32D28ZXqunqzOEOafZQl9Tehc2QjvgDw0GI48Dtq6Dxo7_raAjaOBkk5-fAG0MyWdlcIugq-OOQ_hqFyKpzXzzVP0n24nn0xt3MK3Fh9pb906DFAohkCww-kWlAhzpyKYT2o-ixgWbVYpikOt9WoT7L2_b2ggkkDOjne5af7AIu8onsXFX2O0gXVc-bad31kSO_lmfZUI3_4rbQW3TwsPsUQeVaSM00hW1ckBVYP-OZtiXSt_01D3Eny-VBc4V4DXxPE07AGNglD4EGqzr8p5xd_H4WpcpF4gFRsghV', `SearchKey` = 'wofCscK8wrDgcOQwqCwofCpMOEwrDgsK6wqCp8KDwqTCsMKrw5rDj8KdwwofCpMKnwrDg8OgwqCwrvCn8OGw6LCp8Kzw4LDrsK0wqDkMwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4wrDgMK6'
# [15-Jan-2025 09:07:16] /finance/root/bg/invoices.html?from=&to=&keyword=tem 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvCn8OGw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [15-Jan-2025 09:07:20] /finance/root/bg/invoices/2405.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` = 2405
            LIMIT 1

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