Excellent! Yes, the above worked. There were also some problems when doing Admin creations of products and I'll need to test that as well. But thanks very much for the below. Really looking forward to this module becoming more permanent in future ZenCart releases... it always makes me nervous at upgrade and patching time!

Quote Originally Posted by mc12345678 View Post
I can confirm that setting the db mode to ONLY_FULL_GROUP_BY and incorporating the above modification fixes that issue. Please let me know if other such issues arise so that they may be addressed.

As to the complexity of the query, well, some of that is because of how the SBA table has more information in a field than it should for trying to have a normalized database. There is a plan to split the data out a little more but is a bit of an overhaul of the underlying system.