Optimize Query

Optimize Query
Hi, need a mysql expert to optimize some queries, add index, caches etc..

If you are really good at optimizing tables, drop a PM and we can discuss it there..