# [15-May-2024 12:17:17] /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-May-2024 12:17:22] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [15-May-2024 12:18: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
# [15-May-2024 12:18:33] /finance/root/bg/invoices.html?from=&to=&keyword=veselinski 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvDhcOGw6jCp8ODw6TDpMK1w4bCusOMw4bC%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [15-May-2024 12:20:57] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [15-May-2024 12:20:59] /finance/root/bg/ajax/clients/form.html?_=1715764859148 167.99.142.201
# [15-May-2024 12:22:59] /finance/root/bg/ajax/clients/insert.html?_=1715764979142 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` = '63', `Language` = 'bg', `LastUpdate` = '2024-05-15 12:22:59', `Data` = '5s1MVrh7V3hBx8MxkxZs1D1FyFfHPzw2yMur6XRx12ZQVpbSIZA76S6ZamY9L9ClnOuHWqoXgljd0UosFK0NrwKxGDaOlTGPeQOIa8QPTz_aL7FkLr_XzQGOUYKffNBXKeEuHZc1IM3hxumyiw6lKDseyQz6mS1shSysGpocxSstfndn6dR5fjEAgnFzIC3rGxKktm3ENvvy-070_Qd1p2j3Ub9r1l9sFXulhgHiDvYL61TpCY2zRd3DFap_cRpLL8ssbRAIVzO_NB3gvp9xC-kfvBcceQ1KvjRVNUct2c7te311CWh_QohL3FobeYtzS2xkG5e5W87ePZkCQD0U7sWjKZMsP1IuL3lRX56-eabBjy3NW3PQJDGN4XTP5aUbI4VAsDgq4fwnaUMFW4lfxR4_T_Ye7p-0h3uk4loLXas', `SearchKey` = 'wrrCoMKyw6LCp8ODwrrDwofCpMOPwrDg8OgwqCq8KDwqTDlsKsw4zDn8KdwqPChMKuwrjCvMOVw5TCjMKVwp3DgMOTwqPCuswofCpMOPwrDgMK6wrPCtcKDwrHCuMKrw5rCucKhwwofCpMOqwrDg8OgwrPCtcKDwqTCsMKrw5rDwofCpMOIwrDgcK6wqCqMKDwqTCn8Ksw4zDj8KhwrLChMKhwp7CvMOXwwofCscOWwrDgcOQwrPCtsKDwrHCwofCscK0wrDgMK6wqCpMKDwqTCo8Ksw4zDj8KhwrLChMKhwrzCvMOXwwofCpMOPwrDgcOQwrPCt8KDwqTDhMKrw5jDwofCpMK8wrDgMK6wrPCtsKDwqTDlsKrw5rCpMKdwqDChMKhwwqTCrMOXw6bCmsKww5fCpcKgw5LDl8', `Top` = 0, `Visible` = 1, `PostDate` = '2024-05-15 12:22:59'
# [15-May-2024 12:22:59] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [15-May-2024 14:18:04] /finance/root/bg/clients.html?from=&to=&keyword=veselinski 167.99.142.201

set names utf8

