# [22-Dec-2023 12:10:11] /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
# [22-Dec-2023 12:10:25] /finance/root/bg/ajax/invoices/form/clone/2132.html?pid=2132&_=1703239824944 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2132
            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
# [22-Dec-2023 12:11:40] /finance/root/bg/ajax/invoices/insert.html?_=1703239899777 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 9 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` = '2149', `Language` = 'bg', `PostDate` = '2023-12-22 12:11:40', `LastUpdate` = '2023-12-22 12:11:40', `Type` = '1', `ParentID` = 0, `Data` = 'LzYiUxbkfo-MxSWxUmNcr9o9u5AqyS53iAl_Kam_lE-X3gwpEOP96K7DsnfWdL74_r43NHfPceukN8FEj5wfeC7RHup0tmM0paMwa7KkmNWwQ8dtVee_5pGpq9Fo3KNxBzg1bErYyov4t57xxN3FACIYA6oXXHRCFaCEBFOJJjSgu2IPUp1VNjm04AVOovh4wWctncCzAyI7g0LQp1dC8InOktZIyVeJKq57l2Es3RbWNMqGozDcF7Pbo9DomNu5f0gSrRxESZGnNgddQleCQpxAiUfISR1dG0-Y9g2F5aqT3zlWv2enms5My6ObC6RxezC7XXbyq1UYznKbiiiMbu-LaJcZZWbVR_26brwFsZzOA1Ck71Lak8o2d-mduyuVN-4kfwRg7jEKlN9xJNFNsCE_XhnQdZntl7kD0eM4JMn1uivqbV4HjOJ7KzUivkXl24xgw4BfNQgbv_IMhKpmMKphqMf3BaYAjtBggQN4DHfl1v6UC5VJwSeOZzpwvcIPAzqAX_XomuRQ1sJBmH8B08pwHZCvlqC-Nk0kCCGGZra0jBhnOqMKeu2mMel0BFQzRf0J_D1IUyklo8ghCUEhVjCXd6E7wq7g_VQRAPrZmi87E1EQ6VaazCJckiDSLq01OVRLT_85kXVa_FTZZ2NN_2sDuwL852pBVQ-J5FYLYhaAVT3pq-1PTqLf2sz3k6UWbEgLP3v4FdMRl-XZV9y1vBYp5yCkJwoXxeUMWCC2s06B1XrINdyRU-wR2Q2n4uE6C-VHKlEkl_GpEcq4R5wT7ZmJ6ZeEP5YIrdKbw74q79LQHSlAiAgSi4qidISBQrwb2cwjglIPOIzVlX1d2stjPN2ukFtVYOyFtb45cWjDWxqLq18lG-8HYjmdgmQqEdyY70XKONEjOyLAmSIn9jwwLOkNWFr3ttLjCTJZKEtOaWN-7eWvuzJ7JPPbWLZ4wieVjU6b6uOLg7B-Ur4a-2QJ-nQlcwGclbSQK_miUDmB4ZfOWvvidIZt-nlnMeg_OioEmlkl2p_GmstXoyBYo_mI2jXmvq1wtD03oOSsQAUQMwU8Ls_nJ4Q_d9NkhmwQExsL27oy996AyeE5BXiV3cKS-nz4uEpirfiDG_IQh3p3gFBOnFeVnQe947xEzqDBUd-GaIJFlHkpdEtqOBMsL0c7sp2zwFTOgViR_0-CUcOugaNdljbPhqdL4rDJ_4fi_r7Op9rX6eYL51AHAFim_VfXe_a4C32lxu5bG05f0Zz2mjo6nxpbPOWuEriU0W7F2CFwnKSWgWqR7kOw0I94KVCSFWVbS78QtbeIu2RrHADFag9VbkArsHm26S6V-9k_YALHWSuz0rS_YpGSCkTs4Cc9ipmiqgCn1O3jrTf_ExIuHmrIpLlOCO0jI3A0JhkEXNBMsGcFBPLty7PFV6vefKzj2tS0VF0ujskef2pSWyGn5RBDgRYMwiwmq2TbGSfme9h9UkiKO6yZSJHrbdd5Fq8eQqSZaeUGD8fry5-ajKbwY-eUUvL5fYg9NnWY473GrrrF5dy8sIgUo8t4XbkEmlDQOcJrIUbYCHelWbyqYZ79v417Fincxgc3GlsdpUYe_Juqj3l_qQbUJurQg9ohTTeajeX89qA5-kfTEpsf10qK3rbKtx0e5SpYqzaYHtO6yF4WLClR9ZuoplVR-ZJw4tnBsyiSANJutjOIegnS--NRXIzlz_-NbIQ0NsSprPBL16SQ0quMNYaapdsRRn8HRSfiFU-f4YcLuMZQLK5nEy7fh4_85oKFHaycDNP0rBLlISHPgsvoB9TKZJq5erIkh5I0hJYtVFDDDeKQ3Iir4-FTgQIExhS5SyIMph4uMX_BreUR', `SearchKey` = 'wofCpMK4wrDgsKlwqDrcKDwqTCwofCpMKnwrDg8OgwqCwrrCisOGw6PCsMKew4LDo8K1wovCvsOGw4fCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw5jCucKd'
# [22-Dec-2023 12:11:40] /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
# [22-Dec-2023 12:11: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
# [22-Dec-2023 12:11:58] /finance/root/bg/ajax/invoices/form/clone/10382.html?pid=10382&_=1703239917239 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10382
            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
