# [22-Jul-2024 14:36:36] /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-Jul-2024 14:36:42] /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-Jul-2024 14:37:38] /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-Jul-2024 14:37:58] /finance/root/bg/invoices/2268.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` = 2268
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [22-Jul-2024 14:41:02] /finance/root/bg/ajax/invoices/form/clone/2268.html?pid=2268&_=1721648464122 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2268
            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-Jul-2024 14:42:51] /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-Jul-2024 14:42:57] /finance/root/bg/invoices/2268.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` = 2268
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [22-Jul-2024 14:44:03] /finance/root/bg/invoices/2267.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` = 2267
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [22-Jul-2024 14:44:42] /finance/root/bg/ajax/invoices/insert.html?_=1721648683738 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 41 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` = '2287', `Language` = 'bg', `PostDate` = '2024-07-22', `LastUpdate` = '2024-07-22 14:44:42', `Type` = '1', `ParentID` = 0, `Data` = 'u-dA-BIZpud65TiRSN3jFM9ON8bg5jc8StRScinuDwqlkx0sYJeW3NyUHtmcw3xV8LbQ4gnMNY-kT7IsOmu3I2nT1vOCM4AHC_gYkPC7MDpC_WzbQ0ihgBzmYCxEsaXj4HM3nKJUEcf0eDinTT1ihaFCVu6ISwoSHWGZUguiCJvphqvhmgKbEhDyWCvNJROgnDRry6K3f0076YeammN-Z_OX_3asIH94ksl4dEYyHr0k4vjFw6ZJz0a5ZX1gVscSywyiEWGiY34Ku_9l6ke5ZVpJw45-e8gw_dlZ1Z5xSv1x4e9oM5EOZOfGq6XloSjl3CVHnsyhO7VGSkH4QJvQP2pPCcbzwduNdJZiNj9STz5ArGv8enEOELvfriToCUesXr0SbYfAoGTkfpYbb0-nJRjfdiuAPr0wN4VKkqDt7hT-ukowmkNelBrtCMrKs8C-jeGk9gTbQLgACuhXB5qyNP5j0A-EEgCtga0Mvu4ppR5_qE7j-xvdf0vG9318taDu7pytoZGhLN1jG2HPUZkXo1FlsFOBDDSBwCCTn1zIXT6Z_OJAf0H6N4VZVhzya9IRTD-6XdAiLWE9qwph2Svj2q5kPTJOhVK1KB6UWf351yXdaO_IGuKZzPBBZ-xwyeKaaaKn8VnvWJ8Frq4ztx0Ng7ZTFHF0wO8yZkEZ3nDHQPZnyv8yWr7X44FuNVsD1Hyc0SwVDCGUrUWxIVF6IhcSGBq-3G_kVqfDj6fHJrtM9CMqBJ9GMVI6xVDR1jGPTGpSt8z6iD8Z50CDail_7IkeTXwxNZvljJ80EtaAl1ylYwCSGDqjHwVD0_F0tkRjukEHHFnAhXKGcZRbcEybSfoBHFs3O__Smwi5w_3CxIYr5NECqhZz2Y4-xkpAnLsMS2jy_UIXsEKwVHll_DeXTAvqi6FG2WjvPlQT2S5IsWZsKD3yxa7-Vj4cqcEKdu2Xd0zYPOGw17Y8z1XXwrPUwb3AeqCwaJVX2TOFdvT6zGHsT0nJ2WMFHksNWQEq2euZB_i2Af--Llajah6-y8JHyZnvtJtw7Zj01uyv2p9QPuaeNqU5XxauJPk4jDYS3jRfLeZbKllB_1wDqXsI2uiOJFWHYHXY1gxBtFiw4_juqXC9AArWSGqZJeLsxOZVfHEfdUMtG6XABlWJUNlmKy57gvwv8kDfj_4kc3mNfdfRwWjAzJrq2hO7A-1VUvOmXOq5vwpXsOFsBp4mQ5VN_6QmsbBQ0aHGfF--JUreEOvk6Vi8OcSGaUHYfss1aywMRsNwlz05r7owNHerksY8k4GsV_K1FwvIKFhYt8OMf16ar0vRAc9IjCJvdSjv5ulm-aJvBhGzCjO-rdRrCbYCMqatpdON3q6m2SSxY7DaQAcs-KrzVk0', `SearchKey` = 'wofCpMOIw4DCtcwofCpMK0w4DCtMOQwqCpcKDwrHCwofCpMOqwrDgcOQwqCrcKDwqTDlsKrw5nCucKdwqHChMKhw4zCvcOKw6TCiMKMwp3DjcwofCpMK0wrDgcwrHCr8OKw5bCsMKew4LCwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4wrDgMK'
# [22-Jul-2024 14:44:42] /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-Jul-2024 14:44:48] /finance/root/bg/invoices/2287.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` = 2287
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [22-Jul-2024 14:45:21] /finance/root/bg/ajax/invoices/form/2287.html?_=1721648722511 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2287
            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-Jul-2024 14:45:28] /finance/root/bg/ajax/invoices/update/2287.html?_=1721648729785 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 41 AND
                `Visible` = 1
            LIMIT 1

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1 AND
                `Visible` = 1
            LIMIT 1

