# [02-Apr-2025 07:48: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
# [02-Apr-2025 07:48: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
# [02-Apr-2025 07:49:19] /finance/root/bg/ajax/invoices/form/clone/10443.html?pid=10443&_=1743569359526 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10443
            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
# [02-Apr-2025 07:49:40] /finance/root/bg/ajax/invoices/insert.html?_=1743569380907 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 62 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` = '2462', `Language` = 'bg', `PostDate` = '2025-04-01', `LastUpdate` = '2025-04-02 07:49:40', `Type` = '1', `ParentID` = 10443, `Data` = 'ZHuemI9S6a1mRswkIM3NN1YFKGPEzG-zsQo5UWUlD36-jd3OHF5CJv_lqOy336N7FO_Cpwlp7pqyU-Ob9ALJPt9E3nq9BCEJiU3kykzrJutbtEDQ0Hp-BWGWJjgUX6N6E0-eprLnAZcNAqzLzXlorl-HWOxeAwc8HinSAZwcszzZB9X69vVcs8tUlsSIJ_5IboceRDjGFktWASN-P4YFo6UyeEUehN0MqTg71ArkuZVQkMxR3u-nC7LZRATj93vIjYcEMFurD23oE-2zgtyVnf_vaCUuavXnb04Nt6KFIffUSVMUgb3OgsglU1XzyAeoYk-9KW9LrexP7-_gfFmJecChA4JanJUBGkgIJLCRxMvOExUQu_fy_ZoQIPd0EFEmIiH9ej1apXhzLZ8QX2-o5f4uUU4BVvkCFShU7LMIS36kcEeS1xuwh0FN3H01w3LSlcaPMaj9L21zIBG2u7TzJ5_ff95lyeEvW0W3BYmIsnvZPlCMNtGikRIXOE0xgw82ew1LdHMkUbimpIeM6Mx1PILKYTS83XFinBb_nxzk7StfrX6SvvOfsIalcSdpm1EBKM8xUZmCaXS5qx3XGRQsVQnAvmc_SGNgQkNf3U54KaT3stjvFJ7AiGsFoZt16TjSx1uvtMKKIRu1fE8VS4pasq0QDajJibf1B-TSmf2DVqWNZdBptDbN41ceQjsKjnHtsjA_CXD7f-62tUBugSCOruf2Oc_s8vnQs8vATKqspjfoW-XxUJHkHce36NzKUm9hIPHucRWmqAylx5jHXhlPyR0A-BuNZuLUYYru82DYUBjhAm4jT-0DKgMGpDArvPVt_aKdp-Q5UrBOsrskHimyQYLPcowvR73yVjlXtsVwVtk1LXkCD7cGQigKYsJjbLDSPmzjdjf6oT39vE_kzGkxc0_PlKf-Az6Ih8R-Aq5hYrXeVcObie8ZSMfTDTWAB3xrET_N40T0nBYeJLQDMO7ufurMuZIUCx5PU29h7TEvMcqElQp9Zxed948PU5uUfMaNyIeEx2ki_qm3tWisWGb7onr-jh5kE8706Zs8L1nj7hSQSz7x-AxhD_ztv6ctYAKXOqKfziVl9C5gw7qqfEV0S7e8gimy2qshD9b5JZInuNAeAMwUVVaQIxtwv0RWngSOVta7jCVrloQYreYVjToMF6x__kkQolPnEtENe8LaFPT128sFShc4T7stW2NmAlAMfQFcwQzyRPXKrQPbsQrhpiM-UBg5Z1pErbAEvwbThXIAGdCCG6bmJCrralVRaGIGIwgPkIPZ4k_0wPTs02chWJHWw2bxT0KISSpoE1TXEHH_ksJrtG8D8TRUGGAt52Wd', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwrnCisKpwqPCp8OEwwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4wrDgMK6wqCqcKDwrHCwrnCisKpwqPCp8OEwwofCpMK0wrD'
# [02-Apr-2025 07:49:40] /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
# [02-Apr-2025 07:49:44] /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
# [02-Apr-2025 07:49:53] /finance/root/bg/ajax/invoices/form/2441.html?_=1743569393406 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2441
            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
