1054 Unknown column error after site went live

[DivaVocals]

So if you go to these links you get the errors in the queries as shown:
http://www.hairisle.com/products_new

1054 Unknown column 'p.master_categories_id' in 'on clause'
in:
[select count(p.products_id) as total FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id), zen_products_description pd LEFT JOIN zen_hide_categories h ON (p.master_categories_id = h.categories_id) WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 ]

http://www.hairisle.com/products_all

1054 Unknown column 'p.master_categories_id' in 'on clause'
in:
[select count(p.products_id) as total FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id), zen_products_description pd LEFT JOIN zen_hide_categories h ON (p.master_categories_id = h.categories_id) WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 ]

This did not ocurr on the dev site as you can see:
http://clients.overthehillweb.com/hairisle/products_new
http://clients.overthehillweb.com/hairisle/products_all


I've been doing a LOT of searching of this forum and Googling, and my research indicates that this might be an issue with the on clause of the left join.. This post was very helpful in nundging me inthe right direction. It reads in part:
http://www.zen-cart.com/forum/showpo...47&postcount=6

The real culprit is Mysql data base queries. Once your host upgrade sql database to 5.x, you need to fix your sql queries...

So I took a look at both dev and the live site and yes indeed they are on different versions of mySQL. (thought my server was running 5.x.. it's not... I'll deal with that later this week)

DB Versions:
hairisle dot com - Database: MySQL 5.0.81-community-log
clients dot overthehillweb dot com/hairisle - Database: MySQL 4.1.22-max-log

So I think I have a grasp on WHAT the issue is, and if I can get some assistance to what the corrected syntax for these queries should be, I should be good to go in correcting the queries for these pages..

I am hoping a SQL guru can pop in to help.. YES I read other threads on this error.. Unfortunately the queries are different, and I can't make the leap to figure out how to correct the syntax of this query based on some of the other threads.. Hope someone will take pity on me and help..