Help With Query

[JahShuWah]

Here is a query that is still not working:

 

select count(p.products_id) as total from (products_description pd, products) p LEFT JOIN manufacturers m on p.manufacturers_id = m.manufacturers_id LEFT JOIN specials s on p.products_id = s.products_id, products_to_categories p2c 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 = '18'

 

It isn't working because there are parenthesis missing. They are to be placed such that the LEFT JOIN's will work.

 

Can anyone help me figure out where to place the parenthesis' in this multiple LEFT JOIN query?

 

Thanks in advance.