SELECT * FROM `clients` WHERE `SearchKey` LIKE '%wrvDhcOGw6jCp8ODw6TDpMK1w4bCusOMw4bC%' ORDER BY `PostDate` ASC
# [15-May-2024 14:18:13] /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-May-2024 14:18:18] /finance/root/bg/invoices.html?from=&to=&keyword=veselinski 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvDhcOGw6jCp8ODw6TDpMK1w4bCusOMw4bC%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [15-May-2024 14:18:21] /finance/root/bg/ajax/invoices/form/clone/2110.html?pid=2110&_=1715771901607 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2110
            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-May-2024 14:18:51] /finance/root/bg/ajax/clients/select/type_0.html?keyword=ppm&_=1715771931415 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCoMKyw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCoMKyw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [15-May-2024 14:19:10] /finance/root/bg/ajax/invoices/insert.html?_=1715771950778 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 63 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` = '10402', `Language` = 'bg', `PostDate` = '2024-05-15', `LastUpdate` = '2024-05-15 14:19:10', `Type` = '0', `ParentID` = 0, `Data` = 'U1kksj923n3h7he5Ya9_naQBID2xJAbnggGPn3HFlqLbBxoyIsucA28SFgoz-pyWqhHHgsGRQbxqCirvjxRtcDsI2_mREpMHX9Gz7AKHPhdGaL7P0BRrMLSFw0gte6CiNGFKpDa6izOc6AFJjjSqw69Y-RsEbvj2pNmdaAmQYyQ0xCRd0HRj-xCphQ91mQxTNpN6iYsfrY4hGyBWYfYaSx9evNsM4UovIdAtIC9XYYdtEzaQC-t8o6B4MP1s94sYEYC-wRxcPLT2ZGkyB6UQ0z6va6bTjKkyqKw0MgnTtfiHf06SuTyrRveIKn_KvITeItIS2u6cDGixeb40XExKQrg_awfW4mhxpjOy71e3YDXWIAEc3wdsVAyOZZV1lUokDSxYyoBVmygs3lP3xBGoV-Q3cUCwJ8jSJkkOfufBOygLvmLtshcQyHOJLCRfRbIk6udWlvA4JmmafG68gFGs1pD90up9cSj-kSDy3690v75Rs6DxC1QyKv-LU56ZslZt97GBY7bUEvN2N6jvZhvJ-TdwBJexHqFImVX212MD09yfwBvoRYrOkug83TsTmsZnypU9-K9T4rsAaa5YKQacKldSHRoTV67qhzlrvy-FiaVptWO7jQLjq6SVGc1aaxXUxAj68Li0bIURKMVHorsqxAwO5qjGjE_7A5PGJG-ugC-zGfOpZMn0v3dhgPxS01aKwsLqD0rR96l1UcZRbdAwhmaYEx5NOisiDdOou1fpuTTBxU8U3Q2F48L3On3-0GrLovO8SIRiCEGw-x1qH9yk_JUoYh-ZfosHKDgPhyrExSzp7GtaY_FqpNqwBV5CAeMVXzLRcqTrjYbBRoHzMO-Q1MSa3oTefbJrcI2euTdpen9UY5YdGKqmwa6MuFUMba1BtS-PSHTxYCvGsq6tah84XqRAtnkD_XYEZpUNbC9EoSSaybyBUGDSUNPuBjHlFJ7Ak9dztLsB8VjoMK3nRPdS2UINUjKoAL1dQc7jk_wS61UD7jrpSQ8IR_q0GU7hih2jcG_c71I3h2CEcI-VVb_MAQtvRYJnuXToNBIm6tgZ9JkfwdtloxrNbL-3niBThMlsOdJ7P6vIw4N7Npxs1HotZnN1XsEt_kRCcQmQ91-fvPF5cv9xWJHRkQb2V2HViYJYKv4nIRwKPWf7ssITZKYf9WhHsBHFXTQEi5TxFr8kYUBTZzSoVr0vXWBOdtifrO28', `SearchKey` = 'wofCpMOPwrDg8OgwqCq8KDwqTDlsKsw4zDn8KdwqPChMKuwrjCvMOVw5TCjMKVwp3DgMOTwqPCuswofCpMOPwrDgMK6wrPCtcKDwrHCuMKrw5rCucKhwwofCpMOqwrDg8OgwrPCtcKDwqTCsMKrw5rDwofCpMOIwrDgcK6wqCqMKDwqTCn8Ksw4zDj8KhwrLChMKhwp7CvMOXwwofCscOWwrDgcOQwrPCtsKDwrHCwrrCoMKyw6LCp8ODwrrDwo'
# [15-May-2024 14:19:10] /finance/root/bg/invoices.html?from=&to=&keyword=veselinski 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvDhcOGw6jCp8ODw6TDpMK1w4bCusOMw4bC%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [15-May-2024 14:19:12] /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
# [15-May-2024 14:19:16] /finance/root/bg/invoices/10402.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` = 10402
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [15-May-2024 15:47:30] /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-May-2024 15:47: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
