my guess is that the problem is being caused by this part of the rsItems recordset:
WHERE items.ItemBrandID=brands.BrandID
It seams odd to me that only one join on the page would cause this error.
try taking that out, and see if the error goes away.
Ultimately, to fix it you will need to contact the host, but if removing that part of the where clause fixes the error, at least you will now that whatever restriction the have for the max join size is ridiculous since recordsets with one, 2 or even 4 joins are very commonplace.