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 'or c.categories_id=) or cd.categories_id=)order by rand () limit 1' at line 1
in:
[SELECT p.products_id,p.products_image,pd.products_name FROM zen_news_articles_text nt,zen_categories_description cd,zen_products p,zen_products_to_categories pc,zen_products_description pd WHERE nt.categories_id=cd.categories_id and p.products_id=pd.products_id and pc.products_id=pd.products_id and pc.categories_id=cd.categories_id and (cd.categories_id in ( SELECT c.categories_id FROM zen_categories c inner join zen_categories zc on zc.categories_id=c.parent_id where zc.categories_id= or c.categories_id=) or cd.categories_id=)order by rand () limit 1]