Product Listing Problem when Logged into Account

[Marotta1]

I tried to set up customer groups for wholesale and retail pricing tonite. I switched my status in the store admin area to whoelsale. When I logged in to my customer account I began to get the following error message on product pages. It only occurs when I am logged into my account. Can anyone give me some idea of what this is referring to and how I can fix it?

1052 - Column 'products_id' in from clause is ambiguous

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

[TEP STOP]

[nostradamus]

did you add a customer to the group?

[Marotta1]

I added myself to the wholesale group. That's when the error started.

[Marotta1]

If anyone needs it, the fix for this is as follows.

In catalog/includes/boxes/specials.php replace

 using (products_id, customers_group_id) 
  

with

 on (s.products_id = pg.products_id and s.customers_group_id = pg.customers_group_id) 
  

You'll be good to go with different prices for wholesale and retail customers when they're logged in to accounts.