# [05-Jun-2024 09:21:16] /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
# [05-Jun-2024 09:21:18] /finance/root/bg/invoices/2262.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` = 2262
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2024 09:23:13] /finance/root/bg/ajax/invoices/form.html?_=1717568593253 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
# [05-Jun-2024 09:25:19] /finance/root/bg/contacts.html 167.99.142.201

set names utf8

SELECT * FROM `contacts` ORDER BY `PostDate` ASC
# [05-Jun-2024 09:25:23] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [05-Jun-2024 09:25:26] /finance/root/bg/ajax/clients/form/1.html?_=1717568726157 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1
            LIMIT 1
# [05-Jun-2024 09:26:04] /finance/root/bg/ajax/clients/update/1.html?_=1717568763551 167.99.142.201

set names utf8

SELECT * FROM `clients` WHERE 1  AND ID = '1' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'clients', '1bg', 'YJCF-L2s98i1JwBKDfRPtadUQRZ0hHyhPZjr_cX4ErKJ22DCDqdmRxDzCAtqFGqjypWsro2nze98swDKX0nY5A6LJfK4tntjUBXLi_5NV2FGlbsA9CgGH6Mj5gmHCYtxPYMjp6eqSd1kdCKiD8S0SEjRoSK3pmsaTXqCBIcvcdjfYDwLge3DcoUA_G0CKLRwhxYtACHC-cT-05eocS3kK28ges4HQiu0O28ZNGbfJ4nKrDexAg6f0IjcXO7W_ChS_bZSIHOGlmVFOFrR-uYEeqim4AiCSpc6jct_i48CvyEJIY4kIlZ-iD1fzedAzgn4gSm-B0FvHRZrfhPRR2EXP8W8oLCYzSbv0cb_brW5WBhxHG5adXoHWG7N0Elv5jm5rzO5E3vGdL5AVrkWwDLyKmEP4Ny04lnUeTBKKyx39ZTY15Pra4XIhVQaCFtjbUsHEw6sARnBA3ebuXcPBw40pTylngw775Zdhf63vvzZwfNWXKE4fSQfbVTSS7yIQP2MlrlNEqf1LS61Tr9zIMzHbcyC_JjnFxaYIJAN6jG5PPqi3gGLqkWuw2mnZN6DO3Tmk0hA6Te38fnyRBziST7_NbrIG7oS5lvHuI0SFGm8Xvtyxby_axSS_h82dCbwULPRsXvAIzwKr-wgLfIdRbGU0rcWOLVZLlDPr8Dpgp5QfdznGpFXUFfboqIw2vEb-_ZG2pVJQu907Ma5_Oz70Q0xOmG5jeu-M_f8fm86PJjGklXqyXqNjPex4lqggweRgYAooyL7Oubl3hLGeNHcJhNfYMh93oOUO387nqaqU03NR2FufH4rJyyLqQWFVgsGeVxojPLVy-rhlCwsZCXrL0lE8Mg5cm6xIrBVWJ55NRLrwuv1lnb-YG91YJ4GjnyovuYYudF0ZqtqlEksLsKNC5ZtDIF3tNZFAkoprEJLK3e5Pkp3iHNB2mfGFGjGfLI6OkLy0-jZ3gCXZh_WLL7FZNEhRccHMNiusSDt7AYxWJRag6rf78m2-11IrReVU7Z8bNrPnnCVdEhIY48XG2gr1k0epitJ4GXVX1NQbS_OXif89Y9Ty5YUGA-nNcjLHGO47GNI')

SELECT * FROM `clients` LIMIT 1

SHOW COLUMNS FROM `clients`

UPDATE `clients` SET `ID` = '1', `Language` = 'bg', `LastUpdate` = '2024-06-05 09:26:04', `Data` = 'i5YOUy8Yz_FZhVGkmrQfVGtLWiR_svR6T6VTgotTkngH-5FOHfiQD6Gxo4ZXeo0z94l5SCHeGp1WRRwhu7-zH3mF0D5Qp6dw0u6LI86EDWHXpUh-RHsUmpcMdIzq2wDp0YIlGcptAJhYPkmd73HloCDMCRU7sqaddG2ra4ldAXa99Ln3pTl40YKO5oKRukV5ExGZChPRuK_ZIPYU4pa7fR96tcUQv4RkxfHVeaf9LdcjAzZsLYuLjbAlOEzeyDP9k2GUt6qknPTxMOlUcSiNm6PwrRjqcHNFqcqFOIpXEJD-h9xcvEMIYAyvutlO0ZUaTDddfZ05zKjDH4rI_YxPykZL0Ul3kvmYWacyRpWNgA0', `SearchKey` = 'wrnCr8K2wqLCp8KfwrbDnMK2wpDlMOKwr7DwofCpMOqwrDgMK6wqCqsKDwrHCwofCpMOAw4DCtMK6wqDq8KDwrHDgMKrw5rCucKdwwofCpMOIwrDg8OgwqCocKDwqTCwofCscOIw4DCtMK6wqCqMKDwrHCtMKsw4zDn8KdwwofCpMOEwrDgMK6wqDrcKDwqTCsMKsw4zCucKhwrHChMKhw4TCvMOWwwqTCrMOTwpCmsOAw5PCqcKhw4LDgc', `Top` = 1, `Visible` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [05-Jun-2024 09:26:04] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [05-Jun-2024 09:26:10] /finance/root/bg/ajax/clients/form/1.html?_=1717568769461 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1
            LIMIT 1
