# [19-Nov-2025 08:22:00] /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
# [19-Nov-2025 08:22:11] /finance/root/bg/invoices.html?from=01.11.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-11-01 00:00:00' AND '2024-11-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [19-Nov-2025 08:22:32] /finance/root/bg/invoices.html?from=01.12.2024&to=31.12.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-12-01 00:00:00' AND '2024-12-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [19-Nov-2025 08:22:42] /finance/root/bg/invoices/2384.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` = 2384
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2025 08:28: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
# [19-Nov-2025 08:33:21] /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
# [19-Nov-2025 08:33:32] /finance/root/bg/invoices.html?from=01.12.2025&to=31.12.2025&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-12-01 00:00:00' AND '2025-12-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [19-Nov-2025 08:33:39] /finance/root/bg/invoices.html?from=01.12.2024&to=31.12.2024&keyword= 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2025 08:33:55] /finance/root/bg/ajax/invoices/form/clone/2384.html?pid=2384&_=1763534034711 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2384
            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
# [19-Nov-2025 08:34:24] /finance/root/bg/ajax/invoices/insert.html?_=1763534063034 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 70 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` = '10478', `Language` = 'bg', `PostDate` = '2025-11-19', `LastUpdate` = '2025-11-19 08:34:24', `Type` = '0', `ParentID` = 0, `Data` = '_vkDrcis6T467cChfV-BEjpZxT23sF3DIMocjhsZYV1D0HDm1-n9agzRsioNySwedoegB94YJajGem95gLx68Q7Ok4veDrJUCYETebRmQCAWVRbgKzEiAN_iVCGEM_-wXqOz8z6a2GJYHjj_0vRC_h51M-j4iVbbo__x-uWylKz1wY6JuxTEuu7CYaYwFm1BQbHMop6B0Xa2k4mw2YkZ4nhwF9OVw--Y9jojxswklVCIbCI1rpPxAkmiDQbSeijxvgMjQvyjE3JkAi183sbqxuTlcJ2W3YmnvzY-e2PekY-0EedJBxj4ISUTr-G0dux8ubg3N7fMn_M14gcs-RGwuIbFwMVaIvbKC97p61dV4q5ythgQgZdls64VeD_dISucTiEafBdrcqyh4npqFZ8npdYkvubJff3R6cQ0zMAkFdsxnrjCG8IVUDWzNNn0WhjrNmryMvxQzHfnO7uNsm5My0Sch0alJozE744RU7SyQPa1e4XcLcq8Am8V6VUqcLV9n98PP_oZHem3T7cHFLsL50Z_29GQd4I82AVn7mV_YxngOd41UkGWfDJyY4r_RaGLTKjeTbDWDPij8gBblutNQwFrfl3LbZovkPlNvuYBl6YnGaIcZlGOxASfn7kv8oTloBEopmDF1f24HrJn8-_VO9PsZVAMnLh8Qqayd6RsWwO7qkV5C_NIU-8P-i89bDpTiwIYH18eo2QiSqhRflf69hAFqOgvObmh4-_Fv9S7eMyeOa0WfFfbNFZXvW6fdy5_YxSyNklwuhMpDiZaaksSf_0b2oswUTwNN-rou-HaKxSR46kRuewI9hjuem-vDFf7KqAPDerwpejigQb7Z-aqOxOPcD6YFMFYed7__jUkhBLJVoujOZcQej16uplbNeUWai6NPf4BAx5-NbGJ1CIyhgm98Mc4av6PS58EZLhOg3Q1IZIMDXhHkOBZWJiq1nRzjjQmzjAzLNWpw76BqsCIPw', `SearchKey` = 'wofCscOIwrDgMK6wrPCt8KDwrHCwofCpMOAw4DCtMK6wrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwrjCn8K2wp7CsMwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscOAwr'
# [19-Nov-2025 08:34:24] /finance/root/bg/invoices.html?from=01.12.2024&to=31.12.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-12-01 00:00:00' AND '2024-12-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [19-Nov-2025 08:34:26] /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
# [19-Nov-2025 08:34:28] /finance/root/bg/invoices/10478.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` = 10478
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2025 09:12:51] /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
# [19-Nov-2025 09:12:53] /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
# [19-Nov-2025 09:12:56] /finance/root/bg/invoices/10478.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` = 10478
            LIMIT 1

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