1052 error - new products & sppc

[caw]

I'm getting a 1052 error:

1052 - Column 'products_id' in from clause is ambiguous<br><br>select p.products_id, pd.products_name, IF(pg.customers_group_price IS NOT NULL,pg.customers_group_price, p.products_price) as products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s LEFT JOIN products_groups pg using (products_id, customers_group_id) where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' and s.customers_group_id= '1' order by s.specials_date_added desc limit 10

This error shows up (when you click on a product - product_info.php) in the column where the 'new products' box should be, and only when logged in as a wholesale customer. This error does not occur when not logged in or when logged in as a retail customer.

I haven't been able to find a fix for this in the forums.
My basic SQL knowledge isn't sufficient to figure this one out.

Thanks for the help...