# [10-Aug-2023 16:16:10] /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
# [10-Aug-2023 16:16:16] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [10-Aug-2023 16:17:37] /finance/root/bg/clients.html?from=&to=&keyword=ХЕВИ 167.99.142.201

set names utf8

SELECT * FROM `clients` WHERE `SearchKey` LIKE '%wofCscOIwrDgcOQwqDrcKDwqTD%' ORDER BY `PostDate` ASC
# [10-Aug-2023 16:17:55] /finance/root/bg/ajax/clients/form.html?_=1691673474855 167.99.142.201
# [10-Aug-2023 16:19:38] /finance/root/bg/ajax/clients/insert.html?_=1691673577633 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` = '44', `Language` = 'bg', `LastUpdate` = '2023-08-10 16:19:38', `Data` = 'i3TrOxt4CGT9UaWSVaFIPBWeEg_iJWtmZX2vXKmyHF7dMtdvtHI_99cd4OUruZPjSTxy2avNeia9KY2kR9zINwn8MJg8hPnlQvzigsG_ZowpXsgwi7OhycxtGaMpclfRqUxlEQghMLY7WqAmF0OhuoqtarlLRX1xh0QyQnMlTmqo4jMU06sDjLkunQNkGKP1_VkfLw3SHKYjBeqcdxuVCVpbaCscvulGKDpB7Z3S729fbt0ayhvUW4gMXXLIcWJHmNDAlG2jQFZn3Ss-QeMWh8MOs3HEdVT535L3Ezl7_2zr82Ij9Qz2W53rBjHvV1-Pdt4JET9gLgO6BXiNJt4X-Qmx3BxfaffMbnmCVHeAX7Q', `SearchKey` = 'wrjCn8OGwqDCrsODwrrDp8K3wqCwofCscOIwrDgcOQwqDrcKDwqTDwofCpMOiwrDgsKlwrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwofCscOIw4DCtMK6wqCqMKDwrHCtMKsw4zDn8KdwqPChMKhwoXCvMOUwwofCpMK4wrDg8OgwqDrMKDwqTCo8Krw5rDn8KdwpzChMKhwp7CvMOUwwqTCrMK1wqHCm8OAwr3CpcKhwpzCtc', `Top` = 0, `Visible` = 1, `PostDate` = '2023-08-10 16:19:38'
# [10-Aug-2023 16:19:38] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [10-Aug-2023 16:19:40] /finance/root/bg/ajax/clients/form.html?_=1691673580046 167.99.142.201
# [10-Aug-2023 16:21:21] /finance/root/bg/ajax/clients/insert.html?_=1691673680145 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` = '45', `Language` = 'bg', `LastUpdate` = '2023-08-10 16:21:21', `Data` = 'leQBbCI5pgmLH6MDC41iQkdwsn0SrRwwpTl6o2pc23dU4t7gQKDFZ8ejjrYNlgfpNnsOHi8dzcmlWSxBJBj58dpYgwhXP_Y8Azrvsnwlyno8kw9gLtuMxQ3w4aR01ofmm40wblcU4_P2OQw_mZCuZtTtH_rd-V4YP0qipnTyAk_PPOUzgVGen3z3nUnX7ENHiFpDlyP7u43jsQetaSNzaqOsgPwplC37EH9i0tfqyJdSVSPlIFK7sVLYw_aQaG7uTWYmtPc4qURqOUwgiG9vKV77Id4D6kh7L6xO67u6YB2weoKMEjAhDeKyS9d5YRjrSkl1mw55lZWFKuFdLrdo5MsxyAHdVMuJMtXlRCbrjzJbSx17uR5Hl_pVwc6xjit5', `SearchKey` = 'wrDDhcKpw5fCr8Kew6DDqsK3w4XDwofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLwwofCpMK4w4DCtMK6wqDq8KDwrHCuMKsw4DwofCpMK4wrDg8OgwqDrMKDwqTCo8Krw5rDn8KdwpzChMKhwp7CvMOWwwofCscOIw4DCtMK6wqCqMKDwrHCtMKsw4zDn8KdwqPChMKhwoXCvMOUwwofCpMK4wrDg8OgwqDrMKDwqTCo8Krw5rDn8KdwpzChMKhwp7CvMOUwwqTCrMK1wqHCm8OWwrnDq8Kgw4LCvc', `Top` = 0, `Visible` = 1, `PostDate` = '2023-08-10 16:21:21'
# [10-Aug-2023 16:21:21] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [10-Aug-2023 16:21:29] /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
# [10-Aug-2023 16:21:34] /finance/root/bg/ajax/invoices/form.html?_=1691673693135 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
# [10-Aug-2023 16:21:39] /finance/root/bg/ajax/clients/select/type_0.html?keyword=bobo&_=1691673698331 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrDDhcKpw5fCr8%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rDDhcKpw5fCr8%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [10-Aug-2023 16:21:51] /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
# [10-Aug-2023 16:22:03] /finance/root/bg/invoices/2065.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2065
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Aug-2023 16:34:16] /finance/root/bg/ajax/invoices/insert.html?_=1691674455531 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 45 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` = '2070', `Language` = 'bg', `PostDate` = '2023-08-10 16:34:16', `LastUpdate` = '2023-08-10 16:34:16', `Type` = '1', `ParentID` = 0, `Data` = 'EvBewLE6rowG3HMOP1q285H0w81XUA1AahoWRvPviazcbACKo83tF_C50ocigLDHBu--MSsJ0UA_rU3Xq9Rf7lfpNf-wGJOuJW1Pih1DOw2-iu1P_-t85hawUD5cBs0pQbGDu5DbPUIw9PNhZ-H9q534BAGuDln9gF1RRpcfR1FN_09BtVLwwN9ZpyLP5plm3Ff-b6UZc6RuulEK2DbiBAOrg781UxxtAjfg5Wg4Gh1bnK3SVMMY38Fnv-9KJ9zVn0A03kXqxeZp9NggWHfsAVHUiwCZIZzcF1sHZ9hB-APgM13K6j6WiXReUbiPXxHXKW2zunX6BQl0epbj_-rkCVWIyKiEe5VDOTopD8SrWbOAd23N6GmFLCo_XOgcBcwcRxaouAaxA9CyDyjyqxX-whMSnvXZoR39ttf5u1JssnhPMryft7vwN2RAujPJ2t6q1wKxphA70IJ3tjUvWPEPLQylfeCH6oa3Yagf1XkFIrCNJs513zt_BHXjClvSAf30kraDGF7oimec0-Fi4dkLJsHZHUAnciXLtcf1wUVVFvBjqmRyQID1DYOpN3XBd4gv3ZCZECK19NOJizLq_rCnXe5fa9Koi3t9Sv149zIdNy_dF3Qd9tK1931O__tZkNKyNoiwzT7n2BeHQREVhkvHw9aTpb-aY5BdjeBC9FUgMbdqcT7ckdCJs4I7heZscZh4qxYS9us1MuY6UY_37OhtTpwfYnKTXFoUxB75AK8WHygtaoV-bNl0Qt9_vYt_MlRoljsoIqb69wslqgqbFkqv8rAOow37M1o3KEXlhE0iRBQDjhdEs8TtOaarNNl8zh3PnPF1ftjly7vTOKXhPhyP-ez2Y07fXqGWavmORFln5ciCDCTaftP_vYWQsj7TbNNta9Lxv6Hm6E0GNaX7UYd49QHxFG6rztRv-ilbbZRZeX0eYRpX7JDywBsPsMSOH4GZ0TjnuVZiY-AfPYqXrFcwikbk514MO8WhVVuTF9WsASfhdi7apmvvb_0akJv24Ie9XwESbu4Q2dDtvhZCdyBheWcFohTnDqF9sFr1Xp2uN-0-K1lc7cuCMerBW0VwUt-E', `SearchKey` = 'wofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLwwofCpMK4w4DCtMK6wqDq8KDwrHCuMKsw4DwofCpMK4wrDg8OgwqDrMKDwqTCo8Krw5rDn8KdwpzChMKhwp7CvMOWwwrDDhcKpw5fCr8Kew6DDqsK3w4XDwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8O'
# [10-Aug-2023 16:34:16] /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
# [10-Aug-2023 16:34:19] /finance/root/bg/ajax/invoices/form.html?_=1691674458992 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
# [10-Aug-2023 16:34:27] /finance/root/bg/ajax/clients/select/type_0.html?keyword=hev&_=1691674467010 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrjCn8OGw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rjCn8OGw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [10-Aug-2023 16:36:00] /finance/root/bg/ajax/invoices/insert.html?_=1691674559530 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 44 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` = '2071', `Language` = 'bg', `PostDate` = '2023-08-10 16:36:00', `LastUpdate` = '2023-08-10 16:36:00', `Type` = '1', `ParentID` = 0, `Data` = 'qaSezuIciv6nrvERto7R_gPl6I16h11tYSXgUXdjZo2BYnUczMtL3T5SWmSKLcboBosm-cKZ7z79R-mKGN6oeGJvGaLVuvPcj-7i4f25GWbSw3Zul8dUeqFsLi1fs9vKqkuIyTIlgwEz2XBn0J_pdwLo4QkszIm-35Tl7xuohkwsrJFCllKWSHMXy_aLVQgotC8AeagxAKTf9A8pOGm9sKKqMWPugguN4TOZLYPmqhxb42Ftme9vKRfbzFVLJDG57cJ0U0e_XnHl12fjD7-Eqk0hPOGwWxu_0HskzAu6idrL3byLaLXB5oOpvclOo7sO4AHvgis0N6lQHNnaz92SH4o2XKA_p0eiSkkgeXvzclpuh1q-kEfSSW0WUghYK14xOO5pKJjbnhJ5ApTm5Y-lcnEbYvH_cjZHVSeihRfGT7rSqgjYAH2Mp_fyRtcONYi6dO5aCh8sAchmLdAE0IEw5ZtV4G0tBIEScQHSpf1n67d1YU-SmL-BvKHW9nPr71Tt3hZ2BH1IbMtmr6jL4IcJA1YGjEQv6ZylUUT_b2a5v7PHrK9gAO8vfVDg0VQLR9rwcY8icFYysvR3vrkXPrFrnE2FfdRaUVTQyAiwDQRs1zfunYGba7x69g-LfC1rxCKnhqXTvjV3qvracgLjdnIonUAbsA74se2cp1Fx07xL3ZPBS7eQQWrZoXme3RyFCy9kfMx1Dl_q6Oj6fBdrxWO9mmrMcG1tH-CBo_lHI9iHu-GoB3quFOz2ciZ10N_Df7uuCLP-0HFD2TnimwyAUJpxwi_y0Nh2NzuRup5WJ2tb1dlWHzciYQnhwWZy45fQu1kOWxFNgtq5bU_A3Ych21d8D_eIEgrEBRppo4uk2wbPDO8KNWmAdh25GLecOUTdlEb4eXI9pJ0tq9Jd3kA5djRk1w9v6QxZayGHBPurgNtrOVVkdUMmceOMlPpvuBE_HZFm5C0UORtPy0m_wjmxjbH91S2dU1OqPYw02II38m0Mvfj_RoPGl8S3iMY-2AgDbX0CAApjYsfjxac2PZ9KQhARpijWX-79PelXAupe1HWAA9_NOBz2wRi-qcobb5AHn1YI', `SearchKey` = 'wofCscOIwrDgcOQwqDrcKDwqTDwofCpMOiwrDgsKlwrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwrjCn8OGwqDCrsODwrrDp8K3wqCwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwrrChMKhwrTCvMOWw6TCiMwofCpMOiw4DCtsOgwqCw'
# [10-Aug-2023 16:36: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
# [10-Aug-2023 16:36:35] /finance/root/bg/invoices/2070.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2070
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Aug-2023 16:36:54] /finance/root/bg/invoices/2071.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2071
            LIMIT 1

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