error code 1052 - Column 'products_id' in from clause is ambiguous

[Guest]

Hi there

when using the manufacturers-filter, an error code appears:

 

1052 - Column 'products_id' in from clause is ambiguous

 

select count(p.products_id) as total from (products p, products_description pd, manufacturers m, products_to_categories p2c )left join specials_retail_prices s using(products_id) where p.products_status = '1' and p.products_fsk_18_hidden = '0' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '11' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '72'

 

Is there anyone who can help me solving this problem?

thanks,

Jan

[Jan Zonjee]

Hi there

when using the manufacturers-filter, an error code appears:

 

1052 - Column 'products_id' in from clause is ambiguous

Can you try changing the query to:

 

select count(p.products_id) as total from (products p, products_description pd, manufacturers m, products_to_categories p2c ) left join specials_retail_prices s on ptc.products_id = s.products_id where etcetera

 

So using(products_id) becomes on ptc.products_id = s.products_id