Okay.. sooooooo... it's not for lack of trying.. But I do NOT see how the Hide Categories query in here synchs up to the actual query being kicked out in the error message (let alone how to apply DrBytes fix.. )

Arrrrrrrrrrrrrrrrrrrrrrggggggggggggghhhhhhhh!!!

DrByte, I PROMISE you I am trying to learn how to fish on my own, but I REALLY am stuck.. **sigh** Hope you will still help..

Here's what I am looking at in my includes/templates/custom_template/templates/tpl_products_all_default.php file..
Code:
<?php
//  Begin hideCategories code
 $products_all_query_raw = preg_replace('/, ' . TABLE_PRODUCTS_DESCRIPTION . ' pd(\s*)WHERE/', ' LEFT JOIN ' . TABLE_HIDE_CATEGORIES . ' h ON (p.master_categories_id = h.categories_id), ' . TABLE_PRODUCTS_DESCRIPTION . ' pd WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND', $products_all_query_raw);
 $products_all_split = new splitPageResults($products_all_query_raw, MAX_DISPLAY_PRODUCTS_ALL);
//  End hideCategories code
?>