# [31-Mar-2025 10:27: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
# [31-Mar-2025 10:27:42] /finance/root/bg/ajax/invoices/form/2441.html?_=1743406057506 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
# [31-Mar-2025 10:27:46] /finance/root/bg/ajax/invoices/update/2441.html?_=1743406061030 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', 'CzeXAwfbRkwpkfxkRc8Qedvecf8f1Y61y7mlKzNb4DEo0wNa7O2cZSxLegZaNUIDpM2m4ea6CAmT0jvyai30IGNlVxbxUcC06i_gzHP1S7cCnH1GOUGEL1O2U5u4CTrTI2inowTivC6pAs714CeZHEWVNGNBC2z5zYKFBXELK3Xomyx9N3N970cQYB_b32TyL_f3EMdEbAP96uwBB1BrmZqwJCDZ0ewoEH4L1Mf14SOoZ1CMlYES95SFDmhIBX3Yv6QRBnI9ncVqanvOidf7Ttg39qhvcD2101MZRW0bdaC7ojLchkYyV2UXI2GkMr1jW-hSTwRw_cbdLYBiQcZmZ1QXUE5WPo6PPeiTTH37QYSeoHuEoWhBX42gt_qbAAiAhnVlrx3xw5hRnJdGuKv5LULaiPh2NCfFmznIY5bBq_IeqhMugYxxH7QvPH2LDzWW-CqZdME7io76FM-55V3gYivfGGAlv1mwSieVZVZQuTr3Bram66MRG2w8p6nhvMbiTVl39SHEbg2XJ69XXg5-WAHqVDtqI7KrrtKQQ2RCyKjwx0Sf-tF3vQuAwfoOrl-GurmPpC22jRi2gv5DMDEBDPGAMRh3EQHKi1MFy44j-BNmmLFIb8fhfN_r0WtNk33nD3Z5CYqszsy5aMvV6LYOf1pRdLie7wY5BUgw_OPeJF5cZNKR63q8-ARNkIkCThp148R1G6NY8FZbFUx8tEk8t-kgYD85saxitj9piQuQ0mwUV9KKDeEcX4atZVG7byFnDuDT8KDlIDLmRdO8Pv6pY-SCIeGSJPNAIlHnh3zlM_5bh9yorNzf-tikzW5a7gyvQRQclrqb79hQCpKXLW2jM17Nn3o9IlJjxGTqsNiRJugoAVYvyHEtLo8QJZyuHOEOn0fMiVckE9NCKKK4B2xc1kG5FxvEB2F7kKJHmuCVwkqW4YnjXYuxQ2pg6tLQZBYg61Z7ldg6r0_96fKfc5m8y16yDtSWBzMT41TcDRo1zefEPCjXuOaV2hF7oacKsmj-D3ssyP6o3Cp8T62fJCPooJzlyaNpkDDPNO9WBDi2JtQ-770HEBMt-In4O6ls4bovD1pdZ-bfH22WgpyspT7foQbY7aDyQvT0DyN11lpk1wjx6lQmO5sBSebUfKagSyXnSRguegItMCnSfKSSz9GAT7I7yui8maq6kSmQZWTAfEnHuYCsWzm5zjvAY7W_8u0eXclLtx8RIbT0GPAcx3Sx9gkJfc9BHG0xB1jowjnOSgpu87CYE4lI-64qJHT7RN8UytCD1d_TwTS8PJcNf6CPVGmOKaEUXqQDvjQgL73iv0cDtcCNSEV2fRXbTaBUiWAJf4pPyYR9vEFUA5Hb05l_cgOqbzvFSauqXnvCCsFakSSYDNzfXKE4VWRcgGQ_I-mSB7wcB6WF9FV2XX7sLJTtVKud7ysQopty72r9i5gD0lFsskk7nQLE0mkH9pg2uKqVQM3rdWZhS1NB4UoYYI6VVX_KQQMgKzo87vPwvDl5ToXrA339bs5Ukvun_Jsrq171Cp0SX59w0fzGst0i5KPtTPro62xFPD1FF6nfFdexJrPF1iCV6WvYyRPqWA40yAcDtKzPkgPX6-guFCTRWw-IE0yzz3oZO4sfl2ty6NRiZyLZoDJIFkA8R_bCHFR3fQe8Af0RP8dyORRmDOo0iyWhViyXYMXM7SfiMOdIud7HKUm6_j1sBo6UoozrSYtYcvOZoBUnD9xXvSg7wue2gb36vYTSfYuB6DW_h1yespzGSHmJWVZLXgkNq5stF93tnvYPpvR84zrEkhJECsfun0GVOf3zdMQpmblKbMuC1fE6H0yY-_kPfTU4JhPBQIBbni2lv3Y2HmDaVgY4CyPmkcvzAYY6ZmjU1CpE1fkWy9anyIUK40l7s3tSjhVREZ_hezYnX8cRpZ08t_vEw_If6ffnWXSIfwsgZ66PFVTPzR_nrd8NWC7AjWjfVPJWEfAR7LqoMgf0vE3Nwx5k4gZW43jLwqZyZQwZMpjRVQLMeowMVPMRUNwKWxFPpfYv5XU6kJLL')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2441', `Language` = 'bg', `PostDate` = '2025-03-04', `LastUpdate` = '2025-03-31 10:27:46', `Type` = '99', `ParentID` = 0, `Data` = 'slDupLE-H_4bPLv0_3jIOOvHjAZwUSgb0p3-HdTmJ5Bqoxd4vdWH72xkVZoE1d7XasnjO05tZQf5UE3XBS2BWns9HLHMDcsJ4XmAB_YrRRcOe5gwezWYgRVDkk7qp2UmYqtIMpGHQL4zQnjo-Bu89YQnwpBiwcijhpv0qasfd5ATJW65LITv2KLVxG03FANdo8MCwyzZL7sJHB0-GGmDH2jW5A3mbD3j7WbKDg4vtEwG9YgZEdTlqmDgU0cYmPZKoMCWhnEn5IY-fEVWaZ1wEKQ_z8AvmnxBUu-xfyIDiykSElYGVdxomxZqoUmhSA2cjx8Y2y1I73jeL0axQYbnOS0qwuIV7K6almRVlW_zha6B9mWgyrSmMUPyK0ZQr9-IEShK756nRXgVffJfciOlF0UssL7-mB6AYsJKCgy9fMC065RLLaWXgubMtQa_LTuI9xJfOGy4UIdarOF8v3FyFXB-M8jGQ3ggPUvq6FNWd1_QGnjSBkTytCJOP_kzPbmSjbB39MX8YyjnMW1j6A4tp3LxKCHxC4uCID0ZgarsPeB1DcXzoUACluO3PlPZL33WluEx60nbgBibsZy-kO_Q31y0BX2bO-tRsFcEMrS4g3shZU93KMQ7S0S785r7zqtipR0gpx9jP-HfPe2V0ooCean1UMI55ttNXYVPWQ2T7sKxuPlKjKI9qfWJwnY-lxxhOWYbelZzB4ZZ_je2s5nzYl8ruZzRpY37UDVtazHVZcARqnEwu7k9D7iNljUqBZ4awzVR4mj27bMqLs3Qd3mnfWuXnw0g_iUpUhha1g2ldeqt2X1azzZsa--lMX1zNAA4sTv_6OXjdcsQb_8BjMgvWVKhgnHevObuA77du_18xLoX0dIKlrn0BxSc17e65-DeFdaUKoTGsf5bdwN80HM_BHbTyczEj2XLpRLpW7sjlirE4UoJTNKosUdhMEP7-7iFl0tXXEBtlvcCuePZKkpauw8y--A2gLcv0Lcq-L_4p5BWQ02JsRh6NOYaRn3L-oJEZLngv2FEUfqXbCVGVoFXB0xRDu5oVuHKj7mlPF8ipxCfLzblIEmHPSNniN0kmSsA', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwrnCisKpwqPCp8OEwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6w' WHERE `ID` = '2441'
# [31-Mar-2025 10:27: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
# [31-Mar-2025 10:27:48] /finance/root/bg/invoices/2441.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` = 2441
            LIMIT 1

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

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