Autocomplete and db_rewrite_sql

On a Debian system with MySQL 4.1.x I could not get the autocomplete function to work. I found that the queries in content_taxonomy_autocomplete_load() never returned anything.

The queries don't make use of db_rewrite_sql(), the documentation suggest that they should.

http://api.drupal.org/api/5/function/db_rewrite_sql
"Rewrites node, taxonomy and comment queries. Use it for listing queries. Do not use FROM table1, table2 syntax, use JOIN instead."

I rewrote the queries, see patch, and got it working on my system.

The patch also makes the autocomplete function to add a space after the comma between terms, just like the taxonomy module does.

Thanks for a very useful module!