# [07-Aug-2024 15:55:25] /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
# [07-Aug-2024 15:55:28] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [07-Aug-2024 15:55:48] /finance/root/bg/ajax/clients/form.html?_=1723035347934 167.99.142.201
# [07-Aug-2024 15:57:18] /finance/root/bg/ajax/clients/insert.html?_=1723035437919 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` = '69', `Language` = 'bg', `LastUpdate` = '2024-08-07 15:57:18', `Data` = 'ZFf_4zYaRjDNUgTMU7BCJym1NNxHcU699cTI_jSvSPleOfnCA8bfhZocTFSBHKeGoa_J_aXrSNN5IzdwVj1F7mayt2Yy5wpdgf3dZHWcr6cn_0Kk5NZDi3YNbamztot_tVQ8fqT7zvF-DJIFHxLtz3FeDfKQfwPlByMUiRmETNRJNudsG3GmhvMLDEW2cSk8pQRDfVRx86lCvSGAFpFPCrejIq3LNamdDbZPFS_7gMoq4NAguv3V0M9gwHtcrG5MlH40j0gwJ2bUSz_xN9_PTilFNIireMt2dsROtGJHphT9RsvHM9zBTyxu7lsmLJsRfiWaDww46OZ9nvNnouJ-B2t14HMBJ6XnX4K_hpuMHxkRLkQewTYcSzyuhbxX20IyEkhkzJYEBzDLIpK2GLKWSBbCe8aFrMNa4j9-PQXvKXjypMEPBizrSVNhRDvLfSW2', `SearchKey` = 'wrjCr8OKwwofCscOAwrDgcwofCpMOawrDg8OQwqDrcKDwqTDhMKsw4zDj8KhwwofCscOEwrDg8OgwqCrcKDwqTCwofCpMOqwrDgcOQwqCrcKDwqTDlsKrw5nCucKdwqHChMKhw4zCvcOKw6TCiMKMwp3DjcwofCpMK0wrDgcwofCpMK0wrDgsKlwqCpcKDwqTDnsKsw4zDj8Kdw6bChMKhwoXCvMOVwr7CjMKewp3DjcwofCpMK8wrDgsK6wqCqsKDwrHCuMKrw5vDn8KhwrDChMKhwonCvMOUw6TCiMKHwp3DjcwofCpMOqwrDgMK6wqCqcKDwrHCtMKsw4zDn8KdwqDChMKuwwqTCrMOTwpCmsOWw4HCpsKgwpzDl8', `Top` = 0, `Visible` = 1, `PostDate` = '2024-08-07 15:57:18'
# [07-Aug-2024 15:57:18] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [07-Aug-2024 15:57:21] /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
# [07-Aug-2024 15:57:26] /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
# [07-Aug-2024 15:57:27] /finance/root/bg/ajax/invoices/form.html?_=1723035446996 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
# [07-Aug-2024 15:57:31] /finance/root/bg/ajax/clients/select/type_0.html?keyword=ifm&_=1723035450742 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrjCr8OKw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rjCr8OKw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [07-Aug-2024 15:58:00] /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
# [07-Aug-2024 15:58:12] /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
# [07-Aug-2024 15:58:37] /finance/root/bg/ajax/invoices/insert.html?_=1723035516655 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` = '10425', `Language` = 'bg', `PostDate` = '2024-08-07', `LastUpdate` = '2024-08-07 15:58:37', `Type` = '0', `ParentID` = 0, `Data` = 'e7O8PTNSb7wMYe8UMoQEIpy8hypklcG4E8WR2t1pzJ5rBE2_cyuOjI7zG1F9ZRlII2O0GXYa9m2JjbzgGFuMb_MuhlIigmv9wIBI7tHsD9hJg2HJdZVjuFlMFeNkcFDoLa5up-nJApaXrOAsS8dqHZxySjDpo_W6kTrQbCiP7H2Dyip3WfJ9CW7z_1AIpFrox2y1m_vDbUmHwRe8s7dGNmhcdTdSl-epxXfQNifMfh6kTG1aFv74tC_MhlXmToucNncCllAEx6kluUgnTxSwAUP_h0gjNj0pnOU67qRrFhBUCsrfuhVrC4bC9mwKPguXkfSWSYdJAdl3Pw_EPitzNvklr8n4rdQxXfjtW4n57SxHUvm9ww5mGfR_f4rZPmXKS8w4ZeVHLN_AIZBDtJS0IQjg1dKGzvEzEODgoUCOsx8krTQDJJNZf68e256_UiJG8FlZ7EhEQu1tgXAIuQ_GhTIOexSATX-HFbCYIOR3umtEsGE1CNUDCfCH5wkGSBudHtYh4Udvrr1gdArU6BH--hJ8a1aoZHPxZej717kySyXlcFPgfblpMLxLc9YD-4kpe1xNBtuiq9mMsTs8IpkzUiTStx5A0z4JC_bxQ63xf-YlOd7BhmpMAXhirH2EkjoorxBuu1KqCAmIwMYUlB2t70xnNOYamzEoSxydPH2V4PzOBGv6cKfaFMMFbkBCk9mcRnNA4AqwK6F94U3BmWTmQnP02sIT6eUtpP57eEwnV7KxxzUWNXMYRJFZpgAHGsD6XtcA38U9NXFM1t4_Qr7pC-L2fUzz5t-ggZ9VtzGbRYIJjy3WxNL6xI6oTYrd4GS0rhVE8OXNxeAAh29duDzlSjbVFi6vDfwME7NzHnKNxiLToZl0S_LyCd5RwQoIH07sFrSghfcxQlONdjQI9hSAM3G1bC2oyjdKi9Y6rquKOSZ0HreuyAgRn3bz-CUUkEcxyWDUJ5CRfskh8QLy0cm_2evct7xfao_nl-Zc6ZPYDRphVOj5ENiB2bx51cw-P708mE21EMypEYRKooIJHOoH4c8YdT7Dxd6E2tWVuo1FxQBPL5_rSNzVxeG6eDWSEosQ', `SearchKey` = 'wofCscOAwrDgcwofCpMOawrDg8OQwqDrcKDwqTDhMKsw4zDj8KhwwofCscOEwrDg8OgwqCrcKDwqTCwofCpMOqwrDgcOQwqCrcKDwqTDlsKrw5nCucKdwqHChMKhw4zCvcOKw6TCiMKMwp3DjcwofCpMK0wrDgcwrjCr8OKwwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5'
# [07-Aug-2024 15:58:37] /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
# [07-Aug-2024 15:58:40] /finance/root/bg/invoices/10425.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` = 10425
            LIMIT 1

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