# [23-May-2024 14:38:10] /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
# [23-May-2024 14:38:13] /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
# [23-May-2024 14:38:16] /finance/root/bg/ajax/invoices/form/clone/10403.html?pid=10403&_=1716464297084 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10403
            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
# [23-May-2024 14:39:20] /finance/root/bg/ajax/invoices/insert.html?_=1716464360735 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 64 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` = '2247', `Language` = 'bg', `PostDate` = '2024-05-21', `LastUpdate` = '2024-05-23 14:39:20', `Type` = '1', `ParentID` = 10403, `Data` = 'otRqMer51ENLrs5hRKb6SjPr62OgcpZO2DnPCdNFjkbmP1sAfoHuFnN0MSGtilLhAQsagQ-VnXqRvo5wUg-OJd69h0WSHslc8rJ5gtMf93Xcev4eXdBzAEMkdUL-wmcnvFp_LYAMoiboEiWyF6kvAtNKg2tTrdPQCDDA9dxLlPQI9MvGPrxjmLdQbm_qllnCD8tXnO-MdeWv2t8wkbXekyOlIebYtoRR1ID5rtC8Ro_e7Si1h2Uk-ka-hTWFSdgbQSuDQFNqd3u2FNLQjsNgVudThOLoI0-02-6rDnCZvxkq5SgD_uulXOnwnK8Q2OEIwXbMqYTzaqNZY0hPXBZFaJ2fR3G6SIG9IN8D--uMl7wMBNa6gvQqe3eIxmYSJq0TZyN7PKkTQIAeNyXhUxaI2X5TXY5yJOH3X54p6aSPE8iE-3qMy5Oe3kA7A-0Rxy_jwdsZfoV24WE69cENKaraiJNJhw099YURCeh7WzEcs9JZmeDSQCJ_nqFfG4H0GB_fN92j0OuaUi0c6rjWNkBRidvzZ2soizzJ6NfdqdeDc46HkZ_Ra8TwEyt-e1ESEx5va-AQ-BtflaPZHRUTVCqA08YF1emZaRDij20rgzxLzIaouE40J4M32gcqKjQOzfZCMMgONM_pyKUF0QOjV7OSM_25OFQej4goSRKwV4I1LHnGgrdu6oIe0yspQz_Rb2u6_GCUHwdTLh1b0qEB4QHRph1jjfcfbOL2n2ytrz7mUL_UdJCva_m2KXF14LJt6nNrDKcVFHWkeTll32moBZLIbRQW3cHUYVE3NLUwOWr7KmX6BCh3glZ47JYZT_fEjdaTSJdAs7cIKeaNKD2H0j0_bb4KVJ2cGHU_3WRmW-UGbQSjWBewfyrEDDzpg6Rp0ZYT1q7mk371ma05TTxXW4MOpL5Iv3p8rTZFoTjIqC_wls0nGZDmfRDM-izAAQ0RtvpWqSWRaMsbvok9rwBj_XVwg9FXOEkEA583cJAWDJhk4rFIJVqJ4AcqjeqiK7rUMU47fwoXP62YOmxUbQxEjHiiguC9GSmKA0P9JbRWu4STkeFGQu5eJ5QZ4CAjGKLOopASUZKkMkmTvGdut-8OlqgOrg', `SearchKey` = 'wofCscK8w4DCtMK6wqDq8KDwqTCn8Ksw4zCwofCscK4wrDgcOQwrPCtcKDwqTCuMKrw5rCucKdwwofCpMK0w4DCtMKlwrPCt8KDwqTCwofCpMK4wrDgMwofCpMKnwrDg8OgwqCwrvCoMKw5bCscOEwr7DwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhw'
# [23-May-2024 14:39:20] /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
# [23-May-2024 14:39:22] /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
# [23-May-2024 14:39:24] /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
# [23-May-2024 14:39:27] /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
# [23-May-2024 14:39:35] /finance/root/bg/invoices/2247.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` = 2247
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [23-May-2024 14:48:31] /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
