Thanks for the help, but I receive the same error I was getting before:

"1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 15' at line 10
in:
[select distinct p.products_quantity, p.products_id, p.products_image, p.products_model, pd.products_name, p.products_ordered from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and p.products_quantity > 0 and p.master_categories_id != 123 and p.products_id != 1992 order by p.products_ordered desc, pd.products_name LIMIT 50 limit 0, 15]"

The setting I have in the admin for product listing per page is 15. I suppose the product listing page and the best sellers page don't like competing over limits! If its an easy fix, then by all means feel free to let me know, but if its going to be a time-consuming pain, please don't hesitate to ignore me! It's not a huge deal or anything.