# [19-Apr-2023 15:10:39] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [19-Apr-2023 15:10:40] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [19-Apr-2023 15:10:50] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [19-Apr-2023 15:10:58] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [19-Apr-2023 15:11:01] /finance/root/bg/ajax/clients/form.html?_=1681906266448 167.99.142.201
# [19-Apr-2023 15:12:24] /finance/root/bg/ajax/clients/insert.html?_=1681906349129 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` = '26', `Language` = 'bg', `LastUpdate` = '2023-04-19 15:12:24', `Data` = 'H8ThZaCwAUVDJe4RYZbNiTl6gLivFeMnPXEBBfQXXppoM7AFe6X-8t71LZh2CymnDW4YzCcbpcSzmdg4FJpIBxhBTX9zaC0bL7gYwDW2AHsPugqwvdjG_1uowFZg8SSH1xoJ8l9Pkn_Uwza7OIFoSQYhpQkshn3xy8-wiEZcUm641D9U82h5fzJwDS0o6IWcEnBmen24pscOSJm7QfdSL7yLNmFSKduStA-GKXMwBPIDSZnpUMDHILHxCFWSgivZwBCnNz4ZkZrafSRr-m6AcIpo9KVLwBUoEstkWApKxFx5HM29N8WnYOVzcCzFGT5NDa-JN09DpFlPvkgkY4rIWQ', `SearchKey` = 'wofCscK0wrDgcOQwqCp8KDwqTCo8Krw5vCwofCpMKnwrDg8OgwqCwofCpMKjwrDgsK6wqCqsKDwqTCo8Krw5rCpMKdw6bChMKhwwofCpMKjwrDgcOQwqCpMKDwrHDi8Krw5rCpMKdwqXChMKhwonCvMOUwwqTCrMK5w6bCmsOAw5PCpMKhw4LCtc', `Top` = 0, `Visible` = 1, `PostDate` = '2023-04-19 15:12:24'
# [19-Apr-2023 15:12:24] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [19-Apr-2023 15:12:27] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [19-Apr-2023 15:12:29] /finance/root/bg/ajax/invoices/form.html?_=1681906354750 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
# [19-Apr-2023 15:12:32] /finance/root/bg/ajax/clients/select/type_0.html?keyword=rez&_=1681906357794 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrDhcOGw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrDhcOGw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [19-Apr-2023 15:12:35] /finance/root/bg/ajax/clients/select/type_0.html?keyword=рез&_=1681906360555 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCscK0wrDgcOQwqC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCscK0wrDgcOQwqC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [19-Apr-2023 15:14:40] /finance/root/bg/ajax/invoices/insert.html?_=1681906485808 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 26 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

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '1985', `Language` = 'bg', `PostDate` = '2023-04-19 15:14:40', `LastUpdate` = '2023-04-19 15:14:40', `Type` = '1', `Data` = 'ZS7slWVO5nbh5A86D00yf6jQpT8rN7jwLO0UHZ0KSyUJMNT9NHDHe0zev8nLO2G2wxBBS-MxODnyeeQsZTmJkEpx-9n2DkHhqDWyzy-1B3e_goHvwvtkPwl062dyTrLaPVa0W8M0qVQ30k5tb3SBKGQfn40NCDGjNHXeCVphXG42VIoZn9lcdWPM8cqjzXN7u9qSyqvCfVij6-52S-HId-dmCIscahAsqt9ZAtm7EFrRJ-wQPC369-84n3691tEVMGwy0vJ3-CIvNDfFmW39O70YaXYVMjF9gvg63oWdowKVErG8Ye6l53cuVgxqK2aoCyeON6fBr9Ajk_9BXFGh0_YR25tkF6IAGYdwBWHaOtoRkhN_sCkMaMtXyos5XTYpyIjNYk30U4HvpgZYs5gWz3vl7Lqx8iGtSw8Pg4Qz2uVZLxS6waObnbwSBKEadhdXJZ9EUrHccBByvLxCbtFhZRGTL7H-x5YZ5vkcw-1fKFjAKiZskk_zo5pxWQL7OmE8_t7lEnWEZkUu_S1ijFL6VuK7Cgrn6rXsB0AXK2StmEXrDOk8C9lqymdBKsMuStqyLAGCshqQwN6j6pu_uHcDTzdrG92i_hv5gt9NUBLXwcBLNCexDxLjneVrZbmD5ak81INXcF0eNKMmoXIIxbZ5kF4g95Y80ZIsu6NDLy6itrQOLGlRzs_RQDUXEz5kV7jYDcJrf_NKXbgM7btxDpa3i3EnQNcsvoD8dcEI1U78dqlr2V4ctY_am1OcU_kEgMxTkNHWr6t8_LivrgOfqHA-Aue-7I6H2o9XNXvM2VQZR5o6fjpvkATkzXmae7gMu04TMtN_XCwD4nPXHHFTxJvYczPPZrnpcqSh7cGTRn8ppWiJl_ra3k3ZuXsurLgKKV9HRif2q_yOSEvlQYisQLI7g2DDTZwn8Kx5FJJ7D1YklKUGsEjZGPJJGR3Lcg4Zt9dmvwvuP1Vzs065dC0keWneBQZFyex9UZz8lABLW6CIRurlzQ-YyVq_evBGT8UZY1VAYKDCo2bQup9VqehROAVA-n_aEpGsLaOkLn_w4exRhrJpVzIXU-MXEc925eItNT_7', `SearchKey` = 'wofCscK0wrDgcOQwqCp8KDwqTCo8Krw5vCwofCpMKnwrDg8OgwqCwofCpMK8wrDg8OQwqCpcKDwqTDgMKsw4zCucKhwrChMKhwp7CvMOUwr7CiMKMwp3DgMwofCpMKjwrDgMwofCscK4wrDgsOgwrPCtcKDwqTDlsKrw5vCpMKhwrLChMKhwonCvMOUw6TCiMwofCpMOWwrDgMwofCpMOPw4DCtMK6wqCocKDwrHCtMKrw5rCpMKdwqDChMKhwq'
# [19-Apr-2023 15:14:40] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [19-Apr-2023 15:14:45] /finance/root/bg/ajax/invoices/form.html?_=1681906490782 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
# [19-Apr-2023 15:14:51] /finance/root/bg/ajax/clients/select/type_0.html?keyword=рез&_=1681906496127 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCscK0wrDgcOQwqC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCscK0wrDgcOQwqC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [19-Apr-2023 15:16:27] /finance/root/bg/ajax/invoices/insert.html?_=1681906592118 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 26 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

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '1986', `Language` = 'bg', `PostDate` = '2023-04-19 15:16:27', `LastUpdate` = '2023-04-19 15:16:27', `Type` = '1', `Data` = 'px6lwDOPJyEJz8jnXtjdWGUaDEsFaAmKjjCc06YPB0ab1f721RWt_wsvWzqki5jmM7-xqDhBrXdgm-lPOKBo8Z2F1YhN-UzBn1eYziDZ_oLqn6UwUwaB72KKoRLIxw3XqHRkOlGFiHCdoLmd0P5oKeJF8zqJpk2ZxuUl4HJ1WcpQysTujnTqEgclOgPctxzN0Zn7leVK4iK3ogkaxcQkdR_c3CRzCFXiRG1gwQVlcuAVTbUSOZTZLsqfQBJACWPyj--uHX2hfGNbsVu_Kq071khcE44qvM6wDR6s0j5MFXMmdvGTLtVCdtIwKqfFagjsSTZxV2NIukvDb69yA4fXX7Zw8R2jD4UfDLWSI7AHA_9N2w9F69-H1uPPL-1L_hKQrpRQG4oOKZobdoVG4LiauKxfrwsB5h9eH6UXQQ6wflKgcT6E4YbyWMFEudE1Rg5NM3d0aiSWUnwysh6evZdfUcTgCKvderDmYl2j0UYeizttSx7GGzvWNCoUN2FtO04i7Tr7sBiiZZBeVw0RleFhUFvMcapXumtkLwZZHQ2JxD5AzvsCgupN_qYyzuOIFFlaEkJn_6NplJDLynLa3YIY_o8-zFm1Fqz4qC7W0e27PPStmE41Rx8KdWPEanhdHf4z7jPDOHzedkObWg-HoPz14ZE-yvMF00Upc6-tnoijXU_1Th6Fwp_mf2-iEQ-HUA80N99z6CFcfzxXe3lUezFnVuNvppP_qWy3eXSAur-W1-gM_uE7f4CxR9YzcdxdhG8C70tYn177ZrflAh-GhJPAbMkKr0ZiDnFZc-nw-dxSANtSpMDmYClizxGtueH1f94qyhVuDVrMp-WUqx2xqKBxgH0nriZooBbeNE0pSqR07P8EzAMcLEP04lSeZBDAFeZ7MCtN3cxgJgJT2QJEwZ_XyQsyd8OYKsqGjuBsXUl017WISqDYORFXf-osy9A4nM1mD_mBDSfNVy_0076c4mvY8jcL5qsB6DUXmpb61JfIvXeOY27nqms_7lPpuc-xY8qKgeafg6_DPTwhrG1crLxIjszdgLCdXQ7ddUS5jllp-UvVvJ4EVNLZbuaVPLgD1-HJlouOONE9vsrD2UbFEzsZEh0VcH5fkuP5qwrmCqPUxdU', `SearchKey` = 'wofCscK0wrDgcOQwqCp8KDwqTCo8Krw5vCwofCpMKnwrDg8OgwqCwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrDgMwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCpMO'
# [19-Apr-2023 15:16:27] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [19-Apr-2023 15:16:37] /finance/root/bg/invoices/1985.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 1985
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-Apr-2023 15:17:06] /finance/root/bg/invoices/1986.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 1986
            LIMIT 1

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