# [28-Feb-2025 12:11:43] /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
# [28-Feb-2025 12:11:50] /finance/root/bg/invoices.html?from=01.02.2025&to=28.02.2025&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-02-01 00:00:00' AND '2025-02-28 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [28-Feb-2025 12:11:55] /finance/root/bg/invoices.html?from=01.02.2025&to=28.02.2025&keyword=ooyes 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrnCisKpwqPCp8OEw%' AND `Inv`.`PostDate` BETWEEN '2025-02-01 00:00:00' AND '2025-02-28 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [28-Feb-2025 12:20:34] /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
# [28-Feb-2025 12:38:17] /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
# [28-Feb-2025 12:38:28] /finance/root/bg/invoices.html?from=01.02.2024&to=28.02.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-02-01 00:00:00' AND '2024-02-28 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [28-Feb-2025 12:38:33] /finance/root/bg/invoices/2189.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` = 2189
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Feb-2025 12:38:49] /finance/root/bg/invoices/2181.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` = 2181
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Feb-2025 12:39:04] /finance/root/bg/invoices/2182.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` = 2182
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Feb-2025 12:39:37] /finance/root/bg/invoices.html?from=01.03.2024&to=30.03.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-03-01 00:00:00' AND '2024-03-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [28-Feb-2025 12:40:22] /finance/root/bg/invoices/2203.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` = 2203
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Feb-2025 15:16: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
# [28-Feb-2025 15:16:52] /finance/root/bg/ajax/invoices/form/2425.html?_=1740748613027 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2425
            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
# [28-Feb-2025 15:16:56] /finance/root/bg/ajax/invoices/update/2425.html?_=1740748617047 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 = '2425' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2425bg', 'yI0cVpCjn0A6rFVXenleFA6sPXW0vxIaIoPq5bCVZrT9odezX3E-2vwV7F_lFselJK0jck6xwmJXYqGPI1Pp7cvj-f17TGDuR095QMs8kD9sfysVcxlu3ab5JHOEeAdYi0v08D2ZgoS4PN1QkSNfP6VSrYOIvjPvgxH-U46axm6n7y8k_VREmMJHq4W0qt9gm4_aCcFYDLSVKwBW3QRmM6M3HIZomHLawbivMpdIkoXYCabpAi2yLxh_ZvbGvo7xxyOgefLr37Rp5XHovHRv58oSKWRH9A59EWYkTt-BSqiHqL3Q6kY4_fpHdB0NXK2szVRHIW3Lszcih0rwBtMlF-CZjwUcwWYypWQ9MAEHjZLTf7oRTlmiENJr5K2jFvC2lVjJJxM1Eawg52ahRut-qW9nlVtnEGjK_3WqkPuBQC5DoFAcvPrJxDZEzQQJVFGLa1k9oJY3FPc5pobHjoFwxH10_C9lfRjrK2PDD0D0GA5DM-YAzdC4PrksjLpDM_8inyVzjaeBgI6OkjKlibyj2i7-of1O0zhv-rMyBoH6QlyQyyi9OlxghmM7fq0TGrjcQYgPkFwfd1J-KT7Ij14atkuqjAqJmI599G_isb1ZAMzynllgoHF0TxH2Ov-tWrRXYxnlgNZBV1ZsfBEcmcTJtZMCE7mKEps591RGLH3WKjj9nsQxvzCMTwsQ-Bnd-zf06znER-3CUCSf5bmBXvY5ygQZR0YTSk0y4nY-A0aOJwCUTdzfupC3nl8G6eFd3O5jPVjgzREMWeA76_z7FaZbNyld2kO8E3M8Ft6Cp2kUBAjyoRmscevL9a0YFhHntGbpMtL9pHrN_bUWW2OfRa9o6KBsGyP67QSus__iiAWrIla2cy6JEJQTm2QLeWqn8VwT1SCZueJ7dpr_f15YXnTs1Pkx6snljKjqTNlfNel9WVk-xxbx9SSaHPmP4_RhES7Urehe3jrgQlcP_DvMNNMqlFnFFR7zAX6xzniS0-YA-ex7uRdZHxSo4jOpEoxKZGk_S_AteAYZciD0rN-aRxGN5nk4dA7y2jTTGuKUivY68VIY6QTAX763O0xxbTDsFtHtIbn88ytDy1R7XbRMcyDdOtJxNcz_7KSPHsPeHCO1Ex1B8I23Ig6F6LkkiJH_wiD7BUQQI8xRWzuDr2LXCNRvYhahG_-dRLWi7SxS4LAlU7Ghoydw2_PTxyvktzumLkEKGrJiKDUbcR_BqnV2wMIFxvBfNCG_8wIYUZCGW5UzNtjmP_FvIWptX3fJwPqdDV7EYLPLU72TeV_C4nsdeHVLBRaTGw7lhhrCTYG8VOsbNZ5YKpXWVqv2-rlU4uxgiK9wJ1fFXIYFxyzLbyzExMwrs92zqXZM5WGLQHAOPz1jv2NqxWDSwSCklcA3sZiEwZgKTyOFXTHNeBH8KVVRnrGyCyIDwvvKc0BxU0VMflW4E86v3vMTyVdmwZL-B9AulvcDe6tQ8is-N8t8_xWNXP_hL_hr1D2uSxFfYN_CaQ-ngRbGcNlK657UKyT3kA1G3dmI4kmljceh7YDCbfJ5tvBiush6rlle9LiZty9UL5k_XKNBfdMCOB0m-gJH4JFcODbU-IVSQxvhJUOWmWCOvenUIJvtoGRTJ8rX0HWVaUAf4i1YJ85tcWGuHD3_VRGLhF43r2mfl3UvYeGnFpjwEUvynH_EHuaVI2ngslb_CHthmsm9nYLZZ5e_FS7Zaq5dzTGGmmlIIlq3gvvaioXSKPqmAS3jQ2dQz2IE5T6sQ1od3qR7HdpIPmjiwf12cWezhi9Q3HSwMBXaldtWIesQGWiRH1HSqj8-kHferkQceKY9KgShogrpxVI8zv9NHfgcKwLzt4wV3xzHPfCu7AaZyOyrjybYlbkpPI9lUEIsXKiDBESRAkXskLED_GwEBe9tOO9Im10OgHJCmDOYG5HQtM6WAuPK7NS4lh0zbfit5IhNigbPw8AWEyQbdUVdhY9hg8mI7UDSN3eBOpkqEjcsfq8bhhf4R-EqghSmBgL_w70O-smh3Z16uVzGWDbs4-N0tmz8tT7LzfbcMK3RbPjGMLTeflTo-FQrB2cJSuz3tq8AOaS_k2OkV7Nll3cAeDJxhlPZuROIMxiyftdmVymUJWZTTUe-4yNAde6g9b800GAtHfqYCWvHw5aizmzjNbsFEGRJ-2qCp2kSeC4t4_OXp0AuNVWdsltQ_j8jiD3ZPgVYH1m2t9EshJkmw1sa5q5nhC3NwTWC0AcpMsVSZR0R772btqr24um5Fl9mH9cuGtrW6LV6xMR-SYTUI4SJozphEBL1OipERigA7TbtY3rjm6zXOxVEggYbJ0Ukdf18EyV0W3xPhRPiVk21qfnLWI9WOoltkZo3CeOiO_FMhlr9w3e7aw')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2425', `Language` = 'bg', `PostDate` = '2025-02-10', `LastUpdate` = '2025-02-28 15:16:56', `Type` = '99', `ParentID` = 0, `Data` = 'szIjIgRev-qIo61fXsD96m-HNFd6pGucaoNT4s9OAPmvKIBR-4l3LKAyhfGr4Vjna17QXWfaJZaw6goymlDvvu5_Vi89Rtk3OB58uIhdexy-5K3cfh-YQpeqT09UL-U5Q9lDL6QxVjGj4nLH8lyx9ysi5oE1k7Jw3QIo3mV8VA_Cz0rb9GV_OcY_9wnRoycE8dK26g0VugODlE6z5_6JTApF9WSLGiiPRWVaG3O3mUrX36nLV0jcLIDEXQdo1EUbKSbAbFD3l47A_5NoitO1uo82RJYeuFt9j72kARyyMMuMlrXw6gDN5aSeOSFWp15F4iqojQktTUd5icqPZcbvuVc8nZXR4FIkpq0KPY8pD23YUoj3BWNWnmwdlgq7go1Y5Oss1FV-A9y_65XYEQOGHixBX0e0BJ-Lyc7Rc0nhHYd_vn4NSOxoM1SNtwy1RNH2arjnG-qioWmqT1ffMZ7MOcW0Y_20Y-mOeIPrNoPZhmy25eVFaBIHclOoL_VFYLeecTRHXdtqqhldhr_cEnZXjleYJBc510PUpyGF-z491DXcNQ1BfziQXXFvAUPYDPV4I8rw1nCLh8wdw8cz6v2sHvUJ3CpaGP6T5eysI5VfxznOg-HGsL_htTk2fDt3_Gg5Y-P9cBhG24MU06ZsdXCdtgEIZhMZML48UmcYhfPBM45AFv9-L4iGcVsQk4M8kwwOePJ3qymgHSvcXGtOP0fSoZchxTJEopuhB-9_PKgPLI100bNr1nhsaZLvxN1kn0O0_IUS1T6EL3V7Aok7AogGmbEhGFDz22TE5ZXPWkvXzAUuiSIawkMx9N6fvwsuR5PwB6C5Mxz254jHVVtMMe5bQHlZ-ZDstDW1aPFopSgng1AyYZgPljRQ8Q7k08apUcAWCgjLp88thVolQmv5F__ECmOs_JuMblQUwG--sXYl1eknf28hWN-0rYGqUnoMlYhLFE1YZ2Wyp1TzfaxH373CWqAEkLJVD0Gx6-_OltOokYd-yfd8_2NJ1TtxWbyBwmveAZXOfAgPgxTtp3c2H8Lx2uB1FvV1CCbpYF-RqESaaPfiG5Yj4vwefsZmhIqqYp3UYeGGzUUk-dYyDFueHSc8Z6gknZfHWJfSeWsnn_5DHONSlEp6NkBv13gGJ-887kLfyS-6JaLdjgqpzs3cs4V1yh5TPyn8qlH4H9duUQBX53EOPOkzVJpwb8m6fMas-wqMhAvCDSgsDjAz4w-MYMHk6inPgoju2-X5SMW3_AxA5KjDD3C_nItp1uBlHnI0DhzPk8xjqVhqeTAf4A3kqRV1_t9vLCNrGRnvVknpAUEOOK7ZPxTn3P0L_p3McejvGCcf', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwrnCisKpwqPCp8OEwwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4wrDgMK6wqCqcKDwrHCwrnCisKpwqPCp8OEwwofCpMK0wrD' WHERE `ID` = '2425'
# [28-Feb-2025 15:16:56] /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
# [28-Feb-2025 15:16:58] /finance/root/bg/invoices/2425.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` = 2425
            LIMIT 1

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