# [10-Jan-2025 15:23: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
# [10-Jan-2025 15:23:16] /finance/root/bg/ajax/invoices/form/clone/2310.html?pid=2310&_=1736515396662 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2310
            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
# [10-Jan-2025 15:24:09] /finance/root/bg/invoices/2268.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` = 2268
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Jan-2025 15:24:17] /finance/root/bg/invoices/2287.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` = 2287
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Jan-2025 15:24:32] /finance/root/bg/ajax/invoices/form/clone/2310.html?pid=2310&_=1736515472925 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2310
            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
# [10-Jan-2025 15:24:49] /finance/root/bg/ajax/invoices/form/clone/2310.html?pid=2310&_=1736515489053 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2310
            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
# [10-Jan-2025 15:25:43] /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
# [10-Jan-2025 15:25:50] /finance/root/bg/invoices/2310.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` = 2310
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Jan-2025 15:31:08] /finance/root/bg/ajax/invoices/insert.html?_=1736515868301 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 69 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` = '2404', `Language` = 'bg', `PostDate` = '2025-01-10', `LastUpdate` = '2025-01-10 15:31:08', `Type` = '1', `ParentID` = 10425, `Data` = 's6Csqz6vNKBYaSK5GyEnBrTZewTnTdcFoQXK7coKXCJOekz9eeyXPugUqH3blHEFWflI9RKIaCnDeOTUpf0G8ODaS6Dd87tvE9A8fo_Y0HSQ4xN9bDlR3S7gGXR7AX3cQN4_c29h2VkLqcxcO1xVfkyUlpTHCuXXwEn0e2S6BV-tFG4P-v6KI-xh4S9gOz3kyNDIQ-kQxDxWm7xW9QgMzu3GndcK_ckBKi_Q6kvwshDqo_0cMO35AzWxclvz54eVQl3q9UVdY_zn6prDvvY8d8kIp4eEVYU3eWwNi6ypKati4gNbcR9F8DkcgwLn4jpKPTNxpOZa4ITX-guQXPK0nYCtMHoghaz-2gUxQJzklcj6RMYsu1W_rjv30BHUdVSAxFUUN379Y62NZINQXm0nqfwLMgtJsqBWrAFK0w0V58zmESyxT6GhJwupPm01z62EGWKpf1B5sSB5qGDVaCU6-HDnTiXKNuW3YYDjsxturG1PDQvExiqEdajI1J734BXGw5G3uD9LRIYapHkSrK8_HGbEguZ3bkXag1AAbpANWnD3DsL29MNsd2XVEbYUqS5G9b6dBWgbKUPBa5xYnwt2pDhPu8j7HfnjUgXdAMErE-0ld5kbB3HVnXhnYUkj6jo-0TyAU0S4mNKassPgSScUdYzGzqEl5TUJvoZ1Y9SWmzcSbZRrRpW0KZ6MMh3HX_adagVJbI5NPV5vombwxGm8LGCuf9gjEJ29hfROx5lTQDkY0ELUemtD8jS3RDfpLuKlhFhXzqDGzouLgGHg-eVCF2ItiNF5vb_5Uj-w_WsKGFiNs2S3gFfPaipKH_TWc3-CPI0smINJLMU89kUipABNfDhlGNxL9EIU6A4jhNC-FGnq8lajINWWa7MVXKL_NKHt2N6HKYH5yl09aWX9j4hfgodmqUy76fx1EoEF3PBKhEUNXzAPzzO7nfKlvds2po8hEncsQvT-vCPWnsKe9vcx6vk31ratR6Tyzs7GcP9QmU95wsQ1gK_4eh4j33ELXpiYE36rGPVJYoN4Dph8XOYFLstEMBf39i87UUc7ma8NBNCcNqGlRdXXak2rsQcluUAZvNBfDoBRQrSuadgCYbo-5M3I45rGVQlxHSZHeqDRAXjal4Q6c2Y2NzO5uMdGpz3H4EMYH5GDwFIn60TTW7LWaTjaeBvy6nJbrVNnc-6oymA4yVJAt_HhFWrVl01l-Znz0W6cHDPlpW8lLc4Ehr-xuGTw5LGYYBl_hZRv1jwoWo0zAwtymU6K9V51TAscIirtlKG5dvXs4_l0hbufuTV6nGry5vaPXl0hOY1MbORPgSA3yAHf3Z9Z0yNbgp8wK-YUIwVfkDcuhIjrJF-CZpLaITjVYi2u46VfCpEHySLJWAscrlmt_7nr104Upb0IleqtYiwOd6KzClQuWrOOqKtXwA', `SearchKey` = 'wofCscOAwrDgcwofCpMOawrDg8OQwqDrcKDwqTDhMKsw4zDj8KhwwofCscOEwrDg8OgwqCrcKDwqTCwofCpMOqwrDgcOQwqCrcKDwqTDlsKrw5nCucKdwqHChMKhw4zCvcOKw6TCiMKMwp3DjcwofCpMK0wrDgcwrjCr8OKwwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCsc'
# [10-Jan-2025 15:31: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
# [10-Jan-2025 15:31:13] /finance/root/bg/invoices/2404.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` = 2404
            LIMIT 1

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