# [09-May-2025 11:50:28] /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
# [09-May-2025 11:50:35] /finance/root/bg/ajax/invoices/form/2464.html?_=1746780635680 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2464
            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
# [09-May-2025 11:50:39] /finance/root/bg/ajax/invoices/update/2464.html?_=1746780639868 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 74 AND
                `Visible` = 1
            LIMIT 1

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1 AND
                `Visible` = 1
            LIMIT 1

SELECT * FROM `invoices` WHERE 1  AND ID = '2464' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2464bg', 'ConRsmW5tlwBD_0kqwiYzsCykwNIOSpd6drISdP7GogflL0bnPeZfBmNeZF-6VbmH_QvP5L9jJBsMDkNDGMsHyi8papVN58n1XRNwbuKeKr0opKClXDNdYkAoLxEuMpNsCOTVRUU-HqDpgEs54b598KgsJQ2FgD4-2bOwJIVUzpsp7jt65-hYQjnnD5gRoPGLrOZbtmRg89OjLoZbPZbdo0P2MQbcuA43zY6FCDnpmfDemDLGFBsy5fhItV7GftHhSWASSoMmG0HvH5jjD445bNVpdpoYrVSj8kso1s7yohM25GsywIP9-H9Pt_fFD9RdkfHj2plzu2KAgjiRqn2kvj2Vp_0ez2rBZjn-8ROSsJyLdWzmR8JB_Z1EZtnlPQ1XyMCH75aHGT6Fm9Jn8heAU6wx6X3yZhrh12kkZliBTKXDmbc34BkHGpVsIjhhOM_2pLUNq7WpghQbOaC2cgcoThiMWCBN7teECyD2jOfoserAh1dMzgilUld2SpmSqMIxRFm_BsJi1cegxT7CwDuHzXRY6ybQeoaCiP9-R2-Dawr-e4CLW8mGmT8kzaUluDFqiPwOZF796P8zXqkakhuK51vGpLdELAFCzc3QfBs-lezR0vLygBnKicIpYyFDanbf_mslQ3zh-66ekljlff2Ho4nA6qDtFqfhknDtyGfEXubPMTQNIig3g6S1HwZnMy1ChJQMEbP_2Mw6VGexotR1U3I4MAg9iXva-ciPwyzrYEBgJyslhDoZlNDaMezxsl21X9xwaqtRfUUba2NTOJ8nElNecvIb_bTxQYxoidPOGMoghR47i5iy2hmDZ4TlbwHvBRIktS_rLHe5dpWNol9irogUXN48HZ7SpO0Isvw6f8XOKjBxe8K8P2uHwdjxBvKJCtSwv4OfcjsOLQKXhYvTr4idRzfCyowbC82aTyd4EUzRwZwnstuAQo00e5kUWDmvkUmbw49x7aK1Ct1mWJ7xAoU5RwonyOSEmD0YnOR9_gXSVr-PvZ9uDhMUFwSeoQWMZ7FTlLGKP5IYE2Xq4mNfxJem8zPXHDJVifDZxbdOH2qsRkC-budA8WnxU06TS7eCXddSqCTExRsJc01UFT-9SN4P9CHJ1axkI9F563sQwvLNkxZCcuxE3CriVj9g4MW6ruMZ7HZP-tV4PoBm9-1hVfFYUylBG_nf_M8M9-8jwqLAHo2xdDXenfrtR1greOXZFkFUSk3Ik7ez6mhTUNCLQq9FxI3ojmNgxUTTJyoRWxUoXwAqHViwnfLInadTH89Or9SQ7f3ZZ9rAJ4VrRpDs0kT1NzSosaV8yU80kaseoVoQoTgsFeEzolLOaD0WHsUDu4_KzsLpyNChxrPNBeDbWWjYum_sNJ9c930wzWmL1GwJJT_H003alV8cyg8TnS3RLa-shp_Jj8dTRIOaX1glIeiX6U8JD5A8uU1Hkn4KL8laFb10TYmfWS8ksJ8Hgp4UJIx6QseaLb_Oq8SDOExWx9JDTNOrVT5Y2Xy75O1jQr1iwHOw_M2YxTmXBt55S3fLENE37GS2ZYRSoIl1QIWRVQRooAiqcVlxfPS4q4nR8JS03K1ddcnaWU0h8ipQ7THQw_6-V4VxHuC1cJOXhVwzTbP4ZSq3xJsbUkYcvnhxJX0VmW7gg91sYa2DrkAXDHRjgtP9p-rEo-IflBEiLfBWmFcabdRX5pPVj480LRJiUQS9WDZ-rJFaV4M4rkPVo7-TtfiNNVkIM-cs8IUfKGLF_s35eogckLAhHDxg9VsyRYjjTGPHrga0Tx9NlE4UUqYsE2amtm2fPfd2GBbDIEiAA')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2464', `Language` = 'bg', `PostDate` = '2025-04-08', `LastUpdate` = '2025-05-09 11:50:39', `Type` = '99', `ParentID` = 0, `Data` = 'aXET55AwAcczN78zobr8nwM7KVSeADhDQS82YCNl7K9xiNQhdgRLw_TeElrDw-T3EdVzcfLglHy110AfflFZu0sBx7Q35wvl1RlPmbvQDstSLl3613UKvkgnJ1amyqrQRQncmc4K503bnhDX_UsZsTz88QwiqRypJAfw-BBUoA6ApDPvhstOT2UWslwX1NUb3eKoKukEkgV7yMofaSvr_UWNMgx9vpNU5vWsAi73fmJyugLRfaBe98y1JFNc79nvpekh6y_KZR1M_IppVneSEHUts7SiKXhR5Ct1qa6CVZZZZKggDSEq8pOSlKxK36rz1Fu1g2bSMwnpTK0bexYZW9zqgCfiv6qzRJOyZU4JrXcF4fOLqogQiaZXHPqS-eZAmIiMVsjOxRi5jEbfwt4j7PDdAy4ghuvBS1V0xEdX4IiTHUqoxl2EQEL7UpBPTFbYKI9D60tcOpU56E4JOsbg8Q3V9sI15CKd9HY7gkIR1bJkBzle9ezXnTYnMkv_2vd-kas2_elmM_HuN9l8ny1R82uQGT-dxxHiMt8tLWNDYF7j2uW-etEd-F8rJsul3swJvIa5hR9kVS1xr_LAf3smtMngcPZRYDKybADUApGfvxfwBaQ0N3mlBqvRQdgRbNTUX1FJcNenaYfwduB4ZAadrcXgW8j_Y9YoLre-sQpVK8q8vD3VF3D-L6YqDedizEbCZeETEgOFGj0uts9Myhg5btTzJC4820Z9AgyV_QxyjOC69Q7LoxeEiZW8BlH2MHJ8NY1FaU6ZRBFak2bnZCaDG218Yc95Uk0obwewZMy1IfRjlBYpYQtBk8Elyu-tgLGc9U24-Wb9Rif4Ykm_24xZrz_CRJBeB7Wc3qMGOI9tSsUbPGMisv9RI6We-gcfaT3DN8ZMT83vbDKmyYG5tUZ3H9FD7hy28U2FfFBRh3Cx39A', `SearchKey` = 'wofCscK0wrDgcOQwqCrMKDwqTDhMKrw5nCwofCpMKnwrDg8OgwqCwrrCi8OCw5rCsMOZw5jDqMKswrDCwofCpMOEwrDgsK6wqDrsKDwqTDlsKsw4zDn8Kdw6bChMKhw4jCvMOVw5TCiMwofCpMOqwrDgMK6wrPCtcKDwqTDnsKrw5nDj8KhwrLChMKhwrzCvMOXw5TCiMwrrCi8OCw5rCsMOZw5jDqMKswrDC' WHERE `ID` = '2464'
# [09-May-2025 11:50:40] /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
# [09-May-2025 11:50:42] /finance/root/bg/invoices/2464.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` = 2464
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [09-May-2025 14:34: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
