# [07-Jun-2024 14:09:42] /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
# [07-Jun-2024 14:09:44] /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
# [07-Jun-2024 14:09:48] /finance/root/bg/ajax/invoices/form/10408.html?_=1717758587234 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10408
            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
# [07-Jun-2024 14:10:12] /finance/root/bg/ajax/invoices/update/10408.html?_=1717758611076 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '10408bg', 'JWUDsgF-babmW1TetbxS5LhBrzoznSo6ah1_BY5iJCTnCQBIVyXS8qg7iuAiGVUecCU5VKznGP99MbxoOe_d0vJbBnRdUdHBClmXcTAYCvgjzVo1Q9vv7GAoepAWHUw7KuE4WsdsTCy0TI9lqzbshuvkzdFbuRzpj-qy-8vOMLAaxpb1VOYCWYaFNOFH124p98nDrEezPFt7JeRp91-PDd9IOGmI1lakl2q0NdXyQas_4BHWsSpNeq2MVZ1tEU8A2QIEVLShKYrOrGrjCnKwVvbgPRMn60wi-LTe-eI_3aiUWCORR-zEnZiL_BXHL5N3dT3GuptlV36yRh_i20srLP7WFCX24OC_gIIqVRP3aqpOMl9GAbjRxFMMmo4RXj0OZo7MACjfQUWzVDQjpsOzfMl7-I7rFikCBRaFCnHDGzzQ00aASSNp0F0dviJ-cERBRT5Il3ITiqBJspnPFJPIlOKy31gxDMwFPw5RQVS271zYPoKDfVInQL_ynA6kMyziqx2XowjCBGEGALsDcD_bpn8bcmRY9JNYWpbGU3io99HiLeA1HFGGu3k52x8Mamu0Tm06BET-8FATNZWkLL8pp1OJJ7gfvl8fxROGlXZ1YarIzNor1EccxyX6hZXeSN6Ijpgdznzg4_SYuwj1bnCA3mdHDMkZxfvOrjq97mjGU0eGd3BtdYJur0UNxuIj7oQPsQ1VdrSr5QSuUsQ5QFro6PiK1ozSEK0IAEDYOQrcQHpimprQb-nFMvR_04uJaMxKk9SDTtfJhy_2X7YmXUO-v1d9vzTl3TSuuYAAY1LMoOrRtQBHv8-OKavIsIo8ZmJ3zGM9c7ukaUrwEQwUn9ZlXgCsOabQ79CaGTvGnX9d6P9NeDQrHZ8LEwUiv75C4smOR6z86PTYoodCxJ_ThOh3T6FOkPu1KHwjVA0WZlUNqjNyBJmL9K9DCt7JqSkqmwhyRC8DRmeTnzN-ngqwFRNPMJedfMi9YZdmLgjSAgI1OucpIPmUp_2MMxwB_eBdxPXGmm55Oof_P9IdXwyiAmqaewvHdEKfj3qjIZ_Qq-KsSr53abD8nbfzm1HZGPn-AOW_PFLiAUVc7FGfua6HEjawcndN9Ipl9bpTS8S_0i-nHP4b2gw_3_e1JXeglmk8ZFPLYxx5ekWrRi5JpBdfkIgt0qe1OqtE7kJ99sC7I_Y8XKWBYcROARPONYIn3i1nbCKtOCvw_OFpjeb7ssdiS0VHI07GGbdXsb8Kip2abuNRB8r0mECt6ZPuoD5NlwfxcYSlZ9oyM4SA6_taEJRKZznVrvorkdKzrqlnY745do7ig0wYpLXTO2vei3MdsRSPGvp4pM5GCLnEY67P-19ni0-JGQ1Xb5vnktgfuFburwB3x-uQDQ1ZTyJHKFounB8omZ2pMu7Kq__zjPsiLtL0zb3h3p-dYjkijqbE8DjukEpZPA9Rq4HQ5B-A9TY0E1HY_7ixazfeFm2gIAyRlaW3p5QMPaddfwemI1cmJ6CwQbbnrlpsc2rG1iX7dJFx_hQZynFCNQLBpZ7ifSXoD9_qnqRtaC2wpWbrzFfULn-2m7WFLjaplLnmR09UWj8t0zhcMt9jxZVwIZQX24nOFeBtLqjSfsUU5UoKThosthE-OwKlvo9wfH_L_MK0_0S4bEXQGKMeX55Iegye4xzc222dEuGPdVRQgiGgJGmkfUansRrvnakRDXv3gx6kYySYP7bG8HTCLZ7U8ONLjpM3aXqdG4LcR9sXM-mRcyG2CGH4Ara1VKWEebLx2IJQZwXgo0bw3J8_gCbHlUYkuaNidGqqOL5WH4NQVWunqB2VWnRn4zH5_MSEyUODMnZuxVYp3cb968UAY9oYHc7K8nTl9WRX1F1Smzhy_GIpvC7VY_LKeBDOjw1I_WQTGhTNQ9F8q2IemiQmGRRlrKmC9MY_-wLCJaydkpnaJD7s_f86td5fVsn5oCM')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '10408', `Language` = 'bg', `PostDate` = '2024-06-05', `LastUpdate` = '2024-06-07 14:10:12', `Type` = '0', `ParentID` = 0, `Data` = 'eT7AB0GH-2Sy1R6WVAxA_8YmhVPMIvayerE0WfwdEj-H4Su4iCOta3l1ZKTGLHBZGTy3oGdrcvBtLDdfBhHygUvWV8BU9Jiyy88NiUkBXmjbGh-KEMRYSQm8G3hmATE1KbKnIJqoE8qoYtHbhhc8pCX9UQnsOk2zt3wQITId_tFChhMY8ysT8XSB02P0tWtFd0aa6zpAXCp-yAL5orYzNj6k3Dzlj91rbbW4Lv5p1Ii9RGUsT0-Glf1fCStsJPrUwsqe0GWQra_3gQA_7XWwmA8qHrJa19Sl6lDieiUiuyTVefB5eXOlchqEB1NkwNf_OCF61jAxEgY97SFS9aGVBA4TOcsF-WHu4LM25zwde7eGtNOfLGQd_GQpOl5xaxritlaEBPryR2vtKuAfs3uIjuUnEiKE-JdlNx9phuB2rVasDxIJw_wxdniLt8kyiUNPJF_p2b5QYY1TX7SfWqvYRacwjVJc8VwnxLKVbGSpvXwpNv4cOM1EU-HPnfAzSp_mTaJfqR5f3C6CkdO93rRTozaqP5sHN9wipjJIr4SCJ_E8bqwVbijtcGzFp-RPEcCYC1wMPlfSqGk-vI0UuBBlD3YZOXz9vFY4c1AVYO7ysO87JTXO7KKmVHBWgq6BSJf4_LnOnoHP0H59JCljn3ghJG1jpW-waVVuskdD0GDiNILvBZXyDSYKL4iXaliEqzwF4FtgDBSs0ov4TDYhS2_w6v5hl2LpLE-PnWxuUq5d1ppYM6dSf-CxPE-MR0TdAvy7Wc-0VfRMhXScpkim4qKV9nyrhkS2OlZgOmQCZChYxUS0D9Z_SgTcRzVvS0NMtpADQ3VQ439uxPqINd3EnWYIU0EFBit4kvvBxh4G3zSR0pUvtjMyjGNxjDe53rNt-yJqJVvcxRkwCwgQhnRTYVn9kbZZRvLZhBJBt9QU3A0NbKol14L8Am_2WhAn5rDxhibK9omfEvi_wp8Z56aVEGeJUbc0cvtRT8wkxdTedpdlaptDpNlZ2Lz6Ohchw9gfOsUN', `SearchKey` = 'wofCpMOPwrDg8OgwqCq8KDwqTDlsKsw4zDn8KdwqPChMKuwrjCvMOVw5TCjMKVwp3DgMOTwqPCuswofCpMOPwrDgMK6wrPCtcKDwrHCuMKrw5rCucKhwwofCpMOqwrDg8OgwrPCtcKDwqTCsMKrw5rDwofCpMOIwrDgcK6wqCqMKDwqTCn8Ksw4zDj8KhwrLChMKhwp7CvMOXwwofCscOWwrDgcOQwrPCtsKDwrHCwrrCoMKyw6LCp8ODwrrDwo' WHERE `ID` = '10408'
# [07-Jun-2024 14:10:12] /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
# [07-Jun-2024 14:10:16] /finance/root/bg/invoices/10408.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` = 10408
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-Jun-2024 14:10:33] /finance/root/bg/ajax/invoices/form/10408.html?_=1717758632497 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10408
            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
