# [30-Jul-2025 09:06: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
# [30-Jul-2025 09:07:01] /finance/root/bg/invoices.html?from=01.07.2025&to=31.07.2025&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-07-01 00:00:00' AND '2025-07-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Jul-2025 14:45: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
# [30-Jul-2025 14:47:09] /finance/root/bg/ajax/invoices/form/clone/2513.html?pid=2513&_=1753876029357 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2513
            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
# [30-Jul-2025 14:47:48] /finance/root/bg/ajax/invoices/insert.html?_=1753876068044 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 2 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` = '2516', `Language` = 'bg', `PostDate` = '2025-07-30', `LastUpdate` = '2025-07-30 14:47:48', `Type` = '1', `ParentID` = 0, `Data` = 'NrEJI4AzSg5kPdyrhRjPJWrdkasZBbpn7irik0LvWmWRE51qb5y73_vFA5YTjkndMJ0-2Egy1FLzNAn00PZcqujswQOf34tKP6ECuVLbDOb9i1IMcru9zmJhPT8g2bh-iDxY0riyMT-Dur66bIMImS3rAd-4gTRPivatQqQCxT_T1MteRRfkAaEoLasHIEZTZ5xjcheyACR9PliAU21UZEfshg2Yq1_NHWAMyNxOUtgrlKb0-L3m2psXrZB8EJBBDaA0mJ6xbLuUvZ4ywEpzHAzg1_JeUKsT5om7CPcqzOW07byBO9ShqHYfDTNUNAM70GmmvSnRnPjnOLBFTSzvu7TMlwu4jLLCM_Z5cTZGjyjrBPGmSfCRNxOgAVBfa1KqeAOH2BHJ9g3gqyyTSf8Zf7NeBeoy9aRx_UiekEH6zH9Z05yXT-NDsaUlKLSx1MXg9yuQ5qqSLA5-Gyez2LAWccL6Ob1lSwsESVtYp5-S9ypIoTccvD6s5m6wnxOGjM47RIc8Gm37H1mkWK4sQfc_EjCsAkTlwdEi4UCb06EzvDcrKccc9Vab1nJD4VgwA_xq-YmArw6St0UFfpTlMSNSWxcvRsMSgYRGuHnNGBi4a0pkxZHYzbQZ5czyTy3UM170xv8VR6CVK7o6MpgI9fWawNXDkToAngGkOMUbU_Qa9SDqgVIIAFUvQA2V-0iQbyaurHbcP9Ro-vCxHLE-jXJBNW85HxpQXADmWKXd_Ems3EdX0jezAmX--YS1nL-aujeta4mdGDED-PKyj-O0ECpgb7F9PqSsD2RmIVQtGlPvDeKtZm-i4Hfd3KqErKJAWRBK0DR1rjuS7COd5MJq8IvHsHxis34nYza7n6GNn7Up5tftqRHQISj3RRH6apUC0zAq1CQlkJNq1zz2ryUrbIqVSI2MIuwAuIJt8Sc2oU1YYX1lkBgnTJzv2G8rcSOR2-l_A4nDBMF3_0PlXrpT16Uk40D82RVzCmxeRFj3-ieuGL8UeZRGMZuBnZ9JHL_133FCe-3RRT1A6kb5cM_Gaay3oQ', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCpMKnw4DCtMOgwrPCvMKDwqTDlsKsw4zDn8Kdw6bChMKhwoXCvMOVwwofCpMKjwrDgMwofCscK0wrDgcOQwqCp8KDwrHCvMKrw5rCpMKhw'
# [30-Jul-2025 14:47:48] /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
# [30-Jul-2025 14:47:51] /finance/root/bg/invoices/2516.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` = 2516
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [30-Jul-2025 14:49:07] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [30-Jul-2025 14:49:52] /finance/root/bg/ajax/clients/form.html?_=1753876192051 167.99.142.201
# [30-Jul-2025 14:50:42] /finance/root/bg/ajax/clients/insert.html?_=1753876242913 167.99.142.201

set names utf8

SELECT MAX(`ID`) + 1 FROM `clients`

SELECT * FROM `clients` LIMIT 1

SHOW COLUMNS FROM `clients`

