# [30-Jul-2024 17:00:33] /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
# [30-Jul-2024 17:00:36] /finance/root/bg/invoices/2287.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` = 2287
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [30-Jul-2024 17:11:06] /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
# [30-Jul-2024 17:11:15] /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
# [30-Jul-2024 17:11:54] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [30-Jul-2024 17:11:55] /finance/root/bg/ajax/clients/form.html?_=1722348716981 167.99.142.201
# [30-Jul-2024 17:12:59] /finance/root/bg/ajax/clients/insert.html?_=1722348780687 167.99.142.201

set names utf8

SELECT MAX(`ID`) + 1 FROM `clients`

SELECT * FROM `clients` LIMIT 1

SHOW COLUMNS FROM `clients`

INSERT INTO `clients` SET `ID` = '68', `Language` = 'bg', `LastUpdate` = '2024-07-30 17:12:59', `Data` = 'hsHGRcaFpbI0pzz_ipdrwOojzQkBIcxI6NqT4_IxRis7SzvL0erstGewMXd7iYnGPT7ZHomLE9-2ukWcH7aDQmJFi9lVyJIOHmFVBCVMDkoIYIxGiAQbVdQJZHp8UedA5TnGeVefNK0WEt2tHn_rg0Pd0K5RCZznfqBVIUS6xcTvdJK8HvegLX_2teWRPt2g25Iht3PXdEC1x9oNsC4uM2ZXz7FIvwSLiYKLpOUPO8R1i4MJicfU5oY-CKDnwBYVrr0-wgGvPRWB1tf3RG5fBV6BK0a5IG5_Zdtaobpmqh-0Zo0DEPJt5UdDBfq43jB_THwJkg0PFAzJwDOLdqB8RaObZvfK7-jLLwKfaMoQ5Gk', `SearchKey` = 'wrvCoMK6w57CpsKewqXDwofCscK8w4DCtMK6wqCqMKDwqTDnsKrw5vDn8KdwwofCpMOAw4DCtMwofCpMOIwrDg8OgwqCocKDwqTCwofCpMOAwrDgcOQwqCocKDwrHCsMKrw5jCpMKdwwofCscK8w4DCtsOgwrPCtcKDwqTCn8Krw5nDj8KdwwqTCrMK5w6bCmsOmwrHDrcKiwpzDl8', `Top` = 0, `Visible` = 1, `PostDate` = '2024-07-30 17:12:59'
# [30-Jul-2024 17:12:59] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [30-Jul-2024 17:13: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
# [30-Jul-2024 17:13:04] /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
# [30-Jul-2024 17:13:05] /finance/root/bg/ajax/invoices/form.html?_=1722348786493 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
# [30-Jul-2024 17:13:07] /finance/root/bg/ajax/clients/select/type_0.html?keyword=tricom&_=1722348788641 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrvCoMK6w57CpsKewqXD%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rvCoMK6w57CpsKewqXD%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [30-Jul-2024 17:14:24] /finance/root/bg/ajax/invoices/insert.html?_=1722348865632 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 68 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` = '10420', `Language` = 'bg', `PostDate` = '2024-07-30', `LastUpdate` = '2024-07-30 17:14:24', `Type` = '0', `ParentID` = 0, `Data` = '_StQsG8K1n75Mg5b8wmqWq4sTLIA1z--xW6FCDP2baRfVy5mAJe7DPULK8w8OlBxdURx24SOaffRzw67RSPx-Wgg7mGXv2Fm2s_-h2Tgvj_xMgJL3Ca-ZIm8u9ytspHnPIYKYOpjDwHhBlzcCVW6hb8qZPfv1Upxuu9XihEtuM-N4SrbW1RwwJWZUUUc-6XyV-9_XjT6YQd3yVeKX8pXbP1XoeysioJqcP_g4Oh98YCy6w0DtvBEFeX0-QQft7IROJwXBpElrdCGWSrRiM1ybhwiUeExWfMDHVPBiDxefFkEQWJwoH2eTBnZhcL6AvQYCK4fXPDjFZwH7HKLcpuZK2H2mg__h6R1AiQCj6BA2Ts7cC-z0vnIHs9TOtAIT-gcfCo8R4v20-ZSpaLKDwhMoFjJsrrbkMsSmUhiy1kycRtmpQmZrncw4gdO6jOIrxzUDf4p3KufeomMzcBYQueDsCVmcDXjITZZcYF6q0Kj73XoBZAtxyPSGI08yxXsngQtEF0t42b3F8spuMU2qUvlJOJixKLnImlc-NF55bquNBBs0DeVEPZAPNOjbWISAFHF6Y70173fCn56Dig5Fvvry3ZRXPJZkMSSXJYbHSRUxg_UBF-kwq06j9fAraWFap9NvVv-ddN8nIca6dJ8c_pEeKO5mggdv8mv6FfERR0UVD1ZAEvedHoim4ypp9slcDOxn8c5BG5vG_3FP8qXhba-snufqMYSy9C4mZy0_Sfl7jD0IzBxp07QSiXeIdXIXM-JkXEZwya1Fpo1nOW8co5XT4559Sr1NpBqgGVoVmk5m-Ad3slmxw6X4sFuyMWdtVVqK0-Q0U97DsqT2zp6WRM-e_HwSORcV5kWKFuzgkRhKxs1LVM1Skl440WBqzHVMvxT9597JUKfv5ZJNYI-cTGHqDAJn_h4vyjeGWkafnt8skUUMd8ESsBLkHoUDZapPuF3MGmQhx9EBYetW7GAERwAjV0u0_WZSzjZf666YzR94aP3cNBF2ke-mcGVCw8YUNpHQus6Xn7HKKUB6fnue1y6ZSFI1hGQF8OJw23g_ytq7Hml9awdz0y4DHXfvQkuDwCnDG0h3jqTL7HwQpOqBKCq-C9wc_IkFyz8_vSnGn9JozPoynDKfI5IqgyAjUvoLQpXRaahcVs9nlnsXFhx5VotHA', `SearchKey` = 'wofCscK8w4DCtMK6wqCqMKDwqTDnsKrw5vDn8KdwwofCpMOAw4DCtMwofCpMOIwrDg8OgwqCocKDwqTCwrvCoMK6w57CpsKewqXDwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqC'
# [30-Jul-2024 17:14:24] /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
# [30-Jul-2024 17:14:26] /finance/root/bg/invoices/10420.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` = 10420
            LIMIT 1

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