What is the best English grammar book out there?

I'm looking for some good grammar books for intermediate and advance level. The book must have tons of exercises and answers for me to correct my exercises. Plus I wish to obatin a book where it is strictly a grammar reference book with no exercises but lots of excellent explanations about how to correct my texts, how to stop doing stucture errors and syntax errors.
try this title

Title: English Syntax and Argumentation
Publisher: Palgrave MacMillan
Author: Bas Aarts
Edition: Paperback
Edition Number: 3
Language: English
ISBN: 0230551211
EAN: 9780230551213
No. of Pages: 323
Publish Date: 2008-05-31
Binding: Paperback
The best one for me is (Longman) A Comprehensive Grammar of the English Language (1985)
Students: We have free audio pronunciation exercises.
The best grammar book that I used is Understanding and Using English Grammar by Betty Schrampfer Azar.