SELECT * FROM `invoices` WHERE 1  AND ID = '2287' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2287bg', 'baGKCGBWVyTRMQ6rOi4BU_uVa1AStyLsPzqgifYqoo7EVbYKBSu5z_TeBHdNerJsA19bXhO4ugbBchblfjoFjkvLNvkEzTT69WmgpqM0hmLRAyUpYZq0-dn2pUlmbOuc-jFd-f6nPmlPAOGgT02dZKQoxyyTc0A-EjuIqXX47OcU0DAMmR5eND5P3ucVzaGXWe-wKulBhAd0vFp9Ypw-0vYFLDBnlJtZxZEZmNxR97z-xUSrla3kk4SQz00H165-4ef9RvgsY-GNsPzvqfjHghFQm-m-CEKJk7UM9B0Ym1ekcste-MaKayRkpDEOVD6ani_Sz1ofbshYdFvuW6lSPUHHgxrZYe3WzNyfRSD2_DNsMEzpl2LMilbcN9p9kShODVlMeElinc-DRmCyUG2zWvvyPKe--E_Fk3IAEHwW_LzNyxz67RiiID6vuvVWQPsJHrPGnkzmKZfy4UdWc4OiDkNMZQDRIlwBWaUlK4CO4MpdzdXMXKpIzwCWpenqeXiCGH7mkm2C9cCRtUMTvv1AyFMIZXQ6iv1VMY_ageZczNZd_34GtWFJXN56SPZC4kUHwD-FZQxzwdb_ibKj1C_cvGRLdVxDCfSS9s6l-Lnoxe23VxIeST6wjv4wY5zrJpilkv_moI2oRrZoQM8giWRYHLo5af-CzQkH3zodRwo-UGOE5VSPcwlrGDIZ0pNZtTo4bMXaNUjoy9gpdY6ERmPG9XtWPJA6kGhfh7zn9PO4N7F1kFxKkqppNpnHffKIwrznbNgkLm4sZzxUj-GHujOhnjbPrNjUBYJ6nK1mCA62CNOpg9sY0TyAyFZEZM01V1x8BKf8bwXhPjDDIbDa-Pt6bY3GpYlyLh2QUc9C0lGJkpFwKFJyZYVxokbsMpCXbrKSWxkq-hVfbQRZl09SolHes5d3gSvMkiX4VD5PU4MC2bYbwXglwklSMMauWdDA9-Ddg0Xw_957WUbWX1NWOsBtaYlf7nfPiswhUlD1BTvZZlfXHUVl6nWZSdkumXjFiyiOJOWa1KkrQMTcvA9vQByIU06fjaLrfxKy_0zi4h9oSK8IJd1u3onVN9oXIO8a8hgLvrORyPZVfcTuCXdh2HVnbhrKBTj74H8G9YEqXyQYkhGGzIzM3iNY_9mEz8VR2N8GgRFCzqQMC5t5DtefAPFfM0-XqjLuds5RtydmFbDTTMDh7iCuQ5pERnbzMvtCL9VfYSizsNJhCBKP_RQ9pVAdi9_NCWQqIJW1vWG8TXksSgptk1UggkeEouUkvZ7jddLGnSK6KKNHT68-09m0DeuYNnP_u9noZ1ER3wQ4xMc_ITXAkFCIIMI4dFd9C5f5bRmoRHVCinbZPhEdEC-ODEihzTvsamaL549y-fc_8D0WXmd9yTFa__k-8JtZmf8gafq2ZN9uFf0Ys5OszyrRDGO7z9HHXWpbJDJH9n1EgFkHLpdM6wMhd5Q3ck4YlZrzAACx8NL6tQaDvWID7RJRKcEptpxM9FHE7H_MHfKRjjEGJ_nKTaKeKJqPN3tqbI_P-ttsPl7R2j8VVwB4GSB9pQDZVAjgw-XBJuuS96fY0ZrdxPFQ8v39Gef105IIajBl3wHV_2yWJczs8yLBSUkdIhGR5muNFfQAS3wmfZlDY5kiNzlMA1eo7G9bkcMhRcleBLPiHDnDp15tWbzC9LTcFJOfbP_HSG-dkM12GjN-bouxwj02mLYjb4OfirzAzKOUKeP7Mq2cod9ii3zxXa62RcUqYIMJXhVA8dFYxIAnBZflqYSmrnlz3FGXDs_tZez0NFwvXyN6vXKiALw6MJbKgU9JH9_-1mouJ8YYXdziA5MtcAu-R6rhQHTkxDkyMXn_BydWOTjvepBe0cMLlW5g9Sr2ZgzSjLgdM4cdZto6et8yYb5GdeZavcXlH3vyo0eH81dWvmtfACTOEQVwJqqk8O2onb3XqR9BoiYICt30sI_i7Ae4E8LbITEbhWMJhltpgvG6GNlKQfFXVL4tyAdvz9KjW7VSKjXk9VIerpY3-V11k_2PcnvP389_Gmj6AZAaSpkCxbZZWzwOLDeHPDRsBEoVeALeRmDUfgRn8wgVaNu8S3Jg-PW6MFb_P3ixGFRl89OcygEaw9MdHCBy2AgTRiIMq1XXTgSzTc1iKTKNvdgDMUXCfRVyy-yuT6H0-quXtHg3gatlFaFqiAwubyZ4xXPQ4EcqBXmG5KOZ8kLdnewH6wMWFXy-Rp0_wmrZCHkjKSG9zsDmf4owVCQ5DOLR2RHStM0WPxkutUdnN4rDlZ5l7YAs6sEyPxe6ZrjEkUW9AIi0UV5lOmznuKSMpzPjy1R7mpYNhwcQyB1T_5M9QszIaeTzs3uxwTGbqv8uo_O5GciYmXY2tfUMWNZfqeKfY7XbE10DkrNK9kXtUj2CElIodthy-QW73CLiJwb_BSwiClxb9Hf2A_Cf7WzkZdAAigCPHw')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2287', `Language` = 'bg', `PostDate` = '2024-07-22', `LastUpdate` = '2024-07-22 14:45:28', `Type` = '1', `ParentID` = 0, `Data` = 'gRMk2C86AS7u9Uf78lAqD2VbrNDWsWLZg98Mc4b4lsDb47Rru_ulIQXzwX4NqbGjIxOmIEJeuXijAHz9i7usoMLz6x2NGwXEmOcJbsZ8KAyMrAbn1IlZ-9IIhU8Yu1DeicJWHqwydVf4bnddOrOPZDE_S2lgDeeFqNqGOsgalGK_SZ7UkbB0Uw59qBnvSOk62X4IpJTeduqArStL6ko2gvvDmRNcAN9kd3LctqExI62O0jkUDLwnx2ZHJNr75zkSLRxa2Fi1QNy7GwInX4Zp2IW4ATu9nnfzRMajAKNN5kjquE8bXrh3Kk8N_nEgQXsZElGVIoJWNqvFVQvTNKOxdHgb9EwVVG4KWHEWZDNrKpUg4G3HVLvCT4qntCJ475Uxtm840pRbjKLCuyQYh6SI3UvZFsOJKFMaWCcLcP-ozDgWWwCOVD_Q5Tqs3uZpFsIcKUz9bAUndJDz3sBfZJBtylfLogxPvUC1jsF0EDF5IZoFvk1BDsqofrUsBc0bNWQymRJHzV3MBtUgPTbCFHjnrfMgkSwmIYcg052919CPfLH0l4k1B-6UeY8KTS2U87U_5skeLtRZ1IaoHMtomkr1qxcTSzLO7sHsjJoqJXhg-wMXy4-yyy9J4MI1DhCPzffjyc5F6ePeRvw-gn9fJHY9OubMYU4sYFJ0fBVuUCJ8odUQcHMDB1Wi3pdNXbrKd-P-M8izbrm8FQRFL6u9MOuQeVHr0BpeSl5eUGJZgw-Vto8mQS9lC1j5tsw1R-IKboOYyEYKXGUcLmbkpiGj6OhhEidK-vP8W6I_EutxY7qyXSaLFMntG-zMr0inZ2N4cuvhJzajQ_vI9L7HcSJKgYrDM_K1VRkuWXzQrMGFhXLS3aFdjYNGqZBt8Fcn4lM6U0bcrDf0bhDw3yvUXD_O1p3jN4fZYqw4ngdkf8REzi0Bg-Q9DqR7F0rcd7LsJ0uzSxLF61UX3KInxSr0RFR4rfeEKW8717oYVQEt4_gk34y_6iw6Wfm_ct9DdWpLOtbONq-FNM3zNuPzADYthQn8mg2JWDScSU2UYFlvmONUV-yQV3hDfyGffZLH-QLJqGX8D9t2xpAXM7USgW-xvNnUh__QbKjmoFBavPBsKNJGxBBj06njkjK2GbVLaM6UJnABoY5jdvTvDBUQ2uWjoWElGyqaQlMd6YZxwbM_YsakzgktqIkhFzga-u8d86C3bc32IC_minpsS6rvfSwhjhoXZk_HIFwt8P9QQeTKL5xsFNMenqmAd6p8WaEdsUEkrfQuzr6WegYdSzBRkdvpKSNP1bXMqz9uZrZvkDnmCF-Skx53IWsgpe3VgtJ4uGBTr4d5evPveNf0fZOVmD8UqdiTdXywWw', `SearchKey` = 'wofCpMOIw4DCtcwofCpMK0w4DCtMOQwqCpcKDwrHCwofCpMOqwrDgcOQwqCrcKDwqTDlsKrw5nCucKdwqHChMKhw4zCvcOKw6TCiMKMwp3DjcwofCpMK0wrDgcwrHCr8OKw5bCsMKew4LCwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4wrDgMK' WHERE `ID` = '2287'
# [22-Jul-2024 14:45:28] /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-Jul-2024 14:45:32] /finance/root/bg/invoices/2287.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` = 2287
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [22-Jul-2024 15:02:01] /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-Jul-2024 15:02:04] /finance/root/bg/invoices/2287.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` = 2287
            LIMIT 1

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