# [20-May-2024 11:29:17] /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
# [20-May-2024 14:41:25] /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
# [20-May-2024 14:41:30] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [20-May-2024 14:41:32] /finance/root/bg/ajax/clients/form.html?_=1716205291115 167.99.142.201
# [20-May-2024 14:46:40] /finance/root/bg/ajax/clients/insert.html?_=1716205599173 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` = '64', `Language` = 'bg', `LastUpdate` = '2024-05-20 14:46:40', `Data` = '7kDjEoMRZ7iZgbP2PvBiTwxmEfg-HCekeGbaRijrgDJuU85iih1O_ZcPvXwLtZX0bgFVk2cCUUxOWGDt34JRJOA5_CY_PanN6gywPL7C1EOrSH5MYWdUD5XgHLhblnZe02k7vqFTZnT-Hnx6LkIunlRQ9cD83bHM1HcGfzY1pU6mczWPaqu3eJoETxpfIxQ2WnWQovLoHamNSUl-OsGWz1F8nUUeN9cnrnFkVXaQcJBbpM95mN8vF18NRcB1abANSVQjUmrSJfffDb0cznksPtpYP2JvgvcFPyta_BfLub_GPeNTkPpYl_95Nj4lBaBzmo_M6nqKaVuQgWwod93vFuj97lnCYdz8x9_R4E208eirDgb_tNTKgVFsYSERG9tM', `SearchKey` = 'wrvCoMKw5bCscOEwr7DwofCscK8w4DCtMK6wqDq8KDwqTCn8Ksw4zCwofCscK4wrDgcOQwrPCtcKDwqTCuMKrw5rCucKdwwofCpMK0w4DCtMKlwrPCt8KDwqTCwofCpMK4wrDgMwofCpMKnwrDg8OgwqCwofCpMK8wrDgsK6wqCocKDwqTDosKrw5nDj8KhwrLChMKhwwofCscK4w4DCtMOgwqCocKDwrHDi8Krw5vDj8KdwpzChMKhwp7CvMOUwwqTDgsKxwp7Cm8KwwrnCpcKhw4LDj8', `Top` = 0, `Visible` = 1, `PostDate` = '2024-05-20 14:46:40'
# [20-May-2024 14:46:40] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [20-May-2024 14:46:43] /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
# [20-May-2024 14:46:45] /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
# [20-May-2024 14:46:49] /finance/root/bg/ajax/invoices/form.html?_=1716205608363 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
# [20-May-2024 14:46:55] /finance/root/bg/ajax/invoices/form.html?_=1716205614211 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
# [20-May-2024 14:47:05] /finance/root/bg/ajax/clients/select/type_0.html?keyword=tsa&_=1716205624721 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrvCoMKw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rvCoMKw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [20-May-2024 14:48:13] /finance/root/bg/ajax/invoices/insert.html?_=1716205692358 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 64 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` = '10403', `Language` = 'bg', `PostDate` = '2024-05-20', `LastUpdate` = '2024-05-20 14:48:13', `Type` = '0', `ParentID` = 0, `Data` = 'fT-D2swPHYqzP6WbGiOdrSo31mzIQtjNRSsEKG84ucn8XMlwXmlT3OSIRlwpAutRr5fZnPsMAs-CpN2no7XO7a2Ec1oeMpl3BSI5x_uQuLzrN3LI0t9q2iDYBQY3DPMxspqI7ruoj7CuANL6SQJkeupLgBUDcAwGBtFLZ0HfMuTB9HlMyguzlR5jN0upFaa3w7L8O6coOMzhD4EOD_zp-hBRa8wRBUhekOD0l-MkFFiZYK-gNbZ_6NoFPL_XtulLIq33zEmYj30FZSLEa6J-FJPZennLTWX250EGas4gg2wpot7X2goE10Mq3uqqsEqsRGX9OlZ5SUpynltYd016XpTpA46AkaHZRDvH1eBtc4H7aYrUBNxtMBBBnoGQnDVxUpdDMi80dTeaL2190UjIJ-bkmWITDqH21jRl91p65SPpbsBkmx2kSKPbwYuwpCvjp2qXa5dd80GZF6XQSlDCD9Elp_jTcLgR21kI9INepbSuKbiV-3iU5ryfvXlhrB1Q_r9TJgF1IyL61Y0RqTYE6CVtlg0EdSTIKwchsJyXbH7-2H8sGNUGEqxXMYkPWNdgPcFS0niKJ1U3NhIaORGAk1uXTCoINevFprsq-6y-a1hWe1NLdNcvEjE1asAsl_Y1Azy9mFjiwPeW5xwsTh4cvgjvSgIV7iqXkZuy3JLtclGFB0LOyTwn6z0cPNahJKHiQRrFbzN-vtwNeszBRqUNiw0j2agbP8K3sTRYBMil_KKO_AgN0OeMCyv4QvBHWhGi6zafvKA3WxHuKaJRxYzp8UT5uWf0uHwIJ8NiGmatggnJxpcnO2Qx0F7vfkwjMSDo454BU8VasRWCXthMV2m1orlMkc0Myf6l55rLfPYicMyzfCMNx_GQ177iEDD5fbsoIVDC0MRqx3G_CKP_YJrC5WE0ZbtX3r9L2hMQUV50rrYzjZk2sv8cadlhpxeGcdM82HUoOHpGxJEmaXD3RhSfDuFsgtNa-bfLHTrkw5KsQdR50iAG_eEFb6gWjJARwGPtAs3lJGO52iMGheVlH7zGPeALqHihEAOgIYcLi1AGkyi-WcTJwduMZbmU0hrpcmMH_TNGqCuOu_Rd8wK0udbaYA', `SearchKey` = 'wofCscK8w4DCtMK6wqDq8KDwqTCn8Ksw4zCwofCscK4wrDgcOQwrPCtcKDwqTCuMKrw5rCucKdwwofCpMK0w4DCtMKlwrPCt8KDwqTCwofCpMK4wrDgMwofCpMKnwrDg8OgwqCwrvCoMKw5bCscOEwr7DwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhw'
# [20-May-2024 14:48:13] /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
# [20-May-2024 14:48:15] /finance/root/bg/invoices/10403.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` = 10403
            LIMIT 1

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

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