I am using MySQL Workbench. I can't deny that it's a very good tool. Unfortunately it doesn't have a query builder feature. So I wonder if there is another one that has a query builder feature?
I would have a good look at Navicat. It's one of the best I've ever seen.
http://www.navicat.com/en/products/navicat_mysql/mysql_overview.html