# [06-Nov-2024 11:21: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
# [06-Nov-2024 11:21:45] /finance/root/bg/ajax/invoices/form/2369.html?_=1730884905921 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2369
            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
# [06-Nov-2024 11:21:52] /finance/root/bg/ajax/invoices/update/2369.html?_=1730884912731 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2369bg', '4JDJU2KLGAHhJp2GhYviAYsArK-qGe-Qoyk50Nn3lFoAGaJTQHX8AQQmAx9dx8ABknvMgMfIZOgUg7xsxZu5rDAmv6OKRezsa3T-RovT3lVsFDnFhCtKFMpA-E56dWC_EstuCFCFOWeBgGOxG4rzTRvvRbdPC8mBi1YcSgXgggkTSDcNAhf0l949pSkC4mjZUY1nF-1W3Q1LmfVGQHG6C_5UGMidTMO-5THxYnrps0s3u0uRtbbhF5rkCmPWlRNkyJu6uJIJ9n0bWGK9aTlOFg-yy22mkKUO0jOO7MdxMHj8REnpjgW076MHVyMpc3embN46ZvE7xuOtz0gRawlajQ6JC7UylUE0O10dZwguyfjQQ0Z97XX_EgUnn4stXzIyQKOZwK1NzhivDq0cYVRBanunasUjivshwmdWWGpRWuKcJnzVxI_5GzVUmBXqHr3t79t-fuwhGCR8tiSqgGXO8Qyl3M_AlYhb22jDtjfspyGDyuDandqQWMvKdIB7FykQ0JLaxpI9mrFnCCZIU26COnWncpPVCTc_YshdeQ-9UFW9V_Di47UcGz6OjPgh82cRLRUVpNBWYqSHHDkTrzOXMGEPmXQk3jiDwYvBA8KSXlfD0E18XollzR9SM_bpIxCWRTeFqxzNOZs2hofBBbAdGgtzF_2QKFyrDlAP2YfGiCE96BzeUrcjMWB4_AOk80OYOPyL_90UC__-PpKwJ0yry4VrMP-0ziZdv0HEqBRBV2YLG21hJ0VV66MOnHTSu3kBT2PuSJkOg1NWzNWv45fo8oTN5AKYB-Q_7IcqMSJZ2s0pEYYvCgsvtEnEHEM4gfJg-VtWUK8jwZLEuhGJFuepOKo_Cc4eyAq6KAuSt621DDiSJEEMgsq5_EdPmeTggLfSs1Ts38sRBcke7rVjJKHO4eOOjn5mCKAhN-QH8nNukqmNDeQodouogzWNpsaXxM22ZQUFB8IYbAaPTeCm-ykEW4WqxsDD_B0QRSAgB_VBGQWTdBa74vIUKPKwdI1EiR3WMeEDUd-a9SGb-lQ3ViOLlZBAiDmuw_50mcO5B171jX7WTwXu7hNlw0Da4FfdhLxLz8pmr4nETwNJ3YTWBx0QQFAfJuB5ZdSoAzFnahxQCtuSnyEcoND1v_VNpM8TvKsQhgv3q5_YefNcc61sPSQSCtyIZiZcEgCImeRihwzZ-bJG9Hi4FS0vdNwGyl_qSoZ1esfIoArVStR0O-JCKa2JYAyMkCoCkR0szo-gXu6IhGPLgnex8ehgaJJHaJOI5L9pr7vRvnpCwUEteNmb3g9UERtVs99NuPgiuj6zw8oSCX5eVOkQiETHBDRSS_BDxJIfco8iXD7yzIj3fgdy_L_55RxydLeli4yd096v9ZWxZNiOzhmLJKl7S0mbdiRqPh26GkV3BGlU-a38SWOj0-JnVTy1UqLVFFlxEOvIGKd31z8GPG1zEp-I2oKJ3M1WGc_dU0hOQoLPXQW574cSST6V5Bks_CxywDmr5uJYP4AjlPYNAIp9pggsBJoXJIOgD5SVJ2BHAnSSQVwns7J9Wh2vKRhLmvbibvdL0E3RwXcaLeJQJaZMoEV6FpBZ-W889jK5nGERf2R0wfTYEJlJbv6sEZsHgoCpORFssN_T0NUaKsrMeNO8mX_GrVL6M_DCLuHev2-7g0wUFDW7N5l0RJM73OTjZ9k2i5asv6uSFdiLSaw13OpFOOiIee7uZGyxqoxq_z-iWIXiHg75M0j3Bodo7YQdagi98VTF0vdOhUlhpUSreUhMR2NuLk15hYi5k-TSiHjhgAvHe-XDv-9jVz4TDCxwNUCvhNKr-a6zUvZv-KvShpNU1KjcxTBtTnKI0h3ZJRsbtdc4Et9LPiA9IAz7jzgc0JBA1wo3ImyRVlyb3SbLNisgNQoFgK3K8xJyeeQH6nNb2NWM_8GKPC6DFYIAbg')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2369', `Language` = 'bg', `PostDate` = '2024-11-04', `LastUpdate` = '2024-11-06 11:21:52', `Type` = '1', `ParentID` = 0, `Data` = 'qHvQFmeqLjD_JT5IKrNXc028WdAhpJOf7LP_EEMw1Kgi88zIFjsCWRliXke6-LAqjcJSZahEOYzGjNUgUu8HCDI5nB4GvgpVmpM34nwuhG8tKoILR2wP4Kbp6LjNG7yXjHXAkbWwTaxAXCMqm9ckZXRSJ-zcoRqvtEK6tKFL3BUllKk_2w43uaybYrpCg4uMUumuTR2bUPKXpljHZvjLV58w6TpuaABv4mW59qW9_JwD-s5KvnXbmjbTEDu_auPsSJWnOdpnrvvNG8agpnQlJE1IL6a9XkZH_FObCZbcwwu_MH0em7Nt0ieljGG1G-qEtF3O9OS7yyrEthcsFv6arQOBuo0B5_FQN9wxb_yVxgivMfXbfN0ENyH6kMMhH5RKnyqqZUvRB6iV6ihznPEtrZL8w076wViOD2zuXPbFocDgRknanlrC2ncZ622I3shxo1KgFwKJJawihaVwWcCT_WzeMDBYkSbhoyiteDHOu5dU-F2eoLdhacv49ypIQD5TOJfLJ7RaVJNnsZbF9lrKYk3EeCSBeuD26Ads0OYQn1CBwhdtH-lEHmw8K_vJtWG-KjChWFsZhrWXnvleWQqtbO6NVUrxcCQyMI5eDzfwmzexek1dzHxaj8KLPenTkC14k63lvGOuXUdnwwT1B35CQVf-ILkPbXfSstlV8RZqZ6F1Ss_HM9l084w4Wkk2MNg75no80d6zn2-RkzKkvNUBcoQavZmPeOUnyW8Q5Bzg-rTOe-A0eka9YYfilsAQZi-fJfrLPtixCc2VkKP6f7WbG-Q7wSOXuXlbSKpcfBsF9LnKgcJfdNCGVoJ8saxNubhh1xa7w65nEceqnOtfIyMhebAHogm8Mvy6mYHj3ndMzrXCNAb8t__Qcb7EAMkURHqDvNa90d5Afefjc3IZoEAKHvpIgzseEoL2Y_ZeE7767KrHRR0t81NkvSlcfrFY2AmCPf1YN5nco_O8QBKztlGROJyFqaQgCj4bfUUrm4e2pv0', `SearchKey` = 'wofCscK8w4DCtMK6wqCqMKDwqTDnsKrw5vDn8KdwwofCpMOAw4DCtMwofCpMOIwrDg8OgwqCocKDwqTCwrvCoMK6w57CpsKewqXDwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8KhwwofCpMOWwrDgMwrHDhcK2w5jCp8ODwrbDqsK1worDwofCpMOWwrDgMwofCpM' WHERE `ID` = '2369'
# [06-Nov-2024 11:21: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
# [06-Nov-2024 11:21:55] /finance/root/bg/invoices/2369.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` = 2369
            LIMIT 1

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