# [06-Jun-2025 11:18:06] /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
# [06-Jun-2025 11:18:13] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [06-Jun-2025 11:18:14] /finance/root/bg/ajax/clients/form.html?_=1749197894420 167.99.142.201
# [06-Jun-2025 11:19:24] /finance/root/bg/ajax/clients/insert.html?_=1749197964343 167.99.142.201

set names utf8

SELECT MAX(`ID`) + 1 FROM `clients`

SELECT * FROM `clients` LIMIT 1

SHOW COLUMNS FROM `clients`

INSERT INTO `clients` SET `ID` = '80', `Language` = 'bg', `LastUpdate` = '2025-06-06 11:19:24', `Data` = 'Zac27hYkTZ715-AXx15Y5Kg2ImQ1NE1Kz8B8-f7zatamQJL7W8fdc7LaKHLl1yFQBvsBzfGMHuw6wpRNr0wBo-UjhUhg61Yj-P4WdWhRnbI1tCH5GyfDhpvr9Qazq5lqZhCkJL8Sf_v8HfxMOWM1nLZouvMWneFkD6bbLCoQNKuV5rkUdBSdhA4HCJ5nJQf3K0QcoLx_Ppm7PE2G9X9_sP3mu7jZPcMRYfO55zNmm2Cnwwdhalhd2vIC2Y-qyg-oHb1lRcMWI9PZACTNI0opGlmxxxubUt1vHq_gjeOJCz9c8a56MhTJJJ47dpfozFpp', `SearchKey` = 'wrrCi8OUw57CsMKfwrrDosK1wpCpcODwr7DgswrDCsMKw6jCp8OEwwrnCr8K2w6PCpsODw5DDoMK1wqDgsOPw4nCwrnDhcK2w6LCp8wrnDhcK2w6LCp8wqTCrMKxwwqbCnMK5wwqbCnMObw', `Top` = 0, `Visible` = 1, `PostDate` = '2025-06-06 11:19:24'
# [06-Jun-2025 11:19:24] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [06-Jun-2025 11:19:28] /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
# [06-Jun-2025 11:19:32] /finance/root/bg/ajax/invoices/form.html?_=1749197971770 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
# [06-Jun-2025 11:19:37] /finance/root/bg/ajax/clients/select/type_0.html?keyword=swi&_=1749197976683 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCi8OUw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCi8OUw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [06-Jun-2025 11:21:04] /finance/root/bg/ajax/invoices/insert.html?_=1749198063838 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 80 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` = '2498', `Language` = 'bg', `PostDate` = '2025-06-06', `LastUpdate` = '2025-06-06 11:21:04', `Type` = '1', `ParentID` = 0, `Data` = 'yfk7uh4uls58uiY0jDXurBR1WdKpvFWqxyRnFMTNG2mw82Mj657jdAQvVd2v4GFA7ZVwV6YL6RehBsaX1aaAqdy_w6D9ESoK1R7pWjIULyI1K0vFv8OY_lLdmKIn5Bytmcc-Fo3VSJyM98lcKx19eQL5WDUP72EdYMpuXcor6hv_VJ5TqSh8vwQaANOyD7wf7f-SewGBQYqFjm2Ghl2iA0ebW9eglqwXIfzbPyu0PRiqBwv1LOAJDCJjfL6g-ZJMUy-uDyF6nrDMMOwjdwdjZVBX9edIAXaTPk69-ygfNlVnHZap1ZaJLaJlmCLqE6qJWzlLvw8ZeMOiG_U1z1CVINAWPcBDAFpbOITJyJY1PHYX3a_1e-jFsKmpdOHdRHGk7OcNF5u9M0wCxJEr1ezhH5uvfnmXxk0aazkzQ8RPVIXSFvtOHSzDNLghWeREPXgnSCm0NlcRbnoGi1rskVxXK4TKfeJxp-j6jkUkXFjQABzXaIEuV5Y7jWt6SeEhXme8rn1qFTR8h251PaY-zYk14L2LZ6oKfcWh2b2jeKC07LQyf-ATRlg6EZ509LJdWAgZdDaYA0BVqzGS7eQTMCGNMACbOgxMB2Jt2X0e8DqLcJZQ1rmcREXpA2icOxnzt1pekK2lk76UBDZs3cFEtW_vIo2NfcNY-1yQqoOQqLrtVtnwRre1dS1qY8qZPxRqec6jN7xFNQe0A9kGmE0_4yYK4Ss6xmnmVG_GVDy3slueXID6BmQAHu5tZNEo2m5_hXe1lYpIMhcDc1R0JcCyhBObhzYqVG9qEiJFqkD3NQjBYyYQ2btJ4b7lDo0QoGHgVMecfcbtk7fb7PgOP16zP-IFJFo2oERlWmTq9323eyHsUe_Z0xz8O9NXMcUQU_dHo78GvabWUcl7osOZvpQKQxKFjNCdLL3SVQ2ldMN9Nf3EhN1lcKQleafAW03u9YoiMtMlkH9_wz_qCCE675ta2mF-dd1RNQDTmy5kLSFRFN9JqUcxuReYCMaiGC7l9FxnMzbeJG2XJ_cuAYpZcOWc7RgQFV7Is7Cb7aTl_049YU6Ri3w', `SearchKey` = 'wrDCsMKw6jCp8OEwwrnCr8K2w6PCpsODw5DDoMK1wqDgsOPw4nCwrrCi8OUw57CsMKfwrrDosK1wpCpcODwr7DgswofCscOAwrDgcOQwqDwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4'
# [06-Jun-2025 11:21:04] /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
# [06-Jun-2025 11:21:08] /finance/root/bg/invoices/2498.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` = 2498
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Jun-2025 11:36:48] /finance/root/bg/invoices/2498.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` = 2498
            LIMIT 1

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