K9真相2012.8 总03期-《用K9做博客实例教程》

期刊导读

由于制作时间不一致，以在线版本为准，期刊不足之处就不再对应修改了。另外，期刊制作的时候K9还没有博客应用，所以运用了“内容”应用制作，原理一样，标签也可以经过简单替换达到同样调用效果。为之前写过《第一个K9 demo是怎样炼成的》企业类演示站点制作教程的姐妹篇，有些重复的内容步骤..

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