1146 - Table 'admin_akku_ndb.specials' doesn't exist
select count(p.products_id) as total from((products_description pd,
products_to_shops p2s,
products_to_categories p2c, products p)
left join manufacturers m
on p.manufacturers_id = m.manufacturers_id )
left join specials s
on (p.products_id = s.products_id
and s.shops_id ='26')
where p2s.products_status not in (4,5)
and p.products_id = p2c.products_id
and p.products_id = p2s.products_id
and p2s.shops_id = '26'
and pd.products_id = p2c.products_id
and pd.language_id = '1'
and p2c.categories_id = 97
[TEP STOP]
|