# [07-Jun-2024 14:10:37] /finance/root/bg/ajax/invoices/update/10408.html?_=1717758637003 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '10408bg', 'suJOFOgghu-U8HyzWkHAMr8HxiPAwoObNt0ABtBGP_6Vt1XqQ-mgNjqJs4Qd3yIBH9s5ZByJoAkZ1TK9TRqbM6b8YPvcniJD01TqwfO8t17GiBGpjbSS3jPD4kgUmx5Eh1LFBRYXq2BzGD3uqU5Ii0H7_HP3RTOVB7giVmFVOHaWSgQwt-L90gtdNLW6b2kpoVJEAk5PRwxihiN4cj_1x91-hzhJtjvPlZx7F_lI7056B5YIG9fZzaBVr7MlbMV--f5svk1QN8SERfijvR8gf_jAs9wd-W1qTYeo642nc7LEU2eBCPbrAq789kOoUYHKNdGf5xFZZ3c8YNOKTOCQBtH5fnzotxP2_7JK4156m7NkWtxYhVPgb-bPxxUua06G9JRQBmATeWUYN4o8Gt0sd0wmBxYqNuDqzTdxn3D137j-GcgEHoUzJN1eoi_WrAAE5d95s0I0qQVo5UHsmEWKO85bdPQ136RJBqTH6grZ7Kkm-2FbEVQ7hWtq_9C7CfpOo861oUJf0jSTFAWSnEQ2gulk2y_fvBRmKy9iod64e_9yEXxhKdVY3ba1016T-wfalgbywGJvUlTy39bulE_7YlD9li359QKeCI0i3iIv-MprwRpzN3d3YzCU1flZksa72JBaOQzEkr7yVRokY9y-DN569Y6s-G0LZ6xNexQhe95L7Fh_MerC6LlvoHfDQRtQkatjnUEIZjkBSI37Dh-X6aWmZgnWrw4L8ZWaAv4NNcrDQc6jcPue_ACbd5UzLYjyzWBqtingLzwjrWvSyR1NbRo7YTZcvzyLmp7XjEzC0X2cEgLlQ95VL0kGho3oEseQu3_amAkqL7f_0JI6AoSyLItSSuM0lZapcPGDXn4LgD9PzRNqJMBT-fpWq242eIyamje8ZXkffFhAQevZmdu3EbskC3Ni38Tl5LswW3TtU_SiHNc-my1bAL0cwM40ly0q8rXJmwuWi-oCCqIbQO1QZW8C28o8EI-yKIjmjJS6lxTeB826nSw8vufXkM8VJ2fEowDzbSQS43OodZHNlV6XHE-TLKhLiOCjzRix8Xw6JMeKeJtJL1vcmZQavhGVZgb4TugC8FkIW7WcmkN2Ih5NswL4Qf77RVq0lwTZ7P_0WSRA7jmaG4ym6wyAlRLZkXHibsdnOWbBgAEAsUo9ZH3Yju0_Pf4cjctbSy15f9u1o4dEFT_8nTxMZLbuOmGJB6vVzVbJEzl9je98F29M1iwlVVviRPIPM8jgSFYrpKS1tkh6N6Jf3kzHpFh84U84i39vXgXIle5WfN1H2youwhxOsBnIsF4R6qCwiuJrColHnkrEJ7Ly5X8S34fP-BCC1YmDIqSOvJ2_cHjeWsbg7wsggANqm06naX_yuCw_nZWtCzV-KdaLRNXLqNswA0VnNtcJVTEyG17_uO559iIrB0qq5C_F-njIEfHG9w5D_wcVk1-GitmjQgTCdN1910SkXVk35I7Qhj0LMNwY9FGcifW85tUDTvJnuiCqKT_r8DCzFMf78-6evjcVA4p1CjtjJ-jfceYPWRZ-Xw0YuPFmWqBGKatxtbrDaFHEwdFo9mccdnmiiRRFnsEmBVajyr9NixM0QA_JyVTyXXdVDXqTxvC3c2oF9DJwSglEpwwACvSNEdff7kd9mgXsjMPznZS7Z5yl6wmnwN91wMIGq60z6QkmV49n5vIjfiVWnm-6EawHfufpX5EkfokaNp12xw6wmC_Vg49t4dt1mnHerK6UUyFHjKmDdDCioSVzznAhUGV68FKumWinZ0EfauKqEjenlELPvzbIyZJ0QVIRtslpErIs4SWsFIWIlhDhrxydd2qmu9N311XNwtWw_BBY4sJ7ksPWsf-zYAVK7D2YB3GF8EVRPdv4ISi1kbgSH8m6uJ-6WGHU3wFiuEEQhceMWYCbHBkG3izWHyMREkYgc8lPd96gogpFimNG35GTFuK21M40t_k')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '10408', `Language` = 'bg', `PostDate` = '2024-06-07', `LastUpdate` = '2024-06-07 14:10:37', `Type` = '0', `ParentID` = 0, `Data` = 'GGnvn4_M3DCMqlWqBaK8_ro5tBNhglp9MrhLRZsnmtp3nsEywRXer87_MoW5bOdDeVesq-AZMS-6NvmdTWcBEumBiS9QJTLth4bxRAX4DNTOVlGkgGKlaZ6zd_tyEqkz5loz9BjpBPLyBaaGq_sqHQdmYZyUJ2HkymxZjnT1JpckCL-aPhkKiS5BRpQmDZ8tBKyxyr-Ohk40y6rv3E5KzVpWRzFPG6ZeKw4y4heTHrkAoV_scqkdtHKbPdry4J2DAvjCMCwPhgo2Y4swgrKpWdpZDU3dIut6Q2IbyDDt8E-j7GiU0LBGK8ve-9XW2hq5HS1vg9iEMXknabuwpMklJ8I8lNTF7rLP9Yn-XEGBb875KwlzDygqe4VZnvD52CAkyjyX2g8X-m_uPRSBEXQBgCnndNBwT68fRvTJAz0XPnj7TtTKljSlmcD8XwJnAYzQUR4rxZspHbPQaxtE-FPVelhNwvhrMTt6nnBHKnnv-8SoI0FypTv6iI_xWfSO4FKoSWqNG0bL02V1SDtoFlOMDqORWL2nrqC82QDzJTOrE-FMmXhYXiKlWrDRNAlKGknXLHZiiDEB_a2XwZ2ZJfycXl62ivsqM8fAh00UPfBp0mOAvb_o_lwxhxyxOp-QtQ29S-6TvN4NP7Nb8FCXRf7BYhI_2Kv9mNLU6C9VAwkB6mrvpOMyA1hc7U-luH78fTlhPaw1FlfjPUUjZr6ube3S2j5Tz3lcDyKj9prSR5oUvbtPHLp4oHLkXnAX9BoGez2U_cnP-klfiU8qjOTkKQROfPtAa2PBm6ilnlC8GhvE74JqhZdO1H7VU0JuBsj5c2CJ1NCAQyxVV5SMSYaI5lbeQCebbb1jX3N7LU0QzPT1NaLOwrUBnC6qMwDVcempWWaEje3oGwOSZTWAdiWmBhfXW21A2AqnEEhMFZ7kZL7toTAKnf5_NTp3eWFzJ7inB_mZF41JuDTjqgFYqR1FVueHgzGFILUGKNU0s3_iBBXi3KTT9cGRBvkP92bvmAoUSFaH', `SearchKey` = 'wofCpMOPwrDg8OgwqCq8KDwqTDlsKsw4zDn8KdwqPChMKuwrjCvMOVw5TCjMKVwp3DgMOTwqPCuswofCpMOPwrDgMK6wrPCtcKDwrHCuMKrw5rCucKhwwofCpMOqwrDg8OgwrPCtcKDwqTCsMKrw5rDwofCpMOIwrDgcK6wqCqMKDwqTCn8Ksw4zDj8KhwrLChMKhwp7CvMOXwwofCscOWwrDgcOQwrPCtsKDwrHCwrrCoMKyw6LCp8ODwrrDwo' WHERE `ID` = '10408'
# [07-Jun-2024 14:10:38] /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
# [07-Jun-2024 14:11:24] /finance/root/bg/invoices/10408.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` = 10408
            LIMIT 1

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