# [02-Aug-2023 14:57: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
# [02-Aug-2023 14:57:16] /finance/root/bg/ajax/invoices/form/2062.html?_=1690977437165 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2062
            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
# [02-Aug-2023 14:57:38] /finance/root/bg/ajax/invoices/update/2062.html?_=1690977459056 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2062bg', 'VZtLdYvjSZ0ynRRUCQC7MOmjwZfRbQKEg-f3Gy7iGSjJK088aH2NU_yh6xjXWS9t-NED4TSOeLj-jfXvfsM5np7mI2WJFhd5gB6w3UtmBUX7cFF43hUb42HPgZX2RXHzcVpPM8CfMZGnNS8nufqzqWHJng3TJhU-FIxmYzaOjawms5cITxWsXxiC61NMyYeAT3h_HmsJPj3abpQo7894H1tpIixWPED5I2ZuUH2LMijiX_2pL8HJycGsGJRkJDStYuSoCTr1idR2JDlAWWTPm6yl8RvrcwHDxqMoQN9nbDpdETMNd_vJaH7-KzcdIxGrTRKp0p8kYNvavS0sfwN-6pIBtq8UDGwPggWA4Abxtfl0d9UAw2eOlzoBRXLV5UbbD3qnr6BE5G6chHyxx8rhohHXRW6HAj2CjKDeJ09XD3qYxjBKHQo_-2NFIpb4fA-WXfF-eaX50xcWEQJ45y6bogZyXkRlxET5cBytwTJLcnEDpf7C5_hW_EVWRlgDZr6pbpLW3OtcyvJQ6VOz8SaByBIFr680UHQN0bIJNYe92V4hLteug2DYnaJyPOOfqDisLjMZ-4f1cPzhuVB7K8OkUKkY6n_Xk7i_eAVWXAdreoQuFYVU2msgvA8duUHFVcL0Ki1E7kXUNfyP_DpshElgo-jWlORkL6jpmTmDrTR-jIfUMSwoW8cuFr4xtz5_bDXTKrN7cKBzfUiiPTXryq7Z5wIgeusNeRnQJmDvXY8UuoTRZNDJ5xBw4iSBHdBksRKWOytWjKu4-jMe3OmHGNr9mOgNy86X8pgb3DyUdw4rYblblgf4QFfepvJaXNAKw26lfzk7aroMmcr4CJxvzRcU6yTQ5tuoZ1293Z0wM-knsWK1nZOI0_Har5hQqRdyStdk87JZ28QxkktYiJh043kkOvJHDsRXapBB42OsgBU6rDQxroACrRBSW9UPH7Tk0XndUV7WXYtTWShGVgeVfIazqwpg7tNWJ3R3MwteCBwQNWjZy0LJ42JdojNfxNpTWgiPa9e90MJCNHE4Be6o3eVuiDJ5Zszpz0xLOZKVWkV161cdTyUFkuC_x9eUUKgLMQ2PYh4TDf3Bky4s6U5s4QY5lc_0oCHqBngGDPjO0JI2s6wAUFo7MMkx13muA_ndUTN-xsFvk8sD4Z8p9VsX5oUaBZvEPVBIRShlDMqAnWTKMxRCRaBeSQw1eCSylktZmECnXb_ymOlWFrfs3huUf7jheBKcz6lJ4nHqd1wFfd8NnSWTv7U-GlzHPpPxFFe045lB5KBJTr90ndLenkmsB63Fsn7nnyTETQdS_nfakX3lC8xf1-pxNhT4jBQewtT0g1c1_5v_1o-PHJKaEGff2jDOeWSbd1gA5i74ogUeYk-tn68bD086cKgqxeN8MaQIuDPxSPi4YygT36or3ODUf8zWfP-K4QizOSSGzU17migQWo1hnl55HsfwTkK3DN0Ie1LF9iQeNbQDX2lQikY5T_obOct5tyEmi6DaFnNhisPmWxS8TLhw6F_AizKPg3EvPPTe99bBDzZhuefOGMGT3TFBlY0EAAuAEaIYiqOrnFVKEItP4zvAx7dhMvMnGBmShMBfoMCAI1xRqFNPS5NomA8rA0fzAcKGhzQyyIT_2X1AXcQGcP3oQEKuWV1-isDQv3KYmQ-ITS6W6REorGJRepky5ayCbFxq8By8NwgJ5_iUs54Bg_yxNnW2VAHAqvJFfQuM3sRwxK4S9GMzwkNUVaW33GzU7tSYYUPvvbHHFpIqoMTsnzxF3KmvsGv8qEKU7gfy-t1-Ab1OVVE3ky8bA8eWWRlpU7QmWSKgT-LztPNwSB4iETGBxw0tvZZscnJkvfvB_CgdJ_GiLHYLSOKccXD-fMEWpPG3xrx05d3Hrfv5xexUe_UKcAcjgCFeWb09gpvGho-HJhtHfv5FNjzZ1rHt6yqovCSHpdXmMDmyJzKBi8GNvDOW4XLGcGAL2aEcPGYVH4eebvZP8HsGWkzuhf_Ae9hBs6eZx-otD_g5Lr071EYRKjPtHFlhtC4GRFwSi3d__M9v9u2BUSQSy4rAKNF53NQKo5tHCnw21QmPbMsfx5Db7uG0hjk-fcs_pmMjnygNlCCcwAa6WvL4lP3nimW1s5IGCx0ITd2XFPXZwjjTLmTKtT4g5LFPbmVdRGsJZpZVlbelUQ0eSH5JtAQUaxPbbK3V09MQTCt6FmXS6kfhp9UuxNN5LSLXSIciB8jOqrsVi05G--5Jl7O4DyL2zQAz_zA4y0RjjcYGkCfD69NmR3f1dG1Y8WIFnGYtpW-NyoN7MTwclR0j2c9BeSu1uLiCAw')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2062', `Language` = 'bg', `PostDate` = '2023-08-02 14:57:38', `LastUpdate` = '2023-08-02 14:57:38', `Type` = '1', `ParentID` = 0, `Data` = 'ulMe_0q0y6woY1YPA1taSXxhsARnzDmqUUIFf98A5PaTCCP_KTnOzkT0xpBNAQ_MFKBiNZ_iUXTYFPRR53dQKWeExhWlA8l7Uiexi0o_zfk9aZ9Xqcqd5x1n6341mVj-UFiYkkA2K5M43RRNOE9TFoeiPLardQf2JQyjXWyHLLI1Top-FJo-V0P_hNQriGQsGuiDmPi96fqLEYi7A2DypmLJoLI3jWWMJuNlo7W43R0DqvyzqQ83yNcLZ2unxVwdB_1I_YR70O5U_HHcyZNybUgEdrpuNy-lp5PvB8oNw20RNneNS6qLK7mQ2Aes3tc0CixyKPEA3LahT61o_mLbIrTHbudwZaRRTIWV7GIuPf0PQNfTn-da702ezt0XHpSNM77A29VmV874Q5Wojh4-uaqp34Qk-O0Wz83OaVUCT0I3quY_lcOIypt5AA5FCNqs4Ehgv5agW2Na07D0ABfQc5hCjt6fIgaW_8Hl8ElDRqagqMUOc68cTfeYe2AAUFFTkXQXnqr3PieK6yIqQ3v3jZxwb44oxtlqWSNUiBwDWIiJudmV5rQjUkj78qGkuB9WuRt6IjdOjvmzDX9v-oDWECdb-MTcmwant2OjPtJuJDxheRDbXxrEifSGB78WU9AHWnvGSTlea11VQ_N-H5ZXYajtRyoSPlrUStyoWwzGSy_KgsBXhuFlfhv8ZlT9461lgXyyaoUF00tPuCNhIyY8LJ9qhYnGH8y7JXQ1nAads5Vnib76xcbPyzU4IugZrspJuLYhS1nO_eWqH3d25tn_3T_arTJmXRDH3N_7LTth9q6awoBW6p1f3tVw-CbhS8q31NypFMzaK0wHcSmGvt08RmPY2b4Rp2VKKkIL5WX6-X4ZOGoi7mSA0IDfK9BG2tYGJXhz88-nJjvr2vYGYxez_ciTlpmZqS7CbBeKoM6mEiP0STsIXOJXuubTMlSwpzvrNk0hb6lrYqUkybKKST-jLWR3O_7CBEsC5Nu7v5-S6XfbetKCr5ZlQWoMURINR47K5dDB3uWxA1inEQD2h1FFBD-jBzufMlTTK8mFxpCOpVQDu_NgeM4EwzklkJtBtOMebi_wz_YCjwQf86p0KK8FZ0Klerwu7BwRDFKYaEz7cfQND7nN5-wG2D2CBLpA1hqalHUeX8Rl1vN7xpc8biQC02RIuIquzaCksPzNy2Tf_UEs8t3Pm-wt6zlKpIQXG8Z43YR5Re8RR0H7nganVPiW1vOHd3WWeET1Ebi0FSVnvzDlkI_qjkyZwoiT_N0esjNz', `SearchKey` = 'wofCpMKjw4DCt8wofCpMOqwrDgcOQwqCpMKDwqTDlsKsw4DwofCpMOIwrDgMOgwrPCtcKDwqTCo8Krw5vCpMKdwwofCpMKnwrDg8OgwqCwrvDhcOcwqTCrsOEwr7DpsKswwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfCh' WHERE `ID` = '2062'
# [02-Aug-2023 14:57:38] /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
# [02-Aug-2023 14:57:46] /finance/root/bg/invoices/2062.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Aug-2023 15:44:38] /finance/root/bg/invoices/2068.html 167.99.142.201

set names utf8

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

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