|
1054 - Unknown column 'p.products_id' in 'on clause'
select count(distinct p.products_id) as total from osc_products_description pd, osc_products p left join osc_manufacturers m on p.manufacturers_id = m.manufacturers_id, osc_products_to_categories p2c, osc_categories c, osc_products_groups pg left join osc_specials s on (p.products_id = s.products_id and s.customers_group_id = '0') where p2c.categories_id = c.categories_id and c.categories_status = '1' and p.products_status and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and p.products_id = pg.products_id and pd.language_id = '5' and pg.customers_group_id = '0' and s.status = '1'
[TEP STOP]
| | | | |
