|
|
1054 - Unknown column 'p2s.products_id' in 'where clause'
select distinct c.categories_id as id, cd.categories_name as name from products p, products_to_categories p2c, categories_to_stores c2s, categories c, categories_description cd where p.products_status = '1' and p.products_id = p2c.products_id and p.products_id = p2s.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.categories_id = c2s.categories_id and cd.language_id = '4' and p.manufacturers_id = '0' and p2s.store_id = c2s.store_id and c2s.store_id = '1' order by cd.categories_name
[TEP STOP]
| |