# [05-Feb-2025 12:28:55] /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-Feb-2025 13:50:57] /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-Feb-2025 13:51:03] /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-Feb-2025 13:51:07] /finance/root/bg/proforma.html?from=&to=&keyword=antiopi 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
             AND `Inv`.`SearchKey` LIKE '%wrDCr8Klwp7CrsODwqXDq8K0w%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [05-Feb-2025 13:51:31] /finance/root/bg/invoices/10411.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` = 10411
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Feb-2025 13:51:45] /finance/root/bg/ajax/invoices/form/clone/10411.html?pid=10411&_=1738756306085 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10411
            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-Feb-2025 13:52:06] /finance/root/bg/ajax/invoices/insert.html?_=1738756327680 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 66 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` = '2424', `Language` = 'bg', `PostDate` = '2025-01-29', `LastUpdate` = '2025-02-05 13:52:06', `Type` = '1', `ParentID` = 10411, `Data` = 'XJ6o_Xnk2L_51doXUdnzaaFMnMzu4ti8ZbENuVz1dIvV4qUtc0xJuL74WdK_SSoboFKPo5MkT1sGgp2FlgxQfLbEyjByS_MecvIKCe9lO3AHf1sWH7mSabd9mHPqYWB4gCowtH3ZLgb89Yw8_L4vxKHBpq0uMAHZAYic3SrMKDfh62_ZQ4I1W3PLH4N2JICp_J0lx90moGHFHCMold11PkTM2ELK6oZe4_43lykU3VAD6z25X_Rt9qu1_bPu6KBnWw0MWJ0VV7F1hfF5I3NI_EY6C-ZG98PgMiaFIeShlDzO3WQZnaOPGowVMS1ywe2pjyvOeVn4MtS6VGXOHfnRolHbU3DTPaw81AolNaRm3AXj4TLIRhl_-1vv_8b9F_BQN1e1kOGsp3J7zPvv7A17Ehc4LuO8Xgf1rVCNR_8_4svTlURlgs4Xx0RwplLLlruVVHe_eAsu3FQsBoAJbwF4yufN6cnhlnO5x-7X-e2X_Reg4UU1YBUaQXs2hhqgiPzMguO0C8eVCn0cCjHFK2B9o5Hs47NJimJhyXwRAkwA7OzG-LRLZt7XrD6Dkflxd-Ud3BxiE7a4fqS4prNer96M1Q1973MqjcSZftRLpC7voT6iogOSdXARnKiSgXpF5N_Swilvj6urORK6w1Xzpip_tV87iJIAZWKRnbgVth6BJiDo3RLTbZmXA9Aiy_ohXzUEc59zpJR1zxaYHIuuf1RW9o4RWflm4mPppxJSYrV1whSBClCZpkQkfC0cuqsKvH8NsZpi4ZMrsiESSgWzwGPA0EGhpGTq0xLjDoOPDsa5qEBDXkJgVNcMGn1yAQM-U0xTBSABY204mMniG3TL7QNLGI1NumMIZs2vYXZd4QRuHH6bYTRlMZDfAf68vanJVrfd6NIQSI_ZqmvMK12LyA6uAlI_PV4LCeJx4QmAL7eGPAXKPxycIJxVG6kpdhqnuu6eggwjEJcMx-VAy_GyEoVysOiT4GTmR__kKMrPqSZlfMVL6S9uiPhjW_iwtsR85eOfznS-MpgNG4sxKA50LvwVyYe_yxEs1VCuC34bUG1FdmGBArYQmlMvRp1dYDb2qIgT_54gpAhseViz6EpFBvexZ3XhjDpxHNRAsB2FrIWmmp6oJVHyXPl6zjJbf3pY-db0zl7EGQMoT_bZzbzk84OF_QISz74YBo1SG7PfWbTvdLZM5VBbDpZV-aAJrHITfwB9M1YIQNZuYcTSqmR-TsbRI4DMUAHOY67DQBjebUTYsexVspdjnxHkcNLUmiviSP0NbCXCTkGb8isxJByhf5p7Mgr9lSM39d4DSETh8QTaw-Yx0XQUwVBZJxLRz-0yp2fXXhChGAKtuNxvULDrR016ps7X4HW7u3_DWBeBx2m66T5CwXZ5zVk5aNUf9tCFXixo0uN6jzgjcm8DS4yDjwGbCYyKHwntPNH0_XRGW4DV31d30bC5hu9C3Gr_tRnYr9MZZHjSjPXw1ab74jmNaqsgJjDVYdQh-cG3AvTjSc5IXzf0xs-7pw2Hdf4IRk6A74kYfL7zWtbnHaoXWAuXqouhP89eIHisdvtho34EQbOnb_FRUreh1ffM1ByHB8KPl-4UwPPqGXIyV-h9aDSLe0MJDWnI5znUpEml1aZItQlvfYJQhZVH9wR5dRumwmp9ixbczkUHk-HQORwDu3lELxqGIH5tEYcdQXS0VZTrYCbhGCWIqPmrl3peYVdTMPishCm4LMSu8ejdTAgyMVWQTspwVG_IamkDXRwen9qwHKBb5fljmGGoE__g6RG2y-tKYd7VfHlLqlAxM5at8NkmUMA_7JDDYbMzix7P_uGkrXqd2zTFaj6ujJp9E1_JXcJTExem', `SearchKey` = 'wofCpMK0wrDg8OQwrPCt8KDwqTDlsKrw5vDn8Kdw47ChMKhwwofCscOEwrDgsK6wqCq8KDwqTDpsKsw4zCwofCpMOIwrDg8OgwqCocKDwqTCwrDCr8Klwp7CrsODwqXDq8K0wwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwq'
# [05-Feb-2025 13:52:06] /finance/root/bg/proforma.html?from=&to=&keyword=antiopi 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
             AND `Inv`.`SearchKey` LIKE '%wrDCr8Klwp7CrsODwqXDq8K0w%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [05-Feb-2025 13:53:01] /finance/root/bg/invoices/2424.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` = 2424
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Feb-2025 13:53:30] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [05-Feb-2025 13:53:34] /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-Feb-2025 13:53:42] /finance/root/bg/invoices/1000000067.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` = 1000000067
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Feb-2025 15:02:59] /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-Feb-2025 15:03:03] /finance/root/bg/invoices/2423.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` = 2423
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Feb-2025 15:24:03] /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-Feb-2025 15:24:08] /finance/root/bg/ajax/invoices/form/clone/10440.html?pid=10440&_=1738761848705 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10440
            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-Feb-2025 15:24:13] /finance/root/bg/ajax/invoices/insert.html?_=1738761854340 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 17 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` = '2424', `Language` = 'bg', `PostDate` = '2025-02-05', `LastUpdate` = '2025-02-05 15:24:13', `Type` = '1', `ParentID` = 10440, `Data` = 'xCU0OpFkbJc0IUc8TPkxtV3r20De72YdqPyX3tl8uYAkYkqyf2XSWZMj62kobHIVLxKnvoDAhG6cU_sWDyFPwslxKlJc9LB-WWbzYOxLOunn17jzxcUiq1HxyHo2TsEM2RXM0EEIeitNOLOpsPFuPdiGQTefp9ViJG5mi1WkRoZ6rH_rqsCiOOGO7oG6V0Ia3nSfcG_SPWgWF_w3hmYiYrg-_89S9AbR30oWGydFWQER20pqGAVP5-mY9Jx5zO5hkJ87cbe-6uyzjP3NdjEzK9XmaEwTMy44T6IT4BSvVFhgXCKsunE812_3Ab3XG4W3ebV8MmNPWSBNfg9ZWcdg1Wtr4JRqMjscNhFcImJt9QAuzgb_xHHfk91ywxME6Q8rEpy5pGiEeaJK7iWv7XUnGBwbSewsvPk8pBKX4RtoDSBd-tH12QPBVAGWx98hjZPKMg595WbWIvYZy4T26hP6F0mDEU09gg_Nub1QUHKyF2PQJFdLJyBvy-NFE0s4qRA0hdG1su0Pb1IV3H8DM4jDA4t9yTpS8VvI-jktE6LiKBc1jo_sgt-hYHjrqXALncTVE9BpYcDuErWUWDsV3fIy_Du3KBYYz9S-XsZk7x-TnHFlG4fC_-SsrDhxjN3ifq_1y-5se7peFJs2sl8zCFfqFU-72xcXvurndD2LYIUY1N-G6Xz1PzOhjJX3oF9iIw_K2y5Y3jm66E4Pv06n0BfRRU1aPy2WhX1QSZme7lLk45xo8TQuTo1GQV-feG2QsMONJFBzGcOW4OKAugi3WA_wdqGxewsEAq_Tp4xyfe2Jj_Or9IxrCEyU8oFGPUd_ZmaPswrZmYWFmcvVWpjpFHtc7G__DOiZOl0h7gJjcp_DKUjAN3iHNhtaCloVYQ1GESZtmalIoHTjSjLVnH_bpVnVku3Y19abc7yTbwPmbIaQDhdBa2_yuAcTR0GyK3IEtQV_5_diy5g4FnWwiPLg6jxOeOVS9lHh7Og07xiXT-SiKj5i6mTOIXlqmi7jv-RBBqwN_lIXWvW7k0xm4TkyCjra2w42Nv3qaLfPCEDsKnM_ewP4BFPaRiCJRtyUdrPPvjQEk1JPDanXiGfeGamLhM2CO0SqsG-GN3zRPJz6R2y7UVy84QSbjOiM7e7-PyRWOchh', `SearchKey` = 'wofCscK4wrDg8OgwrPCucKDwqTCsMKrw5jDn8KhwrLChMKhwwofCpMK0wrDgMOgwqDq8KDwqTCn8Krw5jCpMKdw6bChMKuwpbCvMOVwwofCpMKnwrDg8OgwqCwrrCisKpw5vCpsOEw4LCpMK1worCssKMwr7DgsKPw53CrcKtwpzDwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rD'
# [05-Feb-2025 15:24: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
# [05-Feb-2025 15:24: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
