User:Sun449036002

= 比赛相关数据导出 =
 * 1) 投票总数

SELECT * FROM `match_work_vote` WHERE code=xxxx


 * 1) 总分享量

SELECT SUM(shareNum) t FROM `article` WHERE typeCode='Mxxxxxx'


 * 1) 打赏总人数

SELECT id FROM `balance` WHERE type='reward' AND targetUri IN (SELECT targetUri FROM match_work_apply WHERE code=xxxxxx) GROUP BY userinfoId


 * 1) 单日最高投票总数（自然日内所有文章票数总和）

SELECT COUNT(id) t,FROM_UNIXTIME(createTime, "%Y-%m-%d") date FROM `match_work_vote` where code=xxxxxx GROUP BY date order BY t DESC