subquery with left join in mysql 3.23.53 consume to much time - Can someone help me with this problem?

Hi I have 2 tables and I want a faster report like this. | counter | user company name | +-++ | 65537 | company1 | | 65535 | company2 | | 64563 | company3 | | 52676 | company4 | User table description | Field

subquery with left join in mysql 3.23.53 consume to much time - URGENT

Hi I have 2 tables and I want a faster report like this. | counter | user_company_name | +-++ | 65537 | company1 | | 65535 | company2 | | 64563 | company3 | | 52676 | company4 | User_table description | Field