Mysql expert needed - quick job

I need somebody with excellent MySql skills to write a optimised SQL query for me. I will provide the MySql tables of data and exactly what I want to be queried. The tables involved have 100,000s of rows of data hence this SQL query or set of queries need to be very optimised and use appropriate indexes etc. ## Deliverables I have written some draft SQL which does the job but it takes ~ 30 seconds to complete, I need your work to take less than 1 second ??" I know MySql can handle this ??" I’m not very good at SQL. If the tables of data need to reorganised into a better way then this is fine. So is using sub queries and temporary tables if you need to, providing the time is still less than 1 second. The most important part of all of this is the work needs to be done in the next 24 hours, it must be complete by 21:00GMT Sunday 27th January.