出现错误: Invalid SQL: select count(*) as pronum from(select DISTINCT P.product_id, P.class_id, P.product_code, P.delivery_area_id, P.product_name, P.product_image_two, P.product_image_four, P.status, P.updated_at, P.orderby, PRICE.price_vip, PRICE.price_member, PRICE.price_modern from pm_product as P, pm_product_priceplan as PRICE WHERE (P.status=72 or P.status=71) and P.attrib=1 and P.product_id=PRICE.product_id and P.tea_type = order by updated_at desc,orderby asc) as fromdate Mysql error description: 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 'order by updated_at desc,orderby asc) as fromdate' at line 2 Mysql error number: 1064 Date: 2014-07-07 16:42:25 Script: http://www.salala.com.cn/consearch.php