INSERT INTO `clients` SET `ID` = '84', `Language` = 'bg', `LastUpdate` = '2025-07-30 14:50:42', `Data` = 'uDGXzseav6Cv36qsFe5I0Sa3BbBsQz3RykJBMx60HiqEzPMGnj7NSOF2BXf6BNGXTx7ZA-V-UJ76x9XSFU4of6zlz0y-kdZTHQOF0kp3U4uLiANdYOzHirnX1EzhBs5DU0q2Zmajk9Wz67tAPGHNs75Haj3dGpU80sPh_Wq13Df-8eOL6gmoosCRfNuN_FU98el_GLB1W281EAmmwrqM_PlxhKPdSyCU122PxAzCO1yvsayTF6E1a9gDlSsShf3Jz7xW6GbTbpYNCSWae8bo29RdgunGQodZT38cRlaa1hsGHjAIObyHFfGtfpGOrTzlXmnXN7MOe61rRug2bcMP0tzAtDPyx12NE28LCopVIHCd9U24n7w1tof-X20r5RFB1G6bu0AQswxk9ChSXk9lZA', `SearchKey` = 'wrDCr8Klw57Cr8OEw4LDwofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLwwofCpMK0w4DCtMOQwqCocKDwrHDjsKrw5rCucKdw6bChMKuwrTCvMOWwr7CjMwofCpMK0wrDg8OQwqCqMKDwqTDpsKsw4zCpMKhwwofCpMKjwrDgMK6wqCpMKDwqTDhMKrw5nDn8KdwpChMKhwwofCscK4w4DCtMOgwqCocKDwqTDmsKsw43CpMKdwqDChMKhwp7CvMOUwwqTCrMK5w6bCm8Kww4HDrcKgwqzCtc', `Top` = 0, `Visible` = 1, `PostDate` = '2025-07-30 14:50:42'
# [30-Jul-2025 14:50:43] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [30-Jul-2025 14:50:46] /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
# [30-Jul-2025 14:50:48] /finance/root/bg/ajax/invoices/form.html?_=1753876247925 167.99.142.201

set names utf8

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
# [30-Jul-2025 14:50:51] /finance/root/bg/ajax/clients/select/type_0.html?keyword=ani&_=1753876251169 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrDCr8Klw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rDCr8Klw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [30-Jul-2025 14:51:37] /finance/root/bg/ajax/invoices/insert.html?_=1753876297624 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 84 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` = '2517', `Language` = 'bg', `PostDate` = '2025-07-30', `LastUpdate` = '2025-07-30 14:51:37', `Type` = '1', `ParentID` = 0, `Data` = 'hpKEDm-Ov_NbRnTRRJP4CiOi9fgF_lrmuXiHJ4xFnJvFlAo89a2cwvgoyWqn3MG-TjV0crjajPfuYc6FjlLzgkoHpImvWuAH5a-ttrxQf7wJvinKGBX95ytj3J7zZDBlRjqJFjWCMGIpiCDMdLuLUK0-m5Q5wgE2yaZPlb1Z5JFPq7qCYyr_63LvMOJGY8F4TvH4Pz8rvsjYuXMUOx64yVehzmHMcqvc520Jq9fmcR1yv7sbn2WA1moVzN084NqwahCy-F1ZNdURhu7DqUZGuatEpRtp2RqxBs_cO5DeZ1CAPlnFojr4pTs8zbgjgJJusiXriornxWxyxKuaM8a_88ylkx6cHV-FCck4zMTH5tqNKWRqy-CNCtxRcqvb6twKDuhAq76qXTQSwQPQ4VebdMjFCavPpO6BQmmzifGltZCmpGE7t8Ppg-238x01PfxqEHP_-2aK28guit5Il8MMap-YBKSkfg62nMiZvM4enmKmhvimO6vaTXl6JzMxYYhZ1qKSF-9a6mUjb3X5-s0rwpYxc7g6G_ani2ekMqRmiVTMlfSO3_aGQOGGN26dad54bXhi_594QMV1vdgcw5Aj_GRtfl5J7lOysKvPflhROAxljVk-n_9aoM0I6CeYQBjz5_MXyfXmS81wMyZLTQ6rOEGYe1uzrQOkpsXXcr9jUNEQs3D2vMS81f8_jGQmrOZEHfnNoMj94AiTLxCnhR7tjjPF_RotdK7a383E9k_h2GPw9T3Jq2yiUEYkB0-LG30PeYQkaz6-UVQMcGIoNmIqJGnDceg93xFuS8gUfWPAyY_tLvSLyzdtB0Tg73cS4bxYXSWXnt5XeXbuslUuLafBupk6B6j-kOqQ-yKKaLlSoZyoVzJuuNDkVSotOEOHu_zkOE56uhgkWg9W1lEE9WuJptg9b8CNzPRoumhFqPEju-G1bvAoTeQmMZJraFAn8lIWQIhIYcB_9Rptd-K-nQ8NTqilOi5oYkFUMRvr4eNpwg2EAxEZIlGmpfHKf_MHv9Hu6dbiOEGGVQXBFwf667K5tJrA_lx5bodf_ib3IJqZ8tnJOCBMB5dr0d-PiGb654qa-bQ7txDVDwKVS2h43QCulHifmshSUJntBWsV_N-G5GPjzpRZuY2bnNlb6L9yMA0HfnJ_5Hb5i6j4zLvEFmBdnITgVinJ9Kz2C79VCaPLFf7uwJt-1FowMDlb4l512Bxl_0vn9a6qztfvMPNBHJjtug', `SearchKey` = 'wofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLwwofCpMK0w4DCtMOQwqCocKDwrHDjsKrw5rCucKdw6bChMKuwrTCvMOWwr7CjMwofCpMK0wrDg8OQwqCqMKDwqTDpsKsw4zCpMKhwwrDCr8Klw57Cr8OEw4LDwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMOWwrDg'
# [30-Jul-2025 14:51:37] /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
# [30-Jul-2025 14:51:41] /finance/root/bg/invoices/2517.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` = 2517
            LIMIT 1

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