# [06-Nov-2025 06:04:07] /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
# [06-Nov-2025 06:04:18] /finance/root/bg/invoices/2564.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` = 2564
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Nov-2025 07:47: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
# [06-Nov-2025 07:47:43] /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
# [06-Nov-2025 07:47:49] /finance/root/bg/invoices/10474.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` = 10474
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Nov-2025 08:11:40] /finance/root/bg/proforma.html?from=&to=&keyword=ngobg 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
             AND `Inv`.`SearchKey` LIKE '%wrnDhcOUw6TCpsOZw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [06-Nov-2025 08:11:42] /finance/root/bg/proforma.html?from=&to=&keyword= 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
# [06-Nov-2025 08:11: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
# [06-Nov-2025 08:12:01] /finance/root/bg/invoices.html?from=&to=&keyword=ngobg 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrnDhcOUw6TCpsOZw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [06-Nov-2025 08:12:03] /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
# [06-Nov-2025 08:12:09] /finance/root/bg/invoices.html?from=&to=&keyword=Фондация  167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [06-Nov-2025 08:12:17] /finance/root/bg/invoices/2358.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` = 2358
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Nov-2025 10:13: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
# [06-Nov-2025 10:13:47] /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
# [06-Nov-2025 10:13: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
# [06-Nov-2025 10:13:59] /finance/root/bg/invoices.html?from=&to=&keyword=spisanie8 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCi8Kyw57CsMKewrLDqcK0wqDgc%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [06-Nov-2025 10:14:41] /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
# [06-Nov-2025 10:15:38] /finance/root/bg/ajax/invoices/form/10455.html?_=1762416938425 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10455
            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
# [06-Nov-2025 10:19:03] /finance/root/bg/proforma.html?from=&to=&keyword=spisanie8 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
             AND `Inv`.`SearchKey` LIKE '%wrrCi8Kyw57CsMKewrLDqcK0wqDgc%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [06-Nov-2025 10:19:40] /finance/root/bg/ajax/invoices/form/10455.html?_=1762417180148 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10455
            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
# [06-Nov-2025 10:19:56] /finance/root/bg/ajax/invoices/form.html?_=1762417196056 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
# [06-Nov-2025 10:21:13] /finance/root/bg/proforma.html?from=&to=&keyword=spisanie8 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
             AND `Inv`.`SearchKey` LIKE '%wrrCi8Kyw57CsMKewrLDqcK0wqDgc%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [06-Nov-2025 10:21:25] /finance/root/bg/ajax/invoices/form/clone/10465.html?pid=10465&_=1762417285816 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10465
            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
# [06-Nov-2025 10:21:50] /finance/root/bg/ajax/invoices/insert.html?_=1762417310117 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 5 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` = '10477', `Language` = 'bg', `PostDate` = '2025-11-01', `LastUpdate` = '2025-11-06 10:21:50', `Type` = '0', `ParentID` = 0, `Data` = '2-GWZMBxmCCXENgmV39cYtmUsqDjwFD-GEX-WXhQlM64yCm6eAybDnkl74lYl4EUwbpp-5Pg8hfdVD2PrKjPeB6cW-LRTl14UxzgyDeXX1tRzB7ocy0VfBqqEi1hPJRB3jPU0TOudpBveZ9Kuyl94iZRcNR3tj7XOvz7io6ViRQ6fxB-DlWV9jQ3L8mrIiYaE5jxhWrfjKHIwasgYVojg6VTJWds0qcV9zNFCPWp2_ybeEjK_Q5389rFtb2Bgqcf7UiMWzS003xyD9vUlUNGslgCOZ89Mr5jviBPt2OWYFVcP-207EHtzymqbwm3V0bN1cDBctNed1wAF0I5Ai5Mw12v7XAvBX1CvXL5ooOtx6IyqU0GxUr3hcAt49corQvR-JfVUZXf0my5jJnhihZgp0LBbE-2sglzgiz4ZKR81JzlvJv5DcV09EdzCj3-ft6vU_RRYAou5xO1wD1og3WKgKXgcTGp0MeJE15dp-qozpTyeIkOPdB7JS60f_ILqHs_kxk0jNS78bwMoursxN77NEr6-DxiHAAl5Pcr14VQNbgJD-o7a-AVRmWgJSTM_qX5AH19ynY2U5O3Xvn94VFgB8mpXkmeFq3KNOl6seX4FpS3BT4Xr2SbhhIRoqbi1fdbTGskOnQxApxH9MmGHRGUj_ZiqOLS-ctPqb4BLHSyrEKRXBaUyWl0T4Nul0uMivUSdOp0oH98Xm9QyTybnl88_wf0aBoxDXwU7kYJO-8ft700CQfFJzcm4HDuXo-DyjJ5t69UjdHX-Zbg9AWrLycc6V7diBh33qEFKXj_KUhWcVVHI3JZ3kNCyKeB29C06gGHf7SRVabWvBtj0uxbIJLhL2iURQFg4jD-3Z7gFJdTusX67pJRp9DKDZySWfriXSE_YiLgXvUwVnMAEnTsde7Hxs1hFw61MwlfIbd4pWGGgsJb69zUId8G2IvrCtCDCpx4XlRz9KftWZdS0LTqJgkdd0l1_JM3xFKdgsRKZ0SMvjmwC55hZnE3ucqlKrhkl4_fbcQRhXXmfKjcc3BTmd9ELnpsbpfTzLEg6T6IOB-FJ8c', `SearchKey` = 'wofCpMOiwrDgsKlwrPCuMKDwqTCwofCpMKnwrDg8OgwqCwrrCi8Kyw57CsMKewrLDqcK0wqDgcwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwrrChMKhwrTCvMOWw6TCiMwofCpMOWwrDgMwofCpMOqwrDgcOQwrPCtsKDwqTDhMKsw43DwofC'
# [06-Nov-2025 10:21:50] /finance/root/bg/proforma.html?from=&to=&keyword=spisanie8 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
             AND `Inv`.`SearchKey` LIKE '%wrrCi8Kyw57CsMKewrLDqcK0wqDgc%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [06-Nov-2025 10:22:54] /finance/root/bg/invoices/10477.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` = 10477
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Nov-2025 10:58:29] /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
# [06-Nov-2025 10:58:47] /finance/root/bg/invoices.html?from=01.10.2024&to=30.11.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-10-01 00:00:00' AND '2024-11-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [06-Nov-2025 11:26: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
# [06-Nov-2025 11:26:44] /finance/root/bg/ajax/invoices/form/clone/2577.html?pid=2577&_=1762421205032 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2577
            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
