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 pd.`products_name` like '%'%') AND pd.`products_id` = p2c.`products_i' at line 16

SELECT cdp.categories_name as cat_name, cd.categories_name as subcat_name, pd.products_name, pd.products_id FROM categories c, categories_description cd, categories cp, categories_description cdp, products_description pd, products p, products_to_categories p2c WHERE (pd.`products_name` like '%'%' OR pd.`products_name` like '%'%') AND pd.`products_id` = p2c.`products_id` AND pd.language_id='2' AND c.categories_id = p2c.categories_id AND c.categories_id = cd.categories_id AND cd.language_id='2' AND cp.categories_id = c.parent_id AND cdp.categories_id = c.parent_id AND cdp.language_id='2' AND p.products_id = pd.products_id AND p.products_status = 1 ORDER BY cp.categories_subnav_hidden, cp.sort_order, cd.categories_name

[TEP STOP]