# [05-Jun-2024 09:26:17] /finance/root/bg/contacts.html 167.99.142.201

set names utf8

SELECT * FROM `contacts` ORDER BY `PostDate` ASC
# [05-Jun-2024 09:26:20] /finance/root/bg/ajax/contacts/form.html?_=1717568779773 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20
# [05-Jun-2024 09:26:43] /finance/root/bg/flow.html 167.99.142.201

set names utf8

SELECT * FROM `flow` ORDER BY `PostDate` ASC
# [05-Jun-2024 09:26:47] /finance/root/bg/ajax/flow/form.html?_=1717568806709 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
        
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20
# [05-Jun-2024 09:27: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
# [05-Jun-2024 09:27:19] /finance/root/bg/invoices/2262.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` = 2262
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2024 15:36: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
# [05-Jun-2024 15:44:11] /finance/root/bg/invoices/2262.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` = 2262
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2024 15:44:41] /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
# [05-Jun-2024 16:27:39] /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
# [05-Jun-2024 16:27:42] /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
# [05-Jun-2024 16:27:48] /finance/root/bg/ajax/invoices/form/clone/10402.html?pid=10402&_=1717594068120 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10402
            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
# [05-Jun-2024 16:28:06] /finance/root/bg/ajax/invoices/insert.html?_=1717594085954 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 63 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` = '10408', `Language` = 'bg', `PostDate` = '2024-06-05', `LastUpdate` = '2024-06-05 16:28:06', `Type` = '0', `ParentID` = 0, `Data` = 'SDNv7tu5oGZY63VqmxSAC-EWkR1MbKnJzimWX2N96yZBY1hnSDp5JgMsrC2L-dCBMhRSgUGd5LKNh0NdSIiJKcCOeyGfYYLHbkM2hlHlhLh3T4GWCmCNFDixNeiS0cYsh9LqbyEM4lzci-O9h5WPpJJDAKyh_6GoZ1PVtvNqwdp5WspWIQfT1Um3wgVy5XfVtfJX_tKlJPLuKpCMbAUwUYF7KhNHH4ptY5dz0kxJwyvCD6UPFosnOEoctSVQzFGEnSrLvRbG0tb7wUmoS3tHEB1gFHu6Ip6_gY571PfFLbt7x-ULPkkkUKrVUw7med_2hatXL9FxgeqmEYGip6oFFj8O-b03txmSexdxcU8m3nb-RqiQkWp0Xp-qgzRWEolIsVnuq_DDTNqDcALSfDUED9C1WW7sU64djLz9yUOXQsVKXv5e-6Eh1QlZVqSQzyF0zCWjFP2wf_6udhMmvu2f0nyDlV3Yaf8-uFSd--rk8i6I8BA2sF5X7yO-zbwW6SZDQJM6cxmvrbMq7EEXkRahjIr93C7PVniMj-SKzNhKkpG4XTosVWYY9lPd659wViOHAtSMVYB8dcKlBydbvkBN5DjWjWyNY--6w2C9Gqm1nzs4qjKN-GpO8aE5Ra1Le67klKTZOQiODny0TSXhdf_6h01hf_5tE5AsNYnDROBGz1cDj0-UukT5GNeE4OAYMGxDaF3qnhCAHOIsCJ_V_sSrsitdpzyKAxWb8b6Y59f-gMXefa8MH4_tyfodNsYTVIDPblTJkjTBm3aa7YLPDFOMzg2xFvioYQYQtwOschDGyDRrW4Cu4Xj1OlXBLImpt5_rQoze9YMDnnTLY0-rJcpI7tWBLvF359X8jigMZRjMsXJdnB9TMWfXGgm8fTsZA0rAUX1mgdE-Uc9a6SiPt8fRgg94poNiCTkdCOS2m3n5jmqBhibb1LBLWQIWt-D3zcUxvff9I4x-3_YCW2Tkgjkm5FmtulSQpuMKCvQQe1LjULPGtPJ4o5uvBJ8zA9pqxNOt', `SearchKey` = 'wofCpMOPwrDg8OgwqCq8KDwqTDlsKsw4zDn8KdwqPChMKuwrjCvMOVw5TCjMKVwp3DgMOTwqPCuswofCpMOPwrDgMK6wrPCtcKDwrHCuMKrw5rCucKhwwofCpMOqwrDg8OgwrPCtcKDwqTCsMKrw5rDwofCpMOIwrDgcK6wqCqMKDwqTCn8Ksw4zDj8KhwrLChMKhwp7CvMOXwwofCscOWwrDgcOQwrPCtsKDwrHCwrrCoMKyw6LCp8ODwrrDwo'
# [05-Jun-2024 16:28:06] /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
# [05-Jun-2024 16:28:09] /finance/root/bg/invoices/10408.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` = 10408
            LIMIT 1

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