why do i get a 1054 unknown column p/products on cluase error please

[paraglidingdesigner]

Why when i try to display the products do i get 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 = '58'

 

what have i done to deserve this . please help me. Thank you

[MrPhil]

You have an older version of osC running on MySQL 5. Search for "MySQL 5" on this forum and you'll get lots of instructions on exactly what the problem is, and how to fix it in general.

 

For this specific query, you need to find the PHP code that produces it, and add some parentheses so it becomes:

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 = '58'