# [13-Dec-2023 09:56:42] /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
# [13-Dec-2023 09:56:47] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [13-Dec-2023 09:57:03] /finance/root/bg/ajax/clients/form.html?_=1702454223983 167.99.142.201
# [13-Dec-2023 09:57:46] /finance/root/bg/ajax/clients/insert.html?_=1702454266229 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` = '55', `Language` = 'bg', `LastUpdate` = '2023-12-13 09:57:46', `Data` = 'jYCrRcw6G0atoV4vWURmrN6IzlTVUXMIHBoV5vjzi9KUW4EqLzPBjN-v2wctrQFdwOS45TPceeSat-UpxE-QmpwTxI85M_efJmnKjuUwyqvcY8XLzsarpOKOc65PDkRmODrEDOAGlJ3vselDQYPwXWQX2_V3R4Ib-CXMPWRykyyScFvpNtf_7pX8fijLMNAnsGMWHxAy2S3fsqYRgbG_KMVxbZr9Qq2rBpREa7b7PnRMenGtIU25nHxmXuACPtnYeq3c6vV2EqUjOByLumYa0K9Az_zJhaxARZwc1GpvSFiMhUZndoCAFu4rmpUCi1r1kX7BZU_o55NPg305HFn1Re86yjw-AArUULrYIJyDJ7qXNm3bSbrWcE-9iEwf3WUr4bQcxvUWs3tzfXB5H2HPcx-cfiatewalrsgcMLBfPgE', `SearchKey` = 'wrHDhsK6w5rCp8KewrLCpMKswwofCscOEw4DCtMK6wqCpcKDwqTCvMKrw5jCucKhwrLChMKhwwqTDgsKxw6XCmswofCpMKnwrDg8OgwqCwofCpMOAwrDgcOQwqCocKDwrHCsMKrw5jCpMKdwwofCpMK4wrDg8OgwrPCtcKDwqTDlsKsw4zDj8KdwpzChMKhwwofCscK4wrDg8KlwqDq8KDwrHCtMKrw5vDn8KdwwqTCrMK9w6bCmsOAw4XCpcKgw4LCuc', `Top` = 0, `Visible` = 1, `PostDate` = '2023-12-13 09:57:46'
# [13-Dec-2023 09:57:46] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [13-Dec-2023 09:57:49] /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
# [13-Dec-2023 09:57:53] /finance/root/bg/ajax/invoices/form.html?_=1702454273522 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
# [13-Dec-2023 09:58:01] /finance/root/bg/ajax/clients/select/type_0.html?keyword=fre&_=1702454281610 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrHDhsK6w%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rHDhsK6w%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [13-Dec-2023 09:59:51] /finance/root/bg/ajax/invoices/insert.html?_=1702454391461 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 55 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` = '2146', `Language` = 'bg', `PostDate` = '2023-12-13 09:59:51', `LastUpdate` = '2023-12-13 09:59:51', `Type` = '1', `ParentID` = 0, `Data` = 'Cz39m4df2PhxhUPjeDKIokx8EAuLi1OHqkop9w4IxURhkm1W5j25LUI3v9dyMLarOpmeVthUFZ6wJRwkYFoCzY_6T-6u-TG5hdVjWIaK0UcsAZ3HPVT8Yimx7cN3-b8U1_6FPeAawoos4R4LwUG2W7RwL4dlmkBeBLsioRZ7vtOUuOkteBhdEV-2I_H7uu4J60TFAi17r3rbaXAtC63RowwykuXRLIAm4ZHJlnGRxO-yMjZvZLGykxx5EwhkMVQLFdZBUB4qfZxgDHQtHpfdnPJEluHQoQy2mDUfH3PPLk67ni4fngelbOzpKWCMFQTmR1pta_U19_wBiEJYMBKNfjgneM88EaSBknUO4P9ixLy8ZYYeDyJOtyiU0ZguTiCIo3sc9RwGfVBYE2S-ZokKW_HYQhC9a0EYaRIMhWDKrCPxs1L3WjUJZi02Pvbwojq3jEyvbUQLPkRG7Nr_KrQwjysd3_sBiEc8lFWRlo4VCwVMoKuBWMnthWUyDkB2JWPJD7gDniaqy-tJRZ0-mqFZxT4Y4Wde0dNsWoyyJAXtf1BU_VZ4MWRTLbBuiF2pb56441bD-33NvAuav8AVwJTjuhlp7SiGHrwRXgOlLj_NkGUfAHRLkAZvWHKaUPLRZ26wavzHcj_rnVXvu9RJu-VM3WLbkKSbbv0MR_f1z-5QAkbony66b7Y2qSIeRRs-Ys8D7m5-km3Q4-Ug-92J5r21JEw57CnTemJDUPK33hTXeiwyX7oQt2pjV4YQagCjOso4LwHRQ790IPL251B_Yoda5oU4cL-yQZjhDh6TmAUGs1focililGu8UA0NkWnOtUJPvgf8vb_5h9d4rXNTOmWcsIvoacapEzktR7grSvlATGky11478dR4i7uoxJgAVdUUw5iMxlqEyIlrpyU4n-LlworMy2EW71dfHVhQhydOYRE1mEiK4KKiQ86fg0_kaRU5on00ntdi9pwsl-RBHu_A0XA2_NiYo7SxdFRug89CJX1qhJNt9ssosnCS9moWFWiNQCM37afjTowETG9RjAmhD2NC7KOTNJR1Il5by5TQml2JnRtcRMk3pJD5YdgaLnZ0BFTSCfMlwjXKctpVMKBMNzYO7dQDFDDE5oTZdNrQSvw', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwqTCvMKrw5jCucKhwrLChMKhwwqTDgsKxw6XCmswofCpMKnwrDg8OgwqCwrHDhsK6w5rCp8KewrLCpMKswwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwrrChMKhwrTCvMOWw6TCiMwofCpMOiw4DCtsOgwqCwo'
# [13-Dec-2023 09:59:51] /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
# [13-Dec-2023 09:59:53] /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
# [13-Dec-2023 10:00:54] /finance/root/bg/ajax/invoices/form/clone/10383.html?pid=10383&_=1702454455003 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10383
            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
