# [06-Mar-2024 14:12: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-Mar-2024 14:13:04] /finance/root/bg/invoices.html?from=01.02.2024&to=29.02.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-02-01 00:00:00' AND '2024-02-29 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [06-Mar-2024 14:15:14] /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-Mar-2024 14:30: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
# [06-Mar-2024 14:30:06] /finance/root/bg/invoices/2203.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` = 2203
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 16:36:43] /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-Mar-2024 16:36:45] /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-Mar-2024 16:36:54] /finance/root/bg/ajax/invoices/form/clone/10396.html?pid=10396&_=1709735814242 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10396
            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-Mar-2024 16:37:01] /finance/root/bg/ajax/invoices/insert.html?_=1709735821372 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 58 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` = '2207', `Language` = 'bg', `PostDate` = '2024-03-06 16:37:01', `LastUpdate` = '2024-03-06 16:37:01', `Type` = '1', `ParentID` = 10396, `Data` = 'Tm6-yDiK-JlK-eRN5nVfVkoghQMsqE17bhJE_fAOcCzMlmHFeGBdk8N_SXRA5Q3SrOhQ7yolhgSckdpLvgmTrLx2o4M--vGVVOLRuvG1edzv4zZ4xTxv--j9BlWIW_zFpiCiyit71knv1WZSI6ftsjjOcPN39nGVb6lIPwFgf_Xu1aY5ENnk-UULvi6N3Hm17C1hGOMEvls3Yp58Fkjn-AZ_xs99LLJ5Qc3LirojRjVfx-RroRGUeB0IiAJffWB3_mf58DI7qIasTc0xuFYjdRyxPx50HKVcOkW64mqvoSKP2jlv9hPVSFAvF-ioI5DYhdhpzHwMyBjqBux9bfHO402PhQ-e37VnddrnoQzQa0T0msIb-N1EuXasNNu_znWem8BMNubo76jc-zhu1YKbVK8jcmfSrwfp7tgE22IorHxFTfty1vevhFP81AKTQVw865rPShRsDXxFJDypwnGoTx2JFVDtLxhMXFzbKQcmgRuZlx_ClfV-6tO5HmEyRjrFeO2e2JS2knLcL54zOa7WxIVa-ZytrN9WHgi_7PBphIEBFeKCRaqeGwiqAW-l91ExYGGDMdTGl8rkWa2lwtUgB2SwMYQpAthWW6XnS5gCbI9ajcxhCAnx7mIZwVnl8GS_MRDjwP4vv-XJCKfvSZml5iT0iI6P9JQvLh1P5aSnLoRPDnRBJr4Vmf3OXeYESD_bquL1kEhLmmDbGwa3tt6phsX7oQ6sG3XWctJRMXS3Yltz-UC-y4WiBVezi7xS2-CzH31PpWbgx7JXs8gxYNpAQyA57tys3BaceltYyOzXUYBmWIWSp_4d54-v-yzDOOPir2myVCG-VnCCvu5sz3vxMcfl6Aw0U95n1N7NRL9Z9iNGib2NxH2t-GY-WEcMvGVNzrrrzLKjiJoGsWM5lArxOVWfnUec3uOXsI932RLKuV27XeNC_R4W-9JhT02VPhQbx1DH76yDE9cKuZXJToTCJlHOUM9lxdJUT1F0C38Ykie7e-Jp4D_WioJz_Vb7OUEu2n42xAU4MCje2MUGp8aGGtVoks9zTkOQIw5xmO8-f5o', `SearchKey` = 'wofCscK4wrDgsK6wqCq8KDwqTCuMKsw47Dn8KhwwofCpMOqwrDgMK6wrPCtcKDwqTDlsKsw4DwofCpMOIwrDg8OgwqCocKDwqTCwrrCisOcw6HCscOZw4LDwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOU'
# [06-Mar-2024 16:37:01] /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-Mar-2024 16:37: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-Mar-2024 16:37:15] /finance/root/bg/invoices/2207.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` = 2207
            LIMIT 1

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