# [09-Jun-2024 07:21:30] /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
# [09-Jun-2024 07:21:35] /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
# [09-Jun-2024 07:23:33] /finance/root/bg/ajax/invoices/form/clone/10408.html?pid=10408&_=1717907015511 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10408
            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
# [09-Jun-2024 07:23:43] /finance/root/bg/ajax/invoices/insert.html?_=1717907026417 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` = '2263', `Language` = 'bg', `PostDate` = '2024-06-09', `LastUpdate` = '2024-06-09 07:23:43', `Type` = '1', `ParentID` = 10408, `Data` = 'pEswouNIoYytR66DB4yCOJf31NSDj6mKPDeAIMCbmQtp1nK3C8g3Fndp3hT3CXFKrwZT8AITcWFoBMknZcgP9yRj82QTr2FIPbTs0BNLxq0a7LQTD4cnLAPv8_Q5NllUPpyL_P9yconseZDWnoCdKHd3cb8_OMAEj_SqFbQCaJTlLwXLNF-C5fXh1PvPdcxb3RIjFFWgMskXpMPTIl5X8CFcPhz1K2dcKXWIfWpooUcNMcNF_eVwxSD9YnA5gkYCQU0M-js3mQONUsvTr3Cux3DgTkpjZ2Xb70lH-gJeWja3j6bZhwW5aA3HIfbhhqIyXcPnpWqgUSA8Z0TLET7uPtNzuWXKB1q99kK-UTL66fZ1z_9s1YJAv2evV4nh1udxRokMFiXUHJQBtJ-DojYgml7JNs5Wr1Z1xhmcmJS-s2HF_JQJyeeuPOezHK-prlLpA3XATjnUx2HxryYmJkVFRouch2vHbNUD-WwOejDhlNpTqye6-1ItBVtB9Otb8OEX-KPp_a8dOfMowyVOIX8O9INQdJk1tB0l_eZsHKtZnLxqZnONlE5n7DUaO1jT0xiaiGUSQ7GhaAkNzq3jl1ufXaX8ynSF74bLB-EDrA_q4BttKBVHRyJ_4eLfEdUM-QHLjLVY6D8ucYsoJdQGLwh_dj1KHFxuh8W5nF3qVDEAqz6uXBAYwVWDLwIa8XHxUoM2shxxn5qzqxpOjFWwgC4cvVdWZkEwv3GzgJaosw9pK0gHZIuYY_LY3aMH3A2Hknolz5jvGLbiPPPM2_V2n5_7N5BWVsgLQGSOrGGbOMf588guIXT-S26kgS0V5HAQ0017fWrftqVa8XmwSmho8V5emF8ZvFKEIhRvbf2s3iiaUa35HMP1b8-5Q9cVp2v0DsEMw-GP2O8-05RC3x5Eb9cIGWcSIvwby6R2zFUGdHkZ_mJHp168fMAqDpKUU77xyIggWylWIEsFPQgQCA1rSXMgYrD78ewyA16G_rvdQpZ9uCNOfZllujFsBbMaVhqKue3d', `SearchKey` = 'wofCpMOPwrDg8OgwqCq8KDwqTDlsKsw4zDn8KdwqPChMKuwrjCvMOVw5TCjMKVwp3DgMOTwqPCuswofCpMOPwrDgMK6wrPCtcKDwrHCuMKrw5rCucKhwwofCpMOqwrDg8OgwrPCtcKDwqTCsMKrw5rDwofCpMOIwrDgcK6wqCqMKDwqTCn8Ksw4zDj8KhwrLChMKhwp7CvMOXwwofCscOWwrDgcOQwrPCtsKDwrHCwrrCoMKyw6LCp8ODwrrDwo'
# [09-Jun-2024 07:23:44] /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
# [09-Jun-2024 07:23:52] /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
# [09-Jun-2024 07:23:59] /finance/root/bg/ajax/invoices/delete/2263.html?_=1717907041551 167.99.142.201

set names utf8

