MySQL Error[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 ',region.lat,region.lon) as distance,s.store_id FROM ecm_store s LEFT JOIN ecm_me' at line 1
MySQL Query:SELECT s.*, member.user_name, member.real_name, IF(s.goods_count>0, 1, 0) as has_goods, IF(s.requirement_count>0,1,0) as has_requirement, IF(s.support_count>0,1,0) as has_support, sgrade.sort_order as sgrade_order, getDistance(,,region.lat,region.lon) as distance,s.store_id FROM ecm_store s LEFT JOIN ecm_member member ON s.store_id = member.user_id LEFT JOIN ecm_sgrade sgrade ON s.sgrade = sgrade.grade_id LEFT JOIN ecm_category_store category_store ON s.store_id = category_store.store_id LEFT JOIN ecm_region region ON s.region_id = region.region_id WHERE state = 1 AND is_blocked=0 ORDER BY certed_step desc, has_goods desc, sgrade_order desc, last_login desc, has_requirement desc, has_support desc, s.add_time desc LIMIT 0,10
Wrong File: /eccore/model/mysql.php[534]
Error File: /eccore/model/mysql.php at 286 line. >> mysql_error_report
>> 返回上一页