热门案例赏析
1055) 数据查询错误：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'feeflash.t1.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT t1.title,t1.url,t1.image,t2.cid,t4.tu FROM king_content t1 LEFT OUTER JOIN (king_content_categroy_bind t2,king_content_categroy t3,king_content__case t4) ON t1.id=t2.id and t2.cid=t3.cid and t2.id=t4.id WHERE t1.mid=2 and t1.status=1 and t3.cid1=22 GROUP BY t1.hit desc LIMIT 10
