select contentinfo_id,count(distinct ordermobileno) from mmsoa..sendlog
where send_time>'2009-9-20' and send_time<'2009-9-21'
and len(ordermobileno) between 13 and 15
group by contentinfo_id
having count(distinct ordermobileno)>=50
order by contentinfo_id
select contentinfo_id,count(distinct ordermobileno) from mmsoa..sendlog
where send_time>'2009-9-20' and send_time<'2009-9-21'
and len(ordermobileno) between 13 and 150
and submit_statuscode=1000
and ( report is null or report=1 )
group by contentinfo_id
having count(distinct ordermobileno)>=50
order by contentinfo_id
select contentinfo_id,count(distinct ordermobileno) from mmsoa..nm_sendlog
where send_time>'2009-9-20' and send_time<'2009-9-21'
and len(ordermobileno) between 13 and 15
group by contentinfo_id
having count(distinct ordermobileno)>=50
order by contentinfo_id
select contentinfo_id,count(distinct ordermobileno) from mmsoa..nm_sendlog
where send_time>'2009-9-20' and send_time<'2009-9-21'
and len(ordermobileno) between 13 and 150
and submit_statuscode=1000
and ( report is null or report=1 )
group by contentinfo_id
having count(distinct ordermobileno)>=50
order by contentinfo_id
where send_time>'2009-9-20' and send_time<'2009-9-21'
and len(ordermobileno) between 13 and 15
group by contentinfo_id
having count(distinct ordermobileno)>=50
order by contentinfo_id
select contentinfo_id,count(distinct ordermobileno) from mmsoa..sendlog
where send_time>'2009-9-20' and send_time<'2009-9-21'
and len(ordermobileno) between 13 and 150
and submit_statuscode=1000
and ( report is null or report=1 )
group by contentinfo_id
having count(distinct ordermobileno)>=50
order by contentinfo_id
select contentinfo_id,count(distinct ordermobileno) from mmsoa..nm_sendlog
where send_time>'2009-9-20' and send_time<'2009-9-21'
and len(ordermobileno) between 13 and 15
group by contentinfo_id
having count(distinct ordermobileno)>=50
order by contentinfo_id
select contentinfo_id,count(distinct ordermobileno) from mmsoa..nm_sendlog
where send_time>'2009-9-20' and send_time<'2009-9-21'
and len(ordermobileno) between 13 and 150
and submit_statuscode=1000
and ( report is null or report=1 )
group by contentinfo_id
having count(distinct ordermobileno)>=50
order by contentinfo_id