DELETE FROM `invoices` WHERE `ID` = '2263'
# [09-Jun-2024 07:23: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
# [09-Jun-2024 07:24:27] /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
# [09-Jun-2024 07:24:35] /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
# [09-Jun-2024 07:24: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
# [09-Jun-2024 07:24:49] /finance/root/bg/ajax/invoices/form/clone/10408.html?pid=10408&_=1717907092415 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10408
            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
# [09-Jun-2024 07:24:56] /finance/root/bg/ajax/invoices/insert.html?_=1717907099057 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` = '2263', `Language` = 'bg', `PostDate` = '2024-06-09', `LastUpdate` = '2024-06-09 07:24:56', `Type` = '1', `ParentID` = 10408, `Data` = 'tn6t4U6D6v1awhkBQVF4JnMzPBBC_FFGkU6XqckJgoXN_7reRMlGBH38OeMkHUyxJ3kWWjhfiUKR2DN2okLzE8X_O1GziSYFfoq_g5rF3U-6gpruXvMkzGDjqWnim09KgEejJTJDPnzIS5v1chxF6SIyj7GBOKrJdAjIl5jNiQEThB0PdmGh3WuU2bViSw1ArXPpUZNiw8qXP5XPkMOa9BpZmFaqyjv3iBwohBtrABqU1sD6F1dYi6-xAzUFTgzDb6w5_xqnZKlijypUEo9U_J2v3ACUJGVrtGRjWG6tyxLXq99lu91XZS9dLlXYt3jtGejBnkSZQEv5321D5y97R29rcbupouQciXvnbCf4iIXodeDlBTbMxjuTbrA6CLxCUQ3PuGKxemF0JQmQJoE_3m9dGUGy_dXG8DCeImUvttusil7eXHnkdjq3PlxJO2eIOWmX5sQp0S3-gHMwJPngaa3WgUVCsHkd6kaaSXlF8nSKHe0EQbrL1hB1E6bv7_Cd2nlHhRRVxsg8Epbe9b7Ulp5yeWzpt-kYXWVc2ykeobKxFk8YUakT-sEu5Ypw9vhVgXGVCjLQO-G7z2WRq3hvPj1KV9AmeDLgha6UYIxK5sUZ15X1HOIIugKpbFLenO9xQMuUqRLa4j7r_iqRqrspn9tBnmMi2s9hhwYAoOlSU5JdevnUISwHjWnk1spC4fzVlBguuHuKLbLV6gfETwWjOycI23ncZcTdfWN91BcRgdrXLrxGldrjdaOyze1M2ochyNYLClSZVGmF_i_cSwMhuIDOy7oE_CpdLLMO-W7Tu5mVKMgBprRwuJJV1JaDbz6cUFMdQIG7ycMiFA-tABszsV7nwpzG60QINmyxUrmvGAkGZ6S8ePRPId0Zj_mEcOg-NHQIl0XHWHtffsjduAKv6xfcq3XQiHq2UJxVSXuKucdN3NN0XeT23qUn-y7_7-tBpPxiTZjmz6XRiI1Mp6xWeOjgbagg8CkhJn0YjDRkT-ozXs2OX1iy_siRM9rN4ItY', `SearchKey` = 'wofCpMOPwrDg8OgwqCq8KDwqTDlsKsw4zDn8KdwqPChMKuwrjCvMOVw5TCjMKVwp3DgMOTwqPCuswofCpMOPwrDgMK6wrPCtcKDwrHCuMKrw5rCucKhwwofCpMOqwrDg8OgwrPCtcKDwqTCsMKrw5rDwofCpMOIwrDgcK6wqCqMKDwqTCn8Ksw4zDj8KhwrLChMKhwp7CvMOXwwofCscOWwrDgcOQwrPCtsKDwrHCwrrCoMKyw6LCp8ODwrrDwo'
# [09-Jun-2024 07:24:56] /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
# [09-Jun-2024 07:24:58] /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
# [09-Jun-2024 07:25: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
