- "ifname, imsi, ground from statistics " \
- " where (time_stamp between ? and ?) and binpath != 'TOTAL_DATACALL' " \
- "and binpath != 'TOTAL_WIFI' and binpath != 'TOTAL_BLUETOOTH' " \
- "and binpath != 'TOTAL_IPV4' and binpath != 'TOTAL_IPV6' " \
- "group by iftype, ifname, imsi, hw_net_protocol_type, is_roaming " \
- "order by time_stamp, iftype, ifname, imsi, hw_net_protocol_type, " \
+ "ifname, subscriber_id, ground from statistics " \
+ "where (time_stamp between ? and ?) " \
+ "and binpath NOT LIKE 'TOTAL_%' " \
+ "group by iftype, ifname, subscriber_id, hw_net_protocol_type, is_roaming " \
+ "order by time_stamp, iftype, ifname, subscriber_id, hw_net_protocol_type, " \