# [04-Mar-2025 13:21: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
# [04-Mar-2025 13:21:13] /finance/root/bg/invoices/2413.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` = 2413
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 13:21:28] /finance/root/bg/ajax/invoices/form/clone/2413.html?pid=2413&_=1741087290082 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2413
            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
# [04-Mar-2025 13:21:42] /finance/root/bg/ajax/invoices/insert.html?_=1741087304701 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 37 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` = '10442', `Language` = 'bg', `PostDate` = '2025-03-04', `LastUpdate` = '2025-03-04 13:21:42', `Type` = '0', `ParentID` = 0, `Data` = 'mcn6Gq6n7AR-w_MHWorMR-IShVq0AFpEgDuty8gGWs6egTBQD31qUbqGlbId3WeCkE36oxAZdmWOijpFPOE0umX-OVGE2InQ0moYj1Sd3BOzB9iT2Wu0_XKE_llO56Qt3LSI7IltQMPYnxOyhl-DFA-Mi4UrP9Hpvo-OkaGMBRS8A41RXEVamMcC5BMLu8XqXf783GzY6z__Nr0Hfq93K-UZi2WaG0ufE06wWlOlkCU583gKCWMcoi-SbTFXr2AmBopErjRYF6I0IQyd16ZNRvefOk0fy-5tpySh3denMuvA9UnB3Oc8OzyIvAqGEa6KbdBJyK04Uxw2B1dAF5RMU_lkqRPApZBdtA9w5Y5qcRUyQ1SVjtkl4EutFsDDOaallNkhJV93qk-m24xy7Q3WIJMdpD4b1f7a7AxWUKWKWAJGm700MDddstVO-BMqHFO7Yn83m1qRs92FRcNTXkx9Ar2X7FOq6FCT55Chr5QBkl8rDGBPzVZggV5pIJ2hFeFCg8wqpT2T4JIWeT3e9pGEDLzjCG0IE5mya5loUnlihYfXMEkj4Tx9VwUpxuq6ER2eyaJNx8LG8Kq8Vp05Hw0lw5jlaijkKx8aZhzYFZjzvlS5POq2za9iSq0Vs3K9JxCyV7HVhv4t79iQOTTTrvKXtczAmwOB-IAev0DpUIOcAYNBOFYsZLMhhTyg6I1bRJxgBMIuIejANIlrflrfbFJNRW8bzOXl4W7_CQ33ZMpdwqCWBy3Ya7TQVeQPPM09AyQ8GYjaZgUJI9N3dIr5SQ3uogvVKhTtwl9hosBTF86KFruP3tY-GGy_W5miG8xpRoFDxGG_BDlfQgCvp2a6dA48KKlAOYb1QHh74By-7nbTzX8CyY_rCN9WFczmU8h779ZcHxpTRjpTBgvc8BGG8ZDxk5lab7ZMO4RPW7RIBTEY7nXHifbUJfY-wfgT0Uw8yZL_zDqcKOfaC7gr4ii3dTKY_PXFNA09p4ectlbsB5u_Y-osWgefr3s31UGMsUYmrD9bbpbKfUfWYChV80r6QBPX9Vg8Et7AKVCm3RPrkaZJ4BY', `SearchKey` = 'wofCpMOiw4DCt8wofCpMOPwrDgMK6wrPCtcKDwqTDnsKrw5nDj8KhwwofCpMOIwrDg8OgwqCocKDwqTCwrrCsMKyw5bCsMOawrLCpcKtwrDCwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwrrChMKhwrTCvMOWw6TCiMwofCpMOWwrDgMwofCp'
# [04-Mar-2025 13: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
# [04-Mar-2025 13:21: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
# [04-Mar-2025 13:21:46] /finance/root/bg/invoices/10442.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` = 10442
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Mar-2025 15:08: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
# [04-Mar-2025 15:09:24] /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
# [04-Mar-2025 16:18:01] /finance/root/bg/ajax/invoices/form/clone/2426.html?pid=2426&_=1741097881803 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2426
            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
# [04-Mar-2025 16:18:10] /finance/root/bg/ajax/invoices/insert.html?_=1741097890554 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` = '2441', `Language` = 'bg', `PostDate` = '2025-03-04', `LastUpdate` = '2025-03-04 16:18:10', `Type` = '1', `ParentID` = 0, `Data` = 'JfSsK_8uV8m0ek2Bmb35UkjrrPsPpyzRuqjyI9J-XBVqfq40m_dtWyj7NnUsYf1GtcYIzjgXqY9nZ6W-LBMZ2PJm-YbcN5DONCqRiVLmbECZKmjGtJlp5pGwZtx6SADKbnMntThUWsikUHf9KJs8iyvBM2VWLkG_tQe3LClJBobSNcT_xZGpHbq_lEGoTEwIxrqPkKndPW_ILPW-3O9LZOz2MaZyvBtnKLXAbpk2_majZdt-2XT8lBG2b8kKdTtJX9rx5xic9eZtKj7qEz_LyL_f_lGwVznPJnDAk5-A8fxxB_55MWXMhLVq7F9RJwfFA4BGAJr1IPGuUgPwW0g3js-HkPFvPLUAthuyoeLxejB7725jN9NuFFnxjPXeY3fejALORosPG1YAqykZPV_omYG7HjTjE8KcpJQJsyNsJaw-W9k4aFpKsQAgHl-tiasLjaxij5D6O_m4zku7K5r97PK21dcgTdNobvaarFx3qCuKPqeN341GhGXu0HQIgbmejg7CTan2MhmEDjvblu-vx1UJ4l0yg6YhKR-aAQmTuvVIrcdjNy2RPr6Ah33Yb82UPgHInAg7fo23tAd_FNPBvnqvcJUR4ZJlJVlfP7T5Qi-eMmohd-WmuLBwFdrhexFlAkKHevf5i2p6zyLfRlwrIvBLbSPqYxewN1ZLIDyCKBt40X87UsN9MVTNzD6TfSLyCnAaQP9jmS-utz-ByQe76QvCo9-JyCxcrfmw6YnxmPWphKqPXODU_Lp8AyM2HfiEe5MeZrLVUh3PujLfZOAp1he3rtWz-dywz0IzU5jTsJv3_fb1yepzO4_TyYVk-LVILLRJy3Hqu4i6hq_OzAfMhSetu0LQEC6TAgsRr4XGALl73LDCpzxp4VTtsWtkQkYlUxnlwOC-xj_LrBNaZ-8dQGue9JBs3YNrh85VJMEz25dTtF2AoGObr1Z421xWIEFO4HaCxXdZOAVicwvhUZ-Bx81UC2_rtB3qwu6ycPIa-kSbvMn4K7Xm8zfiHLHiXDD3DZp0C7l_-kPTIMxHbCvA8_yRGvGeYovIWQA06NOL0o8pXmHCi1OPffwPOlMP3WuW', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwrnCisKpwqPCp8OEwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6w'
# [04-Mar-2025 16:18:10] /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
# [04-Mar-2025 16:18:14] /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
# [04-Mar-2025 16:18:15] /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
# [04-Mar-2025 16:18:20] /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
