Quote Originally Posted by waddtown View Post
1109 Unknown table 'p' in field list
in:
[select count(p.products_id) as total ]
in products_new products_all and featured_products pages I thins it has something to do with the columnar display
waddtown, that SQL statement is missing the list of tables. I'm guessing you're using an altered version of /includes/classes/split_page_results.php. I recommend starting with the one that comes with Zen Cart. And then if your template requires some changes to that for some reason, work on fixing those requirements separately.

Perhaps rbarbour's post here might give you some additional insights: Making v154 DIY/Picaflor-Azul templates work with v1.5.5