# [22-Dec-2023 12:12:03] /finance/root/bg/ajax/invoices/insert.html?_=1703239922356 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 54 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` = '2150', `Language` = 'bg', `PostDate` = '2023-12-22 12:12:03', `LastUpdate` = '2023-12-22 12:12:03', `Type` = '1', `ParentID` = 10382, `Data` = 'V-DiDztMxPhc8fO6fg3Mum-DqUHwFqY7lcilF5B5nIyR0RFTyDOaLwOQe_HLwmXSBbm-Blm9fEKC8Fjrs7g9f0VpzB58uzs-n0NJ4hQJmupG_MpFYBxkLmtZX_AKLT_Ciyrc7KkbGtET0GNqE1tCzpTe0S0nMDymcewZFNd-ZvW2OlsssjOnCfAfhuAqJuiZQFIPMZztvbAhpDqUzxbQ3W3JFeRCuC3SKLC2r8eH_eQHvZRug1H5S0KD6FPGuVffA4_oPrgfRp7Z8TNSFbuswH1coZ3c7o21AVerNvXK5fXiJHugoEgg66f34cacTeBfpsLeh73aGy5gztYa04GC2UqncQ9nPKlCGlfG_b_ac4KVixdKHfws5BRLHIgDfgS_g8i3Zkbpeyj7MMYRFXX3ow5GNH12-Ap_1Y5BRByqpnOxEf6z38vdMV8EoaYicZCS1SxV39bjYFOOImwR3DDVj9mEGV39lK1krRXuXD0YtV6i-eb79bNC8twPymYU63tYSl05E5xQmvm7Kw27tOEK5GFJqXGr6NK0v0zsIuhhKHVwOX8pZUdWYVHfX8qbQBSBluSnSbzqzKS2o5Vs7Tfo6R58e8HWQMHKT4WOtTYat2jmoYlStmyrEab404rNikDtk1ns6U81GYq0rfe544nYyAUiO81Li9lHyTXD3gsSMKr-vfc_iZMPkVeHbCW9hfLy-ZPp9Aw08_hQ9xupjnKtvD9tGtTj-6CeThxT7cnWpItWShBtvW8eHzERkdsS_mJpd47pDo6WI1925nJ3pbh2DZ2c3rUgtYCiRgEF8QC06U7Heql4Lzftoz2cFRdJvVhBEO979tUAYw0eaJWObnEpGwyqFRqGfHtOAeUVs5jqdpB03hoXkXs5KYrd9CYP03Gq9KZQKwqhNGZjaozCEKbNfT9aPetP1icBUk-HzS-c6lLRzFeUss_-cAV4vv-8DxKXKAuLD3LXB93K9txkZuMmLZAP-jMPr_c67-ZzPBjTJDlvSAKuCb2fttnRWV4IawAP0tOY9mr_mMQrH-op1Ry1RA', `SearchKey` = 'wofCpMK0w4DCtMK6wqCpcKDwrHCuMKrw5nCwofCscK4w4DCtMOgwrPCtcKDwqTCo8Krw5rCwofCpMOIwrDg8OgwqCocKDwqTCwrDCsMK6w5rCscKzwwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrDgMwofCscK0wrDgMK6wqCp8KDwrHC'
# [22-Dec-2023 12:12: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
# [22-Dec-2023 12:12:06] /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
# [22-Dec-2023 12:12:13] /finance/root/bg/invoices/2149.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` = 2149
            LIMIT 1

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