摘要: 直切正题:每个人,每个栏目,发稿数量统计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 失忆王子 阅读(757) 评论(0) 推荐(0) 编辑