# [04-Dec-2023 09:00:47] /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-Dec-2023 09:01:23] /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-Dec-2023 09:01:26] /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-Dec-2023 09:14:51] /finance/root/bg/invoices/2134.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` = 2134
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Dec-2023 09:43:55] /finance/root/bg/invoices.html?from=&to=&keyword=the 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvCn8OYw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [04-Dec-2023 09:43:59] /finance/root/bg/invoices.html?from=&to=&keyword=smar 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCisKhw5bCsM%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [04-Dec-2023 09:44:06] /finance/root/bg/ajax/invoices/form/clone/2114.html?pid=2114&_=1701675846171 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2114
            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-Dec-2023 09:44:13] /finance/root/bg/ajax/invoices/form/clone/2114.html?pid=2114&_=1701675853586 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2114
            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-Dec-2023 09:45:34] /finance/root/bg/ajax/invoices/insert.html?_=1701675934213 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 50 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` = '2145', `Language` = 'bg', `PostDate` = '2023-12-04 09:45:34', `LastUpdate` = '2023-12-04 09:45:34', `Type` = '1', `ParentID` = 0, `Data` = '6nVnmnZhn_P6l5q6zTw4jY65h7Cdgz9pa1Y6YuIaatY0wFmaiZbcLGHIJzNBeDz70LbR6mWZlQI4KinC4s8qpZfsTsrE66c3OP8qwenZmUu-4GJFGU-Pb5HLyJ9eSZgruUB9GVT_5Kji1pAU9IIPL8xPo2vWq2cfqrEdsDG4cziqQQz9AAMlEsB2V81JImuUXFkgdyNlUGk9U2oCEB8xaRKHm3UqLjZn8XTCigbdSq_l1u6OqMiMncJd0Qx_aAVPB-stCQknq1jTUNwbr7OgvOo3sCRY7_GRkaJ1mKQrLvFX-xWLsoxYEzCShCFt5aps-IF8hQucwPJyEN5mX_5OuA1fWuOyPkPnHGusssVOxr314j8V5n9cuFPVuqhMwGBX7_CAOP99WkimID1-EV9FA8YWKnm-aRuVCpyMpvJqYNrHTNpDJGuEh8bjyds1mQjl5a8ZlOAMrJ2gcOplLrYYYzthuICi2F9VibsTxHhet6uk9EgW6tb6HoRMzzdUOXYbEw-Iwl52j7HxbV-otDi9LgL2z9AH4Z8lBTtx8U46aMPD8d7-oMeIKk2gsfWoSMArvx8ZgHz6uf4JybOLPbn_kWCqqeprH3oNCznS8q5ecvdlCz0hSju1KVpqtd8S3ZBUDo6n7pXazIHdZ5Rf2sCKowTRhQn_cMBshNGolXAv8-Fa3_GuWDvxa0lF3yNj-6GoB7GxoEmJkYiY_e1hX5UO6QSXCIcl7qWFudtlP79qSMM3gEYw-tHlYMAlM59vK9bX1ViHhZnc1i5B0W1WAnp0kXORQop82yx0D2cgxF9sBVJXRcPq76KtZ68yjDoOwnvTmYGvx2Qq2-RuLOj-sNQlvZMRp5kAvaffDAQjkfXXIlq7omeAY_QGbM_piSYJqMANNPcAy8AD9TQRBlIflupTGj5m-0YNiSi0oRjRuk8AkBcM9XpHBZvJNZKP_-G_gGCssrDv6h2qEczCI0_PxFIeWaEnKMYcZkjhByV0vRhTZlg', `SearchKey` = 'wofCscK4wrDg8K6wqDq8KDwrHCsMKsw4zDn8KhwwofCpMKnwrDg8OgwqCwrrCisKhw5bCsMOawr7DwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4wr'
# [04-Dec-2023 09:45:34] /finance/root/bg/invoices.html?from=&to=&keyword=smar 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCisKhw5bCsM%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [04-Dec-2023 09:45:37] /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
# [04-Dec-2023 09:45:43] /finance/root/bg/invoices/2145.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` = 2145
            LIMIT 1

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