# [07-Dec-2023 11:30:50] /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-Dec-2023 11:30:57] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [07-Dec-2023 11:30:59] /finance/root/bg/ajax/clients/form.html?_=1701941459455 167.99.142.201
# [07-Dec-2023 11:32:25] /finance/root/bg/ajax/clients/insert.html?_=1701941545466 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` = '54', `Language` = 'bg', `LastUpdate` = '2023-12-07 11:32:25', `Data` = '0csDXt9FMcoriLtnrkKY59GX_n7nOt-ewVqGbqMlx09OeaBCCqRBwKQwWXgWeFdwshG1OdhGjJr6_BIjdrnJs-lJz00HlR9YZ4VJXnPEaLONhuO1fpDwifaB042D1fbLdI1ln7LT_eJWe6U__95jChx9SQCyJoFlUTWMhKbzFNHjEZiBjzFdeQkha36DqQOvmePoIyu9BxYs6cYGGrjxm8H4JZZnckg6LOwT6jCxwu-d8bCbwxHsHy4JwLpSTarD54NTMSNj1HBNOU3OdHn7228-Ye48l8ODolIb1Tnu9VlMg6JWQ5mD7kMQZ2nfyHWw8xxkA95IIdWmi8Xj4TfASdxbOyiZFftgbd5c96mzAGJZOEExphyPuT0pdO1LXX-P', `SearchKey` = 'wrDCsMK6w5rCscKzwwofCpMK0w4DCtMK6wqCpcKDwrHCuMKrw5nCwofCscK4w4DCtMOgwrPCtcKDwqTCo8Krw5rCwofCpMOIwrDg8OgwqCocKDwqTCwofCpMOPwrDgsKlwqDq8KDwqTDpsKrw5nDj8KdwwofCscK8w4DCtMK6wqCqMKDwrHDgMKrw5vDn8KdwqjChMKhwonCvMOUwwqTDgsKxw6XCmsOmw4XDq8KgwqzCtc', `Top` = 0, `Visible` = 1, `PostDate` = '2023-12-07 11:32:25'
# [07-Dec-2023 11:32:25] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [07-Dec-2023 11:32:31] /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-Dec-2023 11:32:35] /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-Dec-2023 11:32:45] /finance/root/bg/ajax/invoices/form.html?_=1701941565184 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-Dec-2023 11:32:50] /finance/root/bg/ajax/clients/select/type_0.html?keyword=are&_=1701941570345 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrDCsMK6w%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rDCsMK6w%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [07-Dec-2023 11:33:51] /finance/root/bg/ajax/invoices/insert.html?_=1701941631906 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 54 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` = '10382', `Language` = 'bg', `PostDate` = '2023-12-07 11:33:51', `LastUpdate` = '2023-12-07 11:33:51', `Type` = '0', `ParentID` = 0, `Data` = 'YI5u1Ykq1L2hnR-2akdRCto7iw20FpzZcjhpdMLE6F7-PezmQkXOgTx6ksfZm2yoYrVOS4ijoqmD6L8C4o-T_MsvKxwmq2MmxFbCiyqPFYPErhErkv9HdcMdqr6e1Ji7Yz72O3uSnWmmsw_EhmSRT4RCeAl1VILbhEVCVnaFtDgYiLJ3nTU6103h8euipDd_winJWmwUxUzHUIp6O-acMsGAoQRf5qoMMLNFUnu9mi6egUqwVliAAp_aoMFx2njkihxazrgHZ-rH9CrBYRAG4ai8-kC0YAg5VvT6fg2qKCTWuU8kza2i5Kgcc5A5Oe7GgMxOimIcLtmxV6fiVWTQyqZ9s-8hBNn5azD4ZclApvaBEmZg6jY-Nz3gODfp-YPh4a_TvUA-mdyanxROdj1L3VOhJgBCPN6jzGk4W3dc-fCSmGqKGTo9-7rKl5QczVxCYflvlsT1h8ybCeiMzm3vf8Vxwd1kfXJOBC4iQnqy1frB3oWncwXrDPMAjhf9VKt-B2GfAMofLgToqvpu40MbXdaelQnBDtfBsiLIjkKr2SWR4BqIr7m0ClrQcFMke7ABUT0qHbUh9qhZ5lPFNFkgToyR3X3A7mIleT17ui3bvCh_TnEtZXiL7Hd811MIA84GsyAM-lYA9yrNGmV8lt4PVfmYH2Lu1EZ_0oA_8yOk4OzgAQYOQKz_TU5wrvVEHJTxQi9Q5XSR2clfw72yUUUn1UN42nBEODo7n7Pv_L8GoPROln0BDPXRohFG8B63Bjyv-qR1pujwPeXgG7E_oc9YZCmKBiP4N7XsmoG-5U7xZwXkZyS2s52ZnMHvm2VeD7sUgtzvGmfsxbL7IedJblirRGXyTtYb7Ytxm12mTwySgKFamnJekhsc6cuGJSeaVVq1Z3HJ_sCdVs_oIGzPe87PckEG4BfO_G5WYk1tMHBl1BApQ-YvqHvOABPgEgh80iAcJUR82B-avhCmaVnEETkFE2J0jKPJ5fThPwLYFmbKIp70c6WhWvhn2V1beWiQ1ollr_vpF90GXty0b5GVO6d_eA', `SearchKey` = 'wofCpMK0w4DCtMK6wqCpcKDwrHCuMKrw5nCwofCscK4w4DCtMOgwrPCtcKDwqTCo8Krw5rCwofCpMOIwrDg8OgwqCocKDwqTCwrDCsMK6w5rCscKzwwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrDgMwofCscK0wrDgMK6wqCp8KDwrHC'
# [07-Dec-2023 11:33:51] /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-Dec-2023 11:33:54] /finance/root/bg/invoices/10382.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` = 10382
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-Dec-2023 13:41:19] /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-Dec-2023 13:41:22] /finance/root/bg/ajax/invoices/form.html?_=1701949283626 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-Dec-2023 13:42:26] /finance/root/bg/ajax/invoices/insert.html?_=1701949347308 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 2 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` = '10383', `Language` = 'bg', `PostDate` = '2023-12-07 13:42:26', `LastUpdate` = '2023-12-07 13:42:26', `Type` = '0', `ParentID` = 0, `Data` = 'uEurPGz6Bwzcu_UUs3gWD2HokXd6YqJqocKUoWz3_sn0zLbPsdXIKIn2Uf6IHMjg2m_l0L42JxXjoL7kMRBUktTuMgvbZCwOFKZqVXbSDh30hXrIlOq8tcggJjVCIkzjjODQs0OmGNF1tAiz3ruc_E_x8kz8kUxsdmnna5Oja-KmOQtuykz5RTMySneyb9_M5PZZMHAdl_Q2ORt6zc86iadd8DKxpQUpDUixjaALv6sMSUVy3eJq2yi5AqP4R9TtmvGp8G11DSGr1nMLNapzhS3MYoWYWLERC5igFN9bHXfd6Qx3Uesx8B5YbYrPNhQcEcUY6M34ZFi94AUyqpyTCE6qPY_Els7iSDBM6qBKa8JusiOpPAzCOLPAVO8xIwJsTuoePGjVgvRGZguLf0dmUOaCPlUcACcOx2qApcRSa56kGPDtz6t4nwr9iXNqH6YPDePEIlwbh9mbVsOwHgTZQtSGN50fPQR8n2aV9kZRRCkJeg-oyO2leEJNhQC5Nj2o9BceRMcNA2xb0Phk7ad7EQ5F72iTw8hhgx8R7pgtwfyAF3HHh6qGHo_XDkeB1wBHQYC4C_LFAG2fHVPKvu0oYmDql8fKVY0EiyJuRPKyQLszEHC1HdHX3gqRdE7xE78nZpvABLONeUTkF6iBu6faDmBj-mIayCWghbvCiPyZ3FRzdd_nsAjwB8uaUUYEKwvUC5ETjNPnfkIgG6osWHH5o8PFnxDEVDGN30up6WZlYyGsZ4JgYVUegWGUQXvYaOAYBCva_iGZVOblyiSe6oteaY-45ujnUvLAOZJXUuKGyhgY9c6bhjDGuKbCfohM_MYKCXfdHerTSd-bYGmjPu0-BZHTI3AILzWl1opJCsnIRsaJi-FcvT9dQtE1ydHgbv00vzM8rb8EpC0vfMG5E0sU9mSaowuBbqzYwN34u4iR5rdq-jwrkaHgZUwbG35MAXE_y1szXVHsydVStiT85gq3_Myd7iKMDEgQY8Ez-ZQXIFn3_lz9kQfGLvvLszdxZ5o5A7HzCvqWzLRd3MDcufB7rs8ENVtsao3EZJFa1L0uoxIMmd97s5XNKci9KQffxwyd', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwr'
# [07-Dec-2023 13:42:26] /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-Dec-2023 13:42:28] /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-Dec-2023 13:47:42] /finance/root/bg/invoices/10383.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` = 10383
            LIMIT 1

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