# [08-Apr-2024 17:21:12] /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
# [08-Apr-2024 17:21:45] /finance/root/bg/invoices.html?from=01.09.2023&to=30.11.2023&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2023-09-01 00:00:00' AND '2023-11-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [08-Apr-2024 17:22:18] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [08-Apr-2024 17:23:03] /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
# [08-Apr-2024 17:23:06] /finance/root/bg/ajax/invoices/form.html?_=1712586186231 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
# [08-Apr-2024 17:23:08] /finance/root/bg/ajax/clients/select/type_0.html?keyword=smarts&_=1712586188813 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCisKhw5bCsMOawr7D%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCisKhw5bCsMOawr7D%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [08-Apr-2024 17:24:57] /finance/root/bg/ajax/invoices/insert.html?_=1712586297674 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` = '2225', `Language` = 'bg', `PostDate` = '2024-04-08 17:24:57', `LastUpdate` = '2024-04-08 17:24:57', `Type` = '1', `ParentID` = 0, `Data` = 'j7wiKO8z4V8__4diXc3OG8VTAEwedcDmDO8OZ1_mH_NNnNAc8fXHQouup4GpOIC5Bk-Q3zNaS9bjf-pfrIrZ5qobH36yn9S0BNHOrUzYEvdhj3RxVg0fZZ7pvIkH4ocerOM5kvenzPDucCbwzwJ_9rn_FYLzfhtQh4Ud9ghJZn_u51qWFM-ZOZnXg1_V6HQ1TurLn_Ht0ifYaRHG89SkoyyXe_xWiOzyCxPQiYva1SyCQnl_rFh6AGT4c1HWyf6tJf2nx57BNw_M0ijnKZOBZWl7Mp8NgUFCntNKzT-mYmRs3Ze2qCAuGlpa3AS-Gpu8aI764VWr_1eK9znoFv-2oGjIvHRwRjRRhOsDCBwnZr1aECcykhlCBQnehLNJn4m6qn1EKpU9Ua9ejxfFrLUPtFPEyusrJz3s0AZMeasbueoSLoNjnyJNrDoOM7grVqb5fC4rfRfU_7CQxhfdzKrArxPKIIjstastd6HpDXXFLfh1dPk0FPIMUG8jsefMCrnREuuL4OwWbkT6dv3VaN1nk6u9kb5NzGK5N_h6j23yeaDG_OeuwGmNnMooGtoRcar0NGmbUGM4eASAhnPUz5BHnEebgEc1mhVQj_9JvrRe25rbPw_hc2u7vNIp6OhAQ5wBMYUZBokb-8_UvDnAAJswGfhGsiOD1VyVZt6RVUvCC1Sk-hCcVDnjXTUNXryNVFzYT4YDuRp6iP-5HoanOBYOBju2qyVkPHe4uwcXwGaz3A64wIQReQHiIQx87k9FmPGRYB_AQk2-iZ-GdcUXKoReekRbjVJsGc036aLkoo5A6aHhKsi9qc1PJAKAEvdu0PL8RHvGlT5QYcIT3Pj5pG3ueUeVfRhVHZTmN4xEKjdcKj9Qy6POipomN3wvjKsEXAr_BuK_h5Ox8HXSzhtyxXXYiKOHHdQV4QkO1hpe6Hi92ziC3XfeQPmLlvPd8Kf4TU3mhJNShsU6dQw7WItBoq61EpuFIhrrM0FllbGIBtYQMkvBGu2I2wW2rbnTL7mdzfNP1gUthBaqCGkrIJndWOm0Wg', `SearchKey` = 'wofCscK4wrDg8K6wqDq8KDwrHCsMKsw4zDn8KhwwofCpMKnwrDg8OgwqCwrrCisKhw5bCsMOawr7DwofCscK0wrDgcOQwqDrsKDwqTDlsKsw4zDj8KhwrLChMKuwpbCvMOUwr7CjMKawp3DgMOLwqTCscwofCpMOiwrDg8OgwqCrcKDwrHDgMKrw5rCucKdw6nChMKuwqLCvcOIwr7CiMOKwp3DjcODwqPCvMOCwpvCwofCpMKjwrDgMwofCpMO'
# [08-Apr-2024 17:24:58] /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
# [08-Apr-2024 17:25:03] /finance/root/bg/invoices/2225.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` = 2225
            LIMIT 1

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