KingCMS站长访谈2012.2 总06期

期刊导读

　　这期的电子稿我们精心挑选了一些其他网站比较出众的访谈稿件，融入我们的访谈集中。通过对其它网站访谈栏目的了解，笔者发现了一些新的思维，以前笔者仅仅局限于自身的一个访谈，访谈的过程中也是问来问去就那么几个问题，到最后迷惘了，感觉到非常的枯燥乏味，甚至觉得这样的访谈没有多大的意义，因为相同的问题得到的答案也是类似的，就感觉对站长来说也是没有意义..

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=3 and t2.status=1 and t1.id=1654 and t3.tid=t1.tid and t2.id<>1654 GROUP BY t2.id asc LIMIT 1

期刊精彩内容

本期头条

SELECT t1.tid,t2.id,t2.title,t2.url,t2.description,t3.id FROM king_content_tag_bind t1 LEFT OUTER JOIN (king_content t2,king_content_tag_bind t3,king_content_categroy_bind t4) ON t2.id=t3.id and t4.id=t2.id WHERE t4.cid=56 and t2.mid=4 and t2.status=1 and t1.id=1654 and t3.tid=t1.tid and t2.id<>1654 GROUP BY t2.id desc LIMIT 2

本期推荐

SELECT t1.tid,t2.id,t2.title,t2.url,t2.description,t3.id FROM king_content_tag_bind t1 LEFT OUTER JOIN (king_content t2,king_content_tag_bind t3,king_content_categroy_bind t4) ON t2.id=t3.id and t4.id=t2.id WHERE t4.cid=57 and t2.mid=4 and t2.status=1 and t1.id=1654 and t3.tid=t1.tid and t2.id<>1654 GROUP BY t2.id desc LIMIT 3

本期全部【更多】

SELECT t1.tid,t2.id,t2.title,t2.url,t2.description,t3.id FROM king_content_tag_bind t1 LEFT OUTER JOIN (king_content t2,king_content_tag_bind t3,king_content_categroy_bind t4) ON t2.id=t3.id and t4.id=t2.id WHERE t2.mid=4 and t2.status=1 and t1.id=1654 and t3.tid=t1.tid and t2.id<>1654 GROUP BY t2.id asc LIMIT 3