# [05-Aug-2024 13:20:10] /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-Aug-2024 13:20:12] /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-Aug-2024 13:20:28] /finance/root/bg/ajax/invoices/form/clone/10415.html?pid=10415&_=1722853228308 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10415
            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-Aug-2024 13:20:32] /finance/root/bg/ajax/invoices/insert.html?_=1722853232766 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 35 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` = '2308', `Language` = 'bg', `PostDate` = '2024-08-05', `LastUpdate` = '2024-08-05 13:20:32', `Type` = '1', `ParentID` = 10415, `Data` = 'ZEVDN4hj8-NYNyS5jTq0DMBmLNNBiIbdmsbnqcUpc16HzEPK_5bu0Rht_BnDndom6zh4fS6A_AlW-nFSXjb3OTj0O3sOAeh_RQXoFt3tBes3I7iPPeDn85qfsvtzi6sT_CdtJuKuYAoWlZSGwB2iqp7xvI3ueYpx2qbm18ksjp_1mghjPVFCqff2zxceKnSphRAmzmJJCYxC0EnsZRrBHsuwZZBQPr_eESDqZSC6CRsRc0QI4tj3kXz5cnqLJx7KfFI8SV-2NpLkefZpPm011exDUjig80EXsTi1MEIPGo-8Au5Wn14uvSbcSWaPQdosNxnde8JSSjr0M6aYmmmvSg2pRiiGFahDNMPV18ZO8gSPDvQg_QGMBY-nIyqPBNsWAmZERVd61UgBOGitqdPTARkzgMsgykr8azMbXrFqqoPErfySXPWOGvOaBMLNZH4bsvnUAREGZIvJSNIkJfnHDtUTdGxoxQ4ZsA-hloZSE7DYy20_gLy-zOktZHabs8VOk0pRZKcko4MMYkC392kfIIsOS4KrDN5gYvRje0c9OA3z_xBUcI8DjFlu5u9YpdI5wMoSgsZKLYsfOxdEkQWJtq3sjM_2yapiBh-yu_zajqvbDRvkmlHpMRKpIcYNFDcTp5paLb8C7JjJvAEG3A4WVCB-JAJPwdn3wkMn197dr1MwOYsSVeEpIQP_4ELLQEmtnRd99Okb3lK9ZDU-JqyHMayA0NUbtFkP4O9Q8EcKEefi-W7izUHsPGchYlIbKZvTMsJ6KkMzuEWO4yIEHTpgaoaYz-cGNFaeus7PhDfFq1FqoDj7FZ_LglDFwQip7j8kKPCJAnz9PxoSsN60L4ul7iuZn4sVKWASo67p7m4E0gueC0JcGZw62qZQ0CIzCyzxYEduaezKuTxQ_qTW_pvmGNSRAlfOheobX7Xu4cal6oXvw6Q-b4Ok-t5riJYhlLJeGQMvjVpHPx_gq5KKNMzFJYuAgq5fm8V0dGmwH-h5ug1nB3lQ0-DeLQVj5kyxhhFpA6_J75K3G2DzmpjC5Ory1AAjceMAgHYgRLkyDEOVBG3W8wKVTWZvViEkTS3e_1npPWrEhdkOaj7dTztSMMbOZdu3G70dwRNh2D5sWJwrj7UjBiXkCzTWSi7hN5DpBd2N', `SearchKey` = 'wofCpMOPwrDg8OgwrPCvMKDwqTDlsKrw5jDn8KdwqjChMKhwwofCpMK4wrDgMK6wqCp8KDwqTCwofCpMKnw4DCtMK6wqCq8KDwqTDlsKsw43Dn8KdwwofCpMOPwrDgMK6wqCrMKDwqTDi8Krw5vDn8KhwrDChMKhwonCvMOUw6TCiMwrnCi8K6w6HCrsODwrrDwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8'
# [05-Aug-2024 13:20:32] /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-Aug-2024 13:33:58] /finance/root/bg/ajax/invoices/form/clone/10421.html?pid=10421&_=1722854038818 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10421
            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-Aug-2024 13:34:04] /finance/root/bg/ajax/invoices/insert.html?_=1722854044540 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 42 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` = '2309', `Language` = 'bg', `PostDate` = '2024-08-05', `LastUpdate` = '2024-08-05 13:34:04', `Type` = '1', `ParentID` = 10421, `Data` = 'iduQ4SVbTl_qyDnTjzPN9_clVwV5bW5epP2VsUPoT24zWqtXli3nxJmabm7yjaJOjhzT9uN2Fr6E4zm2eLTRP_BsCMy0dRLOvJXPHnfroFitRLUtUQFxwT8Fqq9I4_0xU0eD3qtgjFmrODm8RnAVM5ZUy0QnyqhkcSBct1H5RAnxvrww81ES5a09iU4mkkrSuQ2SQLKSbDGeTCSoM4GaobNwGnSkPVAYSUB6UwWnuuIcRsKosJZ7qMwLGtnSx8zNx1yOx38M_iJTEeJZ7l8qiEnIOCBuyftDEq6KqkdUiHBX4DNtvktVrR7lTUMHofPkeuCu7I7FaiJ6TvafbSyDkkGSdwMNsT1XLQC4v4YNhEdlm_dAKYWwhSt59Axje8LrDFekmwK9uQErOV6ragPn85qPvHIFMw8QyucdTYipiXAuZQTdUXNOKyQbpy60atrm3xIK8EQMdYeM6JUlAi-St5wGOpH6jzRrp_7EDwpN8G9UK5x9kb-5YxRHX-HnNZkXRdFjpStW3xe5t_nPQ77lJGu5uGnaS1WQeeK2QaATwokFEQeW5miJRBCArgQ3_lHxYnFDjOvaqTLgHEwhvZEjsL3Lwonem0XyXu5j4rj8aUks64QOnd_muMKHfyE1r7yQy8qYPe-ykyRxNad7MFFpEahK7jKKA8jdL85weDO0C1XUmQJv1sHH-BZS_5i4ZOw4WkhHUGOBmpQTUOkFSgQj_6gFJY_Cen7OIik9Fk2Wm-8b5nQD-HLa5Or_NYjlloNqWO_UhPJG5b7pOR9souYgIF3XQjMfqXvfxs2cFjyddsWNL72rJ2KeHfX_RP6zqsLBkym6lKcvy77jLnyfUIrGfbHsJ8faznhAV2KWpNlEQxeALpOWzqrsO9rujXKm2Nj3YOeCS8YNVi5Lo1PE_njRrMhbzX8vh--AiUOE_DdEBrqCK4rkCD8p7ltqkk2kdURMMa4qJ4UTkcdtc5LqLymDAqKCNEwUzPiK8BHNonQy5l1c4LD7qfTJboRSYCzGchvlrIwz6CBBG8X4l19tX_E3Rtav3ztJakNga1aIpe0wDnac9dQzDXPyUsG_aS_dkBHpMqaGAY_-tUjo8KZaSl03yAIC0zJUxjL7GtJstrhPEeqOUfWMD72SbAgK97pPIkNLLFmTxKQEAPy8orjOTI-wBj7MHOQgBMqIxM2_BxPrreA', `SearchKey` = 'wofCpMKnwrDgMOQwrPCvsKDwqTDlsKrw5vDj8KhwrHChMKhw4TCvMOWwwofCpMOaw4DCtMOQwrPCt8KDwqTCo8Ksw4zCucKdwqPChMKuwrjCvMOVw5TCjMKVwp3DgMOTwqPCvMwofCpMOqw4DCtMKlwqCp8KDwqTDhMKrw5rCwofCpMOAwrDg8OgwrPCu8KDwqTDwofCpMOEwrDgcOQwqCq8KDwrHDksKrw5nDj8KdwwrHCisKpwp7CsMKew4LD'
# [05-Aug-2024 13:34:04] /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-Aug-2024 13:34:15] /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-Aug-2024 13:34:17] /finance/root/bg/invoices/2308.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` = 2308
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Aug-2024 13:34:29] /finance/root/bg/invoices/2309.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` = 2309
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Aug-2024 13:45:36] /finance/root/bg/invoices.html?from=01.07.2024&to=31.07.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-07-01 00:00:00' AND '2024-07-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
