# [21-Feb-2024 12:40:07] /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
# [21-Feb-2024 12:40:11] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [21-Feb-2024 12:40:13] /finance/root/bg/ajax/clients/form.html?_=1708512013746 167.99.142.201
# [21-Feb-2024 12:41:12] /finance/root/bg/ajax/clients/insert.html?_=1708512072685 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` = '60', `Language` = 'bg', `LastUpdate` = '2024-02-21 12:41:12', `Data` = 'QvFZure7eeblHb7IdVbKmQTbcTOy0YwlCdNdniX-L_pj2Q7Tyb8kiHCvrLzIuivHFrVJCqIzJTx2g5489YnJYUvkrWvWQH7l7p0OedG-9LP8PguvKgS0W9WPFRlMVupdqTeBGgZ7tocXSu7hZoSjMjjpTm6GMWtV8Fd7lCdIiW_el0SpcaWvUWotXzUBkcuWZmGyH5ms1OjRu-KIz3UASELDUpcb3ZevbFkg52E4JucWZe4E7TIyZ9p5ST100JbN0LWhCKTgELzpOl_KK84QLhgSE6fjeF1TeUguAZzPgtN8jeCiDxHnkU7_-rn0pHWQ71GBvypAek96GqLvWV-RZV4ISylO3Km3L8VcyRhIVHTv7-4k-BiuVIRvLHbVegd5', `SearchKey` = 'wrHCr8Kpw6jCr8KzwwofCpMOIwrDg8OgwrPCwofCpMOmwrDgcwofCpMOEwrDgsK6wrPCtsKDwrHCuMKsw4zCucKdwqPChMKhwprCvcOLw6TCjMKcwp3DjcOTwqPCvcwofCpMKnwrDg8OgwqCwofCpMOmw4DCt8OgwqDrMKDwqTCo8Krw5vCucKdwqPChMKuwwofCscK8wrDg8OgwqCpMKDwqTCo8Ksw4zCucKdwpzChMKhwwqTDgsKxw6jCmsOmw4XCpcKgwpzCuc', `Top` = 0, `Visible` = 1, `PostDate` = '2024-02-21 12:41:12'
# [21-Feb-2024 12:41:12] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [21-Feb-2024 12:41:18] /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
# [21-Feb-2024 12:41:22] /finance/root/bg/ajax/invoices/form.html?_=1708512082476 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
# [21-Feb-2024 12:41:27] /finance/root/bg/ajax/clients/select/type_0.html?keyword=еос&_=1708512087700 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCpMOIwrDg8OgwrPC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCpMOIwrDg8OgwrPC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [21-Feb-2024 12:44:07] /finance/root/bg/ajax/invoices/insert.html?_=1708512247644 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 60 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` = '10395', `Language` = 'bg', `PostDate` = '2024-02-21 12:44:07', `LastUpdate` = '2024-02-21 12:44:07', `Type` = '0', `ParentID` = 0, `Data` = 'UzKgK3TAGi83_mniyOoCzjxWveaMTOGkk8XqxJKJTbVYGca6IB37ri6qwk4_nfWSxVigFGIFYZ9VzIQBb3h9qeqjJv2o8floZrobfhy9nKM9hdJqqoZURXzMddpyhMb44GCaDUPHcAr0yPALPw6zpPmKKWHKuFtNzuQCzoupRq-xQxzjsnqLvvCG1SEeoQ1XU44oXH27vk3Je0TpNnO_3xm7KZCf2EwcYcAJ9SkYenq2IxGARdlqqQ_F3ei4SWLmA903CMIODePxyCqWfEzNjvLXhqTfwqvtU_qL348Uif7afGsM2lQELBpxurllnmJFopvjuD51HDC9BIzESMsb82rosmB5A_C6XSwxlrx-8pLwImmZzO-jowhEAYwm3UTh528m2oExC_yBTMFbMXrTWJFbnDPeoc_JrG2bWNqoN7PfkarebwwALMAJAPV6mqF-12E4HR7P1eYKPUDpM0c525jL__26zS1n1Acl0I0qmjQUc3S9JYpu3l_o7y5bqpZzjVAJ60p_uZibHL0F04nf4BtPANWpXWe2RdWLSIRq-WYtDC4VgOwGIaCeTurvQg4ZM_uDx-1ookWgx5CbuVL4xfM2Uwr2cczoEBAxB6tARNwQEZ2uqMuFwgJ4NG1Hmj5gO7hV18KTYGPiUbM05pgol9bq-cFBJgk7WiB1HaGb8q-zCp68yTnNwsClJhCi5pbbHXyf0MvG0OqzlfCNwMNSRdTXeDbIxEmHIBaT5_A4NfqF5C4oHcr0uL821SuBBgPUxadCPK0QPhKO4hw0naaVfys3MW5ykatm8OqlxeHynWooJymMpGFLOka9MBuO75IyYdDRRfla0N97wVLk_8k0AFN9_hZHuqIC9DMQHiWG1orV78N1k7G-Yiuo7yl7xt_0VefRU7ciW1zFBnR4K6JMogYH_FYBOaMSCh0EVgafnw1O9TN4KqQ5Y8_-upNYua3l9vz9UfJwDZb581_GCua-Pg', `SearchKey` = 'wofCpMOIwrDg8OgwrPCwofCpMOmwrDgcwofCpMOEwrDgsK6wrPCtsKDwrHCuMKsw4zCucKdwqPChMKhwprCvcOLw6TCjMKcwp3DjcOTwqPCvcwofCpMKnwrDg8OgwqCwrHCr8Kpw6jCr8KzwwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKr'
# [21-Feb-2024 12:44:07] /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
# [21-Feb-2024 12:44:09] /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
# [21-Feb-2024 12:44:11] /finance/root/bg/invoices/10395.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` = 10395
            LIMIT 1

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