ITI Online Catalog

View Products from: 
1054 - Unknown column 'p.products_id' in 'on clause'

select count(p.products_id) as total from products p left join products_description pd1 on pd1.products_id = p.products_id and pd1.language_id='1' and pd1.affiliate_id = '0', products_description pd, manufacturers m left join specials s on p.products_id = s.products_id left join products_prices pp on p.products_id = pp.products_id and pp.groups_id = '12' and pp.currencies_id = '0' where p.products_status = 1 and pd.products_id = p.products_id and if(pp.products_group_price is null, 1, pp.products_group_price != -1 ) and pd.language_id = '1' and pd.affiliate_id = 0 and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '4'

[TEP STOP]