# [06-Nov-2025 11:30:43] /finance/root/bg/invoices.html?from=01.10.2024&to=30.11.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-10-01 00:00:00' AND '2024-11-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [06-Nov-2025 11:30:47] /finance/root/bg/invoices/2358.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` = 2358
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Nov-2025 12:48:05] /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
# [06-Nov-2025 12:48:11] /finance/root/bg/ajax/invoices/form/clone/2577.html?pid=2577&_=1762426092427 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2577
            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
# [06-Nov-2025 12:48:44] /finance/root/bg/ajax/invoices/insert.html?_=1762426125390 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 11 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` = '2587', `Language` = 'bg', `PostDate` = '2025-11-06', `LastUpdate` = '2025-11-06 12:48:44', `Type` = '1', `ParentID` = 0, `Data` = 'F9lTTiq4pUniLR3XrPJzmcCqJCaSm9DRRufoKCWyPZT6zcs8x9g0zYrk4PmajXzM-PBwyBtpRUunYEi3fVaa9c_aG5p6oEKiYi30vxKkiLZszsQRxY67KnWDYGVlC-FD1JOqInDvspdPZld3U2KA_deBLx4hJn4IoI0VYM58VCtmYonXWmjf4r1NjdCsYZx48-HYmMJFd3eSqSKuxDRVtqtVP78t9ituln9FY9t8BbTXW09hlhTTdBNP5jpvrFyDP1deaXGzy2QWSRk8ChPmt2fzUI8cJcd0mfReSQaE_IXWAd4d0bQivXTfHLalRkYNncwp_IjMCxdEENDBdgeihvh2sCmK128jx2En1AxwZ0nqVAM-2OzbGgVsfls0rkfO4M_2jYLLLbwLQGEuvLZeRYB3Tn5QBcdL_UUAN842euzeJjNvNKQh-6-hudSAoFqqXiOmDsdfaKnBQXEtILnMEJV_JpzIaZVABjgK2wDdnGT1TptceQh-VeCpkpRGCks-DLC56aKiJbub1HVW_Sk__ah89lseaXbl3q9DEh5eYfTGDoXfYRp3QfgfvQfy_6Tpk4LJWt7ObjU813_d5JFwJsE7M3SfBSApqbS4foKhW_21IORB-QiP04yifXZpjxqTdq4jB42fTaT3c9SIK676Ro29dujuPh604Iz5htkbkKpuzt5b9pYT38iEWX30V5grmqSM8rPjp-bHFOVRTwVh0qDFdKtOsEQYq0Wf6Y511OD81t_XiOrc6a67hLOGZRVIZwxtA21icPoyb835JiDNN46mfZmoKLCj8etZvhPq8NKN9UtKQ4cGwe5FD-Do-neyk0eRFbhdcUcixYBqG12wq2fdzUDSw7cmvG_A70E9L3Sv2TM_KehkZGoVE4Ks2iVkqXlPsZ8JFxIdaAvjYOO9kceqQLgChD5xwbQsPXNMJ0EtTa4mkkCJVGGGDf7j-GAFJFKmtqnh2d1j9qw3y2rR4eQfXQRl1ffD4lYc0V5eN1PqrahB3NP8LPScWl01sptNY8LPlCahROmE8vBhxL9EX3jsdcsv3KToMFw3uGx5vu02gAsHz2o9lNeCfRBKGTcXIGfYH0ajRz-EKgDaFRKvpO9pS9AZ4Dl82Hqbx4SZ0nZwK8B0sMqncY8qsb8RxeKze_zVJBHOavMZSh8uIl77TP8EccGop-QHywvNOtbJq_fMKSIgiNe850WacUHCsvxvrBcuHq_TIXizv_MgHKhQpXEIqi0opYzoaAGFLMKfINo', `SearchKey` = 'wofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLwwofCpMOPw4DCtMK6wqCocKDwqTCvMKsw4zCucKdw6bChMKhw4zCvMOVw5TCiMwofCpMK0wrDg8OQwqDq8KDwqTDosKrw5rCucKhwrLChMKhwrzCvcOJwqnCiMKEwp3DgMwofCscOSwrDgcOQwqCrcKDwrHCuMKsw47Dn8KhwwofCpMOWwrDgMwofCpMOIwrDgMOgwrPC'
# [06-Nov-2025 12:48: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
# [06-Nov-2025 12:48:46] /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
# [06-Nov-2025 12:48: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
# [06-Nov-2025 12:49:01] /finance/root/bg/invoices/2587.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` = 2587
            LIMIT 1

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