# [13-Dec-2023 10:01: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
# [13-Dec-2023 10:01:20] /finance/root/bg/invoices/2146.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` = 2146
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Dec-2023 10:01:46] /finance/root/bg/ajax/invoices/delete/2146.html?_=1702454506986 167.99.142.201

set names utf8

DELETE FROM `invoices` WHERE `ID` = '2146'
# [13-Dec-2023 10:01:46] /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
# [13-Dec-2023 10:01:50] /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
# [13-Dec-2023 10:01:52] /finance/root/bg/ajax/invoices/form/clone/10383.html?pid=10383&_=1702454512994 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10383
            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
# [13-Dec-2023 10:02:02] /finance/root/bg/ajax/invoices/insert.html?_=1702454522604 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` = '2146', `Language` = 'bg', `PostDate` = '2023-12-08 10:02:02', `LastUpdate` = '2023-12-13 10:02:02', `Type` = '1', `ParentID` = 10383, `Data` = 'wcRMS0h0Sg_7cRNTBHUntCwTHdrEUVkLul-4cjKGC7nDl4Wqh8AuUwR_RSKoU2zibA2wsaWosBOTQCmMWDGpuOif8C5xNlvM35Qm5lRgtnPDk9hNfu-GQNVjJO7lKe5qcU1pP7EonA7fZiTASbhdMGHip5Qt-QQGC2s5RFoflqG19Siz-1OTLjv6aG6PMoF1oN0tOdyeFnxiBYzkewm2KCKxuMv1Kpq0C7E9NRrwK6z2CYaZPjrXuIBi41DyyNWAFXmDto2xG5wfWVkFBEKBskgXEGYYy9NhWcZj7KaLB4HkZ1Lw5imJi36UEgQRlwxvEKAeoCmfFPHhozBEQlvHLa5xv5-n5lt_m8T1AJ9EeeCaQf-wKY4fi13jJapaFTGVaVReK93pVqH2RW0ThRgUr4rV4sBHUna-eMgicCwQAU0BoeskAAZ3L8elMGrp4xj1Uzi7rXnpLoV5wmzm8SP3bNsEf_Z5jNg0MKJSsSu6s5P0hzmDFidk5AeXBqPLjLxYN5fY3ctw311QVG5-sAAY71rvsUtfDBhb2yUKJ3BRQYWIIwkJVuxWEuBVgYTbS2lp49Y27uj-g6RtCbj2_jQ3RGlT5enFLG_E5n5Whzbfz1CJM3zOdwrzB4TiqiWQxKp8RU-uYFOzxAbxfQkWmVSoDe_E_XqA6YyYgtHIa-vX602v5uO_T4QCmid0Fq17O3cuYRSv6iwoSr2dreQKzBVHqGsUTxx_3zu6GxXZp_SiCm7_R-uFCEYz51MNcutfjFAGTRtdFMYJARVeIxlK67HzhfP7UF33BYxWpEB4YGziVYMuBY1vh--uh4iedo97ET_tji7Xq40u4yD33i2NHm_DnAmnxVw_jdMzM287WyCAELXUKrqpHuDDxsWa0TtQSEvUAoP78mCtLwuS0LULhmvjXdU1wK6M1eB8ghbCjbEnveQ96_E7Df0ekcTDblF6-E0-f_As2Qcf5cYCg9R_ub9Nl0cFSle3np4b7Vb3TazSxNUuYjzsdvDPJRNoupxwDPLUyMb1FQ5MliOiUsAEFD2i07_9sSHuMANFljOe1naXL5bqNokXQxCodG7GGrxTNZmA', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwr'
# [13-Dec-2023 10:02:02] /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
# [13-Dec-2023 10:02:03] /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
# [13-Dec-2023 10:02:07] /finance/root/bg/invoices/2146.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` = 2146
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Dec-2023 10:02:26] /finance/root/bg/ajax/invoices/form.html?_=1702454546947 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
# [13-Dec-2023 10:02:32] /finance/root/bg/ajax/clients/select/type_0.html?keyword=fre&_=1702454552560 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrHDhsK6w%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rHDhsK6w%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [13-Dec-2023 10:02:47] /finance/root/bg/ajax/invoices/insert.html?_=1702454567980 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 55 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` = '2147', `Language` = 'bg', `PostDate` = '2023-12-13 10:02:47', `LastUpdate` = '2023-12-13 10:02:47', `Type` = '1', `ParentID` = 0, `Data` = 'C4ChTohnzdVBIA4SQoSwhtRuhm90Gpo5nW7wE3JOzPaw_rMtiyQJikiPLdfQJyAJR3b0Ii7GIrvXWJnwIcc1Ys0fFp_k03XQ3sQxO0Ozk-yYxP0LsJ_WVBER1sHSpffNc3o_PXnGfvuWVNLTj5BB33mDKvKxu8OnnTK4oR3X-lHODst1nwkcRWJqnF9vZJQBzZLdxfqG0EeimlWI8lJN_cAcc-QWZcrGnh_YrYG3P_qpE4s_J-35LeS3ewc5w9RJ8MllwhLZZScX7ZxFfrBBqcOHlREXUQBadlxGlPuYVi_PNDG0HAiZxsDj-EgbZRgiaFemLQwc3OuN6ZgbvugXupg2X0UnE912xalDhoOA0Bp3Q5ZS0aAnYWJ7YOg15iOvIaborONT5ChHD7rTUJM20PV_SePUM6XkwzAnq_URFYefWxeiScO6Ex_zwrXTtrKc3-uDiJQmCE7dhk_E4P-Mc44WaIzxjiddMgmuauWIfr2wJMFHBvavZsP1GEuu_jMfiE3Pl4tl0_fFR70Yp5g74XMRw2HGIVHH_CfzcT9pVn5lzX3c5VEGPx2iKRCL5ftRPCWmAPfmAV_7OMRac9Fukn031oTF85l11ALqyrZ9Myi6G1MBLAGzh8Mwa-knm9XgQ8yFz28C84trEYl4OP_EnOEgJNPK0250XiPHaqzNrezBLtZk7jP6qrP-EMWGHKCKh_DYJo7oDqD3zyQ7iq5whOAr1f2Qtit1pdW6MNlCU6slRgVzeqj9COODCGk47no8I1VHSFGnXyIirfBHeUBMxFUuteKC9EET1nLRzxmNd_siiDkt4RH9dE78VQOh5OnsrixDuEsYKV3UMs_ZHVm9A-jjBNVEW48Y9bK-YnbAaNDADA4vb-nd5v9nviU8JH8qCOmhHGRl8B5W_reWLGQ2H7sWD9mfjavlC3rVA8GGKb_bA0yjaIMjhN5BZmUu_j5ITGNYUFCmY3eHNU4gtooovvJNmGHJY5jYFlQvCZNdtGcR2STYE9R0tz5VPZuWJTEaxOOL0ZUGNJWOKmePVKfTZsaLbxqAwXTi-q-2pPyrZ3jB9qh3lYvLLqfmuy4CMewGPvXuAomFKbB4MZR9m2Lw53oNfTcB0eM4u8H5jMrulEY', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwqTCvMKrw5jCucKhwrLChMKhwwqTDgsKxw6XCmswofCpMKnwrDg8OgwqCwrHDhsK6w5rCp8KewrLCpMKswwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwrrChMKhwrTCvMOWw6TCiMwofCpMOiw4DCtsOgwqCwo'
# [13-Dec-2023 10:02:47] /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
# [13-Dec-2023 10:02:52] /finance/root/bg/invoices/2147.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` = 2147
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Dec-2023 14:05:49] /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
# [13-Dec-2023 14:05:56] /finance/root/bg/ajax/invoices/form.html?_=1702469157445 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
# [13-Dec-2023 14:06:00] /finance/root/bg/ajax/clients/select/type_0.html?keyword=hea&_=1702469161375 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrjCn8OGw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rjCn8OGw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [13-Dec-2023 14:08:54] /finance/root/bg/ajax/invoices/insert.html?_=1702469334098 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 44 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` = '2148', `Language` = 'bg', `PostDate` = '2023-12-13 14:08:54', `LastUpdate` = '2023-12-13 14:08:54', `Type` = '1', `ParentID` = 0, `Data` = 'S7THlmI5XHnr9Q26XPWhXWsyXC9IPpg31AKVP2jaEaQJyl7LPWTfqwQaKouGp2sYNSgrcru72IuKVHcinsW6LgLHEMW1mZtfvVp_EWpZwSLVssLxxSGEHFOR2a22VGcq_JQS3p6fci7niXuI-OknZgyveJyoYUWLf-wfxfoxqo9Wi442sGPOSfXiZhA95Nly53AxKTMvWwjz9LywbHb5rf1q2VexpwLgkARD81LUZyd7mdDHv58GRVjkBBCSRzy2DypDn8UNgO5QwYDrXYFvcTYAhRmhCPj5xWG34hxatAOhjZeCX8ykRYsdQkvNVI1MnTUwQu2yCyHOAoHpWc6dmaqiyNFMoahXAckO_HTK_TAe52_tlEHPGtkkydKQ7CfK5rHLAJ-1r39MxwxxVG7fTn2tQDPUOXqwIhIVEtZIByjQzlKc45j8ZbIytY0LaF3Vm2LCT8W_zwJQstXNLWYK35-GDeKur4vkTZGg46sKkMrFaZQhGGJLKA-T0CxLjn1oUne30XkZrVd0Q8jrRx9-9sYTigYMj-j4hUdGucEyeQP7dPYq8hGIA3y-gzKYfIwvs_QEzbetA_T3IUV0qrlSdEozfRxslppSoVf1DYZcIB_wyI6Rk3JSM-wx7vVHo2fWJ_3v5ghmyJeMNCfc5y-dKS0gausysx_suP5oukCArlPRFRLt45Yx2Po1YI7bR5NAONn7cA8cs07niRt2pUbRrIv-XLSkL7yVc2p4TMuHdRglbQeyn571igV4DEIwQcgYTwrYRVBOzGH2fItRt8N_UujnmmQZt3Ai3PiG2gYjrXaNzLKesrKqce3A9KJJgUH576a0zcxzzcSkk8nBf2Oq0lgNu_nvmj9NMTOLY23x0a3y47rmKEXGeiTkWUjFk8u9AafIjSCIRQ8eTA5Gjo_RNfWwyFimWtd_Xopc6ulF3W4h8eglFulKQz_ZZauyoUfTfCHK3PyC7DxBJskPLljqCgFGLoXlnvt8Y2OuWwbY6LPYRUvic7gmc7fjyN0qvvKrpCHfsAseVTp3GKgIbCOZcpeu0g6YFlkkLIqQi1Qzpej6-iZxkS0szYir-MRkp1sOc_pK0hv56k8_gFnwaEeKjLKKik4WH1WNAezKpz3M0gSJxmnfzDzhJi0aHHVECVoo7Gj0MBe9UmTmBM3LXqYddymF1lpFQnudwrTIOVgyBU9nf6NXKRoGUYC_CctM8HhnUxf9ltsiuEIrd-21LslkmxNfw0rKhNwmDjzyXP_uHHMcZz_U6kf-GnFEqDEA_djDHOlJbEt0Yerzx7_me6HlVaoQ-6fbd74naAi1YDYpOhMOpYera7S2vC9aByalBxYiha0RtKO0FPCzMyPcQwoKtTiKhXfM9hIXb5wgrJibQKSCGo4Mi8ueb8W-u91HAvgWtcawbeOwLp7srnB_LxepTocbdv2h9E4lUFJ9bDISQgZPo3-cs_RZ2NmOwdKy5zLgkoBiBMgpRf9QCFKvedLWmaY3XTvnp01wWJDEOrwtfC5XCjwYPGQVb4jH0EYOo6bZiZhOr7g7hi0pUPOB48DlhWlCv2MTzW-vUeMK9rdyN_31GG9lId-N_SyuMwHlPwEi68kqTLPYATQU3Zuh5OnE7VrXEH3pyqvi09XqFRjAnR1-Zd95d1TLVTQxiY3KvPbEGrdaF_3rGrrge_eLrnaydtfAwEJfviTF232dv7mPEHv3WLnJ5AZlZURlwebhoA_wCOHY1QO7HDvRotvlNdklLSWWJpHe3Wh1bs0PgyqDuYquRZ2NhJsUNKMbw514NFzkrhNoqBYmQ6jH9atOAcUoRveoxeltaqrLGcWNyVxhxB0ZMJVqtyz5amWpw2CvkvPCeukkS5KaVZCqPRfSOvNFmNjzeAXAQQKmAWlTMewIfZ1_9_j88dyPM7g4Dk5mx0MzUsSMlyI-8eBtQv7TkD_9lw', `SearchKey` = 'wofCscOIwrDgcOQwqDrcKDwqTDwofCpMOiwrDgsKlwrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwrjCn8OGwqDCrsODwrrDp8K3wqCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDg'
# [13-Dec-2023 14:08:54] /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
# [13-Dec-2023 14:08:59] /finance/root/bg/invoices/2148.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` = 2148
            LIMIT 1

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