1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 12
select count(p.products_id) as total from(products p,
products_description pd,
products_to_shops p2s)
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 = p2s.products_id
and p2s.shops_id = '26'
and p.products_id = pd.products_id
and pd.language_id = '1'
and p.products_id in ()
[TEP STOP]
|
