Even without the info I often ask for, I smell "pagination via LIMIT and OFFSET"; it is evil. Here are some of my rants on such:
http://forums.mysql.com/read.php?10,380718 (Efficient MySQL for pagination of large amounts of data on website)
http://forums.mysql.com/read.php?10,360578 (join in union)
http://forums.mysql.com/read.php?115,355941 (Query that returns indexed fields involves FILESORT, why?)
http://forums.mysql.com/read.php?24,291646 (Very Slow Simple Query)
http://forums.mysql.com/read.php?10,292296 (break mysql query? Is this possible in my sql)
http://forums.mysql.com/read.php?125,246731 (Alternative to FOUND_ROWS())
http://forums.mysql.com/read.php?10,243777 (Query performance question (using index slows down?))
http://forums.mysql.com/read.php?24,240838 (Slow search query)
http://forums.mysql.com/read.php?10,239876 (Query performance on database with joins)
http://forums.mysql.com/read.php?24,234339 (MySQL Performance Tuning on my server)
If those don't give you good enough clues, then please explain what you are trying to do, and provide the info mentioned by Zsolt.
http://en.wikipedia.org/wiki/BBCode