I've written and modified many MySQL queries over the last few years, and I've learned quite a bit--especially about joins and sub-query optimization. I hope to share some of what I've learned here soon (particularly regarding performance, since I've recently re-written a number of queries and just reduced one from 6 minutes to less than 1 second).