/*
popkart_chinatele1.mdf 电1
popkart_chinatele2.mdf 电2
popkart_chinaunicom1.mdf 网1
popkart_chinaunicom2.mdf 网2
account 用户信息库
item_unique 稀有部件库
*/
/*
编制人员 维护006#
编制日期 2014年11月6日02:56:58
编制用途 查找所有部件数量异常用户
编制原则 每月最多获取1个稀有部件，账户内4种部件在9代来临前的活动高潮应该已经剩余不多，4种稀有部件都过多的用户首先就是排查对象
需求发放 曹年宝
*/
use popkart_chinatele1.mdf
select account.username,item_unique.wheel,item_unique.engine,item_unique.tire,item_unique.units
from account,item_unique
where item_unique.wheel >3 and item_unique.engine>3 and item_unique.tire>3 and item_unique.units >3
and account.username=item_unique.username
group by username
sort by username asc
into Cheaters_popkart_chinatele1.xls
use popkart_chinatele2.mdf
select account.username,item_unique.wheel,item_unique.engine,item_unique.tire,item_unique.units
from account,item_unique
where item_unique.wheel >3 and item_unique.engine>3 and item_unique.tire>3 and item_unique.units >3
and account.username=item_unique.username
group by username
sort by username asc
into Cheaters_popkart_chinatele2.xls
use popkart_chinaunicom1.mdf
select account.username,item_unique.wheel,item_unique.engine,item_unique.tire,item_unique.units
from account,item_unique
where item_unique.wheel >3 and item_unique.engine>3 and item_unique.tire>3 and item_unique.units >3
and account.username=item_unique.username
group by username
sort by username asc
into Cheaters_popkart_chinaunicom1.xls
use popkart_chinaunicom2.mdf
select account.username,item_unique.wheel,item_unique.engine,item_unique.tire,item_unique.units
from account,item_unique
where item_unique.wheel >3 and item_unique.engine>3 and item_unique.tire>3 and item_unique.units >3
and account.username=item_unique.username
group by username
sort by username asc
into Cheaters_popkart_chinaunicom2.xls补一下防水
[ 此帖被鑫鑫eda2在2014-11-06 14:11重新编辑 ]