# [02-Apr-2025 07:49:57] /finance/root/bg/ajax/invoices/update/2441.html?_=1743569397105 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2441bg', 'gk3tj02X2P8gardYJ-AZoCVhlEp-IUZ-tq-niZMwxzwfBR5wTIJJQ7ynxzmBNn_BfwBmLCdLBcF_UJFaUSHx7bt_FVxw6XAj9fxeHJGBgRivtuFdpYWJ2JriEo7iLoBDnMlD88S48GrPz3HQst5a2R72mloBDYJzYVIBWCNPFvvjF4mqAZMMGSdelQKGHlTFM2RPkC62-HqilQMX3A-GBbMS925uG3lvLj02uV9TgyrBFmqkbJypCNH0gh7bfYYUUyPBz64_UZ9JA_HHsnQ18CliQCs3p19pGlUepniGLBX5pBS9qeYoq2FB4djTNA8R2-F-DJ5nY5F_XO_VsF6sgepDKwAf7_QkRJmicXeJ4MxLYg4W_N8fhmgxVlDcGODvj16-1AmeIStgXajxhufo2O0upeGqybH_Qz6AsizgkSdxYrx7b1uHr9Iib4Uuz37P42sIkbv5joUZkEuKiu7-jsSSdvCayj96Lcm4Pqc5bBHK8rwzDiRE-D9sJnqP02zTf7pOHvOnXA3ioRZk5MasnJFGWnmskHvHu72rjOO0DO_47IZYe_qoAfbmRNIOr5IKAG7ZczphO2iGpfGcJhOoyN8Vr8CZj_WF83QxWgmBAtePax7poOy1axSfvkK3sjxtQ4ZzrIszyNbBR84dv5hXIFhCGrHCKvGSftcKuqXwLerjxiEkl19H_R3_ao1wV8N_bXuFm6m-1qPzKj9-iGGoEgTDL7CYV0ut2tWB0REaKmTax3GJoX-kQZ4pLfVqrX9imF3LVv7ylryEQ4VEa9wX1V8k3yLLuf97fsMy2Fp2esK5DnR4GrgcZ0A2Pl7d-db44AxwknLNOsXO2hcdqEtzhhr7adzqI67ajcCre8BGRAlrxP10x-rMwiC30At5T-FU-LNvLSqyhy0Ikz39jJsgs38SnXGmTUA8k31kDTnrPkeJUnGgJtYx2Y_PnnVT0SyJ0WuvpBJjWAx7AgIRQ2V3A1ZybXUD_CB_gS2wiAa6-FbpJTZaUZ7H4u6wbdpnYcpaIxlxnj04ZrEqf6WI1uMfP4ewtlqkfuAc-hEYqND_9Omv6Hq_o0TqnTALmMgNyWtuzuDGt-Gq-nYSfQXNedZqKgDeeg--7hm2O2zYdrHsyedgwSLJHrIC27ifmama9o4s0b74XOOLThCWryUqgTUjuSHuiX8ad0pHEUsZdAqRlXbeHo6mebeM-Smlw6lQBvpR500_JYbXh6KKjI7QXns0UUkfTTgIOZMg-QiR5bau3h4U-hMfT1U9q7kt5BvP93IH7ZzDT1kiC23NWi_F9Y40tGz5L7Bz_UO0coCMiLSJ7eKbB8cZ2duh7W9Ni4gYHknDoXuZGpVv05nI7F_Yhp-rsaqGyu0V56PrVF3zm_NC9XxHgnJERWA__3nYeIUiCKpSA2pK59Z_NqitcCKYwNHDQ5WRZA-Tm97_YfBIt_-8ybWJw5iuVCAG8jIudU6bP3Zx1-TzfwezOWRJSUv8bR15ZCnDPGUbCS71N16dXiwliGRuQ62c8CF1H1kTvxoa3H-BVUr1FnBuaHV3WgRidkvo1EXv4OC_xaOVl1mUg_f3xTHzC3xw8hgQ2SbQ3l1gk2jQrGzPtbK4MbHCCMTDlVeqXb9dITuICjRHIbsPAmeL-kII1xv7Yq-2BDRYnO7iETl3Zb8HpFT--_cClalsWENHJKrvr8c0qrVg0YaUd4patB3l8W3HcfGj9tcfb1DMymrDyLkS5y2QngDWN6bXjDFPPrGoHMuDWIN_vQ7Pd-mn46y8J1y2J859ijkO1nAActaiwizF-fBf-x5g2fMvA3DRr9OLeiBtwtk-Ei4LQtT25-irjQMTjlUidWV0SKsAKxEn98hyDt4j5RHc7rkjcFoRzKCCIIE4vfn_R2XJQ3leLjSIxxurh_It4kQ-ea0d6CBlTidA0VxEH-vx7bKEGOaUUaf9k1ODC8UZ_RGw6CMlyyBN9DtHL08poyRszX1UZZEYscSpptuA_W3PzaE-qurCSg3MPTAE5qhvDGrJodwluhEjscqfz4kFzfDcABPazqxE')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2441', `Language` = 'bg', `PostDate` = '2025-03-04', `LastUpdate` = '2025-04-02 07:49:57', `Type` = '1', `ParentID` = 0, `Data` = 'cGpibuV2z4_ez0XWUJmSIPUo2cL9mSlTWgfw46znWBgST9P33E-xoLv2hXXyYxxodKy1Oq80HBnTbwpdnVh7orCTxaspNhyyE-_169FDb3k35nt2Pxi10HLMynQrp_TWuA5bhC05SxR_2vZ7rzpBwcaFAC078-P4fBjinuQmQkyeAUNE6H_KTtadG8St9Y_lDPFfZJjBUh-YuAkdFZjeFT3gltOf_VXRwKeFCD4eCmyqIMWPo-yLLbLVFO_bE8jBzYXutrixe0BF3RCExb1KcqQ4Hnu6j0EcbjPqRsDjWpZQESxNZHBxBk4rgD3B8O29p-SiPpSokhu5ncP9q0C8Uvp5Tf6gqgOwZ04SE6GCG9Wo2pUfc-JPL6yVl2MQYUnHX3IrnDgSPcEBPHZ3-vfRWjEizUOO485cRQRKuOYBRnfivGhRDoPAyzJVF5HqFWdZx8x_B78hO2gZcS-HC_TzCg_kV3M25Mc3rjGOMiBZ6wFhjgfxpETlXq3kabCASXGwK80kpF7kq3MitVJxJsyDfRPiNA31h2rY1RPC9cqg3USqccxr3aTIpNIwHOQ20_SoUbI23AqVNQ9JWICgnL52ntV_IMggGoPs3pJFoINefRDIN2TVllZ3pXL3FmaVpbRA3hAvv-PMnPD8mKLL7kAIDQ-PzInTeA6LyZIhuXY-lcgTEfBPq8WpgRATCTDsHUWQUKTgYXv9gW91Edqz-Nd3reyggfCEFDyFzmSBr5gNk8L1E80ML0XzGj4J07-n-pybq5yxieKoJBVyfqBmqJQYS4IV80A98rfxRFGaUkqVu3iE_-3vx-hr96ihDdZsnN4qwI67aNZY3UV7sXC9cbJZ9I8VaAu5FP-cJYGqob8f_T_jJ9DNB4KuOyifA9pMnx7ZQVgI9hyEQSC8jZ73W4uklGQWbNdSIx58DhD6IqiIH5PSQ3-WcqB5WjIjmcu5rthqIK5__imU1rHsuxLGoiDzUiLDNUaVLHxR1HHnZqZEtmDa6AgBRCpXbzqXSalDrXEsFxIqdESdwDtvaqbLTvBTvQaGyTRhVZMvcTjA1VCEBw8J5ykmKX5Wp4Ozf3j6XXBn', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwrnCisKpwqPCp8OEwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6w' WHERE `ID` = '2441'
# [02-Apr-2025 07:49:57] /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
# [02-Apr-2025 10:30:04] /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
# [02-Apr-2025 10:30:13] /finance/root/bg/invoices/2443.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` = 2443
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Apr-2025 10:30:26] /finance/root/bg/invoices/2444.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` = 2444
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Apr-2025 11:04: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
# [02-Apr-2025 11:05:02] /finance/root/bg/invoices.html?from=01.03.2025&to=31.03.2025&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-03-01 00:00:00' AND '2025-03-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [02-Apr-2025 11:07:49] /finance/root/bg/invoices/2444.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` = 2444
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Apr-2025 12:58:10] /finance/root/bg/invoices.html?from=&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [02-Apr-2025 12:58:24] /finance/root/bg/invoices/2462.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` = 2462
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Apr-2025 13:01: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
# [02-Apr-2025 13:03:27] /finance/root/bg/invoices/2457.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` = 2457
            LIMIT 1

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