select count(*) as total from products p , products_description pd, categories c, products_to_categories p2c WHERE p.products_date_available < CURRENT_TIMESTAMP() AND p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id AND ((pd.products_name like '%nobuo%' or p.products_model like '%nobuo%' or pd.products_description like '%nobuo%') ( (pd.products_name like '%9-11%' or p.products_model like '%9-11%' or pd.products_description like '%9-11%') ) ) ORDER BY p.products_last_modified DESC file=>/home/ponchojp/poncho.jp/public_html/fruits/includes/functions/database.php function=>tep_db_error args=>select count(*) as total from products p , products_description pd, categories c, products_to_categories p2c WHERE p.products_date_available < CURRENT_TIMESTAMP() AND p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id AND ((pd.products_name like '%nobuo%' or p.products_model like '%nobuo%' or pd.products_description like '%nobuo%') ( (pd.products_name like '%9-11%' or p.products_model like '%9-11%' or pd.products_description like '%9-11%') ) ) ORDER BY p.products_last_modified DESC,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 '( (pd.products_name like '%9-11%' or p.products_model like '%9-11%' or pd.produc' at line 1
file=>/home/ponchojp/poncho.jp/public_html/fruits/includes/classes/split_page_results.php function=>tep_db_query args=>select count(*) as total from products p , products_description pd, categories c, products_to_categories p2c WHERE p.products_date_available < CURRENT_TIMESTAMP() AND p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id AND ((pd.products_name like '%nobuo%' or p.products_model like '%nobuo%' or pd.products_description like '%nobuo%') ( (pd.products_name like '%9-11%' or p.products_model like '%9-11%' or pd.products_description like '%9-11%') ) ) ORDER BY p.products_last_modified DESC
file=>/home/ponchojp/poncho.jp/public_html/fruits/includes/modules/product_listing.php function=>__construct class=>splitPageResults type=>-> args=>1,10,SELECT DISTINCT p.products_id from products p , products_description pd, categories c, products_to_categories p2c WHERE p.products_date_available < CURRENT_TIMESTAMP() AND p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id AND ((pd.products_name like '%nobuo%' or p.products_model like '%nobuo%' or pd.products_description like '%nobuo%') ( (pd.products_name like '%9-11%' or p.products_model like '%9-11%' or pd.products_description like '%9-11%') ) ) ORDER BY p.products_last_modified DESC limit 0, 10,
