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 '%蝶%' or p.products_model like '%蝶%' or pd.products_description like '%蝶%') ) ORDER BY p.products_last_modified DESC limit -10, 10 file=>/home/ponchojp/poncho.jp/public_html/fruits/includes/functions/database.php function=>tep_db_error args=>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 '%蝶%' or p.products_model like '%蝶%' or pd.products_description like '%蝶%') ) ORDER BY p.products_last_modified DESC limit -10, 10,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 '-10, 10' at line 1
file=>/home/ponchojp/poncho.jp/public_html/fruits/includes/modules/product_listing.php function=>tep_db_query args=>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 '%蝶%' or p.products_model like '%蝶%' or pd.products_description like '%蝶%') ) ORDER BY p.products_last_modified DESC limit -10, 10
