# [05-Mar-2025 16:05: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
# [05-Mar-2025 16:06:15] /finance/root/bg/invoices.html?from=&to=&keyword=process 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCoMK6w6TCpsKew4LDrsK2w%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [05-Mar-2025 16:06:18] /finance/root/bg/ajax/invoices/form/clone/2283.html?pid=2283&_=1741183581130 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2283
            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
# [05-Mar-2025 16:08:40] /finance/root/bg/ajax/invoices/insert.html?_=1741183720449 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 33 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` = '2442', `Language` = 'bg', `PostDate` = '2025-03-05', `LastUpdate` = '2025-03-05 16:08:40', `Type` = '1', `ParentID` = 0, `Data` = 'Z5H5Adc6uYI23J6tKvyrbfljvNhhAMd9Yd2HUGdGaKrtZR0G6CyVVBMpUM2TUYEGvlsoc9I-Yy1Y7iiDW5ymvO6UQtu7esjI46UKZDqnzaB7TRQsVs8jbs0ny9iCCckjzeKVd8rGelH7JrOOfbNanuU7h_fuveTO6PwkT4LIr518uGHBBeEeNEYUvuCeaZ0bIM17ciPmSA-XYAw2vBtBi_MBArrnQs5vmNWcDu5BAT7Fb0T8hdsMpiViIO5rn-K4B1pNZzUAGSqQc37uomfhr7AU9m6ezvYjrM3-HT0Z_n3AMoGUPO_xlhSCTbrbFRkY3shvXew0qntEEe9YIJsQbz4FR3bzKHXNq0F8hFZuQrfvZMxqz0iKWCdFzbXYeglqoky0d4OM31EkuVd-o3vOlk72WjcZaCqrhZnCYBwpIHtEzqV2tUOyuvb9MWZbnVhFrd94OwoRUo8_Vv7yWQ7dbVbrO6Gzu_ncE2noBt0_TevWFnp66seJh25TT7rjaZr75DmmkP_h-w92EQm9ipIRNxwnqmVKltAkEO-Kc7I2MVSVoMENV_Gp8_zfAE72eMFRRVCcufGJh8zjFqLfcHqc0NG5E7eSqwUQtbWmVGe7EHXTKsl4rX2eLIykhlmz570EI-zYtLg3_94rL-HpfXvUYr4w_fkXJHr8qTaUdVt0OTkCyHzlQ4SHDEcGg6beEHEck7J_H5xqzLIZx5vWRICOgJe901ojjJ8iDJexprfTHAG-jNDN6-9xDpQTnko3n2Y-4RWP7y58snCmM7NgGJWDqABe66T3iPU4xtgmu6VNrEc_FJqe8Jana1myS8HycNUfJe9EURodsoQpINg6rwn6A53YhZ9s-heUhjJgciyL8UnsEMJPqqHYQ78_lPAeMqJvkRIThwerUCEBX9GMr-dnvyP1m_89TLcJUn40oFvLnq14VlB0gJmM5eh-_KWwKNRSPglnwucnLGvG_TISxCuxkfP9VdmPrC3p2MGSOB4GTv6dnLvL3q2BLNMOQgqMteQ1C1QB_HqLuah6mup7711N96x2TROl2bCg9iD0LkgC02Pinr2PruEhSn7tpzyvVHg0_SDIUo5Qm4qVrviD8hwWjQ', `SearchKey` = 'wofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLwwofCpMOPw4DCtMK6wqCocKDwrHDjsKrw5nDj8KhwwofCpMOPw4DCtMK6wqCocKDwrHCtMKsw4zDn8KhwrDChMKhwpbCvMOXw5TCjMKVwp3DjcKtwqPCusOowpfCwrrCoMK6w6TCpsKew4LDrsK2wovCusORwr7DgsKowwofCscK4w4DCtsOgwqCp8KDwqTDgMKrw5jCu'
# [05-Mar-2025 16:08:40] /finance/root/bg/invoices.html?from=&to=&keyword=process 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCoMK6w6TCpsKew4LDrsK2w%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [05-Mar-2025 16:08:45] /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
# [05-Mar-2025 16:08:50] /finance/root/bg/invoices/2442.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` = 2442
            LIMIT 1

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