MySQL Query Optimisation

I need a coder who is experienced with optimising MySQL queries for optimum performance. Please do not reply to this project unless you have this experience. I have attached to this project the query that needs to be optimised. Basically this query is to produce a news feed, similar to something like facebook, only not as complicated. It gathers information from different tables, but the problem is that the query is taking a long time and is currently causing the database server to crash. Please let me know if you require any further information. I need this project completing asap.