Php db call dies with mysql 5 vs 4.1?



Hi. I am trying to install a small shopping package and the program is throwing errors with some of the database calls. Here is the error message

1054 - Unknown column ‘p.products_id’ in ‘on clause’

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = ‘1’ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ‘1’ and p2c.categories_id = ‘13’


The column products_id does exist in the table in question, but I am wondering if the p. is a 4.1 versus 5 issue for mysql. the install SQL code worked without a problem and it was generated in 4.1, this is pushing my sql knowledge. so if anyone can tell me what to look for I would appreciate it.