12 2013 档案

phpcmsv9 后台统计编辑发稿数量
摘要：直切正题：每个人，每个栏目，发稿数量统计SELECT a.realname AS 姓名, c.catname AS 栏目名称, count(1) AS 发稿量FROM v9_news bz, v9_category c, v9_admin aWHERE bz.inputtime >= UNIX_TIMESTAMP('20130101000000') AND bz.inputtime = UNIX_TIMESTAMP('20130101000000') AND bz.inputtime <= UNIX_TIMESTAMP('2013123123 阅读全文
posted @ 2013-12-06 16:18 失忆王子 阅读(761) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示