one possible explanation for the way in which the server we're on 

suddenly becomes unresponsive for several seconds occasionally, then 

comes back again.

Basically the index filters "music_genre_filter" and 

"record_company_filter" each contain an SQL queries at line 154 

(approx). In both cases the conditional section of the query is 

incomplete, as there is no join between the products table and the other 

tables that the query references. As a result it attempts to join 

*every* active product to each category record matching the main 

criteria and can sometimes get into such a mess that the server (or 

probably the MySQL engine) grinds to a halt until it's finished, times 

out or runs out of space.



If this is present on your servers, I recommend getting clients to add 

"and p.products_id = p2c.products_id" immediately after the "where" 

clause in both locations.