东坡论坛

相关诊断 【更多】

1055) 数据查询错误：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'focuznet.t1.tid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT t1.tid,t2.id,t2.title,t2.url,t2.date,t3.id FROM king_content_tag_bind t1 LEFT OUTER JOIN (king_content t2,king_content_tag_bind t3) ON t2.id=t3.id WHERE t2.mid=10 and t2.status=1 and t1.id=1595 and t3.tid=t1.tid and t2.id<>1595 GROUP BY t2.id LIMIT 4

• 怀柔生活网2012-05-14
• 怀柔信息网2012-05-14
• 怀柔网城2012-05-14
• 怀柔1232012-05-14